[pgpool-general: 6647] Re: pool_passwd issue

[Tatsuo Ishii]

You cannot use md5 password for that purpose in pool_passwd.  You must
use either plain text password or AES256-CBC encrypted password
instead. See the manual:

http://www.pgpool.net/docs/latest/en/html/runtime-streaming-replication-check.html

Upcoming Pgpool-II 4.1 (supposed to be released in this Fall) will
allow to use md5 password in pool_passwd for this purpose.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

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