On Tue, Sep 14, 2010 at 6:55 PM, Tatsuo Ishii <is...@sraoss.co.jp> wrote:
> Sorry for not enough description about pool_passwd. It's located under > the same directory as pgpool.conf. So the default is > /usr/local/etc/pool_passwd. > > You need to create /usr/local/etc/pool_passwd if the uid to run pgpool > server does not have the right to create a new file under > /usr/local/etc, you need to create an empty /usr/local/etc/pool_passwd > owned by the same uid as pgpool. After that you should be able to > register your password as decribed in the doc. > > Authentication / Access Controls > -- > Tatsuo Ishii > SRA OSS, Inc. Japan > English: http://www.sraoss.co.jp/index_en.php > Japanese: http://www.sraoss.co.jp > Thanks, I should have thought to try that location. :) I put the pool_passwd file in the expected location (custom build, /opt/postgres/etc/pool_passwd and /etc/pool_passwd) and reran my test. I'm still having the same connection problem. I think it would be good to add an additional command line parameter to pgpool to allow overriding the location of that file (the same way the location of pcp.conf, pgpool.conf, and pgpool_hba.conf can be overriden). direct connection: psql -h 10.192.165.125 -p 5432 template1 test Password for user test: psql (9.0rc1) Type "help" for help. template1=# proxied connection: psql -h 127.0.0.1 -p 9999 template1 test Password for user test: psql: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. pgpool log: 2010-09-15 15:48:36 LOG: pid 2324: connection received: host=127.0.0.1 port=46999 2010-09-15 15:48:36 DEBUG: pid 2324: Protocol Major: 3 Minor: 0 database: template1 user: test 2010-09-15 15:48:36 DEBUG: pid 2324: new_connection: connecting 0 backend 2010-09-15 15:48:36 DEBUG: pid 2324: pool_ssl: SSL requested but SSL support is not available 2010-09-15 15:48:36 DEBUG: pid 2324: pool_read_message_length: slot: 0 length: 12 2010-09-15 15:48:36 DEBUG: pid 2324: trying md5 authentication 2010-09-15 15:48:36 DEBUG: pid 2324: DB node id: 0 salt: 458c816a *2010-09-15 15:48:36 DEBUG: pid 2324: read_password_packet_password: failed to read password packet "p"* 2010-09-15 15:48:36 ERROR: pid 2324: do_md5: read_password_packet failed 2010-09-15 15:48:36 DEBUG: pid 2324: do_md5failed in slot 0 2010-09-15 15:48:38 DEBUG: pid 2323: I am 2323 accept fd 6 2010-09-15 15:48:38 LOG: pid 2323: connection received: host=127.0.0.1 port=47001 2010-09-15 15:48:38 DEBUG: pid 2323: Protocol Major: 3 Minor: 0 database: template1 user: test 2010-09-15 15:48:38 DEBUG: pid 2323: new_connection: connecting 0 backend 2010-09-15 15:48:38 DEBUG: pid 2323: pool_ssl: SSL requested but SSL support is not available 2010-09-15 15:48:38 DEBUG: pid 2323: pool_read_message_length: slot: 0 length: 12 2010-09-15 15:48:38 DEBUG: pid 2323: trying md5 authentication 2010-09-15 15:48:38 DEBUG: pid 2323: DB node id: 0 salt: 6d1da26 2010-09-15 15:48:38 DEBUG: pid 2260: reap_handler called 2010-09-15 15:48:38 DEBUG: pid 2260: reap_handler: call wait3 2010-09-15 15:48:38 ERROR: pid 2260: Child process 2323 was terminated by segmentation fault 2010-09-15 15:48:38 DEBUG: pid 2260: child 2323 exits with status 11 by signal 11 2010-09-15 15:48:38 DEBUG: pid 2260: fork a new child pid 2328 2010-09-15 15:48:38 DEBUG: pid 2260: reap_handler: normally exited 2010-09-15 15:48:38 DEBUG: pid 2328: I am 2328 postgres log: LOG: invalid password packet size LOG: unexpected EOF on client connection psql --version psql (PostgreSQL) 9.0rc1 contains support for command-line editing pgpool --version pgpool-II version 3.0 (umiyameboshi)
