[Spce-user] Peering Rules database vs. GUI Issue

[Andreas Granig]

Hi,

Can you share some information about the history of your setup? Which
version did you use for the initial setup? Any things you remember doing
to your peerings, like deleting groups or something?

There have been some issues with older versions couple of months ago in
the triggers synchronizing the databases provisioning and kamailio, but
they have been fixed in 3.1 already.

Andreas

On 08/11/2014 08:33 AM, Gary Nieboer wrote:
> I have another instance of the GUI not matching the database.
> 
> 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.
> 
> Is there anything that can be done to "refresh" the GUI to reflect what
> is actually in the database.
> 
> Also, is it safe to use mysql and delete the rule?
> 
> Thanks,
> 
> Gary
> 
> The Example:   In 
> 
> --
> Gary Nieboer
> 
> 
> 877-763-1014 Toll Free  |  801-657-5484 Utah  |  615-800-6946 Tennessee 
> | 801-694-6106 Mobile
> gary at netdiverse.com <mailto:gary at netdiverse.com>  |   www.netdiverse.com
> <http://www.netdiverse.com/>
> 
> 
> On Fri, Aug 1, 2014 at 2:55 PM, Gary Nieboer <gary at netdiverse.com
> <mailto:gary at netdiverse.com>> wrote:
> 
> 
>     We have experienced a few issues with our "Peering Rules" on SPCE,
>     3.3.1.
> 
>     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.
> 
>     We recently did a comparison of what is shown in the database:
>      lcr_rules
> 
>                                 select * from lcr_rule;
> 
> 
>     Here are a few lines from the database:   Some numbers are replaced
>     with "`" and not fully shown:
> 
>     Note:  Rule 102 is missing from the database
> 
> 
>     | id  | lcr_id | prefix | request_uri | from_uri | stopper | enabled
>     | group_id |
>     +-----+--------+--------+-------------+----------+---------+---------+----------+
>     | 101 |      1 |        | ~~~~~20088  | NULL     |       0 |       1
>     |       23 |
>     | 105 |      1 |        | ~~~~~20186  | NULL     |       0 |       1
>     |       23 |
>     | 106 |      1 |        | ~~~~~74891  | NULL     |       0 |       1
>     |       23 |
> 
> 
> 
>     Now, here is a screenshot of the GUI for the same rules:
>     Note:  Rule 102 exists under peer group 23 for the GUI.
>     Inline image 1
> 
> 
> 
>     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.
> 
>     If you would like more information, we can share it.
> 
>     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.
> 
>     Thanks,
> 
>     Gary
> 
> 
> 
> 
> _______________________________________________
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> https://lists.sipwise.com/listinfo/spce-user
>