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:
TomaszWhat Can I do more ?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.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.I double check kamailio.cfg where i found define statement for DBURL
ERROR: db_mysql [km_my_con.c:109]: db_mysql_new_connection(): driver error: Access denied for user 'kamailio'@'localhost' (using password: YES)
#!define DBURL "mysql://kamailio:kamailiorw@127.0.0.1/kamailio "
2017-02-17 8:06 GMT+01:00 Daniel-Constantin Mierla <miconda@gmail.com>:
Hello,
On 16/02/2017 17:52, przeqpiciel wrote:
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: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 ?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")
- 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-user s
_______________________________________________ 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
-- 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