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
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
