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 ?
Best regards, Tomasz
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
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:
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@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
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 http://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 mailto: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 <http://lists.sip-router.org/pipermail/sr-users/2017-February/096117.html> Cheers, Daniel -- Daniel-Constantin Mierla www.twitter.com/miconda <http://www.twitter.com/miconda> -- www.linkedin.com/in/miconda <http://www.linkedin.com/in/miconda> Kamailio Advanced Training - Mar 6-8 (Europe) and Mar 20-22 (USA) - www.asipto.com <http://www.asipto.com> Kamailio World Conference - May 8-10, 2017 - www.kamailioworld.com <http://www.kamailioworld.com> _______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org <mailto:sr-users@lists.sip-router.org> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users <http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users>
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
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@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@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:
/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@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@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@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
-
Daniel-Constantin Mierla -
przeqpiciel