16 Feb
2017
16 Feb
'17
7:52 p.m.
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
17 Feb
17 Feb
10:06 a.m.
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 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
10:33 a.m.
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(a)gmail.com>om>:
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(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
11:15 a.m.
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(a)gmail.com
<mailto:miconda@gmail.com>>:
Hello,
On 16/02/2017 17:52, przeqpiciel wrote:
--
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
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(a)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(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
11:43 a.m.
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(a)gmail.com>om>:
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(a)gmail.com>om>:
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(a)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(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
2835
days inactive
2836
days old
4 comments
2 participants
participants (2)
-
Daniel-Constantin Mierla -
przeqpiciel