<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
I restarted pgpool between each of my tests.</div>
<div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div id="Signature">
<div>
<div></div>
<div></div>
<div></div>
<div></div>
<div id="divtagdefaultwrapper" dir="ltr" style="font-size:12pt; color:#000000; font-family:Calibri,Helvetica,sans-serif">
<div>
<p style="margin-top:0px; margin-bottom:0px; margin-bottom:0in; line-height:110%">
<font face="Arial, serif"><font color="#000000"><b><font color="#000000"><font size="2" style="font-size:10pt">Jon Schewe</font></font></b></font></font></p>
<p style="margin-top:0px; margin-bottom:0px; margin-bottom:0in; line-height:110%">
<font face="Arial, serif"><font color="#000000"><font size="2" style="font-size:9pt">Principal Software Systems Technologist</font></font></font></p>
<p style="margin-top:0px; margin-bottom:0px; margin-bottom:0in; line-height:110%">
<font face="Arial, serif"><font color="#000000"><font color="#c00000"><font size="2" style="font-size:9pt"><b><br>
</b></font></font></font><font color="#000000"><font size="2" style="font-size:9pt">C: +1 612.263.2718<br>
</font></font></font></p>
<p style="margin-top:0px; margin-bottom:0px; margin-bottom:0in; line-height:110%">
<font face="Arial, serif"><font color="#000000"><font size="2" style="font-size:9pt">O: +1 952.545.5720</font></font></font></p>
<p style="margin-top:0px; margin-bottom:0px; margin-bottom:0in; line-height:110%">
<font face="Arial, serif"><font color="#0563c1"><font size="2"><u>jon.schewe@raytheon.com</u></font></font></font></p>
<p style="margin-top:0px; margin-bottom:0px; margin-top:0.08in; margin-bottom:0.11in; line-height:100%">
<font face="Arial, serif"><font size="3" style="font-size:12pt"><font color="#000000"><font color="#c00000"><font size="2" style="font-size:9pt"><span lang="fr-BE"><b><br>
</b></span></font></font></font><font color="#000000"><font color="#ce1126"><font size="2" style="font-size:10pt"><span lang="fr-BE"><b>Raytheon BBN</b></span></font></font></font></font></font></p>
<p style="margin-top:0px; margin-bottom:0px; margin-bottom:0in; line-height:110%">
<font face="Arial, serif"><font size="3" style="font-size:12pt"><font color="#000000"><font size="2" style="font-size:9pt">Raytheon Intelligence & Space</font></font></font></font></p>
<p style="margin-top:0px; margin-bottom:0px; margin-bottom:0in; line-height:110%">
<font face="Arial, serif"><font size="3" style="font-size:12pt"><font color="#000000"><font size="2" style="font-size:9pt">5775 Wayzata Blvd. Suite 630</font></font></font></font></p>
<p style="margin-top:0px; margin-bottom:0px; margin-bottom:0in; line-height:110%">
<font face="Arial, serif"><font size="3" style="font-size:12pt"><font color="#000000"><font size="2" style="font-size:9pt">St. Louis Park, MN 55416</font></font></font></font>
</p>
<p style="margin-top:0px; margin-bottom:0px; margin-bottom:0in; line-height:110%">
<br>
</p>
<p style="margin-top:0px; margin-bottom:0px; margin-bottom:0in; line-height:120%">
<font face="Arial, serif"><font size="3" style="font-size:12pt"><font color="#0563c1"><u><a href="https://www.rtx.com/" style="color:rgb(5,99,193)"><font color="#000000"><font size="1" style="font-size:8pt">RTX.com</font></font></a></u></font><font color="#000000"><font color="#000000"><font size="1" style="font-size:8pt"><span style="text-decoration:none">
</span></font></font></font><font color="#ce1126"><font size="2" style="font-size:9pt">|</font></font><font color="#ce1126"><font size="1" style="font-size:8pt">
</font></font><font color="#0563c1"><u><a href="https://www.linkedin.com/company/raytheontechnologies" style="color:rgb(5,99,193)"><font color="#000000"><font size="1" style="font-size:8pt">LinkedIn</font></font></a></u></font><font color="#000000"><font color="#ce1126"><font size="1" style="font-size:8pt"><span style="text-decoration:none">
</span></font></font></font><font color="#ce1126"><font size="2" style="font-size:9pt">|</font></font><font color="#ce1126"><font size="1" style="font-size:8pt">
</font></font><font color="#0563c1"><u><a href="https://twitter.com/raytheontech" style="color:rgb(5,99,193)"><font color="#000000"><font size="1" style="font-size:8pt">Twitter</font></font></a></u></font><font color="#000000"><font color="#ce1126"><font size="1" style="font-size:8pt"><span style="text-decoration:none">
</span></font></font></font><font color="#ce1126"><font size="2" style="font-size:9pt">|</font></font><font color="#ce1126"><font size="1" style="font-size:8pt">
</font></font><font color="#0563c1"><u><a href="https://www.instagram.com/raytheontechnologies" style="color:rgb(5,99,193)"><font color="#000000"><font size="1" style="font-size:8pt">Instagram</font></font></a></u></font><font color="#000000"><font color="#ce1126"><font size="1" style="font-size:8pt"><span style="text-decoration:none">
</span></font></font></font></font></font></p>
<br>
</div>
</div>
</div>
</div>
</div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> Bo Peng <pengbo@sraoss.co.jp><br>
<b>Sent:</b> Monday, July 4, 2022 03:10<br>
<b>To:</b> Jon SCHEWE <jon.schewe@raytheon.com><br>
<b>Cc:</b> pgpool-general@pgpool.net <pgpool-general@pgpool.net><br>
<b>Subject:</b> [External] Re: [pgpool-general: 8281] Re: Problems with pool_passwd</font>
<div> </div>
</div>
<div class="BodyFragment"><font size="2"><span style="font-size:11pt;">
<div class="PlainText">Hello,<br>
<br>
> Well, I had it working, but not with the configuration that I thought I had installed.<br>
> I've gone back and done more testing and found the following:<br>
<br>
If you modified passwords.conf, you need to restart Pgpool-II.<br>
<br>
Regards,<br>
<br>
> > > > I'm having some trouble using pool_passwd with pgpool-II 4.3.2.<br>
> > > > I'm using the attached pgpool.conf file where I have specified that the pool_passwd file is named "passwords.conf".<br>
> > > > This file exists and is readable only by the postgres user, which is the same user pgpool-II is running as.<br>
> > > > This file contains:<br>
> > > > sr_check_password = 'TEXTpass1'<br>
> > > > health_check_password = 'TEXTpass2'<br>
> > > > recovery_password = 'TEXTpass3'<br>
> > ><br>
> > > The format of "passwords.conf" should be:<br>
> > ><br>
> > > <username>:<password><br>
> > ><br>
> > ><br>
> > > If your pgpool.conf settings are:<br>
> > ><br>
> > > sr_check_user = 'pgpool'<br>
> > > sr_check_password=''<br>
> > > health_check_user = 'pgpool'<br>
> > > health_check_password = ''<br>
> > > recovery_user = 'postgres'<br>
> > > recovery_password = ''<br>
> > ><br>
> > > passwords.conf should be:<br>
> > ><br>
> > > pgpool:TEXTpasswordofpgpool<br>
> > > postgres:TEXTpasswordofpostgres<br>
> > <br>
> > Thank you for the corrections. I had assumed that the format of the passwords.conf file would be the same as pgpool.conf and that it would use the keys from the conf file.<br>
> > However I see that this is generic for any database user so it makes perfect sense as it is.<br>
> > Now everything is working.<br>
> > Thank you!<br>
> <br>
> Well, I had it working, but not with the configuration that I thought I had installed.<br>
> I've gone back and done more testing and found the following:<br>
> <br>
> This works:<br>
> --- pgpool.conf ---<br>
> pool_passwd = 'passwords.conf'<br>
> sr_check_user = 'pgpool'<br>
> sr_check_password='password1'<br>
> health_check_user = 'pgpool'<br>
> health_check_password = 'password1'<br>
> recovery_user = 'postgres'<br>
> recovery_password = 'password2'<br>
> <br>
> <br>
> This reports 'Password does not match for user "pgpool".' in the postgresql log file.<br>
> --- pgpool.conf ---<br>
> pool_passwd = 'passwords.conf'<br>
> sr_check_user = 'pgpool'<br>
> sr_check_password=''<br>
> health_check_user = 'pgpool'<br>
> health_check_password = ''<br>
> recovery_user = 'postgres'<br>
> recovery_password = ''<br>
> <br>
> --- passwords.conf ---<br>
> pgpool:TEXTpassword1<br>
> postgres:TEXTpassword2<br>
> <br>
> <br>
> This reports 'Password does not match for user "pgpool".' in the postgresql log file.<br>
> --- pgpool.conf ---<br>
> pool_passwd = 'passwords.conf'<br>
> sr_check_user = 'pgpool'<br>
> sr_check_password=''<br>
> health_check_user = 'pgpool'<br>
> health_check_password = ''<br>
> recovery_user = 'postgres'<br>
> recovery_password = ''<br>
> <br>
> --- passwords.conf ---<br>
> pgpool:password1<br>
> postgres:password2<br>
> <br>
> <br>
> Jon Schewe<br>
<br>
<br>
-- <br>
Bo Peng <pengbo@sraoss.co.jp><br>
SRA OSS, Inc. Japan<br>
<a href="https://www.sraoss.co.jp/">https://www.sraoss.co.jp/</a><br>
</div>
</span></font></div>
</body>
</html>