<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<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'm using password authentication over SSL. This works fine with connections from the same network, but doesn't work with connections from another network. Can anyone explain why this isn't working?</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
in pgpool.conf:</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
enable_pool_hba = on<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
pool_passwd = ''<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
in pool_hba.conf:</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
# "local" is for Unix domain socket connections only
<div>local all all trust</div>
<div># IPv4 local connections:</div>
<div>host all all 127.0.0.1/32 trust</div>
<div>host all all ::1/128 trust</div>
<div><br>
</div>
<span>hostssl all all 0.0.0.0/0 password</span><br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<span><br>
</span></div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<span>log output:</span></div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<span>Dec 7 16:20:59 psql-01 pgpool[1085857]: 2021-12-07 16:20:59: pid 1102488: WARNING: unable to get password, password file descriptor is NULL
<div>Dec 7 16:20:59 psql-01 pgpool[1085857]: 2021-12-07 16:20:59: pid 1102488: FATAL: client authentication failed</div>
<span>Dec 7 16:20:59 psql-01 pgpool[1085857]: 2021-12-07 16:20:59: pid 1102488: DETAIL: no pool_hba.conf entry for host "XXX.XXX.XXX.XXX", user "", database "", SSL off</span><br>
</span></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 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 Technologies</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>
</body>
</html>