<!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 12:31 PM, Lee Archer wrote:
<blockquote
cite="mid:B916037C74E10442982E494BA3F108F60FE93D46@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;}
@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]-->
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size: 11pt; font-family:
"Calibri","sans-serif"; color: rgb(31,
73, 125);">Thanks for the reply. Can I suggest that instead
of displaying the value 0 as blank the interface actually
displays 0?</span></p>
</div>
</blockquote>
<br>
You talk here about siremis, like you wrote in another email? Or is
still about the lcr commands in kamctl?<br>
<br>
Cheers,<br>
Daniel<br>
<br>
<blockquote
cite="mid:B916037C74E10442982E494BA3F108F60FE93D46@MAIL1.thebigword.com"
type="cite">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size: 11pt; font-family:
"Calibri","sans-serif"; color: rgb(31,
73, 125);"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family:
"Calibri","sans-serif"; color: rgb(31,
73, 125);"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family:
"Calibri","sans-serif"; color: rgb(31,
73, 125);">Regards<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family:
"Calibri","sans-serif"; color: rgb(31,
73, 125);"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family:
"Calibri","sans-serif"; color: rgb(31,
73, 125);">Lee<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family:
"Calibri","sans-serif"; color: rgb(31,
73, 125);"><o:p> </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:
"Tahoma","sans-serif"; color:
windowtext;" lang="EN-US">From:</span></b><span
style="font-size: 10pt; font-family:
"Tahoma","sans-serif"; color:
windowtext;" lang="EN-US"> Daniel-Constantin Mierla
[<a class="moz-txt-link-freetext" href="mailto:miconda@gmail.com">mailto:miconda@gmail.com</a>] <br>
<b>Sent:</b> 09 November 2010 09:45<br>
<b>To:</b> Lee Archer<br>
<b>Cc:</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> 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: 11pt; 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: 11pt; font-family:
"Calibri","sans-serif";"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family:
"Calibri","sans-serif";">Regards</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family:
"Calibri","sans-serif";"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family:
"Calibri","sans-serif";">Lee</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family:
"Calibri","sans-serif";"> </span><o:p></o:p></p>
<div>
<div style="border-right: medium none; border-width: 1pt
medium medium; border-style: solid none none; padding: 3pt
0cm 0cm; border-color: -moz-use-text-color;">
<p class="MsoNormal"><b><span style="font-size: 10pt;
font-family:
"Tahoma","sans-serif";"
lang="EN-US">From:</span></b><span style="font-size:
10pt; font-family:
"Tahoma","sans-serif";" lang="EN-US">
<a moz-do-not-send="true"
href="mailto:sr-users-bounces@lists.sip-router.org">sr-users-bounces@lists.sip-router.org</a>
[<a moz-do-not-send="true"
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 moz-do-not-send="true"
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 moz-do-not-send="true" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><o:p></o:p></pre>
<pre><a moz-do-not-send="true" 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 moz-do-not-send="true" href="http://www.asipto.com">http://www.asipto.com</a><o:p></o:p></pre>
</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>