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

[Gary Nieboer]

Oops - I forgot to send this to the spce list.  So here it is again.

Andreas,

Thanks for the response.



*>>Can you share some information about the history of your setup?
Whichversion did you use for the initial setup? *

This box was a fresh install with version 3.1.1

We upgraded to 3.3.1  about a month ago.

We have increased the usage and complexity of the system, it is 100% "Peer
to Peer" with no subscribers.




*>>Any things you remember doing to your peerings, like deleting groups or
something?*

Yes, we have added, deleted, and edited many   Peering Groups, Peering
Rules and Rewrite Rules in the system through the GUI.

We have about 30 Peering Groups, 250 peering rules, 10 Rewrite Sets, and 25
Rewrite Rules.


Thanks in advance for any recommendations or feedback.

If we are able to update the database tables directly through mysql, and
then have the GUI reflect what is in the database tables, it would be our
ideal situation and resolution.

Thanks,

Gary



On Mon, Aug 11, 2014 at 2:09 AM, Andreas Granig <agranig at sipwise.com> wrote:

> 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
> >
> _______________________________________________
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> https://lists.sipwise.com/listinfo/spce-user
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20140819/565d5567/attachment-0001.html>