[Pgpool-general] problem with backendkey data

[Tatsuo Ishii]

Great. I have released pgpool 2.6.4 along with these fixes.
--
SRA OSS, Inc. Japan
Tatsuo Ishii

> Hi
> I have been testing pgpool with MS Access.
> It seems that pgpool with V2 protocol is working pretty good.
> No error so far.
> Thank you very much for your quick support.
> 
> Takumi Okubo
> TSD Australia
> ----- 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 5:06 PM
> Subject: Re: [Pgpool-general] problem with backendkey data
> 
> 
> >> >> 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?
> >
> > Looks like ODBC uses very old frontend/backend protocol (called "V2"),
> > which was used pre 7.4 of PostgreSQL. I will look into pgpool to
> > prepare V2 protocol.
> > --
> > SRA OSS, Inc. Japan
> > Tatsuo Ishii