<div dir="ltr">Hi Tatsuo,<div><br></div><div>Sorry for adding one more question,</div><div>regardless of previous case i have one more confusion:</div><div>Suppose <font color="#555555"><span style="letter-spacing:0.2px;white-space:nowrap">enable_pool_hba = off and at DB level we are doing authentication, so in case for cached connection (pgpool to DB), how pgpool authorized client because in that case connection is already there between pgpool to DB<br><br></span></font></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Jul 10, 2019 at 12:20 PM temp temp <<a href="mailto:ttemp666@gmail.com">ttemp666@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">Hi Tatsuo,<div><br></div><div>PostgreSQL is running on 192.168.1.103</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Jul 10, 2019 at 11:59 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">What is the IP address of the host which PostgreSQL is running on?<br>
(I assume that Pgpool-II is running on 192.168.1.233).<br>
<br>
> Hi Tatsuo,<br>
> <br>
> When i directly connect to PostgreSQL, it does ask for password<br>
> <br>
> On Wed, Jul 10, 2019 at 3:54 AM Tatsuo Ishii <<a href="mailto:ishii@sraoss.co.jp" target="_blank">ishii@sraoss.co.jp</a>> wrote:<br>
> <br>
>> > ---------- Forwarded message ---------<br>
>> > From: temp temp <<a href="mailto:ttemp666@gmail.com" target="_blank">ttemp666@gmail.com</a>><br>
>> > Date: Tue, Jul 9, 2019 at 10:38 PM<br>
>> > Subject: Re: [pgpool-general: 6626] pgpool Authentication<br>
>> > To: Tatsuo Ishii <<a href="mailto:ishii@sraoss.co.jp" target="_blank">ishii@sraoss.co.jp</a>><br>
>> ><br>
>> ><br>
>> >> Regarding pgpool authentication (pgpool 4.2)<br>
>> >><br>
>> >> >There's no such a version "4.2". You mean 4.0?<br>
>> >> My mistake, its 4.0<br>
>> >><br>
>> >> > Configuration are<br>
>> >> ><br>
>> >> > pgpool.conf<br>
>> >> > enable_pool_hba = on<br>
>> >> ><br>
>> >> > pool_hba.conf<br>
>> >> > host all all all md5<br>
>> >> > local all all md5<br>
>> >><br>
>> >> >What is your pg_hba.conf?<br>
>> >><br>
>> >> > pool_passwd<br>
>> >> > postgres: "someValue"<br>
>> >> > mpspostgres: "someValue"<br>
>> >> ><br>
>> >> > When i tried to connection to pgpool (with password as "someValue")<br>
>> >> > psql -U mpsroot -p 5432 -h 192.168.1.233 mpsdb<br>
>> >> ><br>
>> >> > Que 1 :I am successfully able to connection even though password for<br>
>> >> > mpsroot user is not present in pool_passwd file and axxording to<br>
>> >> ><br>
>> >> ><br>
>> >><br>
>> <a href="https://pgpool.net/mediawiki/index.php/FAQ#I_created_pool_hba.conf_and_pool_passwd_to_enable_md5_authentication_through_pgpool-II_but_it_does_not_work._Why.3F" rel="noreferrer" target="_blank">https://pgpool.net/mediawiki/index.php/FAQ#I_created_pool_hba.conf_and_pool_passwd_to_enable_md5_authentication_through_pgpool-II_but_it_does_not_work._Why.3F</a><br>
>> >> > Auth should fail<br>
>> >><br>
>> >> >Probably you are of the pattern in the FAQ above.<br>
>> >><br>
>> >> >pg_hba.conf pool_hba.conf pool_passwd result<br>
>> >> >------------------------------------------------------<br>
>> >> >trust md5 yes no auth<br>
>> >><br>
>> >> I don't think above pattern is hit, because i don't have password<br>
>> mpsroot<br>
>> >> in pool_passwd<br>
>> >><br>
>> >> >If not, please share pg_hba.conf.<br>
>> >><br>
>> >> pg_hba.conf<br>
>> >><br>
>> >> local all all trust<br>
>> >> host all all <a href="http://127.0.0.1/32" rel="noreferrer" target="_blank">127.0.0.1/32</a> md5<br>
>> >> host all all <a href="http://0.0.0.0/0" rel="noreferrer" target="_blank">0.0.0.0/0</a> md5<br>
>> >> host replication primaryuser <a href="http://0.0.0.0/0" rel="noreferrer" target="_blank">0.0.0.0/0</a> md5<br>
>><br>
>> When you directly connect to PostgreSQL (no via Pgpool-II), does<br>
>> PostgreSQL ask password?<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>
</blockquote></div>
</blockquote></div>