[pgpool-general: 6646] pool_passwd issue

[Andrew Kerber]

I have an installation I am working on, and I just removed my version 10
installation and decided to go with pgpool-II-11.  When I hardcode the
password for the sr_check_user (sr_check_password) into the pgool.conf
file, everything works fine. But when I generate the password and put it in
the pool_passwd file, i get authentication errors. eg, hardcoded into teh
pgpool.conf:
sr_check_user='postgres'
sr_check_password='pass4321'

works fine.
but when I run this:

pg_md5 -m -f /etc/pgpool-II-11/pgpool.conf -u postgres
password: <entered the same password>

I get the errors below.

Jul 12 11:01:25 pgpool1 pgpool[3845]: [243-1] 2019-07-12 11:01:25: pid
3845: ERROR:  authentication failed
Jul 12 11:01:25 pgpool1 pgpool[3845]: [243-2] 2019-07-12 11:01:25: pid
3845: DETAIL:  password authentication failed for user "postgres"
Jul 12 11:01:25 pgpool1 pgpool[3845]: [244-1] 2019-07-12 11:01:25: pid
3845: LOG:  find_primary_node: make_persistent_db_connection_noerror failed
on node 1
Jul 12 11:01:26 pgpool1 pgpool[3845]: [245-1] 2019-07-12 11:01:26: pid
3845: ERROR:  authentication failed
Jul 12 11:01:26 pgpool1 pgpool[3845]: [245-2] 2019-07-12 11:01:26: pid
3845: DETAIL:  password authentication failed for user "postgres"
Jul 12 11:01:26 pgpool1 pgpool[3845]: [246-1] 2019-07-12 11:01:26: pid
3845: LOG:  find_primary_node: make_persistent_db_connection_noerror failed
on node 0
Jul 12 11:01:26 pgpool1 pgpool[3845]: [247-1] 2019-07-12 11:01:26: pid
3845: ERROR:  authentication failed
Jul 12 11:01:26 pgpool1 pgpool[3845]: [247-2] 2019-07-12 11:01:26: pid
3845: DETAIL:  password authentication failed for user "postgres"
Jul 12 11:01:26 pgpool1 pgpool[3845]: [248-1] 2019-07-12 11:01:26: pid
3845: LOG:  find_primary_node: make_persistent_db_connection_noerror failed
on node 1

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20190712/d1b92e5d/attachment.html>