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

[webgourou]

Hi find the solution,

that was my IP mask which was incorrect in pool_hba.conf
just change 133.137.117.143/32 to 133.137.117.143/0

and everythings works fine now !

Thanks for help

Aurel


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