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

[przeqpiciel]

Ok, I got it !! :)

First my mistake that is wrong define statement instead #!define WITH_MYSQL
i wrote #define WITH_MYSQL, then i saw problem with connection to database
and after good tea and break for that i saw this. I make mistake in
mod_param line where db_url is defined i used wrong password. instead
default kamailiorw for kamailio user I used default password for kamailioro
user.

Thanks all for helps :)

Tomasz

2017-02-17 9:15 GMT+01:00 Daniel-Constantin Mierla <miconda at gmail.com>:

> Try with debug=3 in kamailio.cfg, there should be more debug messages that
> may help.
>
> Did you install mysql client and mysql client library from the debian
> packages? Any changes to mysql server settings?
>
> Cheers,
> Daniel
>
> On 17/02/2017 08:33, przeqpiciel wrote:
>
> 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
>>
>>
>
>
> _______________________________________________
> 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 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/30c9cb04/attachment.html>