[Pgpool-general] problem with backendkey data

[Takumi Okubo]

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