[pgpool-general: 4395] Re: pool_hba md5 how to configure

Wolf Schwurack wolf at uen.org
Fri Feb 5 00:04:57 JST 2016


I'm using pgpool 3.5.0 and postgresql 9.4.5 don't have any issues with md5

Not sure why you are getting this error without looking at you whole environment 

Wolf 


-----Original Message-----
From: webgourou [mailto:webgourou2000 at gmail.com] 
Sent: Thursday, February 04, 2016 7:45 AM
To: Wolf Schwurack <wolf at uen.org>; pgpool-general at pgpool.net
Subject: Re: [pgpool-general: 4392] pool_hba md5 how to configure
Importance: High

hi,

pool_passwd was configured
and password was compared to pg_shadow table...

I use pgpool 3.5.0 and postgresql 9.2.14, could it be an issue ?

Aurel

On 04/02/2016 15:20, Wolf Schwurack wrote:
> 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