What is your connection string in kamailio i.e. DBURL? Also make sure you have defined WITH_MYSQL on the top of kamailio.cfg to load necessary drivers.<div><br></div><div>#!define WITH_MYSQL</div><div><br></div><div>Thank you.</div>
<div><br><br><div class="gmail_quote">On Tue, Feb 12, 2013 at 12:56 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">
Hi <span class="gmail_sendername">Shahzad ,</span><div> </div><div> It is not ,We can able to connect remote mysql ( please find the detail below),moreover we can able create openser db from Kamailio server to remote mysql server</div>
<div><br></div><div><b>Mysql server : 192.168.1.170</b></div><div><b>Kamailio server : 192.168.1.101</b></div><div><br></div><div> </div><div><b>Mysql output :</b></div><div><b><br></b></div><div> <b>mysql -u openser -h 192.168.1.170 -p</b></div>
<div><div>Enter password:</div><div>Welcome to the MySQL monitor. Commands end with ; or \g.</div><div>Your MySQL connection id is 68</div><div>Server version: 5.1.67 Source distribution</div><div><br></div><div>Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.</div>
<div><br></div><div>Oracle is a registered trademark of Oracle Corporation and/or its</div><div>affiliates. Other names may be trademarks of their respective</div><div>owners.</div><div><br></div><div>Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.</div>
<div><br></div><div>mysql></div><div><br></div><div class="gmail_quote"><div>With Regards</div><span class="HOEnZb"><font color="#888888"><div><br></div><div>N.Prakash</div></font></span><div><div class="h5"><div> </div>
<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">Muhammad Shahzad</b> <span dir="ltr"><<a href="mailto:shaheryarkh@gmail.com" target="_blank">shaheryarkh@gmail.com</a>></span><br>
Date: Tue, Feb 12, 2013 at 5:16 PM<br>Subject: Re: [sr-dev] [SR-Users] openser db on an external mysql server<br>To: Development mailing list of the sip-router project <<a href="mailto:sr-dev@lists.sip-router.org" target="_blank">sr-dev@lists.sip-router.org</a>><br>
Cc: Daniel-Constantin Mierla <<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>>, <a href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a>, Indu Priya <<a href="mailto:indu@tevatel.com" target="_blank">indu@tevatel.com</a>>, Prabhakaran B <<a href="mailto:prabhakaran@tevatel.com" target="_blank">prabhakaran@tevatel.com</a>><br>
<br><br>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"><div><div><div><div>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>
</div></div></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div><div><div> 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><font color="#888888"><div>
<br></div><div>N.Prakash</div></font></span><div><div>
<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></div></div></div></div>_______________________________________________<br>
sr-dev mailing list<br>
<a href="mailto:sr-dev@lists.sip-router.org" target="_blank">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><span><font color="#888888"><span><font color="#888888"><br><br clear="all"><div><br></div>-- <br><span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">Muhammad Shahzad</span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">------------------------------</span><span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">-----</span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">CISCO Rich Media Communication Specialist (CRMCS)</span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">CISCO Certified Network Associate (CCNA)</span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">Cell: +49 176 99 83 10 85</span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">MSN: </span><a href="mailto:shari_786pk@hotmail.com" style="color:rgb(17,85,204);font-size:13px;font-family:arial,sans-serif" target="_blank">shari_786pk@hotmail.com</a><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">Email: </span><a href="mailto:shaheryarkh@googlemail.com" style="color:rgb(17,85,204);font-size:13px;font-family:arial,sans-serif" target="_blank">shaheryarkh@googlemail.com</a>
</font></span></font></span></div>
</div><br>
</blockquote></div></div></div><br></div>
</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>