<div dir="ltr"><div dir="ltr">Hi Ishii-San<div><br></div><div>Can you please try the attached fix if it works.</div><div><br></div><div>Thanks</div><div>Best Regards</div><div>Muhammad Usama</div><div><br></div><div><br></div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Aug 9, 2019 at 11:26 AM Muhammad Usama <<a href="mailto:m.usama@gmail.com">m.usama@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div>Hi Ishii-San</div><div><br></div><div>I am looking into this one.</div><div><br></div><div>Thanks</div><div>Best Regards</div><div>Muhammad Usama</div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Aug 9, 2019 at 8:34 AM Tatsuo Ishii <<a href="mailto:ishii@sraoss.co.jp" target="_blank">ishii@sraoss.co.jp</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hi Usama,<br>
<br>
While investigating:<br>
<br>
<a href="https://www.pgpool.net/mantisbt/view.php?id=534" rel="noreferrer" target="_blank">https://www.pgpool.net/mantisbt/view.php?id=534</a><br>
<br>
I think there might be a issue with allow_clear_text_frontend_auth in<br>
certain case.<br>
<br>
1) allow_clear_text_frontend_auth = on<br>
2) user set md5 password in PostgreSQL<br>
3) user set "password", instead of "md5" in pg_hba.conf<br>
<br>
If all the conditions above are met, Pgpool-II always fails with<br>
authentication.<br>
<br>
2019-08-06 13:57:45: pid 16823: FATAL: clear text password authentication failed<br>
2019-08-06 13:57:45: pid 16823: DETAIL: unable to get the password for user: "postgres"<br>
2019-08-06 13:57:45: pid 16823: LOCATION: pool_auth.c:1018<br>
2019-08-06 13:57:45: pid 16823: DEBUG: pool_write: to frontend: kind:E po:0<br>
2019-08-06 13:57:45: pid 16823: LOCATION: pool_stream.c:461<br>
<br>
The setting is above is valid and in fact if directly connecting to<br>
PostgreSQL, auth succeeds.<br>
<br>
Best regards,<br>
--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php" rel="noreferrer" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
Japanese:<a href="http://www.sraoss.co.jp" rel="noreferrer" target="_blank">http://www.sraoss.co.jp</a><br>
</blockquote></div></div>
</blockquote></div></div>