Hello, you have to recompile everything, there was a patch in an internal library. You can also build the rpms by yourself.
Cheers, Daniel On 02/05/16 10:53, Mele Giovanni wrote: > > Thx Daniel! > > > > I will get the code from git. What do I need to recompile? Only > unixodbc module? Any other lib? We are using installation done with > the official rpm and would like to keep an environment as clean as > possible and just change the modified libs. > > > > Thx for this quick support. > > > > > > Regards > > > > > > Giovanni > > > > *From:*Daniel-Constantin Mierla [mailto:mico...@gmail.com] > *Sent:* lundi 2 mai 2016 10:49 > *To:* Mele Giovanni; Kamailio (SER) - Users Mailing List > *Subject:* Re: [SR-Users] Kamailio and Oracle database > > > > Hello, > > hopefully I found and fixed the issue. The usrloc was setting the > value for time already quoted and then the db api was quoting again. I > guess you were using db-only mode for usrloc. > > Can you try again with latest git branch 4.4 or master? Report back > the results in order to know if the issue was fixed or not. > > Cheers, > Daniel > > On 02/05/16 09:59, Mele Giovanni wrote: > > 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-boun...@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@lists.sip-router.org > <mailto:sr-users@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://twitter.com/#%21/miconda> - > http://www.linkedin.com/in/miconda > > Kamailio World Conference, Berlin, May 18-20, 2016 - > http://www.kamailioworld.com > > > > -- > Daniel-Constantin Mierla > http://www.asipto.com > http://twitter.com/#!/miconda <http://twitter.com/#%21/miconda> - > http://www.linkedin.com/in/miconda > Kamailio World Conference, Berlin, May 18-20, 2016 - > http://www.kamailioworld.com -- 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
_______________________________________________ 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
