<div dir="ltr"><div>Hello Michael,</div><div><br></div>How did you generate pool_passwd? The passwords have to start with md5, e.g.<div>user1:md5kjsdhfkjef38389he</div><div>user2:md58hljhfj3kfjdhfkjshdf</div><div>You have to use command pg_md5 --md5auth when creating entries in pool_passwd</div><div><br></div><div>Regards,</div><div>Vlad</div>
</div><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Oct 17, 2016 at 7:15 AM, Bezas, Michael <span dir="ltr"><<a href="mailto:michael.bezas@credit-suisse.com" target="_blank">michael.bezas@credit-suisse.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="EN-GB" link="blue" vlink="purple">
<div class="m_99513570739169912WordSection1">
<p class="m_99513570739169912MsoPlainText">Hi I seem to have pcp auth error - any help would be greatly appreciated. I had this working previously but seems to have stopped…<u></u><u></u></p>
<p class="m_99513570739169912MsoPlainText"><u></u> <u></u></p>
<p class="m_99513570739169912MsoPlainText">I have turned off pool_hba - yet I get this error?<u></u><u></u></p>
<p class="m_99513570739169912MsoPlainText"><u></u> <u></u></p>
<p class="m_99513570739169912MsoPlainText">postgres@-:~> <b>pcp_attach_node -d 10 localhost 9040 postgres postgres 1<u></u><u></u></b></p>
<p class="m_99513570739169912MsoPlainText">DEBUG: send: tos="R", len=46<u></u><u></u></p>
<p class="m_99513570739169912MsoPlainText">DEBUG: recv: tos="r", len=63, data=AuthenticationFailed<u></u><u></u></p>
<p class="m_99513570739169912MsoPlainText">DEBUG: authentication failed. reason=AuthenticationFailed<u></u><u></u></p>
<p class="m_99513570739169912MsoPlainText">AuthorizationError<u></u><u></u></p>
<p class="m_99513570739169912MsoPlainText"><u></u> <u></u></p>
<p class="m_99513570739169912MsoPlainText">pgpool.conf - config<u></u><u></u></p>
<p class="m_99513570739169912MsoPlainText"># - Authentication -<u></u><u></u></p>
<p class="m_99513570739169912MsoPlainText">enable_pool_hba = off<u></u><u></u></p>
<p class="m_99513570739169912MsoPlainText">pool_passwd = 'pool_passwd'<u></u><u></u></p>
<p class="m_99513570739169912MsoPlainText"><u></u> <u></u></p>
<p class="m_99513570739169912MsoPlainText">pcp.conf - config<u></u><u></u></p>
<p class="m_99513570739169912MsoPlainText"># USERID:MD5PASSWD<u></u><u></u></p>
<p class="m_99513570739169912MsoPlainText">postgres:<wbr>e8a48653851e28c69d0506508fb27f<wbr>c5<u></u><u></u></p>
<p class="m_99513570739169912MsoPlainText"><u></u> <u></u></p>
<p class="m_99513570739169912MsoPlainText">pool_passwd - config<u></u><u></u></p>
<p class="m_99513570739169912MsoPlainText">postgres:<wbr>8e40e89c8c95a050dcadea2d7e4d40<wbr>cc<u></u><u></u></p>
<p class="m_99513570739169912MsoPlainText"><u></u> <u></u></p>
<p class="m_99513570739169912MsoPlainText">pool_hba.conf - config<u></u><u></u></p>
<p class="m_99513570739169912MsoPlainText"># "local" is for Unix domain socket connections only<u></u><u></u></p>
<p class="m_99513570739169912MsoPlainText">local all all <wbr> trust<u></u><u></u></p>
<p class="m_99513570739169912MsoPlainText"># IPv4 local connections:<u></u><u></u></p>
<p class="m_99513570739169912MsoPlainText">host all all xx.xx.xx.xx/32 trust<u></u><u></u></p>
<p class="m_99513570739169912MsoPlainText">host postgres postgres xx.xx.xx.xx /32 trust<u></u><u></u></p>
<p class="m_99513570739169912MsoPlainText"><u></u> <u></u></p>
<p class="m_99513570739169912MsoPlainText">Regards<u></u><u></u></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
</div>
<br>
<br><u></u><p class="MsoNormal"><span lang="EN-US" style="font-size:8.0pt;font-family:Courier">==============================<wbr>==============================<wbr>==================<br>Please access the attached hyperlink for an important electronic communications disclaimer:<br><a href="http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html" target="_blank">http://www.credit-suisse.com/<wbr>legal/en/disclaimer_email_ib.<wbr>html</a><br>==============================<wbr>==============================<wbr>==================<u></u><u></u></span></p></div>
<br>______________________________<wbr>_________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" rel="noreferrer" target="_blank">http://www.pgpool.net/mailman/<wbr>listinfo/pgpool-general</a><br>
<br></blockquote></div><br></div>