[Spce-user] Can't create new SIP Peering Groups on MR3.2.1

[Andrew Pogrebennyk]

Hi,
this has been optimized in the next release mr3.5 (internal ticket id is
MT#8371). It should be out in about a week of time. I currently don't
see it possible for me to backport this to the version mr3.4.2.

Regards,
Andrew

On 10/10/2014 12:51 PM, Joel S. | VOZELIA wrote:
> Hi, 
> 
> We have a problem on mr3.2.1, when we try to create a new SIP Peering Group, we can't select the "Contract" as it never finishes "loading..." 
> 
> I think the problem is the amount of contracts that we have... (over 100k customers, each with 1 subscriber):
> 
> mysql> select count(*) from billing.contracts;
> +----------+
> | count(*) |
> +----------+
> |   106769 |
> +----------+
> 1 row in set (0.01 sec)
> 
> mysql>
> 
> Should I try to create the peering group through the API? I already know my peering contract id is "5" so I really don't need to select it from the list.
> 
> If not, can I directly do an INSERT to the provisioning.voip_peer_groups table with peering_contract_id=5 ? Do I have to INSERT into more tables?
> 
> mysql> select name,priority,peering_contract_id from voip_peer_groups;
> +--------+----------+---------------------+
> | name   | priority | peering_contract_id |
> +--------+----------+---------------------+
> | XXXXXX |        1 |                   5 |
> | XXXXXX |        2 |                   5 |
> | XXXXXX |        4 |                   5 |
> | XXXXXX |        3 |                   5 |
> | XXXXXX |        6 |                   5 |
> +--------+----------+---------------------+
> 5 rows in set (0.00 sec)
> 
> mysql> 
> 
> 
> I don't know why I cant do it though the GUI, could there be some sort of "loading timeout" that we are hitting and when the DB query finishes the webpage does not load the data?
> 
> 
> Best regards, 
> Joel.
> _______________________________________________
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> https://lists.sipwise.com/listinfo/spce-user
>