[pgpool-general: 3871] unable to auth with md5 and load balancing

[Joshua D. Drake]

select passwd from pg_shadow where usename = 'postgres';

md57294f054631b20561f6004857f97481e

grep postgres /etc/pgpool2/pool_passwd

postgres:md57294f054631b20561f6004857f97481e

pool_hba.conf:

host    all     all             127.0.0.1/32            md5
host    all     all             10.32.20.18/32          md5

pg_hba.conf:

host    all     all             10.32.20.19/32          md5

ERROR:

Jul 14 15:06:49 ly19 pgpool[58186]: connection received: 
host=10.32.20.18 port=34276
Jul 14 15:06:49 ly19 pgpool[58186]: pool_read_message_length: message 
length (8) in slot 1 does not match with slot 0(12)
Jul 14 15:06:49 ly19 pgpool[58186]: Failed to read the authentication 
packet length. This is likely caused by the inconsistency of auth method 
among DB nodes. In this case you can check the previous error messages 
(hint: length field) from pool_read_message_length and recheck the 
pg_hba.conf settings.

I am not sure what I am missing here?

Sincerely,

JD

-- 
Command Prompt, Inc. - http://www.commandprompt.com/  503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Announcing "I'm offended" is basically telling the world you can't
control your own emotions, so everyone else should do it for you.