[Pgpool-general] pgpool-II 3.0.3 md5 authentication

[Tatsuo Ishii]

> 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.
> 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?

pool_passwd is located under same directory as pgpool.conf.

Raw mode does not require pool_passwd for md5 auth, BTW. Are you sure
that you are in raw mode?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp