[pgpool-general: 3687] Re: DETAIL: invalid backend response. Response does not replied with "R"

Muhammad Usama m.usama at gmail.com
Thu May 7 21:48:56 JST 2015


Hi

Can you check the value of PostgreSQL's *client_min_messages* configuration
in postgresql.conf.
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.

Thanks
Best regards
Muhammad Usama

On Wed, May 6, 2015 at 9:59 PM, Megan . <nagemnna at gmail.com> wrote:

> Good Day all,
>
> I am having some problems with pgpool authentication.  I just setup
> this db server.
>
> Centos 6.6
> pgpool-II-93-3.4.1-1.rhel6.x86_64
> postgresql93-server-9.3.6-1PGDG.rhel6.x86_64
>
> I am running pgpool in mater/slave mode with postgres running
> streaming replication
>
>
> When trying to connect into pgpool i get the below error:
>
> [user at mgmt1 ~]$ psql -h x.x.x.175 -p 9999 -U dbuser dbuser
> Password for user dbuser:
> psql: ERROR:  authentication failed
> DETAIL:  invalid backend response. Response does not replied with "R"
>
> [user at mgmt1 ~]$ hostname -i
> x.x.x.173
>
>
> .175 address is the floating IP address configured for pgpool.
>
> I made sure that I had the md5 password the same in the DB as in the
> pool_passwd file.  I made sure both hba files were using md5. Below
> are my config files.  Any suggestions on how to figure out what is
> wrong are greatly appreciated.
>
>
>
>
> My pool_hba.conf
>
> # IPv4 local connections:
> host    all         all         127.0.0.1/32          trust
> host    postgres        postgres        x.x.x.177/32        trust
> host    postgres        postgres        x.x.x.176/32        trust
> host    postgres        postgres        x.x.x.175/32        trust
> host    postgres          postgres        x.x.x.173/32        trust
> #mgmt1-pro
> host dbuser          dbuser         x.x.x.173/32          md5
> #admin1-prod
> host    dbuser             dbuser             x.x.x.171/32         md5
> host dbuser          dbuser          x.x.x.175/32          md5
>
>
> cat pool_passwd
> dbuser:md5112ee5fd83c53bed5e51897dcfb1e626
>
>
> [root at db1 data]# cat pg_hba.conf
> # TYPE  DATABASE        USER            ADDRESS                 METHOD
> ##local postgres user
> local   all             postgres                                     trust
> ##for pgpool
> host    postgres        health_check        x.x.x.176/32        trust
> host    postgres        health_check        x.x.x.177/32        trust
> #pgpool failover
> local    postgres        pgp_fail                trust
> local    postgres        pgp_fail               trust
> host    all             all             127.0.0.1/32            md5
> ##replication user
> host    replication     repli_user     x.x.x.177/32        md5
> host    replication     repli_user     x.x.x.176/32        md5
> #other db host
> host    postgres        postgres        x.x.x.177/32        trust
> host    postgres        postgres        x.x.x.176/32        trust
> #local   dbuser     dbuser                             md5
> ##build host for non pgpool connection
> host    dbuser     dbuser     x.x.x.28/32     md5
> ##for dbuser through pgpool
> host   dbuser              dbuser          x.x.x.177/32        md5
> host   dbuser              dbuser          x.x.x.176/32        md5
> host    dbuser             dbuser             x.x.x.175/32       md5
> host postgres postgres x.x.x.173/32 md5
> host dbuser dbuser x.x.x.173/32        md5
>
>
>
> postgres=# select passwd from pg_shadow where usename = 'dbuser';
>                passwd
> -------------------------------------
>  md5112ee5fd83c53bed5e51897dcfb1e626
> (1 row)
>
>
>
>
> Part from the pgpool debug:
>
> 2015-05-06 16:56:49: pid 2399: user [No Connection]:DEBUG:  I am 2399
> accept fd 8
> 2015-05-06 16:56:49: pid 2399: user [No Connection]:LOG:  new
> connection received
> 2015-05-06 16:56:49: pid 2399: user [No Connection]:DETAIL:
> connecting host=mgmt1.example.com port=39541
> 2015-05-06 16:56:49: pid 2399: user [No Connection]:DEBUG:  reading
> startup packet
> 2015-05-06 16:56:49: pid 2399: user [No Connection]:DETAIL:  Protocol
> Major: 1234 Minor: 5679 database:  user:
> 2015-05-06 16:56:49: pid 2399: user [No Connection]:DEBUG:  selecting
> backend connection
> 2015-05-06 16:56:49: pid 2399: user [No Connection]:DETAIL:
> SSLRequest from client
> 2015-05-06 16:56:49: pid 2399: user [No Connection]:DEBUG:  reading
> startup packet
> 2015-05-06 16:56:49: pid 2399: user [No Connection]:DETAIL:  Protocol
> Major: 3 Minor: 0 database: dbuser user: dbuser
> 2015-05-06 16:56:49: pid 2399: user [No Connection]:DEBUG:  creating
> new connection to backend
> 2015-05-06 16:56:49: pid 2399: user [No Connection]:DETAIL:
> connecting 0 backend
> 2015-05-06 16:56:49: pid 2399: user [No Connection]:DEBUG:  creating
> new connection to backend
> 2015-05-06 16:56:49: pid 2399: user [No Connection]:DETAIL:  skipping
> backend slot 0 because backend_status = 3
> 2015-05-06 16:56:49: pid 2399: user [No Connection]:DEBUG:  creating
> new connection to backend
> 2015-05-06 16:56:49: pid 2399: user [No Connection]:DETAIL:
> connecting 1 backend
> 2015-05-06 16:56:49: pid 2399: user [No Connection]:DEBUG:  reading
> message length
> 2015-05-06 16:56:49: pid 2399: user [No Connection]:DETAIL:  slot: 1
> length: 12
> 2015-05-06 16:56:49: pid 2399: user [No Connection]:DEBUG:
> authentication backend
> 2015-05-06 16:56:49: pid 2399: user [No Connection]:DETAIL:  auth kind:5
> 2015-05-06 16:56:49: pid 2399: user [No Connection]:DEBUG:
> authentication backend
> 2015-05-06 16:56:49: pid 2399: user [No Connection]:DETAIL:  trying
> md5 authentication
> 2015-05-06 16:56:49: pid 2399: user [No Connection]:DEBUG:  performing
> md5 authentication
> 2015-05-06 16:56:49: pid 2399: user [No Connection]:DETAIL:  DB node
> id: 1 salt: ffffffa64ffffff8432
> 2015-05-06 16:56:49: pid 2399: user [No Connection]:ERROR:
> authentication failed
> 2015-05-06 16:56:49: pid 2399: user [No Connection]:DETAIL:  invalid
> backend response. Response does not replied with "R"
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150507/8fd396e3/attachment.html>


More information about the pgpool-general mailing list