Thread: [ psqlodbc-Bugs-1010368 ] connection problem with postgresql driver 8.03.0100 to postgresql 8.3.0
[ psqlodbc-Bugs-1010368 ] connection problem with postgresql driver 8.03.0100 to postgresql 8.3.0
From
Date:
Bugs item #1010368, was opened at 2008-03-31 07:31 You can respond by visiting: http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1010368&group_id=1000125 Category: None Group: None Status: Open Resolution: None Priority: 3 Submitted By: Sebastian Reitenbach (buzzdee) Assigned to: Hiroshi Inoue (hinoue) Summary: connection problem with postgresql driver 8.03.0100 to postgresql 8.3.0 Initial Comment: I compiled postgres odbc driver version 8.03.0100, but when I try to connect to a 8.3.0 postgres database, then there connection/authentication problems happen: isql FIS MyUser MyPassword -v [28000][unixODBC]Communication error during authentication; Error while reading from the socket. [ISQL]ERROR: Could not SQLConnect dbuser@dbhost:~> isql FIS MyDatabase MyDatabase -v +---------------------------------------+ | Connected! | | | | sql-statement | | help [tablename] | | quit | | | +---------------------------------------+ SQL> I can only connect to the database by a chance of 1/10. Also when I get connected, then when I try entering a SQL statement, I get error messages about not being connected anymore. and below the postgres log from the tries: LOG: connection authorized: user=MyUser database=MyDatabase LOG: unexpected EOF on client connection LOG: disconnection: session time: 0:00:00.002 user=MyUser database=MyDatabase host=192.168.15.106 port=52224 DEBUG: server process (PID 19939) exited with exit code 0 LOG: connection received: host=192.168.15.106 port=52225 DEBUG: forked new backend, pid=19941 socket=6 LOG: connection authorized: user=MyUser database=MyDatabase LOG: unexpected EOF on client connection LOG: disconnection: session time: 0:00:00.003 user=MyDatabase database=MyDatabase host=192.168.15.106 port=52225 DEBUG: server process (PID 19941) exited with exit code 0 LOG: connection received: host=192.168.15.106 port=52226 DEBUG: forked new backend, pid=19943 socket=6 LOG: connection authorized: user=MyUser database=MyDatabase LOG: statement: LOG: statement: select version() LOG: statement: set DateStyle to 'ISO' LOG: statement: set geqo to 'OFF' LOG: statement: set extra_float_digits to 2 LOG: statement: select oid, typbasetype from pg_type where typname = 'lo' LOG: statement: select pg_client_encoding() ERROR: synt x error at or near " at character 1 LOG: could not send data to client: Broken pipe LOG: unexpected EOF on client connection This is the part of the configuration from my odbc.ini: [FIS] Description = PostgreSQL DB Driver = PostgreSQL commlog = yes Database = MyDatabase Host = localhost Server = localhost ServerName = pdtest106.pdtest.intern Username = MyUser Password = MyPassword Port = 5430 Protocol = 6.4 ReadOnly = No RowVersioning = No ShowSystemTables = No ShowOidColumn = No FakeOidIndex = No ConnSettings = Actually, I have no idea, what the protocol version number means. The version 6.4 was the one I found most of the time in the net. I also tried to set it to 8.3, and 8.3.0, but with no difference. Any pointer to an explanation would be great. when I exchange the odbc driver file, with an older one, odbc drvier version 8.1.2, then I do not have connection/login problems at all. ---------------------------------------------------------------------- Comment By: Tommy Ho (tommyho) Date: 2008-04-07 19:10 Message: I was running into the authentication problem with the original 8.03.01 sources using iodbctest. I applied the second patchand gone past the authentication problem. However, I have a different problem with the tuples from a select query notbeing displayed but instead got the error: iODBC Demonstration program This program shows an interactive SQL processor Driver Manager: 03.52.0607.1008 Driver: 08.03.0100 (psqlodbcw.so) SQL>select * from persons; 1: SQLExec = LOG: duration: 2.801 ms (-1) SQLSTATE=00000 id |name |surname |password -----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------- 1: SQLGetData = [iODBC][Driver Manager]Invalid cursor state (0) SQLSTATE=24000 here's the odbc log: cat psqlodbc_root32679.log Driver Version='08.03.0100,200801290001' 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='' NOTICE from backend during CC_connect: 'SDEBUG' NOTICE from backend during CC_connect: 'C00000' NOTICE from backend during CC_connect: 'MInitPostgres' NOTICE from backend during CC_connect: 'Fpostgres.c' NOTICE from backend during CC_connect: 'L2959' NOTICE from backend during CC_connect: 'RPostgresMain' NOTICE from backend during CC_connect: 'SDEBUG' NOTICE from backend during CC_connect: 'C00000' NOTICE from backend during CC_connect: 'MStartTransaction' NOTICE from backend during CC_connect: 'Fxact.c' NOTICE from backend during CC_connect: 'L3930' NOTICE from backend during CC_connect: 'RShowTransactionState' NOTICE from backend during CC_connect: 'SDEBUG' NOTICE from backend during CC_connect: 'C00000' NOTICE from backend during CC_connect: 'Mname: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 21101/1/0,nestlvl: 1, children: <>' NOTICE from backend during CC_connect: 'Fxact.c' NOTICE from backend during CC_connect: 'L3955' NOTICE from backend during CC_connect: 'RShowTransactionStateRec' NOTICE from backend during CC_connect: 'SDEBUG' NOTICE from backend during CC_connect: 'C00000' NOTICE from backend during CC_connect: 'MCommitTransaction' NOTICE from backend during CC_connect: 'Fxact.c' NOTICE from backend during CC_connect: 'L3930' NOTICE from backend during CC_connect: 'RShowTransactionState' NOTICE from backend during CC_connect: 'SDEBUG' NOTICE from backend during CC_connect: 'C00000' NOTICE from backend during CC_connect: 'Mname: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 21101/1/0,nestlvl: 1, children: <>' NOTICE from backend during CC_connect: 'Fxact.c' NOTICE from backend during CC_connect: 'L3955' NOTICE from backend during CC_connect: 'RShowTransactionStateRec' [ PostgreSQL version string = '8.1.8' ] [ PostgreSQL version number = '8.1' ] conn=0x808c0c8, query='select oid, typbasetype from pg_type where typname = 'lo'' NOTICE from backend during send_query: 'SDEBUG' NOTICE from backend during send_query: 'C00000' NOTICE from backend during send_query: 'MStartTransactionCommand' NOTICE from backend during send_query: 'Fpostgres.c' NOTICE from backend during send_query: 'L1996' NOTICE from backend during send_query: 'Rstart_xact_command' NOTICE from backend during send_query: 'SDEBUG' NOTICE from backend during send_query: 'C00000' NOTICE from backend during send_query: 'MStartTransaction' NOTICE from backend during send_query: 'Fxact.c' NOTICE from backend during send_query: 'L3930' NOTICE from backend during send_query: 'RShowTransactionState' NOTICE from backend during send_query: 'SDEBUG' NOTICE from backend during send_query: 'C00000' NOTICE from backend during send_query: 'Mname: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 21102/1/0,nestlvl: 1, children: <>' NOTICE from backend during send_query: 'Fxact.c' NOTICE from backend during send_query: 'L3955' NOTICE from backend during send_query: 'RShowTransactionStateRec' NOTICE from backend during send_query: 'SLOG' NOTICE from backend during send_query: 'C00000' NOTICE from backend during send_query: 'Mstatement: select oid, typbasetype from pg_type where typname = 'lo'' NOTICE from backend during send_query: 'Fpostgres.c' NOTICE from backend during send_query: 'L605' NOTICE from backend during send_query: 'Rlog_after_parse' NOTICE from backend during send_query: 'SDEBUG' NOTICE from backend during send_query: 'C00000' NOTICE from backend during send_query: 'Mparse tree:' NOTICE from backend during send_query: 'D{QUERY :commandType 1 :querySource 0 :canSetTag true :utilityStmt <> :resultRelation 0 :into <> :hasAggs false :hasSubLinks false :rtable ({RTE :alias <> :eref {ALIAS :aliasname pg_type :colnames ("typname" "typnamespace" "typowner" "typlen" "typbyval" "typtype" "typisdefined" "typdelim" "typrelid" "typelem" "typinput" "typoutput" "typreceive" "typsend" "typanalyze" "typalign" "typstorage" "typnotnull" "typbasetype" "typtypmod" "typndims" "typdefaultbin" "typdefault")} :rtekind 0 :relid 1247 :inh true :inFromCl true :requiredPerms 2 :checkAsUser 0}) :jointree {FROMEXPR :fromlist ({RANGETBLREF :rtindex 1}) :quals {OPEXPR :opno 93 :opfuncid 0 :opresulttype 16 :opretset false :args ({VAR :varno 1 :varattno 1 :vartype 19 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 1} {CONST :consttype 19 :constlen 64 :constbyval false :constisnull false :constvalue 64 [ 108 111 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ]})}} :rowMarks <> :forUpdate false :rowNoWait false :targetList ({TARGETENTRY :expr {VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno -2} :resno 1 :resname oid :ressortgroupref 0 :resorigtbl 1247 :resorigcol -2 :resjunk false} {TARGETENTRY :expr {VAR :varno 1 :varattno 19 :vartype 26 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 19} :resno 2 :resname typbasetype :ressortgroupref 0 :resorigtbl 1247 :resorigcol 19 :resjunk false}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations <>} ' NOTICE from backend during send_query: 'Fprint.c' NOTICE from backend during send_query: 'L86' NOTICE from backend during send_query: 'Relog_node_display' NOTICE from backend during next_tuple: 'SDEBUG' NOTICE from backend during next_tuple: 'C00000' NOTICE from backend during next_tuple: 'MCommitTransactionCommand' NOTICE from backend during next_tuple: 'Fpostgres.c' NOTICE from backend during next_tuple: 'L2019' NOTICE from backend during next_tuple: 'Rfinish_xact_command' NOTICE from backend in next_tuple: '' NOTICE from backend during next_tuple: 'SDEBUG' NOTICE from backend during next_tuple: 'C00000' NOTICE from backend during next_tuple: 'MCommitTransaction' NOTICE from backend during next_tuple: 'Fxact.c' NOTICE from backend during next_tuple: 'L3930' NOTICE from backend during next_tuple: 'RShowTransactionState' NOTICE from backend in next_tuple: '' NOTICE from backend during next_tuple: 'SDEBUG' NOTICE from backend during next_tuple: 'C00000' NOTICE from backend during next_tuple: 'Mname: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 21102/1/0,nestlvl: 1, children: <>' NOTICE from backend during next_tuple: 'Fxact.c' NOTICE from backend during next_tuple: 'L3955' NOTICE from backend during next_tuple: 'RShowTransactionStateRec' NOTICE from backend in next_tuple: '' [ fetched 0 rows ] NOTICE from backend during send_query: 'SLOG' NOTICE from backend during send_query: 'C00000' NOTICE from backend during send_query: 'Mduration: 11.033 ms' NOTICE from backend during send_query: 'Fpostgres.c' NOTICE from backend during send_query: 'L1090' NOTICE from backend during send_query: 'Rexec_simple_query' [ Large Object oid = -999 ] [ Client encoding = 'UTF8' (code = 6) ] conn=0x808c0c8, PGAPI_DriverConnect(out)='DSN=PgSQL;DATABASE=pg_ldap;SERVER=;PORT=5432;UID=nac;PWD=xxxxxxxx;SSLmode=disable;ReadOnly=no;Protocol=7.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=255;MaxLongVarcharSize=8190;Debug=1;CommLog=1;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;;LFConversion=0;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=0;ByteaAsLongVarBinary=0;UseServerSidePrepare=0;LowerCaseIdentifier=0;' conn=0x808c0c8, query='select * from persons;' NOTICE from backend during send_query: 'SDEBUG' NOTICE from backend during send_query: 'C00000' NOTICE from backend during send_query: 'MStartTransactionCommand' NOTICE from backend during send_query: 'Fpostgres.c' NOTICE from backend during send_query: 'L1996' NOTICE from backend during send_query: 'Rstart_xact_command' NOTICE from backend during send_query: 'SDEBUG' NOTICE from backend during send_query: 'C00000' NOTICE from backend during send_query: 'MStartTransaction' NOTICE from backend during send_query: 'Fxact.c' NOTICE from backend during send_query: 'L3930' NOTICE from backend during send_query: 'RShowTransactionState' NOTICE from backend during send_query: 'SDEBUG' NOTICE from backend during send_query: 'C00000' NOTICE from backend during send_query: 'Mname: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 21103/1/0,nestlvl: 1, children: <>' NOTICE from backend during send_query: 'Fxact.c' NOTICE from backend during send_query: 'L3955' NOTICE from backend during send_query: 'RShowTransactionStateRec' NOTICE from backend during send_query: 'SLOG' NOTICE from backend during send_query: 'C00000' NOTICE from backend during send_query: 'Mstatement: select * from persons;' NOTICE from backend during send_query: 'Fpostgres.c' NOTICE from backend during send_query: 'L605' NOTICE from backend during send_query: 'Rlog_after_parse' NOTICE from backend during send_query: 'SDEBUG' NOTICE from backend during send_query: 'C00000' NOTICE from backend during send_query: 'Mparse tree:' NOTICE from backend during send_query: 'D{QUERY :commandType 1 :querySource 0 :canSetTag true :utilityStmt <> :resultRelation 0 :into <> :hasAggs false :hasSubLinks false :rtable ({RTE :alias <> :eref {ALIAS :aliasname persons :colnames ("id" "name" "surname" "password")} :rtekind 0 :relid 16516 :inh true :inFromCl true :requiredPerms 2 :checkAsUser 0}) :jointree {FROMEXPR :fromlist ({RANGETBLREF :rtindex 1}) :quals <>} :rowMarks <> :forUpdate false :rowNoWait false :targetList ({TARGETENTRY :expr {VAR :varno 1 :varattno 1 :vartype 23 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 1} :resno 1 :resname id :ressortgroupref 0 :resorigtbl 16516 :resorigcol 1 :resjunk false} {TARGETENTRY :expr {VAR :varno 1 :varattno 2 :vartype 1043 :vartypmod 259 :varlevelsup 0 :varnoold 1 :varoattno 2} :resno 2 :resname name :ressortgroupref 0 :resorigtbl 16516 :resorigcol 2 :resjunk false} {TARGETENTRY :expr {VAR :varno 1 :varattno 3 :vartype 1043 :vartypmod 259 :varlevelsup 0 :varnoold 1 :varoattno 3} :resno 3 :resname surname :ressortgroupref 0 :resorigtbl 16516 :resorigcol 3 :resjunk false} {TARGETENTRY :expr {VAR :varno 1 :varattno 4 :vartype 1043 :vartypmod 68 :varlevelsup 0 :varnoold 1 :varoattno 4} :resno 4 :resname password :ressortgroupref 0 :resorigtbl 16516 :resorigcol 4 :resjunk false}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations <>} ' NOTICE from backend during send_query: 'Fprint.c' NOTICE from backend during send_query: 'L86' NOTICE from backend during send_query: 'Relog_node_display' NOTICE from backend during next_tuple: 'SDEBUG' NOTICE from backend during next_tuple: 'C00000' NOTICE from backend during next_tuple: 'MCommitTransactionCommand' NOTICE from backend during next_tuple: 'Fpostgres.c' NOTICE from backend during next_tuple: 'L2019' NOTICE from backend during next_tuple: 'Rfinish_xact_command' NOTICE from backend in next_tuple: '' NOTICE from backend during next_tuple: 'SDEBUG' NOTICE from backend during next_tuple: 'C00000' NOTICE from backend during next_tuple: 'MCommitTransaction' NOTICE from backend during next_tuple: 'Fxact.c' NOTICE from backend during next_tuple: 'L3930' NOTICE from backend during next_tuple: 'RShowTransactionState' NOTICE from backend in next_tuple: '' NOTICE from backend during next_tuple: 'SDEBUG' NOTICE from backend during next_tuple: 'C00000' NOTICE from backend during next_tuple: 'Mname: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 21103/1/0,nestlvl: 1, children: <>' NOTICE from backend during next_tuple: 'Fxact.c' NOTICE from backend during next_tuple: 'L3955' NOTICE from backend during next_tuple: 'RShowTransactionStateRec' NOTICE from backend in next_tuple: '' [ fetched 3 rows ] NOTICE from backend during send_query: 'SLOG' NOTICE from backend during send_query: 'C00000' NOTICE from backend during send_query: 'Mduration: 2.801 ms' NOTICE from backend during send_query: 'Fpostgres.c' NOTICE from backend during send_query: 'L1090' NOTICE from backend during send_query: 'Rexec_simple_query' conn=0x808c0c8, query='select n.nspname, c.relname, a.attname, a.atttypid, t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull,c.relhasrules, c.relkind, c.oid, d.adsrc from (((pg_catalog.pg_class c inner join pg_catalog.pg_namespace non n.oid = c.relnamespace and c.oid = 16516) inner join pg_catalog.pg_attribute a on (not a.attisdropped) and a.attnum >0 and a.attrelid = c.oid) inner join pg_catalog.pg_type t on t.oid = a.atttypid) left outer join pg_attrdef d on a.atthasdefand d.adrelid = a.attrelid and d.adnum = a.attnum order by n.nspname, c.relname, attnum' NOTICE from backend during send_query: 'SDEBUG' NOTICE from backend during send_query: 'C00000' NOTICE from backend during send_query: 'MStartTransactionCommand' NOTICE from backend during send_query: 'Fpostgres.c' NOTICE from backend during send_query: 'L1996' NOTICE from backend during send_query: 'Rstart_xact_command' NOTICE from backend during send_query: 'SDEBUG' NOTICE from backend during send_query: 'C00000' NOTICE from backend during send_query: 'MStartTransaction' NOTICE from backend during send_query: 'Fxact.c' NOTICE from backend during send_query: 'L3930' NOTICE from backend during send_query: 'RShowTransactionState' NOTICE from backend during send_query: 'SDEBUG' NOTICE from backend during send_query: 'C00000' NOTICE from backend during send_query: 'Mname: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 21104/1/0,nestlvl: 1, children: <>' NOTICE from backend during send_query: 'Fxact.c' NOTICE from backend during send_query: 'L3955' NOTICE from backend during send_query: 'RShowTransactionStateRec' NOTICE from backend during send_query: 'SLOG' NOTICE from backend during send_query: 'C00000' NOTICE from backend during send_query: 'Mstatement: select n.nspname, c.relname, a.attname, a.atttypid, t.typname, a.attnum,a.attlen, a.atttypmod, a.attnotnull, c.relhasrules, c.relkind, c.oid, d.adsrc from (((pg_catalog.pg_class c innerjoin pg_catalog.pg_namespace n on n.oid = c.relnamespace and c.oid = 16516) inner join pg_catalog.pg_attribute a on(not a.attisdropped) and a.attnum > 0 and a.attrelid = c.oid) inner join pg_catalog.pg_type t on t.oid = a.atttypid) leftouter join pg_attrdef d on a.atthasdef and d.adrelid = a.attrelid and d.adnum = a.attnum order by n.nspname, c.relname,attnum' NOTICE from backend during send_query: 'Fpostgres.c' NOTICE from backend during send_query: 'L605' NOTICE from backend during send_query: 'Rlog_after_parse' NOTICE from backend during send_query: 'SDEBUG' NOTICE from backend during send_query: 'C00000' NOTICE from backend during send_query: 'Mparse tree:' NOTICE from backend during send_query: 'D{QUERY :commandType 1 :querySource 0 :canSetTag true :utilityStmt <> :resultRelation 0 :into <> :hasAggs false :hasSubLinks false :rtable ({RTE :alias {ALIAS :aliasname c :colnames <>} :eref {ALIAS :aliasname c :colnames ("relname" "relnamespace" "reltype" "relowner" "relam" "relfilenode" "reltablespace" "relpages" "reltuples" "reltoastrelid" "reltoastidxid" "relhasindex" "relisshared" "relkind" "relnatts" "relchecks" "reltriggers" "relukeys" "relfkeys" "relrefs" "relhasoids" "relhaspkey" "relhasrules" "relhassubclass" "relacl")} :rtekind 0 :relid 1259 :inh true :inFromCl true :requiredPerms 2 :checkAsUser 0} {RTE :alias {ALIAS :aliasname n :colnames <>} :eref {ALIAS :aliasname n :colnames ("nspname" "nspowner" "nspacl")} :rtekind 0 :relid 2615 :inh true :inFromCl true :requiredPerms 2 :checkAsUser 0} {RTE :alias <> :eref {ALIAS :aliasname unnamed_join :colnames ("relname" "relnamespace" "reltype" "relowner" "relam" "relfilenode" "reltablespace" "relpages" "reltuples" "reltoastrelid" "reltoastidxid" "relhasindex" "relisshared" "relkind" "relnatts" "relchecks" "reltriggers" "relukeys" "relfkeys" "relrefs" "relhasoids" "relhaspkey" "relhasrules" "relhassubclass" "relacl" "nspname" "nspowner" "nspacl")} :rtekind 2 :jointype 0 :joinaliasvars ({VAR :varno 1 :varattno 1 :vartype 19 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 1} {VAR :varno 1 :varattno 2 :vartype 26 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 2} {VAR :varno 1 :varattno 3 :vartype 26 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 3} {VAR :varno 1 :varattno 4 :vartype 26 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 4} {VAR :varno 1 :varattno 5 :vartype 26 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 5} {VAR :varno 1 :varattno 6 :vartype 26 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 6} {VAR :varno 1 :varattno 7 :vartype 26 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 7} {VAR :varno 1 :varattno 8 :vartype 23 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 8} {VAR :varno 1 :varattno 9 :vartype 700 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 9} {VAR :varno 1 :varattno 10 :vartype 26 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 10} {VAR :varno 1 :varattno 11 :vartype 26 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 11} {VAR :varno 1 :varattno 12 :vartype 16 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 12} {VAR :varno 1 :varattno 13 :vartype 16 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 13} {VAR :varno 1 :varattno 14 :vartype 18 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 14} {VAR :varno 1 :varattno 15 :vartype 21 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 15} {VAR :varno 1 :varattno 16 :vartype 21 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 16} {VAR :varno 1 :varattno 17 :vartype 21 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 17} {VAR :varno 1 :varattno 18 :vartype 21 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 18} {VAR :varno 1 :varattno 19 :vartype 21 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 19} {VAR :varno 1 :varattno 20 :vartype 21 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 20} {VAR :varno 1 :varattno 21 :vartype 16 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 21} {VAR :varno 1 :varattno 22 :vartype 16 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 22} {VAR :varno 1 :varattno 23 :vartype 16 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 23} {VAR :varno 1 :varattno 24 :vartype 16 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 24} {VAR :varno 1 :varattno 25 :vartype 1034 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 25} {VAR :varno 2 :varattno 1 :vartype 19 :vartypmod -1 :varlevelsup 0 :varnoold 2 :varoattno 1} {VAR :varno 2 :varattno 2 :vartype 26 :vartypmod -1 :varlevelsup 0 :varnoold 2 :varoattno 2} {VAR :varno 2 :varattno 3 :vartype 1034 :vartypmod -1 :varlevelsup 0 :varnoold 2 :varoattno 3}) :inh false :inFromCl true :requiredPerms 0 :checkAsUser 0} {RTE :alias {ALIAS :aliasname a :colnames <>} :eref {ALIAS :aliasname a :colnames ("attrelid" "attname" "atttypid" "attstattarget" "at' NOTICE from backend during send_query: 'Fprint.c' NOTICE from backend during send_query: 'L86' NOTICE from backend during send_query: 'Relog_node_display' NOTICE from backend during next_tuple: 'SDEBUG' NOTICE from backend during next_tuple: 'C00000' NOTICE from backend during next_tuple: 'MCommitTransactionCommand' NOTICE from backend during next_tuple: 'Fpostgres.c' NOTICE from backend during next_tuple: 'L2019' NOTICE from backend during next_tuple: 'Rfinish_xact_command' NOTICE from backend in next_tuple: x NOTICE from backend during next_tuple: 'SDEBUG' NOTICE from backend during next_tuple: 'C00000' NOTICE from backend during next_tuple: 'MCommitTransaction' NOTICE from backend during next_tuple: 'Fxact.c' NOTICE from backend during next_tuple: 'L3930' NOTICE from backend during next_tuple: 'RShowTransactionState' NOTICE from backend in next_tuple: x NOTICE from backend during next_tuple: 'SDEBUG' NOTICE from backend during next_tuple: 'C00000' NOTICE from backend during next_tuple: 'Mname: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 21104/1/0,nestlvl: 1, children: <>' NOTICE from backend during next_tuple: 'Fxact.c' NOTICE from backend during next_tuple: 'L3955' NOTICE from backend during next_tuple: 'RShowTransactionStateRec' NOTICE from backend in next_tuple: x [ fetched 4 rows ] NOTICE from backend during send_query: 'SLOG' NOTICE from backend during send_query: 'C00000' NOTICE from backend during send_query: 'Mduration: 25.955 ms' NOTICE from backend during send_query: 'Fpostgres.c' NOTICE from backend during send_query: 'L1090' NOTICE from backend during send_query: 'Rexec_simple_query' PGAPI_Columns: table='persons',field_name='id',type=23,name='int4' PGAPI_Columns: table='persons',field_name='name',type=1043,name='varchar' PGAPI_Columns: table='persons',field_name='surname',type=1043,name='varchar' PGAPI_Columns: table='persons',field_name='password',type=1043,name='varchar' conn=0x808c0c8, PGAPI_Disconnect ---------------------------------------------------------------------- Comment By: Hiroshi Inoue (hinoue) Date: 2008-04-03 17:20 Message: Please try the second patch. regards, Hiroshi Inoue ---------------------------------------------------------------------- Comment By: Sebastian Reitenbach (buzzdee) Date: 2008-04-02 10:21 Message: I just retried to compile against postgresql 8.3.1, but with the same result. Note, for the test I did not used your patch. ---------------------------------------------------------------------- Comment By: Sebastian Reitenbach (buzzdee) Date: 2008-04-02 08:40 Message: Forgot to mention, I compiled with and without --disable-unicode --disable-openssl but both versions show the same results. ---------------------------------------------------------------------- Comment By: Sebastian Reitenbach (buzzdee) Date: 2008-04-02 08:32 Message: Thanks for the patch, I just tested. It did not apply cleanly: /usr/local/src/psqlodbc-08.03.0100 # patch -p0 < ../psqlodbc.patch patching file ./socket.c Hunk #1 succeeded at 347 (offset -6 lines). Hunk #2 FAILED at 519. Hunk #3 FAILED at 529. Hunk #4 succeeded at 811 (offset -6 lines). Hunk #5 succeeded at 868 (offset -6 lines). Hunk #6 succeeded at 947 (offset -6 lines). 2 out of 6 hunks FAILED -- saving rejects to file ./socket.c.rej However, after taking a look into the source and the patch file, I changed the section to look like this: #ifdef USE_SSL /* * The stuff for SSL. */ /* included in <openssl/ssl.h> */ #define SSL_ERROR_NONE 0 #define SSL_ERROR_SSL 1 #define SSL_ERROR_WANT_READ 2 #define SSL_ERROR_WANT_WRITE 3 #define SSL_ERROR_WANT_X509_LOOKUP 4 #define SSL_ERROR_SYSCALL 5 // look at error stack/return value/errno #define SSL_ERROR_ZERO_RETURN 6 #define SSL_ERROR_WANT_CONNECT 7 #define SSL_ERROR_WANT_ACCEPT 8 // */ However, the patch did not helped. I still get these error messages: isql MyDatabase -v [28000][unixODBC]Communication error during authentication; Error while reading from the socket. [ISQL]ERROR: Could not SQLConnect The mylog_root21305.log is from above message. isql MyDatabase -v [S1000][unixODBC]The database does not exist on the server or user authentication failed. [ISQL]ERROR: Could not SQLConnect The mylog_root21305.log is from above message. ---------------------------------------------------------------------- Comment By: Hiroshi Inoue (hinoue) Date: 2008-04-01 15:53 Message: Please try the attached patch. ---------------------------------------------------------------------- Comment By: Hiroshi Inoue (hinoue) Date: 2008-03-31 10:23 Message: Could you attach the Mylog output ? You will be able to take the log (/tmp/mylog_xxxx.log) by adding the line Debug = 1 to your odbc.ini. regards, Hiroshi Inoue ---------------------------------------------------------------------- You can respond by visiting: http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1010368&group_id=1000125