<span class="Apple-style-span" style="font-family: 'Times New Roman'; font-size: 16px; "><div style="margin-top: 8px; margin-right: 8px; margin-bottom: 8px; margin-left: 8px; font: normal normal normal small/normal arial; ">
Hi,<div><br></div><div>I have the following configuration for my opensips server with mysql. I have showed the mysql table and opensips cfg file content. The issue I am facing is when I place 20 calls to opensips it routes 10 calls to 10.128.46.103 and it disconnects the rest of the calls, it doesnot even go for the other gate way. Please help me.</div>
<div><br></div><div>--Rajib</div><div><p class="MsoNormal">mysql> select * from load_balancer;</p><p class="MsoNormal">+----+----------+------------------------+-----------+------------+-------------+</p><p class="MsoNormal">
| id | group_id | dst_uri<span> </span>| resources | probe_mode | description |</p><p class="MsoNormal">+----+----------+------------------------+-----------+------------+-------------+</p><p class="MsoNormal">
|<span> </span>1 |<span> </span>1 | sip:<a href="http://10.128.46.103:5060">10.128.46.103:5060</a> | pstn=10<span> </span>|<span> </span>2 | gateway_2<span> </span>|</p><p class="MsoNormal">|<span> </span>2 |<span> </span>1 | sip:<a href="http://10.128.46.50:5060">10.128.46.50:5060</a><span> </span>| pstn=25<span> </span>|<span> </span>2 | gateway_3<span> </span>|</p>
<p class="MsoNormal">+----+----------+------------------------+-----------+------------+-------------</p><p class="MsoNormal">Routing Script:</p><p class="MsoNormal">debug=3</p><p class="MsoNormal">memlog=1</p><p class="MsoNormal">
log_stderror=no</p><p class="MsoNormal">log_facility=LOG_LOCAL0</p><p class="MsoNormal"> </p><p class="MsoNormal">fork=yes</p><p class="MsoNormal">children=4</p><p class="MsoNormal">check_via=no<span> </span># (cmd. line: -v)</p>
<p class="MsoNormal">dns=off<span> </span># (cmd. line: -r)</p><p class="MsoNormal">rev_dns=off<span> </span># (cmd. line: -R)</p><p class="MsoNormal"> </p><p class="MsoNormal">port=5060</p><p class="MsoNormal">
</p><p class="MsoNormal">#set module path</p><p class="MsoNormal">mpath="/usr/local/lib/opensips/modules/"</p><p class="MsoNormal"> </p><p class="MsoNormal">loadmodule "maxfwd.so"</p><p class="MsoNormal">
loadmodule "sl.so"</p><p class="MsoNormal">loadmodule "db_mysql.so"</p><p class="MsoNormal">loadmodule "tm.so"</p><p class="MsoNormal">loadmodule "xlog.so"</p><p class="MsoNormal">loadmodule "uri.so"</p>
<p class="MsoNormal">loadmodule "rr.so"</p><p class="MsoNormal">loadmodule "dialog.so"</p><p class="MsoNormal">loadmodule "mi_fifo.so"</p><p class="MsoNormal">loadmodule "signaling.so"</p>
<p class="MsoNormal">loadmodule "textops.so"</p><p class="MsoNormal">loadmodule "load_balancer.so"</p><p class="MsoNormal"> </p><p class="MsoNormal">modparam("mi_fifo", "fifo_name", "/tmp/opensips_fifo")</p>
<p class="MsoNormal">modparam("dialog", "dlg_flag", 13)</p><p class="MsoNormal">modparam("dialog", "db_mode", 1)</p><p class="MsoNormal">modparam("dialog", "db_url", "mysql://opensips:opensipsrw@localhost/opensips")</p>
<p class="MsoNormal"> </p><p class="MsoNormal">modparam("rr","enable_double_rr",1)</p><p class="MsoNormal">modparam("rr","append_fromtag",1)</p><p class="MsoNormal"> </p><p class="MsoNormal">
modparam("load_balancer", "db_url","mysql://opensips:opensipsrw@localhost/opensips")</p><p class="MsoNormal">modparam("load_balancer", "probing_interval", 10)</p><p class="MsoNormal">
</p><p class="MsoNormal">route{</p><p class="MsoNormal"><span> </span>if (!mf_process_maxfwd_header("10")) {</p><p class="MsoNormal"><span> </span>sl_send_reply("483","looping");</p>
<p class="MsoNormal"><span> </span>exit;</p><p class="MsoNormal"><span> </span>}</p><p class="MsoNormal"> </p><p class="MsoNormal"> </p><p class="MsoNormal"><span> </span>if (!has_totag()) {</p>
<p class="MsoNormal"><span> </span># initial request</p><p class="MsoNormal"><span> </span>record_route();</p><p class="MsoNormal"><span> </span>} else {</p><p class="MsoNormal"><span> </span><span> </span># sequential request -> obey Route indication</p>
<p class="MsoNormal"><span> </span>loose_route();</p><p class="MsoNormal"><span> </span>t_relay();</p><p class="MsoNormal"><span> </span>exit;</p><p class="MsoNormal"><span> </span>}</p>
<p class="MsoNormal"><span> </span># handle cancel and re-transmissions</p><p class="MsoNormal"><span> </span>if ( is_method("CANCEL") ) {</p><p class="MsoNormal"><span> </span>if ( t_check_trans() )</p>
<p class="MsoNormal"><span> </span>t_relay();</p><p class="MsoNormal"><span> </span>exit;</p><p class="MsoNormal"><span> </span>}</p><p class="MsoNormal"> </p><p class="MsoNormal">
<span> </span># from now on we have only the initial requests</p><p class="MsoNormal"><span> </span>if (!is_method("INVITE")) {</p><p class="MsoNormal"><span> </span>send_reply("405","Method Not Allowed");</p>
<p class="MsoNormal"><span> </span><span> </span>exit;</p><p class="MsoNormal"><span> </span>}</p><p class="MsoNormal"> </p><p class="MsoNormal"><span> </span># detect resources and do balancing</p>
<p class="MsoNormal"><span> </span>#<span> </span>if ($rU=~"^1") {</p><p class="MsoNormal"><span> </span># looks like a Conference call</p><p class="MsoNormal"><span> </span>#<span> </span>load_balance("1","conf");</p>
<p class="MsoNormal"><span> </span># } else if ($rU=~"^2") {</p><p class="MsoNormal"><span> </span># looks like a VoiceMail call</p><p class="MsoNormal"><span> </span>#<span> </span>load_balance("1","vm");</p>
<p class="MsoNormal"><span> </span>#} else {</p><p class="MsoNormal"><span> </span># PSTN call</p><p class="MsoNormal"><span> </span>load_balance("1","pstn");</p><p class="MsoNormal">
<span> </span>#}</p><p class="MsoNormal"> </p><p class="MsoNormal"> </p><p class="MsoNormal"><span> </span># LB function returns negative if no suitable destination (for requested resources) is found,</p><p class="MsoNormal">
<span> </span># or if all destinations are full</p><p class="MsoNormal"><span> </span>if ($retcode<0) {</p><p class="MsoNormal"><span> </span>#rewritehost("<a href="http://10.128.46.103:5060">10.128.46.103:5060</a>");</p>
<p class="MsoNormal"><span> </span>sl_send_reply("500","Service full");</p><p class="MsoNormal"><span> </span>xlog("SGS: Service full : Call failed");</p><p class="MsoNormal">
<span> </span>exit;</p><p class="MsoNormal"><span> </span>}</p><p class="MsoNormal"> </p><p class="MsoNormal"><span> </span>xlog("SGS: Selected destination is: $du\n");</p><p class="MsoNormal">
<span> </span>$rd = $dd;</p><p class="MsoNormal"><span> </span># send it out</p><p class="MsoNormal"><span> </span>if (!t_relay()) {</p><p class="MsoNormal"><span> </span>sl_reply_error();</p>
<p class="MsoNormal"><span> </span><span> </span>xlog("SGS: Call Not Connected");</p><p class="MsoNormal"><span> </span>}else{</p><p class="MsoNormal"><span> </span>xlog("SGS: Call Connected");</p>
<p class="MsoNormal"><span> </span>}</p><p class="MsoNormal"> </p><p class="MsoNormal"><span> </span>if ( is_method("BYE") ) {</p><p class="MsoNormal"><span> </span>xlog("SGS: Selected Route : $du\n");</p>
<p class="MsoNormal"><span> </span>}</p><p class="MsoNormal">}</p><p class="MsoNormal"> </p><p class="MsoNormal"> </p><p class="MsoNormal">Dec<span> </span>3 09:58:57 usnjpar1askvm01 /usr/local/sbin/opensips[25311]: hash = 2054 fragments no.:<span> </span>1, unused:<span> </span>0<span> </span>bucket size:<span> </span>524288 -<span> </span>1048576 (first<span> </span>989664)</p>
<p class="MsoNormal">Dec<span> </span>3 09:58:57 usnjpar1askvm01 /usr/local/sbin/opensips[25310]: hash = 101 fragments no.:<span> </span>1, unused:<span> </span>0<span> </span>bucket size:<span> </span>808 -<span> </span>808 (first<span> </span>808)</p>
<p class="MsoNormal">Dec<span> </span>3 09:58:57 usnjpar1askvm01 /usr/local/sbin/opensips[25317]: -----------------------------</p><p class="MsoNormal">Dec<span> </span>3 09:58:57 usnjpar1askvm01 /usr/local/sbin/opensips[25312]: TOTAL:<span> </span>71 free fragments = 993256 free bytes</p>
<p class="MsoNormal">Dec<span> </span>3 09:58:57 usnjpar1askvm01 /usr/local/sbin/opensips[25311]: TOTAL:<span> </span>73 free fragments = 994016 free bytes</p><p class="MsoNormal">Dec<span> </span>3 09:58:57 usnjpar1askvm01 /usr/local/sbin/opensips[25310]: hash = 2054 fragments no.:<span> </span>1, unused:<span> </span>0<span> </span>bucket size:<span> </span>524288 -<span> </span>1048576 (first<span> </span>988864)</p>
<p class="MsoNormal">Dec<span> </span>3 09:58:57 usnjpar1askvm01 /usr/local/sbin/opensips[25312]: -----------------------------</p><p class="MsoNormal">Dec<span> </span>3 09:58:57 usnjpar1askvm01 /usr/local/sbin/opensips[25311]: -----------------------------</p>
<p class="MsoNormal">Dec<span> </span>3 09:58:57 usnjpar1askvm01 /usr/local/sbin/opensips[25310]: TOTAL:<span> </span>59 free fragments = 993120 free bytes</p><p class="MsoNormal">Dec<span> </span>3 09:58:57 usnjpar1askvm01 /usr/local/sbin/opensips[25310]: -----------------------------</p>
<p class="MsoNormal">Dec<span> </span>3 09:58:58 usnjpar1askvm01 /usr/local/sbin/opensips[25299]: Memory status (pkg):</p><p class="MsoNormal">Dec<span> </span>3 09:58:58 usnjpar1askvm01 /usr/local/sbin/opensips[25299]: fm_status (0x81b1e40):</p>
<p class="MsoNormal">Dec<span> </span>3 09:58:58 usnjpar1askvm01 /usr/local/sbin/opensips[25299]:<span> </span>heap size= 1048576</p><p class="MsoNormal">Dec<span> </span>3 09:58:58 usnjpar1askvm01 opensips: INFO:core:init_tcp: using epoll_lt as the TCP io watch method (auto detected)</p>
<p class="MsoNormal">Dec<span> </span>3 09:58:58 usnjpar1askvm01 /usr/local/sbin/opensips[25632]: NOTICE:core:main: version: opensips 1.6.0-notls (i386/linux)</p><p class="MsoNormal">Dec<span> </span>3 09:58:58 usnjpar1askvm01 /usr/local/sbin/opensips[25632]: INFO:core:main: using 32 Mb shared memory</p>
<p class="MsoNormal">Dec<span> </span>3 09:58:58 usnjpar1askvm01 /usr/local/sbin/opensips[25632]: INFO:core:main: using 1 Mb private memory per process</p><p class="MsoNormal">Dec<span> </span>3 09:58:58 usnjpar1askvm01 /usr/local/sbin/opensips[25632]: INFO:maxfwd:mod_init: initializing...</p>
<p class="MsoNormal">Dec<span> </span>3 09:58:58 usnjpar1askvm01 /usr/local/sbin/opensips[25632]: INFO:sl:mod_init: Initializing StateLess engine</p><p class="MsoNormal">Dec<span> </span>3 09:58:58 usnjpar1askvm01 /usr/local/sbin/opensips[25632]: INFO:tm:mod_init: TM - initializing...</p>
<p class="MsoNormal">Dec<span> </span>3 09:58:58 usnjpar1askvm01 /usr/local/sbin/opensips[25632]: INFO:xlog:mod_init: initializing...</p><p class="MsoNormal">Dec<span> </span>3 09:58:58 usnjpar1askvm01 /usr/local/sbin/opensips[25632]: INFO:dialog:mod_init: Dialog module - initializing</p>
<p class="MsoNormal">Dec<span> </span>3 09:58:58 usnjpar1askvm01 /usr/local/sbin/opensips[25632]: ERROR:db_mysql:db_mysql_submit_query: driver error: Unknown column 'vars' in 'field list'</p><p class="MsoNormal">
Dec<span> </span>3 09:58:58 usnjpar1askvm01 /usr/local/sbin/opensips[25632]: ERROR:core:db_do_query: error while submitting query</p><p class="MsoNormal">Dec<span> </span>3 09:58:58 usnjpar1askvm01 /usr/local/sbin/opensips[25632]: ERROR:dialog:select_entire_dialog_table: Error while querying (fetch) database</p>
<p class="MsoNormal">Dec<span> </span>3 09:58:58 usnjpar1askvm01 /usr/local/sbin/opensips[25632]: ERROR:db_mysql:db_mysql_free_result: invalid parameter value</p><p class="MsoNormal">Dec<span> </span>3 09:58:58 usnjpar1askvm01 /usr/local/sbin/opensips[25632]: NOTICE:signaling:mod_init: initializing module ...</p>
<p class="MsoNormal">Dec<span> </span>3 09:58:58 usnjpar1askvm01 /usr/local/sbin/opensips[25632]: INFO:textops:mod_init: initializing...</p><p class="MsoNormal">Dec<span> </span>3 09:58:58 usnjpar1askvm01 /usr/local/sbin/opensips[25632]: INFO:load_balancer:mod_init: Load-Balancer module - initializing</p>
<p class="MsoNormal">Dec<span> </span>3 09:58:58 usnjpar1askvm01 /usr/local/sbin/opensips[25632]: INFO:core:probe_max_receive_buffer: using a UDP receive buffer of 255 kb</p><p class="MsoNormal">Dec<span> </span>3 09:58:58 usnjpar1askvm01 /usr/local/sbin/opensips[25632]: INFO:core:probe_max_receive_buffer: using a UDP receive buffer of 255 kb</p>
<p class="MsoNormal">Dec<span> </span>3 09:59:30 usnjpar1askvm01 /usr/local/sbin/opensips[25644]: SGS: Selected destination is: sip:<a href="http://10.128.46.103:5060">10.128.46.103:5060</a></p><p class="MsoNormal">Dec<span> </span>3 09:59:30 usnjpar1askvm01 /usr/local/sbin/opensips[25644]: SGS: Call Connected</p>
<p class="MsoNormal">Dec<span> </span>3 09:59:30 usnjpar1askvm01 /usr/local/sbin/opensips[25644]: SGS: Selected destination is: sip:<a href="http://10.128.46.103:5060">10.128.46.103:5060</a></p><p class="MsoNormal">Dec<span> </span>3 09:59:30 usnjpar1askvm01 /usr/local/sbin/opensips[25644]: SGS: Call Connected</p>
<p class="MsoNormal">Dec<span> </span>3 09:59:30 usnjpar1askvm01 /usr/local/sbin/opensips[25644]: SGS: Selected destination is: sip:<a href="http://10.128.46.103:5060">10.128.46.103:5060</a></p><p class="MsoNormal">Dec<span> </span>3 09:59:30 usnjpar1askvm01 /usr/local/sbin/opensips[25644]: SGS: Call Connected</p>
<p class="MsoNormal">Dec<span> </span>3 09:59:30 usnjpar1askvm01 /usr/local/sbin/opensips[25644]: SGS: Selected destination is: sip:<a href="http://10.128.46.103:5060">10.128.46.103:5060</a></p><p class="MsoNormal">Dec<span> </span>3 09:59:30 usnjpar1askvm01 /usr/local/sbin/opensips[25644]: SGS: Call Connected</p>
<p class="MsoNormal">Dec<span> </span>3 09:59:30 usnjpar1askvm01 /usr/local/sbin/opensips[25644]: SGS: Selected destination is: sip:<a href="http://10.128.46.103:5060">10.128.46.103:5060</a></p><p class="MsoNormal">Dec<span> </span>3 09:59:30 usnjpar1askvm01 /usr/local/sbin/opensips[25644]: SGS: Call Connected</p>
<p class="MsoNormal">Dec<span> </span>3 09:59:30 usnjpar1askvm01 /usr/local/sbin/opensips[25644]: SGS: Selected destination is: sip:<a href="http://10.128.46.103:5060">10.128.46.103:5060</a></p><p class="MsoNormal">Dec<span> </span>3 09:59:30 usnjpar1askvm01 /usr/local/sbin/opensips[25644]: SGS: Call Connected</p>
<p class="MsoNormal">Dec<span> </span>3 09:59:30 usnjpar1askvm01 /usr/local/sbin/opensips[25644]: SGS: Selected destination is: sip:<a href="http://10.128.46.103:5060">10.128.46.103:5060</a></p><p class="MsoNormal">Dec<span> </span>3 09:59:30 usnjpar1askvm01 /usr/local/sbin/opensips[25644]: SGS: Call Connected</p>
<p class="MsoNormal">Dec<span> </span>3 09:59:30 usnjpar1askvm01 /usr/local/sbin/opensips[25650]: SGS: Selected destination is: sip:<a href="http://10.128.46.103:5060">10.128.46.103:5060</a></p><p class="MsoNormal">Dec<span> </span>3 09:59:30 usnjpar1askvm01 /usr/local/sbin/opensips[25650]: SGS: Call Connected</p>
<p class="MsoNormal">Dec<span> </span>3 09:59:30 usnjpar1askvm01 /usr/local/sbin/opensips[25648]: SGS: Selected destination is: sip:<a href="http://10.128.46.103:5060">10.128.46.103:5060</a></p><p class="MsoNormal">Dec<span> </span>3 09:59:30 usnjpar1askvm01 /usr/local/sbin/opensips[25648]: SGS: Call Connected</p>
<p class="MsoNormal">Dec<span> </span>3 09:59:30 usnjpar1askvm01 /usr/local/sbin/opensips[25648]: SGS: Selected destination is: sip:<a href="http://10.128.46.103:5060">10.128.46.103:5060</a></p><p class="MsoNormal">Dec<span> </span>3 09:59:30 usnjpar1askvm01 /usr/local/sbin/opensips[25648]: SGS: Call Connected</p>
<p class="MsoNormal">Dec<span> </span>3 09:59:35 usnjpar1askvm01 /usr/local/sbin/opensips[25645]: SGS: Service full : Call failed</p><p class="MsoNormal">Dec<span> </span>3 09:59:35 usnjpar1askvm01 /usr/local/sbin/opensips[25644]: SGS: Service full : Call failed</p>
<p class="MsoNormal">Dec<span> </span>3 09:59:35 usnjpar1askvm01 last message repeated 4 times</p><p class="MsoNormal">Dec<span> </span>3 09:59:35 usnjpar1askvm01 /usr/local/sbin/opensips[25645]: SGS: Service full : Call failed</p>
<p class="MsoNormal">Dec<span> </span>3 09:59:35 usnjpar1askvm01 /usr/local/sbin/opensips[25648]: SGS: Service full : Call failed</p><p class="MsoNormal">~</p><p class="MsoNormal"><span> </span><span> </span></p>
</div></div></span><br>-- <br>Rajib Deka<br>Software Engineer<br>Servion Global Solution<br>Chennai, India<br><br>Mobile No: + 91 80157 09130<br>