[pgpool-general: 937] Re: Issue w/ md5 auth in master/slave mode

[Lazáro Rubén García Martínez]

The pg_hba.conf in each postgresql server has the same configuration??

Regards.

________________________________
From: pgpool-general-bounces at pgpool.net [pgpool-general-bounces at pgpool.net] On Behalf Of Michael Barrett [loki77 at gmail.com]
Sent: Thursday, August 30, 2012 7:00 PM
To: pgpool-general at pgpool.net
Subject: [pgpool-general: 936] Issue w/ md5 auth in master/slave mode

Hi, I'm working on getting pgpool working in a master/slave setup using md5 authentication.  Here's the versions of software I'm running:

pgpool-II-3.2.0
postgresql-9.1.5

I've setup a pool_passwd file using pg_md5 on the pgpool server for the user 'mike'.  I've also setup the user 'mike' in the postgres database and updated pg_hba.conf to allow md5 connections from the pool host.  As well I've setup pool_hba.conf  with the following entry:

host    all         all         127.0.0.1/32<http://127.0.0.1/32>          md5

Whenever I try to connect (via psql) I get the following error:

psql: ERROR:  MD5 authentication is unsupported in replication, master-slave and parallel modes.
HINT:  check pg_hba.conf

Any idea what might be going on there?  I don't see it attempt to auth against the postgres server at all, and I'm not sure why pgpool is saying that md5 isn't allowed with master-slave mode when it sounds like it has been able to since 3.0.

Thanks in advance!

--
Michael Barrett

________________________________
Fin a la injusticia, LIBERTAD AHORA A NUESTROS CINCO COMPATRIOTAS QUE SE ENCUENTRAN INJUSTAMENTE EN PRISIONES DE LOS EEUU!
http://www.antiterroristas.cu
http://justiciaparaloscinco.wordpress.com

________________________________
Fin a la injusticia, LIBERTAD AHORA A NUESTROS CINCO COMPATRIOTAS QUE SE ENCUENTRAN INJUSTAMENTE EN PRISIONES DE LOS EEUU!
http://www.antiterroristas.cu
http://justiciaparaloscinco.wordpress.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20120830/4467a7bc/attachment.htm>