<div><br></div><div>Hi Govoiper</div><div><br></div><div>Free Memory on my server 2309 MB</div><div><br></div><div><div> total used free shared buffers cached</div><div> Mem: 2795 486 <font color="#ff0000">2309 </font> 0 70 180</div>
<div> -/+ buffers/cache: 234 2561</div><div> Swap: 2927 0 2927</div></div><div><br></div><div><br></div><div><b><u>Kamailio error:</u></b></div><div><b><u><br></u></b></div><div>
<div>ERROR: PID file /var/run/kamailio.pid does not exist -- Kamailio start failed</div><div style="font-weight:bold;text-decoration:underline"><br></div></div><div><br></div><div><u><b>tail -f /var/log/messages:</b></u></div>
<div><br></div><div><div><br></div><div>Feb 12 23:41:28 localhost /usr/local/sbin/kamailio[4280]: INFO: <core> [udp_server.c:230]: INFO: udp_init: SO_RCVBUF is finally 262142</div><div>Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4281]: ERROR: db_mysql [km_my_con.c:109]: driver error: Can't connect to MySQL server on '192.168.1.170' (4)</div>
<div>Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4281]: ERROR: <core> [db.c:320]: could not add connection to the pool</div><div>Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4281]: ERROR: usrloc [ul_mod.c:407]: child(1): failed to connect to database</div>
<div>Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4281]: ERROR: <core> [sr_module.c:896]: init_mod_child(): Error while initializing module usrloc (/usr/local/lib64/kamailio/modules_k/usrloc.so)</div><div>Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4283]: ERROR: db_mysql [km_my_con.c:109]: driver error: Can't connect to MySQL server on '192.168.1.170' (4)</div>
<div>Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4283]: ERROR: <core> [db.c:320]: could not add connection to the pool</div><div>Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4283]: ERROR: auth_db [authdb_mod.c:174]: unable to connect to the database</div>
<div>Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4283]: ERROR: <core> [sr_module.c:896]: init_mod_child(): Error while initializing module auth_db (/usr/local/lib64/kamailio/modules_k/auth_db.so)</div><div>Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4283]: ERROR: <core> [pt.c:350]: ERROR: fork_process(): init_child failed for process 3, pid 4283, "udp receiver child=2 sock=<a href="http://127.0.0.1:5060">127.0.0.1:5060</a>"</div>
<div>Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4283]: : <core> [main.c:1625]: main_loop: Cannot fork</div></div><div><br></div><div>With Regards</div><div><br></div><div>N.Prakash</div><br><div class="gmail_quote">
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="gmail_quote"><div class="im">---------- Forwarded message ----------<br>From: <b class="gmail_sendername">SamyGo</b> <span dir="ltr"><<a href="mailto:govoiper@gmail.com" target="_blank">govoiper@gmail.com</a>></span><br>
Date: Tue, Feb 12, 2013 at 5:49 PM<br>
Subject: Re: [SR-Users] [sr-dev] 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>><br>
</div>
Cc: Muhammad Shahzad <<a href="mailto:shaheryarkh@gmail.com" target="_blank">shaheryarkh@gmail.com</a>>, <a href="mailto:sr-dev@lists.sip-router.org" target="_blank">sr-dev@lists.sip-router.org</a>, Prabhakaran B <<a href="mailto:prabhakaran@tevatel.com" target="_blank">prabhakaran@tevatel.com</a>>, Indu Priya <<a href="mailto:indu@tevatel.com" target="_blank">indu@tevatel.com</a>><br>
<br><br><div dir="ltr">Hi Prakash,<div><br></div><div>Please paste All ERROR appearing and Warnings when you start your kamailio. What is the free memory situation on your server ?</div><div><br></div><div>Regards,</div>
<div>
Sammy</div>
<div><br><div><br></div></div></div><div><div class="h5"><div><div><div class="gmail_extra"><br><br><div class="gmail_quote">On Tue, Feb 12, 2013 at 5:12 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 Muhammad,<div><br><div> Yes, I have define Mysql on top in Kamailio.cfg</div><div><br></div><div> DBURL "mysql://<a href="http://openser:openserrw@192.168.1.170/openser" target="_blank">openser:openserrw@192.168.1.170/openser</a>"</div>
<div><br></div><div><br></div><div> I have attached Kamailio.cfg ,please advice</div><div><br></div><div>With Regards</div><span><font color="#888888"><div><br></div></font></span><div><span><font color="#888888">N.Prakash</font></span><div>
<div><br><br><div class="gmail_quote">On Tue, Feb 12, 2013 at 5:37 PM, Muhammad Shahzad <span dir="ltr"><<a href="mailto:shaheryarkh@gmail.com" target="_blank">shaheryarkh@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">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><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><font color="#888888"><div><br></div><div>N.Prakash</div></font></span><div><div><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: <a href="tel:%2B49%20176%2099%2083%2010%2085" value="+4917699831085" target="_blank">+49 176 99 83 10 85</a></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-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: <a href="tel:%2B49%20176%2099%2083%2010%2085" value="+4917699831085" target="_blank">+49 176 99 83 10 85</a></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>
</div>
</div></div></blockquote></div><br></div></div></div></div>
<br>_______________________________________________<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" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><br>
<br></blockquote></div><br></div>
</div></div></div></div></div><br>
</blockquote></div><br>