[pgpool-general: 4392] pool_hba md5 how to configure

[webgourou]

Hi all,

I would like to use md5 password to make replication.
- So I configure my pgpool.conf with
enable_pool_hba = on
 
- I set my password on pool_passwd

- I add entry on pool_hba.conf
host    all     all             133.137.117.143/32    md5
I want to use delegate_ip

- my pg_hba.conf is configured like this
host    all             all             0.0.0.0/32              md5

and when I try to connect like this:
psql -p9999 -h133.137.177.143 -Uodoo toto
I got those errors...
psql: FATAL:  client authentication failed
DÉTAIL : no pool_hba.conf entry for host "133.137.177.143", user "odoo",
database "toto", SSL on
ASTUCE : see pgpool log for details
FATAL:  client authentication failed
DÉTAIL : no pool_hba.conf entry for host "133.137.177.143", user "odoo",
database "toto", SSL off
ASTUCE : see pgpool log for details


If I try to connect without pool_hba (enable_pool_hba = off)
I get those messages (which are normal since pool_hba is off)
psql: ERROR:  MD5 authentication is unsupported in replication and
master-slave modes.
ASTUCE : check pg_hba.conf
ERROR:  MD5 authentication is unsupported in replication and
master-slave modes.
ASTUCE : check pg_hba.conf

Any idea please ?
Does pool_hba should have special rights?
maybe the tabs are not correct..?

Thanks

Aurel