[ psqlodbc-Bugs-1010368 ] connection problem with postgresql driver 8.03.0100 to postgresql 8.3.0

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(at)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 patch and gone past the authentication problem. However, I have a different problem with the tuples from a select query not being 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 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) left outer 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: '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 inner join 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) left outer 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