<div dir="ltr"><br><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">---------- Forwarded message ---------<br>From: <strong class="gmail_sendername" dir="auto">temp temp</strong> <span dir="auto"><<a href="mailto:ttemp666@gmail.com">ttemp666@gmail.com</a>></span><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">ishii@sraoss.co.jp</a>><br></div><br><br><div dir="ltr"><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">> 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>> <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" 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 mpsroot 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" target="_blank">127.0.0.1/32</a> md5<br>host all all <a href="http://0.0.0.0/0" target="_blank">0.0.0.0/0</a> md5<br>host replication primaryuser <a href="http://0.0.0.0/0" target="_blank">0.0.0.0/0</a> md5<br><br><br><br>Thanks for clarifying my all question. <br><br>
</blockquote></div></div>
</div></div>