WhatsApp / WhatsApp-Business-API-Setup-Scripts

The scripts related to setting up WhatsApp business API
MIT License
410 stars 433 forks source link

Not recognizing PostgreSQL Server Version #30

Closed libardolara closed 4 years ago

libardolara commented 4 years ago

Im deploying the Master with a connection to a PostgreSQL V10.12, when I check the logs there are several errors.

Main messages in the log: The server version of this PostgreSQL is unknown, falling back to the client version Failed to initialize cluster manager, will retry after 1000 ms

logs-from-whatsapp-master-in-whatsapp-master-deployment-64cfbc8676-spt7x.txt

This is my configuration for the deployment db.env:

wa-db-engine=PGSQL
wa-db-hostname=dbhost
wa-db-port=31810
wa-db-username=admin
wa-db-password=*****
wa-db-connection-idle-timeout=180
wa-db-connection-option=sslrootcert=/usr/local/wamedia/cert/6be25d73-0600-11ea-9bce-eaebe975ceba.crt;dbname=db;sslmode=verify-full

Image Version docker.whatsapp.biz/coreapp:v2.27.12

When I check in my DB the version I get these results:

psql -> SELECT version();
"PostgreSQL 10.12 on x86_64-pc-linux-gnu, compiled by gcc (Debian 6.3.0-18+deb9u1) 6.3.0 20170516, 64-bit"

psql -> SHOW server_version;
"10.12"

In the dbhost I see some objects created like the databases configStore and clusterStore, but there are no tables in them.

libardolara commented 4 years ago

Solved. Removed the dbname from the connection options and created a DB with the same username.