View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0005116 | SymmetricDS | Bug | public | 2021-11-08 08:18 | 2022-08-01 19:33 |
Reporter | didier.ros | Assigned To | elong | ||
Priority | high | ||||
Status | closed | Resolution | no change required | ||
Product Version | 3.12.12 | ||||
Summary | 0005116: (FATAL: password authentication failed for user | ||||
Description | Hi I am trying to set up an active-active postgresql cluster according to the following article : "https://blog.crunchydata.com/blog/a-guide-to-building-an-active-active-postgresql-cluster?s=03" When I check the log file I have the following error message >> 2021-11-07 10:49:56,205 ERROR [sales] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Could not get a connection to the database: Cannot create PoolableConnectionFactory (FATAL: password authentication failed for user "rep"). Waiting for 10 seconds before trying to connect to the database again. StackTraceKey.init [SQLException:1862095160] java.sql.SQLException: Cannot create PoolableConnectionFactory (FATAL: password authentication failed for user "rep") << I checked that the connection is possible with the user "rep" Thanks in advance. Didier | ||||
Steps To Reproduce | "https://blog.crunchydata.com/blog/a-guide-to-building-an-active-active-postgresql-cluster?s=03" | ||||
Tags | No tags attached. | ||||
|
You need to set a password for the user, running in psql: ALTER USER rep PASSWORD 'newPassword'; Then tell SymmetricDS about the password in the engine properties file: db.password=newPassword |
|
Hi here are the actions carried out : psql -p 5436 ALTER USER rep PASSWORD 'ertert1234'; cd /depot/symmetric-server-3.12.12/engines/ vi sales.properties db.password=ertert1234 [postgres@DCEYY1YF engines]$ /depot/symmetric-server-3.12.12/bin/sym_service stop Error 6: Server is not running [postgres@DCEYY1YF engines]$ /depot/symmetric-server-3.12.12/bin/sym_service start Waiting for server to start ...... Started vi /depot/symmetric-server-3.12.12/logs/symmetric.log 2021-11-07 10:49:55,782 INFO [startup] [SymmetricEngineHolder] [main] Starting in single-server mode 2021-11-07 10:49:55,940 INFO [sales] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Initializing connection to database 2021-11-07 10:49:56,205 ERROR [sales] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Could not get a connection to the database: Cannot create PoolableConnectionFactory (FATAL: password authentication failed for user "rep"). Waiting for 10 seconds before trying to connect to the database again. StackTraceKey.init [SQLException:1862095160] java.sql.SQLException: Cannot create PoolableConnectionFactory (FATAL: password authentication failed for user "rep") |
|
Edit the Postgres pg_hba.conf file and make sure you have a matching entry so that it is using password based authentication. https://www.postgresql.org/docs/11/auth-pg-hba-conf.html |
Date Modified | Username | Field | Change |
---|---|---|---|
2021-11-08 08:18 | didier.ros | New Issue | |
2021-11-10 18:15 | elong | Note Added: 0002015 | |
2021-11-10 18:15 | elong | Status | new => feedback |
2021-11-11 09:06 | didier.ros | Note Added: 0002016 | |
2021-11-11 09:06 | didier.ros | Status | feedback => new |
2021-11-24 18:22 | elong | Note Added: 0002018 | |
2021-11-24 18:25 | elong | Status | new => feedback |
2022-08-01 19:33 | elong | Assigned To | => elong |
2022-08-01 19:33 | elong | Status | feedback => closed |
2022-08-01 19:33 | elong | Resolution | open => no change required |