<html><head><meta name="Generator" content="PSI HTML/CSS Generator"/>
<style type="text/css"><!--
body{font-family:'Tahoma';font-size:10pt;font-color:'#000000';}
LI{display:list-item;margin:0.00in;}
p{display:block;margin:0.00in;}
body{}
--></style>
</head><BODY ><div><SPAN style="font-size:10pt;">Dear Martin,</SPAN></div>
<div> </div>
<div><SPAN style="font-size:10pt;">Yes, I also tried  "expires" and "last_modified" with date type, however it only stored date information, no time information, but on mysql the openser stores both date and time. I dont know if with no time information the openser will work smootly or not.</SPAN></div>
<div> </div>
<div><SPAN style="font-size:10pt;">I will try to change something as your recommendation and test again, hope to get something better.</SPAN></div>
<div><SPAN style="font-size:10pt;">I will feedback to you about the test..</SPAN></div>
<div> </div>
<div><SPAN style="font-size:10pt;">Best regards,</SPAN></div>
<div> </div>
<div><SPAN style="font-size:10pt;">Tung<br /><br /></span></div>
<div><SPAN style="font-size:10pt;color:navy;">> hi,</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">></SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> I think you should set the "expires" and "last_modified" field to</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> date and not timestamp. And also a small hint.....the fields with</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> Datatype number - constrain them to a distinct size. username</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> should not be nullable!   hope this helps, otherwise contact me!  </SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> regards Martin</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">></SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> From: Tung Tran [<a href="mailto:tr.tung@gmail.com]">mailto:tr.tung@gmail.com]</a></SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> Sent: Wednesday, October 03, 2007 4:15 PM</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> To: Gruber Martin (IFKL IT OS NV)</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> Cc: users@openser.org</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> Subject: RE: [OpenSER-Users] Error when connect to Oracle via ODBC.</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">></SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">></SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> Hi,</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">></SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> This is the structure of my location table.</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> If you need any information please let me know..</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">></SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> Thanks for your help in advanced</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">></SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> Regards</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> Tung</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">></SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> Hi,</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> please send me the structure of your location table.</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> regards</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> martin</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> From: Tung Tran [<a href="mailto:tr.tung@gmail.com]">mailto:tr.tung@gmail.com]</a></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> Sent: Wednesday, October 03, 2007 8:55 AM</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> To: Gruber Martin (IFKL IT OS NV)</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> Cc: users@openser.org</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> Subject: RE: [OpenSER-Users] Error when connect to Oracle via</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> ODBC.</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> Dear Martin,</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> I am using Openser 1.2.2 and the odbc lib is libsqora.so.10.1 I</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> also follow the guide on web to batch the unixodbc module and it</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> runs with the error I just report.</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> (<a href="http://openser.org/pipermail/users/2007-August/012532.html">http://openser.org/pipermail/users/2007-August/012532.html</a>)</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> Please help,</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> Regards</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> Tung</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> Hi,</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>></SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> what version of OpenSER do you use. Seems that something in the</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> source is not running well. Check out the newest version first.</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> If it is not the case let me know!</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>></SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> regards</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>></SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> Martin</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>></SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> From: users-bounces@openser.org [<a href="mailto:users">mailto:users</a>-</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> bounces@openser.org] On Behalf Of Tung Tran Sent: Wednesday,</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> October 03, 2007 7:18 AM To: users@openser.org</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> Subject: [OpenSER-Users] Error when connect to Oracle via ODBC.</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>></SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>></SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> Hi all,</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>></SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> I am trying to connect Openser with Oracle via odbc. So far I</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> can</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> connect sucessfully to Oracle DB via unixODBC module, I can</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> register and make call,</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> However I got this error from Openser debug that I dont know it</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> may effect to Openser operation</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>></SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> 1(9499)</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> 00920: invalid relational operator</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>></SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> 1(9499)</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> unixodbc:SQLExecDirect=HY000:2:920:[Oracle][ODBC][Ora]ORA-</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> 00920: invalid relational operator</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>></SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> 1(9499) db_raw_query: Error while submitting query  1(9499)</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> ERROR:usrloc:get_all_db_ucontacts: raw_query failed  1(9499)</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> unixodbc:SQLExecDirect, rv=100. Query= delete from location</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> where</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> expires</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> expires!=to_date('1970-01-0107:00:00','YYYY-MM-DD HH24:MI:SS')  </SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> 1(9499) unixodbc:SQLExecDirect, rv=-1. Query= select received,</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> contact, socket, cflags from location where expires > now() and</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> cflags & 64 = 64  1(9499)</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-00920:</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> invalid relational operator    1(9499)</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> unixodbc:SQLExecDirect=HY000:2:920:[Oracle][ODBC][Ora]ORA-00920:</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> invalid relational operator  </SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> 1(9499) db_raw_query: Error while submitting query  1(9499)</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> ERROR:usrloc:get_all_db_ucontacts: raw_query failed  1(9499)</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> unixodbc:SQLExecDirect, rv=-1. Query= select received, contact,</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> socket, cflags from location where expires > now() and cflags &</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> 64 = 64  1(9499)</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-00920:</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> invalid relational operator    1(9499)</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> unixodbc:SQLExecDirect=HY000:2:920:[Oracle][ODBC][Ora]ORA-00920:</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> invalid relational operator  </SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> 1(9499) db_raw_query: Error while submitting query  1(9499)</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> ERROR:usrloc:get_all_db_ucontacts: raw_query failed  1(9499)</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> unixodbc:SQLExecDirect, rv=-1. Query= select received, contact,</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> socket, cflags from location where expires > now() and cflags &</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> 64 = 64  1(9499)</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-00920:</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> invalid relational operator    1(9499)</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> unixodbc:SQLExecDirect=HY000:2:920:[Oracle][ODBC][Ora]ORA-00920:</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> invalid relational operator    </SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> Should anyone sucess customize Openser to work smoothly with</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> Oracle? please help.</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>></SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> Thanks and regards</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> Tung</SPAN></div>
</body></html>