Communication error during authentication

Lists: pgsql-odbc
From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Communication error during authentication
Date: 2008-02-04 11:46:31
Message-ID: 200802041246.31934.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-odbc

I am attempting to upgrade from 08.01.0200 to 08.03.0100. I have attached my
odbcinst.ini and .odbc.ini. Connecting from psql and the old ODBC driver
works fine, but the new one gives me "Communication error during
authentication" with the identical configuration and build options. The
driver log is attached. How can I debug this?

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

Attachment Content-Type Size
odbcinst.ini text/plain 422 bytes
.odbc.ini text/plain 433 bytes
psqlodbc_pei27644.log text/x-log 1.9 KB

From: "Hiroshi Saito" <z-saito(at)guitar(dot)ocn(dot)ne(dot)jp>
To: "Peter Eisentraut" <peter_e(at)gmx(dot)net>
Cc: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Communication error during authentication
Date: 2008-02-04 12:42:12
Message-ID: 04cc01c8672b$5d20e270$0301a8c0@HP22720319231
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-odbc

Hi Peter-san.

Um , it is strange?_?

My test as below.

inet% iodbctest DSN=PostgreSQLA
iODBC Demonstration program
This program shows an interactive SQL processor
Driver Manager: 03.52.0406.0126
Driver: 08.03.0100 (psqlodbca.so)

SQL>SELECT usename FROM pg_user;

usename
----------------------------------------------------------------
saito

result set 1 returned 1 rows.

SQL>

-- odbc.ini --
[PostgreSQLA]
Driver = /usr/home/saito/PSQLODBC/psqlodbc/.libs/psqlodbca.so
FetchBufferSize = 99
Description = PostgreSQL ODBC driver
Host = localhost
UserName = saito
Password =
Database = saito
SSLmode = prefer
#SSLmode = disable
ServerOptions =
ConnectOptions =
Options =
ReadOnly = no
RowVersioning = no
ShowSystemTables= no
ShowOidColumn = no
FakeOidIndex = no
Debug = 1

..probably, mylog may be helpful.

Regards,
Hiroshi Saito

----- Original Message -----
From: "Peter Eisentraut" <peter_e(at)gmx(dot)net>
To: <pgsql-odbc(at)postgresql(dot)org>
Sent: Monday, February 04, 2008 8:46 PM
Subject: [ODBC] Communication error during authentication

>I am attempting to upgrade from 08.01.0200 to 08.03.0100. I have attached my
> odbcinst.ini and .odbc.ini. Connecting from psql and the old ODBC driver
> works fine, but the new one gives me "Communication error during
> authentication" with the identical configuration and build options. The
> driver log is attached. How can I debug this?
>
> --
> Peter Eisentraut
> http://developer.postgresql.org/~petere/
>

--------------------------------------------------------------------------------

>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>