[SR-Users] Using MariaDB with sqlops sql_query_async

[davy van de moere]

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>:

>  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 listsr-users at lists.sip-router.orghttp://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>
> --
> Daniel-Constantin Mierlahttp://twitter.com/#!/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
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20150211/f2af21a9/attachment.html>