Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Interfaces Odbc > Communication e...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 2286 of 2382
Post > Topic >>

Communication error during authentication

by peter_e@[EMAIL PROTECTED] (Peter Eisentraut) Feb 4, 2008 at 12:46 PM

--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            =
****t                =
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',****t='',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

--Boundary-00=_XsvpHyQj530qzgT
Content-Type: text/plain
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
MIME-Version: 1.0


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

--Boundary-00=_XsvpHyQj530qzgT--
 




 2 Posts in Topic:
Communication error during authentication
peter_e@[EMAIL PROTECTED]  2008-02-04 12:46:31 
Re: Communication error during authentication
z-saito@[EMAIL PROTECTED]  2008-02-04 21:42:12 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Sun Jul 6 18:30:59 CDT 2008.