<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><title>LCR database issues</title><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";
color:black;}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;
color:black;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";
color:black;}
span.EmailStyle23
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body bgcolor=white lang=EN-GB link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Thanks for the reply. Can I suggest that instead of displaying the value 0 as blank the interface actually displays 0?<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Regards<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Lee<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext'>From:</span></b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext'> Daniel-Constantin Mierla [mailto:miconda@gmail.com] <br><b>Sent:</b> 09 November 2010 09:45<br><b>To:</b> Lee Archer<br><b>Cc:</b> sr-users@lists.sip-router.org<br><b>Subject:</b> Re: [SR-Users] LCR database issues<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><br><br>On 11/9/10 10:29 AM, Lee Archer wrote: <o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>Anyone any idea why these are reporting command disabled?</span><o:p></o:p></p><p class=MsoNormal><br>The commands were disabled because the lcr database structure changed completely in 3.1 and the kamctl lcr commands were no longer valid. None of lcr devs/users added a version to work with latest structure, so I disabled them (you can search sr-dev mailing list archive to read the discussion).<br><br>Juha suggested that because there are many tables and columns to write in, a command line approach will not scale. So the option is to use siremis 2.0 to manage lcr rules. There is however one lcr related command in kamctl that computes for you probability numbers. As I am not a user of lcr module, I cannot help more in this aspect, but we will accept any contribution to kamctl that will make provisioning of lcr work again. Also improvements to siremis for lcr (and not only) are welcome.<br><br>Cheers,<br>Daniel<br><br><br><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>Regards</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>Lee</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p><div><div style='border:none;border-top:solid windowtext 1.0pt;padding:3.0pt 0cm 0cm 0cm;border-color:-moz-use-text-color -moz-use-text-color'><p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> <a href="mailto:sr-users-bounces@lists.sip-router.org">sr-users-bounces@lists.sip-router.org</a> [<a href="mailto:sr-users-bounces@lists.sip-router.org">mailto:sr-users-bounces@lists.sip-router.org</a>] <b>On Behalf Of </b>Lee Archer<br><b>Sent:</b> 08 November 2010 17:27<br><b>To:</b> <a href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><br><b>Subject:</b> [SR-Users] LCR database issues</span><o:p></o:p></p></div></div><p class=MsoNormal> <o:p></o:p></p><p><span style='font-family:"Calibri","sans-serif"'>Hi, I have kamailio configured to get it’s LCR info from a mysql database but</span> <span style='font-family:"Calibri","sans-serif"'>when I try to get this info from the command line I am told the command is disabled. Why is this?</span><o:p></o:p></p><p><span style='font-family:"Calibri","sans-serif"'>[root@kam-3-1-s1 kamailio]# kamctl lcr show_gws</span><o:p></o:p></p><p><span style='font-family:"Calibri","sans-serif"'>ERROR: command disabled</span><o:p></o:p></p><p><span style='font-family:"Calibri","sans-serif"'>[root@kam-3-1-s1 kamailio]# kamctl lcr dump_gws</span><o:p></o:p></p><p><span style='font-family:"Calibri","sans-serif"'>ERROR: command disabled</span><o:p></o:p></p><p><span style='font-family:"Calibri","sans-serif"'>[root@kam-3-1-s1 kamailio]# kamctl lcr show_routes</span><o:p></o:p></p><p><span style='font-family:"Calibri","sans-serif"'>ERROR: command disabled</span><o:p></o:p></p><p><span style='font-family:"Calibri","sans-serif"'>[root@kam-3-1-s1 kamailio]# kamctl lcr dump_routes</span><o:p></o:p></p><p><span style='font-family:"Calibri","sans-serif"'>ERROR: command disabled</span><o:p></o:p></p><p><span style='font-family:"Calibri","sans-serif"'>[root@kam-3-1-s1 kamailio]# kamctl lcr show_gws</span><o:p></o:p></p><p><span style='font-family:"Calibri","sans-serif"'>ERROR: command disabled</span><o:p></o:p></p><p><span style='font-family:"Calibri","sans-serif"'> lcr show_gws....... show database gateways</span><o:p></o:p></p><p><span style='font-family:"Calibri","sans-serif"'> lcr show_routes.... show database routes</span><o:p></o:p></p><p><span style='font-family:"Calibri","sans-serif"'> lcr dump_gws....... show in memory gateways</span><o:p></o:p></p><p><span style='font-family:"Calibri","sans-serif"'> lcr dump_routes.... show in memory routes</span><o:p></o:p></p><p><span style='font-family:"Calibri","sans-serif"'> lcr reload ........ reload lcr gateways and routes</span><o:p></o:p></p><p><span style='font-family:"Calibri","sans-serif"'> lcr eval_weights .. evaluates probability for given GW's weights</span><o:p></o:p></p><p><span style='font-family:"Calibri","sans-serif"'>[root@kam-3-1-s1 kamailio]# kamctl lcr reload</span><o:p></o:p></p><p><span style='font-family:"Calibri","sans-serif"'>ERROR: command disabled</span><o:p></o:p></p><p><span style='font-family:"Calibri","sans-serif"'>Regards</span><o:p></o:p></p><p><span style='font-family:"Calibri","sans-serif"'>Lee</span><o:p></o:p></p><pre><o:p> </o:p></pre><pre><o:p> </o:p></pre><pre>_______________________________________________<o:p></o:p></pre><pre>SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list<o:p></o:p></pre><pre><a href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><o:p></o:p></pre><pre><a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><o:p></o:p></pre><p class=MsoNormal><br><br><o:p></o:p></p><pre>-- <o:p></o:p></pre><pre>Daniel-Constantin Mierla<o:p></o:p></pre><pre><a href="http://www.asipto.com">http://www.asipto.com</a><o:p></o:p></pre></div></body></html>