Global

SSH backup issue on Global

11/11/2025Rick Hansen
SSH backup issue on Global it you are having issue with backup using SSH because they have a new Linux server with OpenSSH version  OpenSSH_9.6p1 the customer needs to do this on their Lunix server to correct it. Get Open SSH version  ssh -V ...

Changing Global IP address causes problems

10/23/2025Rick Hansen
Here are things to check if Global IP address gets changed and NCs aren't connected or you can't launch to them: On Global: usr/local/s2global/SymmetricDS/conf/global.properties /etc/hosts If the old IP address is still in /etc/hosts, you m...

New NC stuck initializing, has partitions but data conflicts don't come up

10/07/2025Rick Hansen
If you are adding a new controller to Global and it's stuck initializing, the partitions have come across to the NC but not the Global System Administrator user, and the data conflicts messages never came up in Global, check the NC database: s2syn...

Can't save to NC: error operator does not exist: character varying = bytea Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.

10/07/2025Rick Hansen
Try to resynch in Global to an NC, or even save a person to the NC and get: error operator does not exist: character varying = bytea Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts. If the...

Find multiple person contacts assigned to a person

09/19/2025Rick Hansen
If you get an error in syslog about multiple person contacts on a person: SELECT count(*),person_id FROM personinfo.person_contacts GROUP BY 2 HAVING count(*)>1; Delete all except one. ...

Upgrade Netbox to 6.2, Mercury MP_1502 gets data conv error in Global

09/09/2025Rick Hansen
From Rad: If  a customer upgrades to 6.2 and configured Mercury MP_1502, they will get data conversion errors in Global. Joe P added a few things here. To clear the errors do the following:  Stage: INSERT into stage_live.networknodetype(typeid...

How to tell if Global is on a VM

08/28/2025Rick Hansen
lspci -v   look for: 1 PCI bridge: VMware  VGA compatible controller: VMware SVGA II Adapter (prog-if 00 [VGA contr 

Clear s2synch.update_queue if NC stuck "verifying config alignment"

08/26/2025Rick Hansen
Clear s2synch.update_queue if NC stuck "verifying config alignment" Steve S did this at Allina: The two NCs with "verifying config alignment" had credential attributes and access levels in s2synch.update_queue that Global was not pulling from th...

Find access level removals from Netboxes

08/21/2025Rick Hansen
Find API user personid,then: \copy (select p.id, p.text6, p.firstname, p.lastname, s2g.name AS acccesslevel,ptalgh.lastmod FROM person p JOIN s2activity.person_to_accesslevel_group_history ptalgh ON p.id=ptalgh.personid JOIN s2group s2g ON s2g.id=...

Upgrade Netbox to 6.2, get replication error in Global

06/13/2025Rick Hansen
Upgrade Netbox to 6.2, get replication error in Global because of missing Honeywell VMS type Add missing VMS type to Global server: stage=> INSERT INTO stage_live.vmstype(vmstypeid,name) VALUES(15,'Honeywell'); Error will clear immediately ...