> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
