Re: [SR-Users] Using MariaDB with sqlops sql_query_async

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@gmail.com mailto:miconda@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@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://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@lists.sip-router.org <mailto:sr-users@lists.sip-router.org>
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users