Its not a Kamailio error, it is problem with connecting to mysql server. Error 4 means No MySQL Server Running On Specified Host.<div><br></div><div>May be MySQL server is down or there is some firewall running or MySQL not listening on IP you specified.</div>
<div><br></div><div>Thank you.</div><div><br><br><div class="gmail_quote">On Tue, Feb 12, 2013 at 12:11 PM, Prakash N <span dir="ltr"><<a href="mailto:prakash.n@tevatel.com" target="_blank">prakash.n@tevatel.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> Dear Daniel,<div><br></div><div> Thanks for your quick response</div><div><br></div><div> We can able to create operseb db on remote mysql server ,but Kamailio not getting start</div>
<div><br></div><div>
<font color="#ff0000"> Error detail:</font></div><div><br></div><div> ERROR: db_mysql [km_my_con.c:109]: driver error: Can't connect to MySQL server on '192.168.1.170' (4)<div> ERROR: <core> [db.c:32 0]: could not add connection to the pool</div>
<div> ERROR: auth_db [authdb _mod.c:174]: unable to connect to the database</div><div> ERROR: <core> [sr_modu le.c:896]: init_mod_child(): Error while initializing module auth_db (/usr/local/lib64/kamailio/modules_k/auth_db.so)</div>
<div><br></div><div><br></div><div>I have attached my kamailo.cfg ( we followed Kamailio and Asterisk real time installation) ,please advice </div><div><br></div><div>With Regards</div><span class="HOEnZb"><font color="#888888"><div>
<br></div><div>N.Prakash</div></font></span><div><div class="h5">
<div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><br><div class="gmail_quote">---------- Forwarded message ----------<br>From: <b class="gmail_sendername">Daniel-Constantin Mierla</b> <span dir="ltr"><<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>></span><br>
Date: Tue, Feb 12, 2013 at 2:41 PM<br>Subject: Re: [SR-Users] openser db on an external mysql server<br>To: "SIP Router - Kamailio (OpenSER) and SIP Express Router (SER) - Users Mailing List" <<a href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a>>, <a href="mailto:sr-dev@lists.sip-router.org" target="_blank">sr-dev@lists.sip-router.org</a>, <a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a><br>
Cc: Prabhakaran B <<a href="mailto:prabhakaran@tevatel.com" target="_blank">prabhakaran@tevatel.com</a>><br><br><br>
<div bgcolor="#FFFFFF" text="#000000">
<div>Hello,<br>
<br>
kamailio database is created with:<br>
<br>
kamdbctl create<br>
<br>
the host of mysql server has to be specified in kamctlrc file via
DBHOST variable - kamctlrc is located in same directory as
kamailio.cfg.<br>
<br>
In kamailio.cfg, update the db_url value (or DBURL define) to
reflect the mysql server host.<br>
<br>
Cheers,<br>
Daniel<div><div><div><div><br>
<br>
On 2/12/13 4:16 AM, Prakash N wrote:<br>
</div></div></div></div></div>
<blockquote type="cite"><div><div><div><div>Hi All,
<div><br>
</div>
<div> I am new this Kamailo ,ther is any step by step document to
set up openser db on an external mysql server ?</div>
<div><br>
</div>
<div>With Regards</div>
<div><br>
</div>
<div>N.Prakash</div>
<div><br>
</div>
<br>
<fieldset></fieldset>
<br>
</div></div></div></div><pre>_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><span><font color="#888888"><span><font color="#888888">
</font></span></font></span></pre><span><font color="#888888"><span><font color="#888888">
</font></span></font></span></blockquote><span><font color="#888888"><span><font color="#888888">
<br>
<br>
<pre cols="72">--
Daniel-Constantin Mierla - <a href="http://www.asipto.com" target="_blank">http://www.asipto.com</a>
<a href="http://twitter.com/#!/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/miconda</a>
Kamailio World Conference, April 16-17, 2013, Berlin
- <a href="http://conference.kamailio.com" target="_blank">http://conference.kamailio.com</a> -</pre>
</font></span></font></span></div>
</div><br>
</blockquote></div><br></div></div></div>
<br>_______________________________________________<br>
sr-dev mailing list<br>
<a href="mailto:sr-dev@lists.sip-router.org">sr-dev@lists.sip-router.org</a><br>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">Muhammad Shahzad</span><br style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
<span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">------------------------------</span><span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">-----</span><br style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
<span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">CISCO Rich Media Communication Specialist (CRMCS)</span><br style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
<span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">CISCO Certified Network Associate (CCNA)</span><br style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
<span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">Cell: +49 176 99 83 10 85</span><br style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
<span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">MSN: </span><a href="mailto:shari_786pk@hotmail.com" style="color:rgb(17,85,204);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)" target="_blank">shari_786pk@hotmail.com</a><br style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
<span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">Email: </span><a href="mailto:shaheryarkh@googlemail.com" style="color:rgb(17,85,204);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)" target="_blank">shaheryarkh@googlemail.com</a>
</div>