<div dir="ltr"><div><span style="font-size:12.8000001907349px"><br></span></div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, May 7, 2015 at 7:30 PM, Megan . <span dir="ltr"><<a href="mailto:nagemnna@gmail.com" target="_blank">nagemnna@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">Thanks for your reply.<br>
<br>
I have it set to log: client_min_messages = log<br>
<br></blockquote><span style="font-size:12.8000001907349px">client_min_messages = log should be fine, but still to be sure, can you please try restoring it to default value (i.e</span><span style="font-size:12.8000001907349px"> client_min_messages = </span><span style="font-size:12.8000001907349px"> notice) and check if it works.</span><div><span style="font-size:12.8000001907349px">And are you getting any authentication failure messages in postgresql server log?</span></div><div><span style="font-size:12.8000001907349px"><br></span></div><div><span style="font-size:12.8000001907349px">Thanks and regards</span></div><div><span style="font-size:12.8000001907349px">Muhammad Usama</span></div><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
Is this an issue?<br>
<br>
Thanks.<br>
<div><div><br>
On Thu, May 7, 2015 at 8:48 AM, Muhammad Usama <<a href="mailto:m.usama@gmail.com" target="_blank">m.usama@gmail.com</a>> wrote:<br>
> Hi<br>
><br>
> Can you check the value of PostgreSQL's client_min_messages configuration in<br>
> postgresql.conf.<br>
> Looking at the code it appears that if client_min_messages in PG's<br>
> configuration is set to some level of DEBUG.., it could cause this issue.<br>
><br>
> Thanks<br>
> Best regards<br>
> Muhammad Usama<br>
><br>
> On Wed, May 6, 2015 at 9:59 PM, Megan . <<a href="mailto:nagemnna@gmail.com" target="_blank">nagemnna@gmail.com</a>> wrote:<br>
>><br>
>> Good Day all,<br>
>><br>
>> I am having some problems with pgpool authentication. I just setup<br>
>> this db server.<br>
>><br>
>> Centos 6.6<br>
>> pgpool-II-93-3.4.1-1.rhel6.x86_64<br>
>> postgresql93-server-9.3.6-1PGDG.rhel6.x86_64<br>
>><br>
>> I am running pgpool in mater/slave mode with postgres running<br>
>> streaming replication<br>
>><br>
>><br>
>> When trying to connect into pgpool i get the below error:<br>
>><br>
>> [user@mgmt1 ~]$ psql -h x.x.x.175 -p 9999 -U dbuser dbuser<br>
>> Password for user dbuser:<br>
>> psql: ERROR: authentication failed<br>
>> DETAIL: invalid backend response. Response does not replied with "R"<br>
>><br>
>> [user@mgmt1 ~]$ hostname -i<br>
>> x.x.x.173<br>
>><br>
>><br>
>> .175 address is the floating IP address configured for pgpool.<br>
>><br>
>> I made sure that I had the md5 password the same in the DB as in the<br>
>> pool_passwd file. I made sure both hba files were using md5. Below<br>
>> are my config files. Any suggestions on how to figure out what is<br>
>> wrong are greatly appreciated.<br>
>><br>
>><br>
>><br>
>><br>
>> My pool_hba.conf<br>
>><br>
>> # IPv4 local connections:<br>
>> host all all <a href="http://127.0.0.1/32" target="_blank">127.0.0.1/32</a> trust<br>
>> host postgres postgres x.x.x.177/32 trust<br>
>> host postgres postgres x.x.x.176/32 trust<br>
>> host postgres postgres x.x.x.175/32 trust<br>
>> host postgres postgres x.x.x.173/32 trust<br>
>> #mgmt1-pro<br>
>> host dbuser dbuser x.x.x.173/32 md5<br>
>> #admin1-prod<br>
>> host dbuser dbuser x.x.x.171/32 md5<br>
>> host dbuser dbuser x.x.x.175/32 md5<br>
>><br>
>><br>
>> cat pool_passwd<br>
>> dbuser:md5112ee5fd83c53bed5e51897dcfb1e626<br>
>><br>
>><br>
>> [root@db1 data]# cat pg_hba.conf<br>
>> # TYPE DATABASE USER ADDRESS METHOD<br>
>> ##local postgres user<br>
>> local all postgres trust<br>
>> ##for pgpool<br>
>> host postgres health_check x.x.x.176/32 trust<br>
>> host postgres health_check x.x.x.177/32 trust<br>
>> #pgpool failover<br>
>> local postgres pgp_fail trust<br>
>> local postgres pgp_fail trust<br>
>> host all all <a href="http://127.0.0.1/32" target="_blank">127.0.0.1/32</a> md5<br>
>> ##replication user<br>
>> host replication repli_user x.x.x.177/32 md5<br>
>> host replication repli_user x.x.x.176/32 md5<br>
>> #other db host<br>
>> host postgres postgres x.x.x.177/32 trust<br>
>> host postgres postgres x.x.x.176/32 trust<br>
>> #local dbuser dbuser md5<br>
>> ##build host for non pgpool connection<br>
>> host dbuser dbuser x.x.x.28/32 md5<br>
>> ##for dbuser through pgpool<br>
>> host dbuser dbuser x.x.x.177/32 md5<br>
>> host dbuser dbuser x.x.x.176/32 md5<br>
>> host dbuser dbuser x.x.x.175/32 md5<br>
>> host postgres postgres x.x.x.173/32 md5<br>
>> host dbuser dbuser x.x.x.173/32 md5<br>
>><br>
>><br>
>><br>
>> postgres=# select passwd from pg_shadow where usename = 'dbuser';<br>
>> passwd<br>
>> -------------------------------------<br>
>> md5112ee5fd83c53bed5e51897dcfb1e626<br>
>> (1 row)<br>
>><br>
>><br>
>><br>
>><br>
>> Part from the pgpool debug:<br>
>><br>
>> 2015-05-06 16:56:49: pid 2399: user [No Connection]:DEBUG: I am 2399<br>
>> accept fd 8<br>
>> 2015-05-06 16:56:49: pid 2399: user [No Connection]:LOG: new<br>
>> connection received<br>
>> 2015-05-06 16:56:49: pid 2399: user [No Connection]:DETAIL:<br>
>> connecting host=<a href="http://mgmt1.example.com" target="_blank">mgmt1.example.com</a> port=39541<br>
>> 2015-05-06 16:56:49: pid 2399: user [No Connection]:DEBUG: reading<br>
>> startup packet<br>
>> 2015-05-06 16:56:49: pid 2399: user [No Connection]:DETAIL: Protocol<br>
>> Major: 1234 Minor: 5679 database: user:<br>
>> 2015-05-06 16:56:49: pid 2399: user [No Connection]:DEBUG: selecting<br>
>> backend connection<br>
>> 2015-05-06 16:56:49: pid 2399: user [No Connection]:DETAIL:<br>
>> SSLRequest from client<br>
>> 2015-05-06 16:56:49: pid 2399: user [No Connection]:DEBUG: reading<br>
>> startup packet<br>
>> 2015-05-06 16:56:49: pid 2399: user [No Connection]:DETAIL: Protocol<br>
>> Major: 3 Minor: 0 database: dbuser user: dbuser<br>
>> 2015-05-06 16:56:49: pid 2399: user [No Connection]:DEBUG: creating<br>
>> new connection to backend<br>
>> 2015-05-06 16:56:49: pid 2399: user [No Connection]:DETAIL:<br>
>> connecting 0 backend<br>
>> 2015-05-06 16:56:49: pid 2399: user [No Connection]:DEBUG: creating<br>
>> new connection to backend<br>
>> 2015-05-06 16:56:49: pid 2399: user [No Connection]:DETAIL: skipping<br>
>> backend slot 0 because backend_status = 3<br>
>> 2015-05-06 16:56:49: pid 2399: user [No Connection]:DEBUG: creating<br>
>> new connection to backend<br>
>> 2015-05-06 16:56:49: pid 2399: user [No Connection]:DETAIL:<br>
>> connecting 1 backend<br>
>> 2015-05-06 16:56:49: pid 2399: user [No Connection]:DEBUG: reading<br>
>> message length<br>
>> 2015-05-06 16:56:49: pid 2399: user [No Connection]:DETAIL: slot: 1<br>
>> length: 12<br>
>> 2015-05-06 16:56:49: pid 2399: user [No Connection]:DEBUG:<br>
>> authentication backend<br>
>> 2015-05-06 16:56:49: pid 2399: user [No Connection]:DETAIL: auth kind:5<br>
>> 2015-05-06 16:56:49: pid 2399: user [No Connection]:DEBUG:<br>
>> authentication backend<br>
>> 2015-05-06 16:56:49: pid 2399: user [No Connection]:DETAIL: trying<br>
>> md5 authentication<br>
>> 2015-05-06 16:56:49: pid 2399: user [No Connection]:DEBUG: performing<br>
>> md5 authentication<br>
>> 2015-05-06 16:56:49: pid 2399: user [No Connection]:DETAIL: DB node<br>
>> id: 1 salt: ffffffa64ffffff8432<br>
>> 2015-05-06 16:56:49: pid 2399: user [No Connection]:ERROR:<br>
>> authentication failed<br>
>> 2015-05-06 16:56:49: pid 2399: user [No Connection]:DETAIL: invalid<br>
>> backend response. Response does not replied with "R"<br>
>> _______________________________________________<br>
>> pgpool-general mailing list<br>
>> <a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br>
>> <a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
><br>
><br>
</div></div></blockquote></div><br></div></div>