#docker

Failed Server Connection Issue

TLDR raymand1992 experienced a server connection establishment failure. v_shnu recommended verifying credentials and db connectivity. The issue was fixed using the .in DATABASE_URL variable.

Powered by Struct AI

1

7
16mo
Solved
Join the chat
Aug 21, 2022 (16 months ago)
raymand1992
Photo of md5-b082528ee54c7b4b5b7e5cc6ed92e2c0
raymand1992
09:53 PM
2022-08-21T21:37:47.350Z pid=1 tid=2ctd WARN: ActiveRecord::ConnectionNotEstablished: connection to server at "152.206.177.43", port 5432 failed: FATAL: password authentication failed for user "ext"
connection to server at "152.206.177.43", port 5432 failed: FATAL: password authentication failed for user "ext"
Aug 22, 2022 (16 months ago)
v_shnu
Photo of md5-310ea2ceb91b0b302b8f700488e094ad
v_shnu
09:08 AM
As you can see, Chatwoot is not able to connect to your database.

Could you confirm your credentials and see if you have connectivity to the database?
09:09
v_shnu
09:09 AM
Use psql -h <host-name> -U <user> -d <db-name>
raymand1992
Photo of md5-b082528ee54c7b4b5b7e5cc6ed92e2c0
raymand1992
02:15 PM
psql -h 152.206.177.43 -U ext -d chatwoot_production
Password for user ext:
psql (12.12 (Ubuntu 12.12-0ubuntu0.20.04.1))
SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, bits: 256, compression: off)
Type "help" for help.

chatwoot_production=#
v_shnu
Photo of md5-310ea2ceb91b0b302b8f700488e094ad
v_shnu
06:14 PM
Could you ssh into the sidekiq/rails container and see if you can access them with the psql cli?
raymand1992
Photo of md5-b082528ee54c7b4b5b7e5cc6ed92e2c0
raymand1992
06:37 PM
the error was fixed by just using the .in DATABASE_URL variable
Aug 23, 2022 (16 months ago)
v_shnu
Photo of md5-310ea2ceb91b0b302b8f700488e094ad
v_shnu
06:21 PM
Thanks for sharing. Will take a look.