<html><body><div id="zimbraEditorContainer" style="font-family: arial, helvetica, sans-serif; font-size: 12pt; color: #000000" class="3"><div data-marker="__SIG_PRE__"><div>Hello Luca, .pcppass should be in the home directory of the user you invoke in the command, in your case pgpool user's home.</div><div>Moreover, instead of 1.1.1.1 you should put localhost or hostname.</div></div><div><br></div><hr id="zwchr" data-marker="__DIVIDER__"><div data-marker="__HEADERS__"><b>Da: </b>"Luca Maranzano" <liuk001@gmail.com><br><b>A: </b>"pgpool-general" <pgpool-general@pgpool.net><br><b>Inviato: </b>Venerdì, 10 settembre 2021 13:22:48<br><b>Oggetto: </b>[pgpool-general: 7701] PGPool-II 4.2.3 on CentOS 7.9: PCP Commands are ignoring .pcppass file<br></div><div><br></div><div data-marker="__QUOTED_TEXT__"><div dir="ltr"><div class="gmail_default" style="font-size:small">Hi all,</div><div class="gmail_default" style="font-size:small"><br></div><div class="gmail_default" style="font-size:small">subject says all, I'm getting crazy trying to understand why pcp commands are completely ignoring .pcppass file.</div><div class="gmail_default" style="font-size:small"><br></div><div class="gmail_default" style="font-size:small">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.</div><div class="gmail_default" style="font-size:small"><br></div><div class="gmail_default" style="font-size:small">I've tried with user root and user postgres:</div><div class="gmail_default" style="font-size:small"><br></div><div class="gmail_default" style="font-size:small"># ls -l /root/.pcppass /var/lib/pgsql/.pcppass <br>-rw------- 1 root root 44 Sep 10 13:06 /root/.pcppass<br>-rw------- 1 postgres postgres 83 Jul 17 09:42 /var/lib/pgsql/.pcppass</div><div class="gmail_default" style="font-size:small"><br></div><div class="gmail_default" style="font-size:small">The command is:</div><div class="gmail_default" style="font-size:small"><br></div><div class="gmail_default" style="font-size:small">pcp_watchdog_info -h 1.1.1.1 -p 9898 -U pgpool</div><div class="gmail_default" style="font-size:small"><br></div><div class="gmail_default" style="font-size:small">The file contains:</div><div class="gmail_default" style="font-size:small">1.1.1.1:9898:pgpool:redactedpassword</div><div class="gmail_default" style="font-size:small"><br></div><div class="gmail_default" style="font-size:small"><span class="gmail-VIiyi" lang="en"><span class="gmail-JLqJ4b gmail-ChMk0b">What am I doing wrong?</span></span></div><div class="gmail_default" style="font-size:small"><span class="gmail-VIiyi" lang="en"><span class="gmail-JLqJ4b gmail-ChMk0b"><br></span></span></div><div class="gmail_default" style="font-size:small"><span class="gmail-VIiyi" lang="en"><span class="gmail-JLqJ4b gmail-ChMk0b">Thanks in advance</span></span></div><div class="gmail_default" style="font-size:small"><span class="gmail-VIiyi" lang="en"><span class="gmail-JLqJ4b gmail-ChMk0b">Regards</span></span></div><div class="gmail_default" style="font-size:small"><span class="gmail-VIiyi" lang="en"><span class="gmail-JLqJ4b gmail-ChMk0b">Luca</span></span></div><div class="gmail_default" style="font-size:small"><span class="gmail-VIiyi" lang="en"><span class="gmail-JLqJ4b gmail-ChMk0b"><br></span></span></div><div class="gmail_default" style="font-size:small"><br></div><div class="gmail_default" style="font-size:small"><br></div></div>
<br><br>
<font style="background-color:#ffffff">
<p align="center"><font style="background-color:#ffffff">Click <a href="https://www.mailcontrol.com/sr/K3UUO6qA3d3GX2PQPOmvUtiZD_0EqjaRnb9QQDAKWpPk5yU1wVmlulTW6IGbcKO-EJYWkiIbcMmJRcENOpaP7A==" target="_blank" rel="nofollow noopener noreferrer">here</a> to report this email as spam.</font></p></font>
<br>_______________________________________________<br>pgpool-general mailing list<br>pgpool-general@pgpool.net<br>http://www.pgpool.net/mailman/listinfo/pgpool-general<br></div></div></body></html>