<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<tt>Hi Jonathan,<br>
<br>
The "dr show" actually does a full select from the dr_rules table,
ordered by the groupid column. So, what do you mean by "</tt><tt>Its
still showing rule id's that don't exist anymore" ? Using a
regular select over the dr_rules table shows you some records
which are not listed by "dr show" (also from DB) ??<br>
<br>
Best regards,<br>
</tt>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a>
OpenSIPS Summit 2018
<a class="moz-txt-link-freetext" href="http://www.opensips.org/events/Summit-2018Amsterdam">http://www.opensips.org/events/Summit-2018Amsterdam</a>
</pre>
<div class="moz-cite-prefix">On 03/11/2018 06:56 PM, Jonathan
Mabrito wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAL4wWrgCJf23x22FjOCafc4iHubEdXRkNVPkahEf0SYPsbB_ww@mail.gmail.com">
<div dir="ltr">After some more investigating, I determined the
routing issues turned out to be regex manipulation errors I had
going on in the Dialplan module. All looks good on number
routing now.
<div><br>
</div>
<div>I am noticing issues thought still with the output of
"opensipsctl dr show" and the routing table for dr_rules. Its
still showing rule id's that don't exist anymore, its not
showing the order of precedence for rules correctly, etc.
Since the number routing is ok, I suspect the show command may
just be the issue. I can reproduce this on our Opensips 2.3
and 2.2.6 nodes.</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr">On Fri, Mar 9, 2018 at 3:11 PM Jonathan Mabrito
<<a href="mailto:mabritoj@gmail.com" moz-do-not-send="true">mabritoj@gmail.com</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">Today I started noticing a discrepancy of
entries between whats in our MySQL database and whats loaded
in the OpenSIPS memory for DR_Rules.
<div><br>
</div>
<div>For instance, if I run "opensipsctl dr show" I see a
rule with ID 402 and 405. If I look in the MySQL database
and in the dr_rules table, I do not see any rules with
these ID's. </div>
<div><br>
</div>
<div>I am not sure what is causing this or really how this
is happening. Trying to comb thru the syslog output to see
if anything stands out. I do see the parse statements when
its reading the DB and I can tell its not reading any
entries with ID's of 402 and 405.</div>
<div><br>
</div>
<div>I can upload any logs etc that might be helpful. Just
let me know! Could use some assistance on this as its
causing some routing issues of certain numbers. </div>
</div>
-- <br>
<div dir="ltr" class="m_-7615617459524752530gmail_signature"
data-smartmail="gmail_signature">
<div dir="ltr">-Jonathan</div>
</div>
</blockquote>
</div>
-- <br>
<div dir="ltr" class="gmail_signature"
data-smartmail="gmail_signature">
<div dir="ltr">-Jonathan</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</body>
</html>