<div dir="ltr">Hi,<div><br></div><div>You are not doing anything wrong - on very quick inspection of the code it appears you won't be able to issue the command via the xhttp_rpc module.</div><div><br></div><div>So other than changing DB (although I assume you are using MSSQL for a very specific reason), it looks like you may have to stick to the original remote SSH connection idea. Until someone has time and inclination to add the unixodbc support that is.</div>
<div><br></div><div>Unless anyone else can offer some alternative...</div><div><br></div><div>Regards,</div><div><br></div><div>Charles</div><div><br></div><div class="gmail_extra"><br><br><div class="gmail_quote">On 30 September 2013 08:01, Grant Bagdasarian <span dir="ltr"><<a href="mailto:GB@cm.nl" target="_blank">GB@cm.nl</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div lang="EN-US" link="blue" vlink="purple"><div><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Hello,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">I’ve loaded the mi_rpc module and configured the rpc_url param, but I can’t issue the kamcmd mi ds_reload command from the web interface. Executing the command in the console works just fine, but only when I leave the binrpc modparam as default.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">I’m probably doing something wrong.<u></u><u></u></span></p><div class="im"><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.0pt;font-family:"Courier New""># ----- xhttp params ------<u></u><u></u></span></p></div><p class="MsoNormal" style="text-autospace:none">
<span style="font-size:9.0pt;font-family:"Courier New"">modparam("xhttp", "url_match", "^/http_rpc")<u></u><u></u></span></p><div class="im"><p class="MsoNormal" style="text-autospace:none">
<span style="font-size:9.0pt;font-family:"Courier New""><u></u> <u></u></span></p><p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.0pt;font-family:"Courier New""># ----- xhttp_rpc params ------<u></u><u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.0pt;font-family:"Courier New"">modparam("xhttp_rpc", "xhttp_rpc_root", "http_rpc")<u></u><u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.0pt;font-family:"Courier New""><u></u> <u></u></span></p></div><p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.0pt;font-family:"Courier New""># ----- mi_rpc params ------<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New"">modparam("mi_rpc","rpc_url","tcp:<a href="http://192.168.1.10:2046" target="_blank">192.168.1.10:2046</a>")<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New""><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">The mi_rpc documentation says: “rpc_url”. This parameter is required if you need to run RPC commands from the MI. It must match a URL to which the RPC is bound.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Is this referring to the binrpc modparam?<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Any tips?<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> <a href="mailto:sr-users-bounces@lists.sip-router.org" target="_blank">sr-users-bounces@lists.sip-router.org</a> [mailto:<a href="mailto:sr-users-bounces@lists.sip-router.org" target="_blank">sr-users-bounces@lists.sip-router.org</a>] <b>On Behalf Of </b>Charles Chance<br>
<b>Sent:</b> Saturday, September 28, 2013 9:42 AM</span></p><div class="im"><br><b>To:</b> Kamailio (SER) - Users Mailing List<br><b>Subject:</b> Re: [SR-Users] Communicate with Kamailio through external application<u></u><u></u></div>
<p></p><p class="MsoNormal"><u></u> <u></u></p><div><p class="MsoNormal">Hi,<u></u><u></u></p><div class="im"><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">It would appear then that unixodbc support is not currently available in kamctl directly, so you are in fact limited to MI command ds_reload.<u></u><u></u></p>
</div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">For your case, you could try loading MI_RPC module which exports an additional RPC command: mi.<u></u><u></u></p></div><div><p class="MsoNormal">
<u></u> <u></u></p></div><div><p class="MsoNormal">Then issue your command like:<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">kamcmd mi ds_reload<u></u><u></u></p></div>
<div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">If that works for you, then the same command passed via xhttp_rpc should also work.<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p>
</div><div><p class="MsoNormal">Cheers,<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">Charles<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div>
<div><p class="MsoNormal" style="margin-bottom:12.0pt"><u></u> <u></u></p></div></div></div><p class="MsoNormal"><u></u> <u></u></p></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">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><br clear="all"><div><br></div>
</div></div>
<br>
<font face="Helvetica, Arial, sans-serif"><font size="2"><span style="font-size:10pt"><a href="http://www.sipcentric.com/" title="blocked::http://www.sipcentric.com/" target="_blank">www.sipcentric.com</a><br>
<br>
Follow us on twitter <a href="http://twitter.com/sipcentric" title="blocked::http://twitter.com/sipcentric" target="_blank">@sipcentric</a><br>
<br>
<font color="gray">Sipcentric Ltd.
Company registered in England & Wales no. 7365592.</font> <font color="gray">Registered
office: Unit 10 iBIC, Birmingham Science Park, Holt Court South, Birmingham B7 4EJ.</font></span></font></font>