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
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<to_date('2007-10-0307:53:20','YYYY-MM-DD HH24:MI:SS') AND
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