[SR-Users] Kamailio and Oracle database

[Daniel-Constantin Mierla]

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-tp147990p148019.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
> 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/c001a071/attachment.html>