[Pgpool-general] problem with backendkey data

[Takumi Okubo]

----- Original Message ----- 
From: "Tatsuo Ishii" <ishii at sraoss.co.jp>
To: <t-okubo at tsysd.net>
Cc: <pgpool-general at pgfoundry.org>
Sent: Wednesday, October 19, 2005 4:41 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>
>> 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.....
>
> Could you send me the debug out in case of accessing from ODBC?
> --
> SRA OSS, Inc. Japan
> Tatsuo Ishii
>

the error messages are;

2005-10-19 16:53:00 DEBUG: pid 26517: I am 26517 accept fd 6
2005-10-19 16:53:00 DEBUG: pid 26517: Protocol Major: 2 Minor: 0 database: 
nittel user: nittel
2005-10-19 16:53:00 DEBUG: pid 26517: connecting postmaster Unix domain 
socket: /tmp/.s.PGSQL.5432
2005-10-19 16:53:00 DEBUG: pid 26517: connected to postmaster Unix domain 
socket: /tmp/.s.PGSQL.5432 fd: 9
2005-10-19 16:53:01 DEBUG: pid 26517: trying clear text password 
authentication
2005-10-19 16:53:01 ERROR: pid 26517: pool_do_auth: expect "K" got N

I wonder that pgAdmin3 uses ODBC connection which is configured in Windows 
Configuration Tool or pgAdmin3 has own ODBC library?

Cheers

Takumi Okubo