[SR-Users] Kamailio and Oracle database

Mele Giovanni giovanni.mele at nagra.com
Mon May 2 09:59:33 CEST 2016


Hello,

It is two single quote characters ('). If I try with one double quote character ("), it also fails. The only way to make it work is to have one single quote character surrounding the date.

Regards

Giovanni

From: sr-users [mailto:sr-users-bounces at lists.sip-router.org] On Behalf Of Daniel-Constantin Mierla
Sent: lundi 2 mai 2016 09:49
To: Kamailio (SER) - Users Mailing List
Subject: Re: [SR-Users] Kamailio and Oracle database


Hello,

are there two single quote characters or one double quotes character? Can you test if it works with double quotes instead of single quotes?

Cheers,
Daniel

On 02/05/16 09:42, gmele wrote:

Hello Daniel,



thx for your quick answer.



After having failed with db_oracle module, we effectively tried db_unixodbc.



But even with unixodbc, we got some strange errors when kamailio tries to do

queries including dates in the where clause:



Example of an error reported by kamailio:



May  2 08:30:14 newvm1 /usr/sbin/kamailio[26298]: ERROR: nathelper

[nathelper.c:2089]: nh_timer(): failed to fetch contacts

May  2 08:30:15 newvm1 /usr/sbin/kamailio[26298]: ERROR: db_unixodbc

[dbase.c:133]: db_unixodbc_submit_query(): rv=-1. Query= select

received,contact,socket,cflags,path,ruid from location *where

expires>''2016-05-02 06:30:15'' *AND partition=11 AND keepalive=1

May  2 08:30:15 newvm1 /usr/sbin/kamailio[26298]: ERROR: db_unixodbc

[connection.c:220]: db_unixodbc_extract_error():

unixodbc:SQLExecDirect=HY000:1:933:[Oracle][ODBC][Ora]ORA-00933: SQL command

not properly ended#012

May  2 08:30:15 newvm1 /usr/sbin/kamailio[26298]: ERROR: <core>

[db_query.c:132]: db_do_query_internal(): error while submitting query





As you can see, the date in the request seems has a double quote surrounding

it : where expires>''2016-05-02 06:30:15''. In fact it is 2 times the

character <'>.



If I execute the above request in the isql tool provided by unixODBC, it

also fails. If I remove the double quote around the date, it works:



select received,contact,socket,cflags,path,ruid from location *where

expires>'2016-05-02 06:30:15' *AND partition=11 AND keepalive=1;



Do you have an idea on how to correct this problem?



Thx



Regards



Giovanni







--

View this message in context: http://sip-router.1086192.n5.nabble.com/Kamailio-and-Oracle-database-tp147990p148005.html

Sent from the Users mailing list archive at Nabble.com.



_______________________________________________

SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list

sr-users at lists.sip-router.org<mailto:sr-users at lists.sip-router.org>

http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users



--

Daniel-Constantin Mierla

http://www.asipto.com

http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda

Kamailio World Conference, Berlin, May 18-20, 2016 - http://www.kamailioworld.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20160502/8732e9f0/attachment.html>


More information about the sr-users mailing list