<div dir="ltr">I think it be easier if I show you. I uploaded a export of the "dr show" command and an export for the dr_rules and dr_gateways MySQL table here: <a href="https://drive.google.com/open?id=1YapVA5u2ftl7ASXYpN0LFZfnRCVdDKRW">https://drive.google.com/open?id=1YapVA5u2ftl7ASXYpN0LFZfnRCVdDKRW</a><div><br></div><div>Take a look at the dr show export for rules and for example look at groupid 7 and notice there is only one entry. In the dr_rules table export, there a few dozen entries with groupid 7 (actually routing seems to work when I dial a few of the numbers if groupid 7). Another example would be too look at groupid 8 in the dr show output. Notice that some id's in the dr_rules export that are not in the show output (the higher groupid's). </div><div><br></div><div>Take a look at the dr show export for gateways and look at how many gateways are returned in the show output vs whats in the db table export. </div><div><br></div><div>Also, I thought dr show showed the precedence selection of dr_rules? It looks like its just a output with a "order by groupid" applied to the SQL select. Maybe that was a wrong assumption on my end?</div><div><br></div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr">On Mon, Mar 12, 2018 at 10:17 AM Bogdan-Andrei Iancu <<a href="mailto:bogdan@opensips.org">bogdan@opensips.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div 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="m_4833324289091672971moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="m_4833324289091672971moz-txt-link-freetext" href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-solutions.com</a>
OpenSIPS Summit 2018
<a class="m_4833324289091672971moz-txt-link-freetext" href="http://www.opensips.org/events/Summit-2018Amsterdam" target="_blank">http://www.opensips.org/events/Summit-2018Amsterdam</a>
</pre></div><div bgcolor="#FFFFFF" text="#000000">
<div class="m_4833324289091672971moz-cite-prefix">On 03/11/2018 06:56 PM, Jonathan
Mabrito wrote:<br>
</div>
</div><div bgcolor="#FFFFFF" text="#000000"><blockquote type="cite">
<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" target="_blank">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_4833324289091672971m_-7615617459524752530gmail_signature" data-smartmail="gmail_signature">
<div dir="ltr">-Jonathan</div>
</div>
</blockquote>
</div>
-- <br>
<div dir="ltr" class="m_4833324289091672971gmail_signature" data-smartmail="gmail_signature">
<div dir="ltr">-Jonathan</div>
</div>
<br>
<fieldset class="m_4833324289091672971mimeAttachmentHeader"></fieldset>
<br>
</blockquote></div><div bgcolor="#FFFFFF" text="#000000"><blockquote type="cite"><pre>_______________________________________________
Users mailing list
<a class="m_4833324289091672971moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>
<a class="m_4833324289091672971moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</div>
</blockquote></div>-- <br><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr">-Jonathan</div></div>