[SR-Users] Kamailio and Oracle database

[gmele]

Hello Daniel,

I patched our kamailio 4.4.0 with the following modified files:

lib/srdb1/db_ut.h
lib/srdb1/db_ut.c
modules/urloc/dlist.c

I recompiled and replaced libsrdb1.so.1.0 and usrloc.so.

Now when kamailio starts, it still reports error:

May  2 11:33:43 newvm1 /usr/sbin/kamailio[15899]: 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 09:33:43*

It seems that your patch has removed a part of the query: the query is
missing the last quote of the date and the rest of the where clause:
*
' *AND partition=11 AND keepalive=1*


Regards

Giovanni




--
View this message in context: http://sip-router.1086192.n5.nabble.com/Kamailio-and-Oracle-database-tp147990p148019.html
Sent from the Users mailing list archive at Nabble.com.