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