On Mon, Apr 25, 2011 at 6:42 PM, Tatsuo Ishii <[email protected]> wrote:
> > 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? > > Yes. Actually I think it comes from the fact that I do the following: user1$ psql -U user2 mydb user2 is the one in pg_hba on the backend sides, but putting either user1 or user2 in pool_passwd gives an error, however: user2$ psql mydb works fine. Is psql -U maybe not supported in that kind of setup?
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
