Thread: Communication error during authentication

Communication error during authentication

From
Peter Eisentraut
Date:
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

Re: Communication error during authentication

From
"Hiroshi Saito"
Date:
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@gmx.net>
To: <pgsql-odbc@postgresql.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
>