[pgpool-general: 7704] Re: PGPool-II 4.2.3 on CentOS 7.9: PCP Commands are ignoring .pcppass file

Bo Peng pengbo at sraoss.co.jp
Mon Sep 13 17:45:42 JST 2021


Hello,

> subject says all, I'm getting crazy trying to understand why pcp commands
> are completely ignoring .pcppass file.
>
> The command is:
> 
> pcp_watchdog_info -h 1.1.1.1 -p 9898 -U pgpool

You need to use "-w" or "--no-password" option.

pcp_watchdog_info -w -h 1.1.1.1 -p 9898 -U pgpool

[Doc]
https://www.pgpool.net/docs/latest/en/html/pcp-common-options.html

> I'm sure the file is correct, I've also tried to use strace and from the
> output there is no attempt to open $HOME/.pcppass file.
> 
> I've tried with user root and user postgres:
> 
> # ls -l /root/.pcppass /var/lib/pgsql/.pcppass
> -rw------- 1 root     root     44 Sep 10 13:06 /root/.pcppass
> -rw------- 1 postgres postgres 83 Jul 17 09:42 /var/lib/pgsql/.pcppass
> 
> The command is:
> 
> pcp_watchdog_info -h 1.1.1.1 -p 9898 -U pgpool
> 
> The file contains:
> 1.1.1.1:9898:pgpool:redactedpassword
> 
> What am I doing wrong?
> 
> Thanks in advance
> Regards
> Luca


-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan
http://www.sraoss.co.jp/


More information about the pgpool-general mailing list