My bad, It is true, Kamailio writes to /var/log/syslog. First what I saw is error about not loaded db_mysql module because I make mistake with define statement but I fix it. Now I have a problem with connection to database.

ERROR: db_mysql [km_my_con.c:109]: db_mysql_new_connection(): driver error: Access denied for user 'kamailio'@'localhost' (using password: YES)

I double check kamailio.cfg where i found define statement for DBURL

#!define DBURL "mysql://kamailio:kamailiorw@127.0.0.1/kamailio"

And again I checked this credentials on mysql command and I will connect with this login and password another credentials in kamailio.cfg I dont see, next file is kamctlc where is everything fine.

What Can I do more ?

Tomasz

2017-02-17 8:06 GMT+01:00 Daniel-Constantin Mierla <miconda@gmail.com>:

Hello,

On 16/02/2017 17:52, przeqpiciel wrote:

Hi,

I'm trying to setup dispatcher module to working with mysql database but when i put to kamailio.cfg below lines then kamailio wont starts.

loadmodule "dispatcher.so"
modparam("dispatcher", "db_url", "mysql://kamailioro:kamailioro@localhost/kamailio")
modparam("dispatcher", "table_name", "dispatcher")

i tried connect to mysql with credentials which you can see in mod_param line and i could query all kamailio database. im really new in this and i dont know how to debug this, is anybody could help me with it ?

there was an answer to your email sent before subscribing to the list (which was released from moderation queue of the mailing list), see it at:

- http://lists.sip-router.org/pipermail/sr-users/2017-February/096117.html

Cheers,
Daniel

-- Daniel-Constantin Mierla www.twitter.com/miconda -- www.linkedin.com/in/miconda Kamailio Advanced Training - Mar 6-8 (Europe) and Mar 20-22 (USA) - www.asipto.com Kamailio World Conference - May 8-10, 2017 - 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