[Pgpool-general] problem with backendkey data

[Takumi Okubo]

----- Original Message ----- 
From: "Tatsuo Ishii" <ishii at sraoss.co.jp>
To: <t-okubo at tsysd.net>
Sent: Wednesday, October 19, 2005 12:27 PM
Subject: Re: [Pgpool-general] problem with backendkey data


>> ----- Original Message ----- 
>> From: "Tatsuo Ishii" <ishii at sraoss.co.jp>
>> To: <t-okubo at tsysd.net>
>> Cc: <pgpool-general at pgfoundry.org>
>> Sent: Tuesday, October 18, 2005 11:34 PM
>> Subject: Re: [Pgpool-general] problem with backendkey data
>>
>>
>> >> i am having an error that i have two servers(say serv1 and serv2), 
>> >> both
>> >> have
>> >> postgreSQL 8.0.3
>> >> and pgpool(2.6.3) is running on the primary server(serv1).
>> >>
>> >> i have been trying to access the DBs via pgpool and i have had errors
>> >> below:
>> >>
>> >> 2005-10-18 19:40:41 DEBUG: pid 9991: I am 9991 accept fd 6
>> >> 2005-10-18 19:40:41 DEBUG: pid 9991: Protocol Major: 3 Minor: 0 
>> >> database:
>> >> nittel user: postgres
>> >> 2005-10-18 19:40:41 DEBUG: pid 9991: read_message_length: lenghth: 8
>> >> 2005-10-18 19:40:41 DEBUG: pid 9991: trying clear text password
>> >> authentication
>> >> 2005-10-18 19:40:41 ERROR: pid 9991: do_clear_text_password: failed to
>> >> read
>> >> password packet "p"
>> >> 2005-10-18 19:40:41 ERROR: pid 9991: pool_do_auth: backend does not
>> >> return
>> >> authenticaton ok
>> >> 2005-10-18 19:40:50 DEBUG: pid 9991: I am 9991 accept fd 6
>> >> 2005-10-18 19:40:50 DEBUG: pid 9991: Protocol Major: 3 Minor: 0 
>> >> database:
>> >> nittel user: postgres
>> >> 2005-10-18 19:40:50 DEBUG: pid 9991: read_message_length: lenghth: 8
>> >> 2005-10-18 19:40:50 DEBUG: pid 9991: trying clear text password
>> >> authentication
>> >> 2005-10-18 19:40:50 DEBUG: pid 9991: read_message_length: lenghth: 65
>> >> 2005-10-18 19:40:50 ERROR: pid 9991: pool_do_auth: invalid messages
>> >> length(65) for BackendKeyData
>> >>
>> >> both DBs have the same data and a postgres.cof file. it seems that the
>> >> two
>> >> postmasters do not send the same backendkeydata to pgpool but 
>> >> postmasters
>> >> have no errors.....
>> >>
>> >> does anyone have any ideas?
>> >
>> > pgpool 2.6.3/PostgreSQL 8.0.3/replication mode/password authentication
>> > works for me. I want to know what kind of packet you received before
>> > the error message. Can you apply following patches and send me the
>> > debug out?
>> > --
>> > SRA OSS, Inc. Japan
>> > Tatsuo Ishii
>> >
>> > *** pool_auth.c 25 Jun 2005 00:58:46 -0000 1.4
>> > --- pool_auth.c 18 Oct 2005 13:31:17 -0000
>> > ***************
>> > *** 243,252 ****
>> >  /*
>> >  * message length (V3 only)
>> >  */
>> > ! if (protoMajor == PROTO_MAJOR_V3 && (length =
>> > pool_read_message_length(cp)) != 12)
>> >  {
>> > ! pool_error("pool_do_auth: invalid messages length(%d) for
>> > BackendKeyData", length);
>> > ! return -1;
>> >  }
>> >
>> >  /*
>> > --- 243,261 ----
>> >  /*
>> >  * message length (V3 only)
>> >  */
>> > ! if (protoMajor == PROTO_MAJOR_V3)
>> >  {
>> > ! if (kind != 'K')
>> > ! {
>> > ! pool_error("pool_do_auth: expect \"K\" got %c", kind);
>> > ! return -1;
>> > ! }
>> > !
>> > ! if ((length = pool_read_message_length(cp)) != 12)
>> > ! {
>> > ! pool_error("pool_do_auth: invalid messages length(%d) for
>> > BackendKeyData", length);
>> > ! return -1;
>> > ! }
>> >  }
>> >
>> >  /*
>> >
>>
>> Hi
>> Thanks for your help. I have patched your codes above and I have got 
>> error
>> messages...
>>
>> 2005-10-19 12:00:41 DEBUG: pid 16563: I am 16563 accept fd 6
>> 2005-10-19 12:00:41 DEBUG: pid 16563: Protocol Major: 3 Minor: 0 
>> database:
>> nittel user: postgres
>> 2005-10-19 12:00:42 DEBUG: pid 16563: read_message_length: lenghth: 8
>> 2005-10-19 12:00:42 DEBUG: pid 16563: trying clear text password
>> authentication
>> 2005-10-19 12:00:42 ERROR: pid 16563: do_clear_text_password: failed to 
>> read
>> password packet "p"
>> 2005-10-19 12:00:42 ERROR: pid 16563: pool_do_auth: backend does not 
>> return
>> authenticaton ok
>> 2005-10-19 12:00:46 DEBUG: pid 16563: I am 16563 accept fd 6
>> 2005-10-19 12:00:46 DEBUG: pid 16563: Protocol Major: 3 Minor: 0 
>> database:
>> nittel user: postgres
>> 2005-10-19 12:00:46 DEBUG: pid 16563: read_message_length: lenghth: 8
>> 2005-10-19 12:00:46 DEBUG: pid 16563: trying clear text password
>> authentication
>> 2005-10-19 12:00:46 ERROR: pid 16563: pool_do_auth: expect "K" got N
>>
>> In addition, when I turn off all log options in postgres.conf then I can
>> access to pgpool......does that help?
>
> Yes, it does. Can you tell me the exact postgresql.conf settings for
> log options so that I could reproduce your problem?
> --
> SRA OSS, Inc. Japan
> Tatsuo Ishii
>
Hi
Thank you very much for your help. As you know, I could access to pgpool but 
when I try to access from MS Access-ODBC-Pgpool-PostgreSQL, I have got the 
same error from pgpool.
Again, if I turn off  log options it works.....
I am very sorry asking so many questions.....

cheers

Takumi Okubo
TSD Australia