PipelineFX Forum

Qube! => Known Bugs, Fixes, and Patches => Topic started by: jburk on June 14, 2018, 12:41:01 AM

Title: Qube 7 supervisor can fail to connect to the PostgreSQL server
Post by: jburk on June 14, 2018, 12:41:01 AM
This can occur either during the upgrade procedure from Qube 6 to Qube 7 or if the supervisor configuration is modified with WranglerView 7.0-0 or 7.0-0a at any time after a successful installation or upgrade.

The root cause of both of these issues is due to a

database_port=3300 (or 3306)

line present in the supervisor's qb.conf file.  If your supervisor's supelog file contains entries like:

[Jun 13, 2018 17:37:29] jburk-15-mbPro[74627]: ERROR: QbDatabasePostgreSQL::_connect() Unable To Init Database: could not connect to server: No such file or directory
   Is the server running locally and accepting
   connections on Unix domain socket "/tmp/.s.PGSQL.3306"?

please open the qb.conf in a text editor, comment out the database_port line, and restart the supervisor service.

We will be patching the installation and upgrade procedures, as well as WranglerView, to address this in the next few days.