<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#ffffff" text="#000000">
    <br>
    <br>
    On 11/9/10 10:29 AM, Lee Archer wrote:
    <blockquote
      cite="mid:B916037C74E10442982E494BA3F108F60FE93734@MAIL1.thebigword.com"
      type="cite">
      <meta http-equiv="Content-Type" content="text/html;
        charset=ISO-8859-1">
      <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;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0cm;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Times New Roman","serif";}
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";}
span.EmailStyle18
        {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]-->
      <div class="WordSection1">
        <p class="MsoNormal"><span style="font-size: 11pt; font-family:
            &quot;Calibri&quot;,&quot;sans-serif&quot;; color: rgb(31,
            73, 125);">Anyone any idea why these are reporting command
            disabled?</span></p>
      </div>
    </blockquote>
    <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>
    <blockquote
      cite="mid:B916037C74E10442982E494BA3F108F60FE93734@MAIL1.thebigword.com"
      type="cite">
      <div class="WordSection1">
        <p class="MsoNormal"><span style="font-size: 11pt; font-family:
            &quot;Calibri&quot;,&quot;sans-serif&quot;; color: rgb(31,
            73, 125);"><o:p></o:p></span></p>
        <p class="MsoNormal"><span style="font-size: 11pt; font-family:
            &quot;Calibri&quot;,&quot;sans-serif&quot;; color: rgb(31,
            73, 125);"><o:p>&nbsp;</o:p></span></p>
        <p class="MsoNormal"><span style="font-size: 11pt; font-family:
            &quot;Calibri&quot;,&quot;sans-serif&quot;; color: rgb(31,
            73, 125);">Regards<o:p></o:p></span></p>
        <p class="MsoNormal"><span style="font-size: 11pt; font-family:
            &quot;Calibri&quot;,&quot;sans-serif&quot;; color: rgb(31,
            73, 125);"><o:p>&nbsp;</o:p></span></p>
        <p class="MsoNormal"><span style="font-size: 11pt; font-family:
            &quot;Calibri&quot;,&quot;sans-serif&quot;; color: rgb(31,
            73, 125);">Lee<o:p></o:p></span></p>
        <p class="MsoNormal"><span style="font-size: 11pt; font-family:
            &quot;Calibri&quot;,&quot;sans-serif&quot;; color: rgb(31,
            73, 125);"><o:p>&nbsp;</o:p></span></p>
        <div>
          <div style="border-right: medium none; border-width: 1pt
            medium medium; border-style: solid none none; border-color:
            rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color;
            padding: 3pt 0cm 0cm;">
            <p class="MsoNormal"><b><span style="font-size: 10pt;
                  font-family:
                  &quot;Tahoma&quot;,&quot;sans-serif&quot;;"
                  lang="EN-US">From:</span></b><span style="font-size:
                10pt; font-family:
                &quot;Tahoma&quot;,&quot;sans-serif&quot;;" lang="EN-US">
                <a class="moz-txt-link-abbreviated" href="mailto:sr-users-bounces@lists.sip-router.org">sr-users-bounces@lists.sip-router.org</a>
                [<a class="moz-txt-link-freetext" 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 class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><br>
                <b>Subject:</b> [SR-Users] LCR database issues<o:p></o:p></span></p>
          </div>
        </div>
        <p class="MsoNormal"><o:p>&nbsp;</o:p></p>
        <p><span style="font-family:
            &quot;Calibri&quot;,&quot;sans-serif&quot;;">Hi, I have
            kamailio configured to get it&#8217;s LCR info from a mysql
            database but</span> <span style="font-family:
            &quot;Calibri&quot;,&quot;sans-serif&quot;;">when I try to
            get this info from the command line I am told the command is
            disabled.&nbsp; Why is this?</span><o:p></o:p></p>
        <p><span style="font-family:
            &quot;Calibri&quot;,&quot;sans-serif&quot;;">[root@kam-3-1-s1
            kamailio]# kamctl lcr show_gws</span><o:p></o:p></p>
        <p><span style="font-family:
            &quot;Calibri&quot;,&quot;sans-serif&quot;;">ERROR: command
            disabled</span><o:p></o:p></p>
        <p><span style="font-family:
            &quot;Calibri&quot;,&quot;sans-serif&quot;;">[root@kam-3-1-s1
            kamailio]# kamctl lcr dump_gws</span><o:p></o:p></p>
        <p><span style="font-family:
            &quot;Calibri&quot;,&quot;sans-serif&quot;;">ERROR: command
            disabled</span><o:p></o:p></p>
        <p><span style="font-family:
            &quot;Calibri&quot;,&quot;sans-serif&quot;;">[root@kam-3-1-s1
            kamailio]# kamctl lcr show_routes</span><o:p></o:p></p>
        <p><span style="font-family:
            &quot;Calibri&quot;,&quot;sans-serif&quot;;">ERROR: command
            disabled</span><o:p></o:p></p>
        <p><span style="font-family:
            &quot;Calibri&quot;,&quot;sans-serif&quot;;">[root@kam-3-1-s1
            kamailio]# kamctl lcr dump_routes</span><o:p></o:p></p>
        <p><span style="font-family:
            &quot;Calibri&quot;,&quot;sans-serif&quot;;">ERROR: command
            disabled</span><o:p></o:p></p>
        <p><span style="font-family:
            &quot;Calibri&quot;,&quot;sans-serif&quot;;">[root@kam-3-1-s1
            kamailio]# kamctl lcr show_gws</span><o:p></o:p></p>
        <p><span style="font-family:
            &quot;Calibri&quot;,&quot;sans-serif&quot;;">ERROR: command
            disabled</span><o:p></o:p></p>
        <p><span style="font-family:
            &quot;Calibri&quot;,&quot;sans-serif&quot;;">&nbsp;lcr
            show_gws....... show database gateways</span><o:p></o:p></p>
        <p><span style="font-family:
            &quot;Calibri&quot;,&quot;sans-serif&quot;;">&nbsp;lcr
            show_routes.... show database routes</span><o:p></o:p></p>
        <p><span style="font-family:
            &quot;Calibri&quot;,&quot;sans-serif&quot;;">&nbsp;lcr
            dump_gws....... show in memory gateways</span><o:p></o:p></p>
        <p><span style="font-family:
            &quot;Calibri&quot;,&quot;sans-serif&quot;;">&nbsp;lcr
            dump_routes.... show in memory routes</span><o:p></o:p></p>
        <p><span style="font-family:
            &quot;Calibri&quot;,&quot;sans-serif&quot;;">&nbsp;lcr reload
            ........ reload lcr gateways and routes</span><o:p></o:p></p>
        <p><span style="font-family:
            &quot;Calibri&quot;,&quot;sans-serif&quot;;">&nbsp;lcr
            eval_weights .. evaluates probability for given GW's weights</span><o:p></o:p></p>
        <p><span style="font-family:
            &quot;Calibri&quot;,&quot;sans-serif&quot;;">[root@kam-3-1-s1
            kamailio]# kamctl lcr reload</span><o:p></o:p></p>
        <p><span style="font-family:
            &quot;Calibri&quot;,&quot;sans-serif&quot;;">ERROR: command
            disabled</span><o:p></o:p></p>
        <p><span style="font-family:
            &quot;Calibri&quot;,&quot;sans-serif&quot;;">Regards</span><o:p></o:p></p>
        <p><span style="font-family:
            &quot;Calibri&quot;,&quot;sans-serif&quot;;">Lee</span><o:p></o:p></p>
      </div>
      <pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
    </blockquote>
    <br>
    <pre class="moz-signature" cols="72">-- 
Daniel-Constantin Mierla
<a class="moz-txt-link-freetext" href="http://www.asipto.com">http://www.asipto.com</a></pre>
  </body>
</html>