Threat Report: Exposing Malware in Linux-Based Multi-Cloud Environments | Download Now

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

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

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
Labels (1)
Was this article helpful? Yes No
No ratings
Article Information
Author:
Creation Date:
‎09-30-2016
Views:
708
Contributors