Hello,
indeed, the length without quotes was not adjusted. I pushed another patch, can you try again?
Cheers, Daniel
On 02/05/16 11:42, gmele wrote:
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-tp14799... Sent from the Users mailing list archive at Nabble.com.
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users