Author Topic: Qube 7 supervisor can fail to connect to the PostgreSQL server  (Read 166 times)

jburk

  • Administrator
  • *****
  • Posts: 493
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.
« Last Edit: June 14, 2018, 12:48:33 AM by jburk »