<div dir="ltr">Hi<br><br>Can you check the value of PostgreSQL's <i>client_min_messages</i> configuration in postgresql.conf.<div>Looking at the code it appears that if client_min_messages in PG's configuration is set to some level of DEBUG.., it could cause this issue.</div><div><br></div><div>Thanks</div><div>Best regards</div><div>Muhammad Usama</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, May 6, 2015 at 9:59 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:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">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 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">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>
</blockquote></div><br></div>