[Pgpool-general] problem with backendkey data

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

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