<div dir="ltr">I have another instance of the GUI not matching the database.<div><br></div><div>A peering rule ID 233 exists in the database & it was different than the rule showing in the GUI. Changing the rule in the GUI didn't adjust the database. Deleting the rule in the GUI didn't adjust the database.</div>
<div><div><br></div><div>Is there anything that can be done to "refresh" the GUI to reflect what is actually in the database.</div><div><br></div><div>Also, is it safe to use mysql and delete the rule?</div><div>
<br></div><div>Thanks,</div><div><br>Gary</div><div><br></div><div>The Example: In </div>
</div></div><div class="gmail_extra"><br clear="all"><div><div dir="ltr">--<br>Gary Nieboer<div><br><div><img src="http://netdiverse.com/content/images/netDiverse_FINAL_Digital_4M.png" width="200" height="46"><span></span><span></span></div>
<div><br>877-763-1014 Toll Free | 801-657-5484 Utah | 615-800-6946 Tennessee | 801-694-6106 Mobile<br>
<a href="mailto:gary@netdiverse.com" target="_blank">gary@netdiverse.com</a> | <a href="http://www.netdiverse.com/" target="_blank">www.netdiverse.com</a><br> </div></div></div></div>
<br><br><div class="gmail_quote">On Fri, Aug 1, 2014 at 2:55 PM, Gary Nieboer <span dir="ltr"><<a href="mailto:gary@netdiverse.com" target="_blank">gary@netdiverse.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr"><br clear="all"><div><div>We have experienced a few issues with our "Peering Rules" on SPCE, 3.3.1.</div></div><div><br></div><div>A created rule exists in the GUI, but when routing a call through the SBC, the call follows a route to a default peer rather than the peer indicated in the GUI.</div>
<div><br></div><div>We recently did a comparison of what is shown in the database: lcr_rules</div><div><br></div><div> select * from lcr_rule;<br></div><div><br></div><div><br></div><div>Here are a few lines from the database: Some numbers are replaced with "`" and not fully shown:</div>
<div><br></div><div>Note: Rule 102 is missing from the database</div><div><br></div><div><br></div><div><div><font face="courier new, monospace">| id | lcr_id | prefix | request_uri | from_uri | stopper | enabled | group_id |</font></div>
<div><font face="courier new, monospace">+-----+--------+--------+-------------+----------+---------+---------+----------+</font></div></div><div><div><font face="courier new, monospace">| 101 | 1 | | ~~~~~20088 | NULL | 0 | 1 | 23 |</font></div>
<div><font face="courier new, monospace">| 105 | 1 | | ~~~~~20186 | NULL | 0 | 1 | 23 |</font></div><div><font face="courier new, monospace">| 106 | 1 | | ~~~~~74891 | NULL | 0 | 1 | 23 |</font></div>
</div><div><br></div><div><br></div><div><br></div><div>Now, here is a screenshot of the GUI for the same rules:</div><div>Note: Rule 102 exists under peer group 23 for the GUI.</div><div><img src="cid:ii_14793533d13d9509" alt="Inline image 1" style="margin-right:25px"><br>
</div><div><br></div><div><br></div><div><br></div><div>It appears we should trust the data in the database and not the GUI, but I'm assuming it is not desired behavior for the GUI and database to reflect different info.</div>
<div><br></div><div>If you would like more information, we can share it.</div><div><br>Please let me know if there is anything we can do to ensure the GUI reflects the actual activity of the database and ngcp/kamailio.</div>
<div><br></div><div>Thanks,</div><div><br>Gary</div>
</div>
</blockquote></div><br></div>