Migrate from XIQ-SE 24.2 to 24.7 fails with database migration error

[MaeveBanks]

Hey all, I'm trying to migrate an installation of XIQ-SE from 24.2 to 24.7. Specifically 24.2.15.5 to 24.7.11.22.

There's nothing special configured on the existing machine, we're relatively new to using XIQ-SE as it stands. It's essentially just being used for its local switch management. Yesterday, I updated it to 24.2.15.5 from some previous version of 23. Then, following this guide, I spun up an instance of 24.7.11.22. From the previous setup, I ran /usr/loca/Extreme_Networks/NetSight/scripts/permitSQLaccess.sh. From the destination server, I ran the migration script and provided the root password. 

When I did this, it failed after Initializing New Database, saying 0.0% of the data has been migrated. I rooted through some logs and determined that the error is "failed to connect to pqsl at 'localhost' as user 'netsight': database error: socket error in 'connect': ERRCONNREFUSED".

I know a bit about databases but not specifically PQSL. It seems fairly self-evident that something is failing when the script tries to talk to its locally managed PostgreSQL database due to a permissions issue. This happens both when the new server was installed using a netsight user to run the server and the root permissions, and I used the root account to run this script either way.

I'm about to try to send this information to GTAC. Does anyone know why this may be occurring? Thanks.

[Zdeněk_Pala]

That issue is not present in version 24.10.10 As indicated in the mentioned help page, the migration should be executed with root privileges:

sudo /usr/local/Extreme_Networks/NetSight/scripts/migrateFromVersion24_2.sh -s <IP-of-the-source> -u <username-for-OS-access>

[Robert_Haynes]

You should run the migration script logged in as the alternative 'netsight' user if the new system was deployed as the 'netsight' user. Running the script from root will indubitably create permission issues, especially during raw file transfers when ownership bits are set.