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/
[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
[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 =
DSN info: DSN='PostgreSQL test',server='localhost',port='',dbase='template1',user='',passwd='xxxxx'
onlyread='Yes',protocol='',showoid='No',fakeoidindex='No',showsystable='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
Home |
Main Index |
Thread Index