On Sun, Sep 19, 2010 at 11:31 PM, Tatsuo Ishii <ishii@xxxxxxxxxxxx> wrote:
Sorry for delay. I had a trip outside Japan.
No problem.
I found nasty bug with pgpool. Please try attached patches.
I tried the patch file and I still cannot connect. The only other difference is that I've already upgraded our images to Postgres 9.0.0 from rc1.
Here is the pgpool debug log:
2010-09-20 19:43:19 DEBUG: pid 1329: I am 1329 accept fd 6
2010-09-20 19:43:19 LOG: pid 1329: connection received: host=127.0.0.1 port=39064
2010-09-20 19:43:19 DEBUG: pid 1329: Protocol Major: 3 Minor: 0 database: template1 user: test
2010-09-20 19:43:19 DEBUG: pid 1329: new_connection: connecting 0 backend
2010-09-20 19:43:19 DEBUG: pid 1329: pool_ssl: SSL requested but SSL support is not available
2010-09-20 19:43:19 DEBUG: pid 1329: pool_read_message_length: slot: 0 length: 12
2010-09-20 19:43:19 DEBUG: pid 1329: pool_do_auth: auth kind:5
2010-09-20 19:43:19 DEBUG: pid 1329: trying md5 authentication
2010-09-20 19:43:19 DEBUG: pid 1329: DB node id: 0 salt: 89d02c38
2010-09-20 19:43:19 DEBUG: pid 1329: read_password_packet_password: failed to read password packet "p"
2010-09-20 19:43:19 ERROR: pid 1329: do_md5: read_password_packet failed
2010-09-20 19:43:19 DEBUG: pid 1329: do_md5failed in slot 0
2010-09-20 19:43:21 DEBUG: pid 1350: I am 1350 accept fd 6
2010-09-20 19:43:21 LOG: pid 1350: connection received: host=127.0.0.1 port=39066
2010-09-20 19:43:21 DEBUG: pid 1350: Protocol Major: 3 Minor: 0 database: template1 user: test
2010-09-20 19:43:21 DEBUG: pid 1350: new_connection: connecting 0 backend
2010-09-20 19:43:21 DEBUG: pid 1350: pool_ssl: SSL requested but SSL support is not available
2010-09-20 19:43:21 DEBUG: pid 1350: pool_read_message_length: slot: 0 length: 12
2010-09-20 19:43:21 DEBUG: pid 1350: pool_do_auth: auth kind:5
2010-09-20 19:43:21 DEBUG: pid 1350: trying md5 authentication
2010-09-20 19:43:21 DEBUG: pid 1350: DB node id: 0 salt: 474a91ef
2010-09-20 19:43:21 DEBUG: pid 1350: send_password_packet: backend does not return R
2010-09-20 19:43:21 DEBUG: pid 1350: do_md5failed in slot 0
