#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.

16mo

Join the chat

Aug 21, 2022 (16 months ago)

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)

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

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

06:14 PM

Could you ssh into the sidekiq/rails container and see if you can access them with the psql cli?

raymand1992

06:37 PM

the error was fixed by just using the .in DATABASE_URL variable

Aug 23, 2022 (16 months ago)

v_shnu

06:21 PM

Thanks for sharing. Will take a look.

Chatwoot

Chatwoot | Knowledge Base powered by Struct.AI

Indexed 2221 threads (46% resolved)

Generate Knowledge

Similar Threads

Avatar Upload Issue and Connection Problems in Chatwoot 2.17.0

h2so4 has an avatar issue in their server and faced connection problems after updating from Chatwoot 2.17.0 to 2.17.1. thinness2722 mentioned a bug in 2.17.0.

6mo

Resolving Redis Connect Errors and Database Mismatches

justman10000 had trouble connecting to Redis and encountered a database password authentication error. pranavrajs provided constant guidance to fix the Redis issue and justman10000 resolved the database problem independently.

24mo

Migrating Chatwoot Version: Port Connection Issue

arix0001 faced an issue in migrating Chatwoot versions due to an invalid integer value in the port connection option. After consultation and troubleshooting with sojan_official and v_shnu, the problem was resolved by adding the `POSTGRES_PORT` environment variable.

24mo