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

[Luca Maranzano]

Hello Francesco,
the file actually is in the home of the user that is invoking the command,
I've tried with root and postgres.
We do not have a pgpool user in our setup, CentOS runs pgpool with postgres
user.

The point is that it seems that pcp commands do not try to use the .pcppass
file.

Thanks
Regards,
Luca




On Fri, Sep 10, 2021 at 1:52 PM Francesco Mazzi <fmazzi at comune.genova.it>
wrote:

> Hello Luca, .pcppass should be in the home directory of the user you
> invoke in the command, in your case pgpool user's home.
> Moreover, instead of 1.1.1.1 you should put localhost or hostname.
>
> ------------------------------
> *Da: *"Luca Maranzano" <liuk001 at gmail.com>
> *A: *"pgpool-general" <pgpool-general at pgpool.net>
> *Inviato: *Venerdì, 10 settembre 2021 13:22:48
> *Oggetto: *[pgpool-general: 7701] PGPool-II 4.2.3 on CentOS 7.9: PCP
> Commands        are ignoring .pcppass file
>
> Hi all,
>
> subject says all, I'm getting crazy trying to understand why pcp commands
> are completely ignoring .pcppass file.
>
> 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
>
>
>
>
>
> Click here
> <https://www.mailcontrol.com/sr/K3UUO6qA3d3GX2PQPOmvUtiZD_0EqjaRnb9QQDAKWpPk5yU1wVmlulTW6IGbcKO-EJYWkiIbcMmJRcENOpaP7A==>
> to report this email as spam.
>
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20210910/a9425979/attachment.htm>