Psql errors on startup following a backup restore or upgrade (Cluster)

[#1]

Version

All Versions of Cb Response

Cause

There is a new psql database with a new password. This password was updated on the master configuration file cb.conf, but not the minions.

Symptoms

OperationalError: (OperationalError) FATAL:  password authentication failed for user "cb"

Solution

1. Open cb.conf configuration file on the master
   

   vi /etc/cb/cb.conf

2. Search for DatabaseURL
   

   / DatabaseURL

3. Complete steps 1 and 2 on Minions.
4. Replace cb password on minions to match psql password from master
   

   # SQLAlchemy DB URL to be used when connecting to PostgreSQL
   DatabaseURL=postgresql+psycopg2://cb:PASSWORDHERE@localhost:5002/cb

5. Restart the cluster
   

   /usr/share/cb/cbcluster stop
   /usr/share/cb/cbcluster start