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

Megan . nagemnna at gmail.com
Thu May 7 23:30:40 JST 2015


Thanks for your reply.

I have it set to log:  client_min_messages = log

Is this an issue?

Thanks.

On Thu, May 7, 2015 at 8:48 AM, Muhammad Usama <m.usama at gmail.com> wrote:
> 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
>
>


More information about the pgpool-general mailing list