[OpenSER-Users] Error when connect to Oracle via ODBC.

List overview All Threads
Download

newer

older

[Users] AVP management

[OpenSER-Users] New db_berkeley...

Tung Tran

3 Oct 2007 3 Oct '07

5:17 a.m.

Attachments:

attachment.html (text/html — 4.3 KB)

Show replies by date

Martin.Gruber1＠infineon.com

3 Oct 3 Oct

6:30 a.m.

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<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

Should anyone sucess customize Openser to work smoothly with Oracle? please help.

Thanks and regards Tung

Tung Tran

6:55 a.m.

Martin.Gruber1＠infineon.com

10:19 a.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@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

Tung Tran

2:15 p.m.

Martin.Gruber1＠infineon.com

4 Oct 4 Oct

6:44 a.m.

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

Tung Tran

6:58 a.m.

Tung Tran

7:28 a.m.

Martin.Gruber1＠infineon.com

5 Oct 5 Oct

7:09 a.m.

Hi Tung,

yes it is possible because the Query looks like a little bit strange. Maybe you should check out the newest version of OpenSER......because i watched my Query and it looks okay. Give it a try an tell me if it is running or not!

kind regards,

Martin

________________________________

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

Mr. Martin,

Sorry the errors are not disappear after I change the username to not null. I think the errors should be in this query

1(14057) unixodbc:SQLExecDirect, rv=-1. Query= select received, contact, socket, cflags from location where expires > now() and cflags & 64 = 64 1(14057) unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-00920: invalid relational operator

If I copy this query and run directly on Oracle then I got error too, but I change the query to "select received, contact, socket, cflags from location where expires > now() and cflags = 64"

then it works,

Do you think there is a bug in the code ?

Regards,

Tung

...

he fields with Datatype number - constrain them to a distinct size

...

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

Tung Tran

8:14 a.m.

6359

Age (days ago)

6361

Last active (days ago)

sr-users@lists.kamailio.org

9 comments

2 participants

tags (0)

participants (2)

Martin.Gruber1＠infineon.com
Tung Tran