<div dir="ltr"><div>Hi Ishii-San</div><div><br></div><div>Thanks for confirming the fix. I have committed the patch in master and 4.1 branches after making the suggested change.</div><div><br></div><div>Best regards<br></div><div>Muhammad Usama</div><div><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Sat, Aug 17, 2019 at 6:19 AM Tatsuo Ishii <<a href="mailto:ishii@sraoss.co.jp">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">Thank you Usama.<br>
<br>
Your fix works great!<br>
<br>
BTW, I have changed around line 1035:<br>
<br>
ereport(DEBUG,<br>
(errmsg("using clear text authentication with frontend"),<br>
errdetail("backend is using password authentication")));<br>
<br>
"DEBUG" to "DEBUG1".<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>
<br>
From: Muhammad Usama <<a href="mailto:m.usama@gmail.com" target="_blank">m.usama@gmail.com</a>><br>
Subject: Re: allow_clear_text_frontend_auth sometimes does not work<br>
Date: Fri, 16 Aug 2019 18:57:21 +0500<br>
Message-ID: <<a href="mailto:CAEJvTzX0MZ7TCd7nsyvWc9PSpXn24tjGGNckD7vi-2bj35HkUQ@mail.gmail.com" target="_blank">CAEJvTzX0MZ7TCd7nsyvWc9PSpXn24tjGGNckD7vi-2bj35HkUQ@mail.gmail.com</a>><br>
<br>
> Hi Ishii-San<br>
> <br>
> Can you please try the attached fix if it works.<br>
> <br>
> Thanks<br>
> Best Regards<br>
> Muhammad Usama<br>
> <br>
> <br>
> <br>
> <br>
> On Fri, Aug 9, 2019 at 11:26 AM Muhammad Usama <<a href="mailto:m.usama@gmail.com" target="_blank">m.usama@gmail.com</a>> wrote:<br>
> <br>
>> Hi Ishii-San<br>
>><br>
>> I am looking into this one.<br>
>><br>
>> Thanks<br>
>> Best Regards<br>
>> Muhammad Usama<br>
>><br>
>> 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>
>><br>
>>> 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<br>
>>> failed<br>
>>> 2019-08-06 13:57:45: pid 16823: DETAIL: unable to get the password for<br>
>>> 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<br>
>>> 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>
>>><br>
>><br>
</blockquote></div></div>