<div dir="ltr">Hey all,<div><br></div><div>I think I may have found a bug, I have the following setup:<div><br></div><div><ul><li>pgpool-II version 3.3.6 (tokakiboshi)<br></li><li>Centos 6.4<br></li><li>Master / slave mode, streaming</li></ul></div><div><br></div><div><table border="1" style="font-size:12.8000001907349px;border-collapse:collapse;color:rgb(0,0,0);font-family:sans-serif;line-height:19.2000007629395px"><tbody><tr><td style="border:1px solid rgb(204,204,204);padding-left:5px;padding-right:5px"><font face="monospace, monospace">pg_hba.conf</font></td><td style="border:1px solid rgb(204,204,204);padding-left:5px;padding-right:5px"><font face="monospace, monospace">pool_hba.conf</font></td><td style="border:1px solid rgb(204,204,204);padding-left:5px;padding-right:5px"><font face="monospace, monospace">pool_passwd</font></td><td style="border:1px solid rgb(204,204,204);padding-left:5px;padding-right:5px"><font face="monospace, monospace">result</font></td></tr><tr><td style="border:1px solid rgb(204,204,204);padding-left:5px;padding-right:5px"><font face="monospace, monospace">md5</font></td><td style="border:1px solid rgb(204,204,204);padding-left:5px;padding-right:5px"><font face="monospace, monospace">md5</font></td><td style="border:1px solid rgb(204,204,204);padding-left:5px;padding-right:5px"><font face="monospace, monospace">yes</font></td><td style="border:1px solid rgb(204,204,204);padding-left:5px;padding-right:5px"><font face="monospace, monospace">md5 auth</font></td></tr></tbody></table></div><div><br></div><div>I see the following behavior:</div><div><br></div><blockquote style="margin:0px 0px 0px 40px;border:none;padding:0px"><div><div><font face="monospace, monospace">-bash-4.1$ psql -h 192.168.3.193 -U replication postgres</font></div></div><div><div><font face="monospace, monospace">psql.bin (9.4.1.4)</font></div></div><div><div><font face="monospace, monospace">Type "help" for help.</font></div></div><div><div><font face="monospace, monospace"><br></font></div></div><div><div><font face="monospace, monospace">postgres=></font></div></div></blockquote><div><div><br></div><div>Which is fine, but if I get the database name wrong I see:</div><div><br></div></div><blockquote style="margin:0px 0px 0px 40px;border:none;padding:0px"><div><div><div><font face="monospace, monospace">-bash-4.1$ psql -h 192.168.3.193 -U replication postgress</font></div></div></div><div><div><div><font face="monospace, monospace">psql.bin: server closed the connection unexpectedly</font></div></div></div><div><div><div><font face="monospace, monospace"> This probably means the server terminated abnormally</font></div></div></div><div><div><div><font face="monospace, monospace"> before or while processing the request.</font></div></div></div></blockquote><div><div><br></div><div>And in the PGPool logs I see this:</div><div><br></div></div><blockquote style="margin:0px 0px 0px 40px;border:none;padding:0px"><div><div><font face="monospace, monospace">2015-08-27 17:19:22 LOG: pid 21711: pool_do_auth: maybe protocol version mismatch (current version 3)</font></div></div><div><font face="monospace, monospace"><br></font></div></blockquote><font face="arial, helvetica, sans-serif">I was expecting this (direct connection to PostgreSQL):</font><br><blockquote style="margin:0px 0px 0px 40px;border:none;padding:0px"><div><font face="monospace, monospace"><br></font></div><div><font face="monospace, monospace"><div><div>-bash-4.1$ psql -h 192.168.3.190 -U replication postgress</div><div>psql.bin: FATAL: no pg_hba.conf entry for host "192.168.3.190", user "replication", database "postgress", SSL on</div><div>FATAL: no pg_hba.conf entry for host "192.168.3.190", user "replication", database "postgress", SSL off</div></div><div><br></div></font></div></blockquote><font face="arial, helvetica, sans-serif">When I look at the logs for PostgreSQL (for the PGPool connection) it seems like it's doing the right thing:</font><div><font face="monospace, monospace"><br></font></div><blockquote style="margin:0px 0px 0px 40px;border:none;padding:0px"><div><font face="monospace, monospace">2015-08-27 17:21:47 EST [25254]: [1-1] user=replication,db=postgress,client=192.168.3.193 192.168.3.193(51321) (0:28000)FATAL: no pg_hba.conf entry for host "192.168.3.193", user "replication", database "postgress", SSL off<br></font></div></blockquote><div><blockquote style="margin:0px 0px 0px 40px;border:none;padding:0px"><div><font face="monospace, monospace"><div><br></div></font></div><div><font face="monospace, monospace"><br></font></div></blockquote><font face="arial, helvetica, sans-serif"><div>Cheers,<br></div></font><div><div><div class="gmail_signature"><div style="color:rgb(184,39,106);font-weight:bold;font-style:normal;font-variant:normal;font-stretch:normal;font-size:14px;line-height:normal;font-family:Arial,Helvetica,sans-serif">
<br>
<span style="color:rgb(50,59,98)">James Sewell,</span><br>
<span style="color:rgb(169,169,169)"><span style="font-style:normal;font-variant:normal;font-weight:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Arial,Helvetica,sans-serif">PostgreSQL Team Lead / Solutions Architect </span></span><br>
<span style="color:rgb(169,169,169)">______________________________________</span><br>
</div>
<img alt="" src="http://www.lisasoft.com/sites/lisasoft/files/u1/logo1.jpg" style="margin: 0px; width: 153px; height: 50px;"><br>
<div style="font-style:normal;font-variant:normal;font-weight:normal;font-stretch:normal;font-size:12px;line-height:20px;font-family:Arial,Helvetica,sans-serif;color:rgb(64,64,64);margin:0px">
<span style="color:rgb(169,169,169)">Level 2, 50 Queen St, Melbourne VIC 3000</span><br>
<br>
<strong>P </strong><span style="color:rgb(169,169,169)"><span style="font-family:Arial,Verdana,sans-serif">(+61) 3 8370 8000</span></span><span style="color:rgb(169,169,169)"> </span><strong> </strong><span style="color:rgb(50,59,98)"><span style="width:15px;display:inline-block"><strong>W</strong></span></span> <a style="color:rgb(64,64,64);margin:2px 0px;text-decoration:none"><span style="color:rgb(169,169,169)">www.lisasoft.com</span></a> <span style="color:rgb(50,59,98)"><span style="width:15px;display:inline-block"><strong>F </strong></span></span><span style="color:rgb(169,169,169)"><span style="font-family:Arial,Verdana,sans-serif">(+61) 3 8370 8099</span></span></div>
<div style="padding-top:8px">
</div></div></div>
</div></div></div></div>
<br>
<p><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:14.545454025268555px;background-color:rgb(255,255,255)"><hr><font size="1" color="Gray" face="Arial">The contents of this email are confidential and may be subject to legal or professional privilege and copyright. No representation is made that this email is free of viruses or other defects. If you have received this communication in error, you may not copy or distribute any part of it or otherwise disclose its contents to anyone. Please advise the sender of your incorrect receipt of this correspondence.</font></div></p>