Problem: Database migration fails in Stratusphere 5.8.x
Symptoms:
Copy DB from remote HUB/DB operation fails, returning error below:
ERROR - Exporting of Database portal failed
Getting table count from local Database
psql: FATAL: database "portal" does not exist
Table Count: 0
ERROR: Database counts do not match
Your database migration did not work correctly
/bin/lwl: line 97: pcont: command not found
Possible Resolution(s):
The failure is caused by the heightened SSL requirement in PostgreSQL. To workaround this, we need to temporarily change SSL config and change it back afterward.
- On the destination Stratusphere appliance, login as root (https://www.liquidware.com/support/articles/210640403-Cannot-logon-as-root-to-the-console-in-Stratusphere-5-5) and run the following commands:
grep ssl_ciphers /var/lib/pgsql/current/data/postgresql.conf
(verify that it returns "ssl_ciphers..." not "#ssl_ciphers..." with a pound sign)
sed -i 's/ssl_ciphers/#ssl_ciphers/g' /var/lib/pgsql/current/data/postgresql.conf
grep ssl_ciphers /var/lib/pgsql/current/data/postgresql.conf
(verify that it shows"#ssl_ciphers" now)
/etc/init.d/postgresql-9.5 restart
- Continue with Copy DB from remote HUB/DB operation again
- Once the DB copy is complete, revert the SSL config:
sed -i 's/#ssl_ciphers/ssl_ciphers/g' /var/lib/pgsql/current/data/postgresql.conf
grep ssl_ciphers /var/lib/pgsql/current/data/postgresql.conf
(verify that it shows"ssl_ciphers" now)
/etc/init.d/postgresql-9.5 restart
Product: Stratusphere Fit/UX
Product Version: 5.8.1 and above
Expires on: 365 days from publish date
Updated: October 10, 2016