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

> 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

I have used PostgreSQL 9.0 + pgpool-II 3.0 and they work fine with md5
auth. Your log seems to indicate that the password in pool_passwd and
the one in pg_shadow are not identical. Can you verify that?
The query result:

select passwd from pg_shadow where usename = 'test';

must be identical the password in pool_passwd for user test.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp