hi,
 
I think you should set the "expires" and "last_modified" field to date and not timestamp.
And also a small hint.....the fields with Datatype number - constrain them to a distinct size.
username should not be nullable!
 
hope this helps, otherwise contact me!
 
regards
Martin


From: Tung Tran [mailto:tr.tung@gmail.com]
Sent: Wednesday, October 03, 2007 4:15 PM
To: Gruber Martin (IFKL IT OS NV)
Cc: users@openser.org
Subject: RE: [OpenSER-Users] Error when connect to Oracle via ODBC.

Hi,
 
This is the structure of my location table.
If you need any information please let me know..
 
Thanks for your help in advanced
 
Regards
Tung

> 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@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@openser.org [mailto:users-
>> bounces@openser.org] On Behalf Of Tung Tran Sent: Wednesday,
>> October 03, 2007 7:18 AM To: users@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