Problem: Stratusphere Hub standalone stops working after upgrading to 5.5
Symptoms: After upgrading Stratusphere Hub Standalone to 5.5, its UI becomes unaccessible.
Possible Resolution(s):
In Stratusphere 5.5, we start using SSL in Hub-Database communications. However, the upgrade process may fail to enable SSL option in database config on Standalone Hub. To verify if that is the case, you can follow these steps:
- Logon to Stratusphere Hub as friend/sspassword, and 'su -' to swtich to root.
- Run: grep ssl /var/lib/pgsql/9.1/data/postgresql.conf
- Check and see if it returns with "#ssl = off". If so, proceed with the correction procedure below; otherwise, please contact support
To correct "#ssl = off" error, run the following commands in order:
sed -i 's/#ssl = off/ssl = on/g' /var/lib/pgsql/9.1/data/postgresql.conf
grep ssl /var/lib/pgsql/9.1/data/postgresql.conf (verify that ssl is set to on)
sv restart postgresql
sv restart tnt-backend
The UI of Stratusphere Hub should return in a couple minutes.
Product: Stratusphere Fit/UX
Product Version: 5.5
Expires on: 365 days from publish date
Updated: July 30, 2013 ***Update needed***