Communication error during authentication
am 04.02.2008 12:46:31 von Peter Eisentraut--Boundary-00=_XsvpHyQj530qzgT
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
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/
--Boundary-00=_XsvpHyQj530qzgT
Content-Type: text/plain;
charset="us-ascii";
name="odbcinst.ini"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
filename="odbcinst.ini"
[PostgreSQL ANSI]
Description = PostgreSQL ODBC driver (ANSI version)
Driver = /usr/lib/odbc/psqlodbca.so
Setup = /usr/lib/odbc/libodbcpsqlS.so
Debug = 0
CommLog = 1
[PostgreSQL Unicode]
Description = PostgreSQL ODBC driver (Unicode version)
Driver = /usr/lib/odbc/psqlodbcw.so
Setup = /usr/lib/odbc/libodbcpsqlS.so
Debug = 0
CommLog = 1
--Boundary-00=_XsvpHyQj530qzgT
Content-Type: text/plain;
charset="us-ascii";
name=".odbc.ini"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
filename=".odbc.ini"
[PostgreSQL test]
Description = PostgreSQL
Driver = PostgreSQL ANSI
Trace = No
TraceFile = /tmp/psqlodbc.log
Database = template1
Servername = localhost
UserName =
Password =
Port =
ReadOnly = Yes
RowVersioning = No
ShowSystemTables = No
ShowOidColumn = No
FakeOidIndex = No
ConnSettings =
--Boundary-00=_XsvpHyQj530qzgT
Content-Type: text/x-log;
charset="us-ascii";
name="psqlodbc_pei27644.log"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
filename="psqlodbc_pei27644.log"
DSN info: DSN='PostgreSQL test',server='localhost',port='',dbase='template1',user='',p asswd='xxxxx'
onlyread='Yes',protocol='',showoid='No',fakeoidindex='No',sh owsystable='No'
conn_settings='',conn_encoding='(null)'
translation_dll='',translation_option=''
conn = 0x81414c8, PGAPI_Connect(DSN='PostgreSQL test', UID='pei', PWD='xxxxx')
Driver Version='08.03.0100,200801220001'
Global Options: fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=255, max_longvarchar_size=8190
disable_optimizer=1, ksqo=1, unique_index=1, use_declarefetch=0
text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1 NAMEDATALEN=64
extra_systable_prefixes='dd_;', conn_settings='' conn_encoding=''
CONN ERROR: func=original_CC_connect, desc='', errnum=210, errmsg='Communication error during authentication'
------------------------------------------------------------
henv=0x81413d0, conn=0x81414c8, status=0, num_stmts=16
sock=0x813e568, stmts=0x81413f8, lobj_type=-999
---------------- Socket Info -------------------------------
socket=10, reverse=0, errornumber=5, errormsg='Error while reading from the socket.'
buffer_in=135524512, buffer_out=135528616
buffer_filled_in=0, buffer_filled_out=0, buffer_read_in=0
CONN ERROR: func=PGAPI_Connect, desc='Error on CC_connect', errnum=210, errmsg='Communication error during authentication'
------------------------------------------------------------
henv=0x81413d0, conn=0x81414c8, status=0, num_stmts=16
sock=0x813e568, stmts=0x81413f8, lobj_type=-999
---------------- Socket Info -------------------------------
socket=10, reverse=0, errornumber=5, errormsg='Error while reading from the socket.'
buffer_in=135524512, buffer_out=135528616
buffer_filled_in=0, buffer_filled_out=0, buffer_read_in=0
--Boundary-00=_XsvpHyQj530qzgT
Content-Type: text/plain
Content-Disposition: inline
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
--Boundary-00=_XsvpHyQj530qzgT--