<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
text-align:right;
direction:rtl;
unicode-bidi:embed;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed"><a name="_MailEndCompose"><span style="color:#1F497D">I *<b>believe</b>* (although I’m not certain) that you have to configure pgpool -> postgres as trust, and appserver -> pgpool
as md5. That’s what I’ve done in my installation here. There may be other ways…perhaps someone else will chime in.<o:p></o:p></span></a></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed"><span style="mso-bookmark:_MailEndCompose"><span style="color:#1F497D"><o:p> </o:p></span></span></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed"><span style="mso-bookmark:_MailEndCompose"><span style="color:#1F497D">HTH,<o:p></o:p></span></span></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed"><span style="mso-bookmark:_MailEndCompose"><span style="color:#1F497D"><o:p> </o:p></span></span></p>
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="1086" style="width:407.25pt">
<tbody>
<tr>
<td colspan="3" style="padding:0in 0in 0in 0in">
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed"><span style="mso-bookmark:_MailEndCompose"><span style="color:#1F497D"><img width="1086" height="140" id="Picture_x0020_1" src="cid:image005.png@01D244C4.AD102180" alt="banner2"></span></span><span style="mso-bookmark:_MailEndCompose"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#1F497D"><o:p></o:p></span></span></p>
</td>
<span style="mso-bookmark:_MailEndCompose"></span>
</tr>
<tr style="height:7.5pt">
<td style="padding:0in 0in 0in 0in;height:7.5pt">
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed"><span style="mso-bookmark:_MailEndCompose"><span style="font-size:1.0pt;font-family:"Times New Roman",serif;color:#1F497D"> <o:p></o:p></span></span></p>
</td>
<span style="mso-bookmark:_MailEndCompose"></span>
<td style="padding:0in 0in 0in 0in;height:7.5pt"><span style="mso-bookmark:_MailEndCompose"></span></td>
<span style="mso-bookmark:_MailEndCompose"></span>
<td style="padding:0in 0in 0in 0in;height:7.5pt"><span style="mso-bookmark:_MailEndCompose"></span></td>
<span style="mso-bookmark:_MailEndCompose"></span>
</tr>
<tr>
<td nowrap="" valign="top" style="padding:0in 0in 0in .25in">
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed"><span style="mso-bookmark:_MailEndCompose"><b><span style="font-size:8.5pt;font-family:"Arial",sans-serif;color:#666666">David Sisk</span></b></span><span style="mso-bookmark:_MailEndCompose"><span style="font-size:8.5pt;font-family:"Arial",sans-serif;color:#666666"><o:p></o:p></span></span></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed"><span style="mso-bookmark:_MailEndCompose"><span style="font-size:8.5pt;font-family:"Arial",sans-serif;color:#666666">Engineer - Software<o:p></o:p></span></span></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed"><span style="mso-bookmark:_MailEndCompose"></span><a href="mailto:dsisk@cisco.com"><span style="mso-bookmark:_MailEndCompose"><span style="font-size:8.5pt;font-family:"Arial",sans-serif;color:#666666;text-decoration:none">dsisk@cisco.com</span></span></a><span style="mso-bookmark:_MailEndCompose"><span style="color:#1F497D"><o:p></o:p></span></span></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed"><span style="mso-bookmark:_MailEndCompose"><span style="font-size:8.5pt;font-family:"Arial",sans-serif;color:#666666">Tel:
<o:p></o:p></span></span></p>
</td>
<span style="mso-bookmark:_MailEndCompose"></span>
<td width="550" valign="top" style="width:206.25pt;padding:0in 0in 0in 15.0pt">
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed"><span style="mso-bookmark:_MailEndCompose"><b><span style="font-size:8.5pt;font-family:"Arial",sans-serif;color:#666666">Cisco Systems, Inc.<o:p></o:p></span></b></span></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed"><span style="mso-bookmark:_MailEndCompose"><span style="font-size:8.5pt;font-family:"Arial",sans-serif;color:#666666">7025-6 Kit Creek Road PO Box 14987<br>
RESEARCH TRIANGLE PARK<br>
27709-4987<br>
United States<br>
cisco.com<o:p></o:p></span></span></p>
</td>
<span style="mso-bookmark:_MailEndCompose"></span>
<td style="padding:0in 0in 0in 0in"><span style="mso-bookmark:_MailEndCompose"></span></td>
<span style="mso-bookmark:_MailEndCompose"></span>
</tr>
</tbody>
</table>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed"><span style="mso-bookmark:_MailEndCompose"><span lang="EN-GB" style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#1F497D;display:none"><o:p> </o:p></span></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="800" style="width:300.0pt">
<tbody>
<tr>
<td style="padding:0in 15.0pt 0in .25in">
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed"><span style="mso-bookmark:_MailEndCompose"><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#009900"><img border="0" width="36" height="38" id="Picture_x0020_3" src="cid:image006.png@01D244C4.AD102180" alt="http://www.cisco.com/assets/swa/img/thinkbeforeyouprint.gif">Think
before you print.<o:p></o:p></span></span></p>
</td>
<span style="mso-bookmark:_MailEndCompose"></span>
</tr>
<tr>
<td style="padding:0in 15.0pt 0in .25in">
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed"><span style="mso-bookmark:_MailEndCompose"><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#999999">This email may contain confidential and privileged material for
the sole use of the intended recipient. Any review, use, distribution or disclosure by others is strictly prohibited. If you are not the intended recipient (or authorized to receive for the recipient), please contact the sender by reply email and delete all
copies of this message.<o:p></o:p></span></span></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed"><span style="mso-bookmark:_MailEndCompose"><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#999999">Please
</span></span><a href="http://www.cisco.com/web/about/doing_business/legal/cri/index.html" title="Legal Information"><span style="mso-bookmark:_MailEndCompose"><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#0E58A0">click here</span></span><span style="mso-bookmark:_MailEndCompose"></span></a><span style="mso-bookmark:_MailEndCompose"><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#999999">
for Company Registration Information.<o:p></o:p></span></span></p>
</td>
<span style="mso-bookmark:_MailEndCompose"></span>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed"><span style="mso-bookmark:_MailEndCompose"><span style="color:#1F497D"><o:p> </o:p></span></span></p>
<span style="mso-bookmark:_MailEndCompose"></span>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed"><b>From:</b> pgpool-general-bounces@pgpool.net [mailto:pgpool-general-bounces@pgpool.net]
<b>On Behalf Of </b>Avi Weinberg<br>
<b>Sent:</b> Sunday, November 20, 2016 11:38 AM<br>
<b>To:</b> pgpool-general@pgpool.net<br>
<b>Subject:</b> [pgpool-general: 5129] md5 authentication<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed"><o:p> </o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">Hi Experts<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed"><o:p> </o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed"><o:p> </o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">I have in both pool_hba.conf and pg_hba.conf authentication method md5. I have password file pool_passwd defined with user postgres and I also have user password file for postgres
".pgpass". <o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">If I connect using port 5432 all works well
<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed"><o:p> </o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">If I connect using port 9999 I'm getting this error<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed"><o:p> </o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">[root@h2-nms pgpool]# psql -Upostgres -h 172.18.255.40 -p9999<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">psql: server closed the connection unexpectedly<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed"> This probably means the server terminated abnormally<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed"> before or while processing the request.<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed"><o:p> </o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">If I change pg_hba.conf to trust it works well again.
<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed"><o:p> </o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">What am I missing?<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed"><o:p> </o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">Thanks<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">Avi<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed"><span style="font-size:12.0pt;font-family:"Times New Roman",serif">IMPORTANT - This email and any attachments is intended for the above named addressee(s), and may contain information
which is confidential or privileged. If you are not the intended recipient, please inform the sender immediately and delete this email: you should not copy or use this e-mail for any purpose nor disclose its contents to any person.
<o:p></o:p></span></p>
</div>
</body>
</html>