[SR-Users] Using MariaDB with sqlops sql_query_async

Daniel-Constantin Mierla miconda at gmail.com
Thu Feb 12 10:00:02 CET 2015


I just added a note in the readme of the function inside the sqlops module.

Cheers,
Daniel

On 11/02/15 08:13, davy van de moere wrote:
> Nope, and that was exactly the issue! With the async module added to
> it, it just works. It wasn't clear out of the documentation for me,
> but it makes a whole lot of sense now ;)
>
> Thank you Daniel, for being our light in our dark moments ;)
>
>
>
> 2015-02-10 19:57 GMT+01:00 Daniel-Constantin Mierla <miconda at gmail.com
> <mailto:miconda at gmail.com>>:
>
>     Hello,
>
>     have you set the core async workers parameter?
>
>       - http://www.kamailio.org/wiki/cookbooks/4.2.x/core#async_workers
>
>     Cheers,
>     Daniel
>
>
>     On 10/02/15 19:44, davy van de moere wrote:
>>     Does anyone know if the async queries of kamailio work with
>>     mariadb? I'm on kamailio 4.2.3, and I can't get the async way of
>>     querying to work. I don't get any errors, but I don't see the
>>     queries to be executed.
>>
>>     the relevant part of my config is:
>>
>>     loadmodule "db_mysql.so"
>>
>>     loadmodule "sqlops.so"
>>
>>     modparam("sqlops","sqlcon","ca=>mysql://kamailio:kamailiorw@localhost/kamailio")
>>
>>     sql_query_async("ca", "insert into cdr_events (callid) values
>>     ('$ci') ");
>>
>>
>>     When just replace sql_query_async with sql_query, I do see
>>     inserts passing by.
>>
>>
>>     Do I just bluntly miss something? Or does someone have some good
>>     pointers?
>>
>>
>>     Thx!
>>
>>     Davy
>>
>>
>>
>>     _______________________________________________
>>     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://twitter.com/#!/miconda <http://twitter.com/#%21/miconda> - http://www.linkedin.com/in/miconda
>     Kamailio World Conference, May 27-29, 2015
>     Berlin, Germany - http://www.kamailioworld.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://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio World Conference, May 27-29, 2015
Berlin, Germany - http://www.kamailioworld.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20150212/6da114d6/attachment.html>


More information about the sr-users mailing list