3 Oct
2007
3 Oct
'07
1:19 p.m.
Hi,
please send me the structure of your location table.
regards
martin
________________________________
From: Tung Tran [mailto:tr.tung@gmail.com]
Sent: Wednesday, October 03, 2007 8:55 AM
To: Gruber Martin (IFKL IT OS NV)
Cc: users(a)openser.org
Subject: RE: [OpenSER-Users] Error when connect to Oracle via ODBC.
Dear Martin,
I am using Openser 1.2.2 and the odbc lib is libsqora.so.10.1
I also follow the guide on web to batch the unixodbc module and it runs
with the error I just report.
(http://openser.org/pipermail/users/2007-August/012532.html)
Please help,
Regards
Tung
Hi,
what version of OpenSER do you use. Seems that something in the
source is not running well. Check out the newest version first.
If it is not the case let me know!
regards
Martin
From: users-bounces(a)openser.org [mailto:users-bounces@openser.org]
On Behalf Of Tung Tran
Sent: Wednesday, October 03, 2007 7:18 AM
To: users(a)openser.org
Subject: [OpenSER-Users] Error when connect to Oracle via ODBC.
Hi all,
I am trying to connect Openser with Oracle via odbc. So far I can
connect sucessfully to Oracle DB via unixODBC module, I can
register and make call,
However I got this error from Openser debug that I dont know it may
effect to Openser operation
1(9499) unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-
00920: invalid relational operator
1(9499) unixodbc:SQLExecDirect=HY000:2:920:[Oracle][ODBC][Ora]ORA-
00920: invalid relational operator
1(9499) db_raw_query: Error while submitting query 1(9499)
ERROR:usrloc:get_all_db_ucontacts: raw_query failed 1(9499)
unixodbc:SQLExecDirect, rv=100. Query= delete from location where
expires
expires!=to_date('1970-01-0107:00:00','YYYY-MM-DD HH24:MI:SS')
1(9499) unixodbc:SQLExecDirect, rv=-1. Query= select received,
contact, socket, cflags from location where expires > now() and
cflags & 64 = 64 1(9499)
unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-00920:
invalid relational operator 1(9499)
unixodbc:SQLExecDirect=HY000:2:920:[Oracle][ODBC][Ora]ORA-00920:
invalid relational operator
1(9499) db_raw_query: Error while submitting query 1(9499)
ERROR:usrloc:get_all_db_ucontacts: raw_query failed 1(9499)
unixodbc:SQLExecDirect, rv=-1. Query= select received, contact,
socket, cflags from location where expires > now() and cflags & 64
= 64 1(9499)
unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-00920:
invalid relational operator 1(9499)
unixodbc:SQLExecDirect=HY000:2:920:[Oracle][ODBC][Ora]ORA-00920:
invalid relational operator
1(9499) db_raw_query: Error while submitting query 1(9499)
ERROR:usrloc:get_all_db_ucontacts: raw_query failed 1(9499)
unixodbc:SQLExecDirect, rv=-1. Query= select received, contact,
socket, cflags from location where expires > now() and cflags & 64
= 64 1(9499)
unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-00920:
invalid relational operator 1(9499)
unixodbc:SQLExecDirect=HY000:2:920:[Oracle][ODBC][Ora]ORA-00920:
invalid relational operator
Should anyone sucess customize Openser to work smoothly with
Oracle? please help.
Thanks and regards
Tung