[Pgpool-general] pgpool-II 3.0.3 md5 authentication

[E.D.]

Hi everyone,

I'm running pgpool2 on a Debian server, with two backends (one 8.4 and one
9.0). From the pgpool2 box I can psql to the two backends just fine.

# dpkg --list | grep pgpool2
ii  pgpool2                                3.0.3-2
connection pool server and replication proxy for PostgreSQL

My pgool2 is set to raw mode (soon to be replication), uses pool_hba and
pool_passwd.

When trying to connect to pgpool-II with psql, I get an MD5 auth error
(coming from pgpool-II), and indeed the log shows:

Apr 25 12:48:16 server pgpool: 2011-04-25 12:48:16 LOG:   pid 23735:
pgpool-II successfully started. version 3.0.3 (umiyameboshi)
Apr 25 12:48:16 server pgpool: 2011-04-25 12:48:16 DEBUG: pid 23779: I am
23779
Apr 25 12:48:16 server pgpool: 2011-04-25 12:48:16 DEBUG: pid 23735:
find_primary_node: not in streaming replication mode
Apr 25 12:48:16 server pgpool: 2011-04-25 12:48:16 DEBUG: pid 23781: I am
23781
Apr 25 12:48:21 server pgpool: 2011-04-25 12:48:21 DEBUG: pid 23779: I am
23779 accept fd 5
Apr 25 12:48:21 server pgpool: 2011-04-25 12:48:21 DEBUG: pid 23779:
Protocol Major: 3 Minor: 0 database: testuser user: testuser
Apr 25 12:48:21 server pgpool: 2011-04-25 12:48:21 ERROR: pid 23779:
pool_get_passwd: passwd_fd is NULL
Apr 25 12:48:21 server pgpool: 2011-04-25 12:48:21 ERROR: pid 23779: "MD5"
authentication with pgpool failed for user "testuser"
Apr 25 12:48:21 server pgpool: 2011-04-25 12:48:21 DEBUG: pid 23735:
reap_handler called
Apr 25 12:48:21 server pgpool: 2011-04-25 12:48:21 DEBUG: pid 23735:
reap_handler: call wait3
Apr 25 12:48:21 server pgpool: 2011-04-25 12:48:21 DEBUG: pid 23735: child
23779 exits with status 512

I understand that the pool_passwd can't be found (from "pool_get_passwd:
passwd_fd is NULL") but fail to see where to configure the location in any
of the config files. By default the pg_md5 utility created it under
/etc/pgpool2/pool_passwd.

Would anyone know what's wrong in my setup?

Thanks,

ED
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20110425/f0a520c0/attachment.html>