<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">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>