<div dir="ltr"><div><div><div>Ok, I got it !! :)<br><br></div>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. <br><br></div>Thanks all for helps :)<br><br></div>Tomasz<br></div><div class="gmail_extra"><br><div class="gmail_quote">2017-02-17 9:15 GMT+01:00 Daniel-Constantin Mierla <span dir="ltr"><<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<p>Try with debug=3 in kamailio.cfg, there should be more debug
messages that may help.</p>
<p>Did you install mysql client and mysql client library from the
debian packages? Any changes to mysql server settings?</p>
<p>Cheers,<br>
Daniel<br>
</p><div><div class="h5">
<br>
<div class="m_7171589448314867422moz-cite-prefix">On 17/02/2017 08:33, przeqpiciel wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div>
<div>
<div>
<div>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.<br>
<br>
ERROR: db_mysql [km_my_con.c:109]:
db_mysql_new_connection(): driver error: Access denied
for user 'kamailio'@'localhost' (using password: YES)<br>
<br>
</div>
I double check kamailio.cfg where i found define statement
for DBURL<br>
<br>
#!define DBURL "mysql://<a href="http://kamailio:kamailiorw@127.0.0.1/kamailio" target="_blank">kamailio:kamailiorw@<wbr>127.0.0.1/kamailio</a>"<br>
<br>
</div>
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.<br>
<br>
</div>
What Can I do more ?<br>
<br>
</div>
Tomasz<br>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">2017-02-17 8:06 GMT+01:00
Daniel-Constantin Mierla <span dir="ltr"><<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>></span>:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<p>Hello,<br>
</p>
<span> <br>
<div class="m_7171589448314867422m_-3812737507930335272moz-cite-prefix">On
16/02/2017 17:52, przeqpiciel wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div>
<div>
<div>Hi,<br>
<br>
</div>
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.<br>
<br>
loadmodule "dispatcher.so"<br>
modparam("dispatcher", "db_url",
"mysql://kamailioro:kamailioro<wbr>@localhost/kamailio")<br>
modparam("dispatcher", "table_name",
"dispatcher")<br>
<br>
</div>
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 ?<br>
<br>
</div>
<br>
</div>
</blockquote>
</span> 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:<br>
<br>
- <a class="m_7171589448314867422m_-3812737507930335272moz-txt-link-freetext" href="http://lists.sip-router.org/pipermail/sr-users/2017-February/096117.html" target="_blank">http://lists.sip-router.org/pi<wbr>permail/sr-users/2017-February<wbr>/096117.html</a><br>
<br>
Cheers,<br>
Daniel<span class="m_7171589448314867422HOEnZb"><font color="#888888"><br>
<pre class="m_7171589448314867422m_-3812737507930335272moz-signature" cols="72">--
Daniel-Constantin Mierla
<a class="m_7171589448314867422m_-3812737507930335272moz-txt-link-abbreviated" href="http://www.twitter.com/miconda" target="_blank">www.twitter.com/miconda</a> -- <a class="m_7171589448314867422m_-3812737507930335272moz-txt-link-abbreviated" href="http://www.linkedin.com/in/miconda" target="_blank">www.linkedin.com/in/miconda</a>
Kamailio Advanced Training - Mar 6-8 (Europe) and Mar 20-22 (USA) - <a class="m_7171589448314867422m_-3812737507930335272moz-txt-link-abbreviated" href="http://www.asipto.com" target="_blank">www.asipto.com</a>
Kamailio World Conference - May 8-10, 2017 - <a class="m_7171589448314867422m_-3812737507930335272moz-txt-link-abbreviated" href="http://www.kamailioworld.com" target="_blank">www.kamailioworld.com</a></pre>
</font></span></div>
<br>
______________________________<wbr>_________________<br>
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users
mailing list<br>
<a href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a><br>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" rel="noreferrer" target="_blank">http://lists.sip-router.org/cg<wbr>i-bin/mailman/listinfo/sr-user<wbr>s</a><br>
<br>
</blockquote>
</div>
<br>
</div>
<br>
<fieldset class="m_7171589448314867422mimeAttachmentHeader"></fieldset>
<br>
<pre>______________________________<wbr>_________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a class="m_7171589448314867422moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a>
<a class="m_7171589448314867422moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/<wbr>cgi-bin/mailman/listinfo/sr-<wbr>users</a>
</pre>
</blockquote>
<br>
<pre class="m_7171589448314867422moz-signature" cols="72">--
Daniel-Constantin Mierla
<a class="m_7171589448314867422moz-txt-link-abbreviated" href="http://www.twitter.com/miconda" target="_blank">www.twitter.com/miconda</a> -- <a class="m_7171589448314867422moz-txt-link-abbreviated" href="http://www.linkedin.com/in/miconda" target="_blank">www.linkedin.com/in/miconda</a>
Kamailio Advanced Training - Mar 6-8 (Europe) and Mar 20-22 (USA) - <a class="m_7171589448314867422moz-txt-link-abbreviated" href="http://www.asipto.com" target="_blank">www.asipto.com</a>
Kamailio World Conference - May 8-10, 2017 - <a class="m_7171589448314867422moz-txt-link-abbreviated" href="http://www.kamailioworld.com" target="_blank">www.kamailioworld.com</a></pre>
</div></div></div>
<br>______________________________<wbr>_________________<br>
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list<br>
<a href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><br>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" rel="noreferrer" target="_blank">http://lists.sip-router.org/<wbr>cgi-bin/mailman/listinfo/sr-<wbr>users</a><br>
<br></blockquote></div><br></div>