[pgpool-general: 4040] Re: MD5 authentication

[Pablo Sanchez]

[ Comments below, in-line ]


On 09/08/2015 11:11 AM, Thomas SIMON wrote:
> Hi all,

Hi Thomas

> I'm using pgpool in master/slave mode, with passwords stored in
> pool_passwd.  Postgres and pgpool are on the same host.
>
> I'm trying to configure md5 access to my pgpool instance, with
> following configuration in pg_hba.conf
>
> # IPv4 local connections:
> host    all             all             127.0.0.1/32 trust

What other settings do you have in pg_hba.conf?

    grep -v '^#' pg_hba.conf | grep -v '^$'


> And this configuuration in pool_pba.conf
>
> host    all         all         my_ip/32     md5
>
> When i'm connecting with " psql -p 9999 -h my_ip db -U user" ; with any
> user, pgpool never asks me a password, and i'm directly logged in.
> Can anyone knows why pgpool does not asks me for password ?

Also, in order to get PGPool to use its /pool_hba.conf/ I had to pass
the following argument at start up of PGPool:

    -a /etc/pgpool-II/pool_hba.conf

In my case, the .conf file is found in /etc/pgpool-II

Just to be sure, you need to have the following enabled in
/pgpool.conf/:

    enable_pool_hba = on
    pool_passwd = 'pool_passwd'

The pool_passwd should have entries like the following:

    someuser:md5aabbcc...

I hope the above helps.

Cheers,
--
Pablo Sanchez - Blueoak Database Engineering, Inc
Ph:    819.459.1926         Blog:  http://pablo-blog.blueoakdb.com
iNum:  883.5100.0990.1054