View Issue Details

IDProjectCategoryView StatusLast Update
0005116SymmetricDSBugpublic2022-08-01 19:33
Reporterdidier.ros Assigned Toelong  
Priorityhigh 
Status closedResolutionno change required 
Product Version3.12.12 
Summary0005116: (FATAL: password authentication failed for user
DescriptionHi
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"
TagsNo tags attached.

Activities

elong

2021-11-10 18:15

developer   ~0002015

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

didier.ros

2021-11-11 09:06

reporter   ~0002016

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")

elong

2021-11-24 18:22

developer   ~0002018

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

Issue History

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