Re: pgpool-II 3.0 + postgres 9rc1 + md5 authentication not working

On Sun, Sep 19, 2010 at 11:31 PM, Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp> 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