[pgpool-general: 9037] Re: cannot get .pgppass file to work

[Bo Peng]

Hi,

> $ cat ~/.pcppass
> *:5432:postgres:postgres
>
> 
> $ pcp_node_info -w -p 5440 -U postgres -n 1

It seems that the port is different.

In pcp command you use 5440, but in .pcppass 5432 is specified.

On Thu, 29 Feb 2024 22:55:17 -0700
Sbob <sbob at quadratum-braccas.com> wrote:

> All;
> 
> 
> I cannot get .pcppass file to work
> 
> 
> I setup my pcp.conf file to have the following:
> 
> 
> $ pg_md5 postgres
> e8a48653851e28c69d0506508fb27fc5
> 
> 
> 
> $ cat /etc/pgpool-II/pcp.conf
> # USERID:MD5PASSWD
> postgres:e8a48653851e28c69d0506508fb27fc5
> 
> 
> 
> $ cat ~/.pcppass
> *:5432:postgres:postgres
> 
> 
> $ chmod 0600 ~/.pcppass
> 
> $ export  PCPPASSFILE=/var/lib/pgsql/.pcppass
> 
> 
> $ pcp_node_info -w -p 5440 -U postgres -n 1
> FATAL:  authentication failed for user "postgres"
> DETAIL:  username and/or password does not match
> 
> 
> 
> However passing in a pw works (using the password:  postgres)
> 
> $ pcp_node_info -W -p 5440 -U postgres -n 1
> Password:
> 172.16.108.161 5432 2 0.333333 up up primary primary 0 none none 
> 2024-02-29 22:22:40
> 
> 
> 
> what am I doing wrong?
> 
> 
> Thanks in advance
> 
> 
> 
> 
> 
> 
> 
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general


-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS LLC
TEL: 03-5979-2701 FAX: 03-5979-2702
URL: https://www.sraoss.co.jp/