[pgpool-general: 4393] Re: pool_hba md5 how to configure
Wolf Schwurack
wolf at uen.org
Thu Feb 4 23:20:03 JST 2016
You missed two steps
In pgpool.conf
#File name of password file
pool_passwd = 'pool_passwd'
Then run this command as root
# pg_md5 --md5auth --username=<user> -p
You don't need the entry in pg_hba.conf
Wolf
-----Original Message-----
From: pgpool-general-bounces at pgpool.net [mailto:pgpool-general-bounces at pgpool.net] On Behalf Of webgourou
Sent: Thursday, February 04, 2016 7:02 AM
To: pgpool-general at pgpool.net
Subject: [pgpool-general: 4392] pool_hba md5 how to configure
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
_______________________________________________
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