[SR-Users] Problem with dispatcher on Kamailio 4.2 and Debian 8

[przeqpiciel]

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 at 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 Mierlawww.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 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/20170217/9940e753/attachment.html>