Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

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

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group