[Pgpool-general] problem with backendkey data

[Tatsuo Ishii]

> ----- 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