[SR-Users] Problem with dispatcher on Kamailio 4.2 and Debian 8
przeqpiciel at gmail.com
Fri Feb 17 09:43:19 CET 2017
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
Thanks all for helps :)
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?
> 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
> 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:firstname.lastname@example.org/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 ?
> 2017-02-17 8:06 GMT+01:00 Daniel-Constantin Mierla <miconda at gmail.com>:
>> On 16/02/2017 17:52, przeqpiciel wrote:
>> 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
>> 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
>> 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
> 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
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the sr-users