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

Поиск
Список
Период
Сортировка
От Bryan Murphy
Тема Re: pgpool-II 3.0 + postgres 9rc1 + md5 authentication not working
Дата
Msg-id AANLkTinVLE+ynM1qkBLteNTrz2dxTOUa9arfRYotnzTy@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pgpool-II 3.0 + postgres 9rc1 + md5 authentication not working  (Tatsuo Ishii <ishii@sraoss.co.jp>)
Ответы Re: pgpool-II 3.0 + postgres 9rc1 + md5 authentication not working  (Tatsuo Ishii <ishii@sraoss.co.jp>)
Список pgsql-general
On Sun, Sep 19, 2010 at 11:31 PM, Tatsuo Ishii <ishii@sraoss.co.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



В списке pgsql-general по дате отправления:

Предыдущее
От: Dave Page
Дата:
Сообщение: Re: Installing Contrib Modules with a Precompiled Binary
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: Alter Table Auto_Increment