[Spce-user] Adding an alias to a subscriber deletes specific existing set of alias

Gerhard Jungwirth gjungwirth at sipwise.com
Thu Aug 6 12:52:26 EDT 2015


Hi,

thanks for the bugreport. This issue has now been fixed with the latest 
release of ngcp-panel (mr3.8.2.12). Please update and tell us if that 
solves your issue.

Gerhard

On 08/04/2015 04:40 PM, Andrew Pogrebennyk wrote:
> Ok, thanks for dump.. I will check with our web dev. This may take a
> couple of days before I get back to you, though.
>
> Andrew
>
> On 08/04/2015 04:38 PM, Abel Alejandro wrote:
>> The count looks the same but the ORDER of the DID that do not appear on
>> the Edit form is different. The BAD did are 17877487645 and 17879057355
>>
>>
>> mysql> select count(*) from provisioning.voip_dbaliases where
>> subscriber_id=47;
>> +----------+
>> | count(*) |
>> +----------+
>> |       85 |
>> +----------+
>> 1 row in set (0.00 sec)
>>
>> mysql> select count(*) from billing.voip_numbers where subscriber_id=43;
>> +----------+
>> | count(*) |
>> +----------+
>> |       85 |
>> +----------+
>> 1 row in set (0.00 sec)
>>
>> mysql> select * from billing.voip_numbers where subscriber_id=43;
>> +-------+----+-----+---------+-------------+---------------+--------+--------+---------------------+
>> | id    | cc | ac  | sn      | reseller_id | subscriber_id | status |
>> ported | list_timestamp      |
>> +-------+----+-----+---------+-------------+---------------+--------+--------+---------------------+
>> |   911 |  1 | 787 | 7052432 |          10 |            43 | active |
>>     0 | 2014-06-17 13:11:32 |
>> |  8972 |  1 | 787 | 2687353 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:44 |
>> |  8973 |  1 | 787 | 6524000 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:44 |
>> |  8974 |  1 | 787 | 6524001 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:44 |
>> |  8975 |  1 | 787 | 6524002 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:44 |
>> |  8976 |  1 | 787 | 6524003 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:44 |
>> |  8977 |  1 | 787 | 6524004 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:44 |
>> |  8978 |  1 | 787 | 8054100 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:44 |
>> |  8979 |  1 | 787 | 8346242 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:44 |
>> |  8980 |  1 | 787 | 9354000 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:44 |
>> |  8981 |  1 | 787 | 9354001 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:44 |
>> |  8982 |  1 | 787 | 9354002 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  8983 |  1 | 787 | 9354004 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  8984 |  1 | 787 | 9350102 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  8985 |  1 | 787 | 8492888 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  8986 |  1 | 787 | 6525000 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  8987 |  1 | 787 | 6525001 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  8988 |  1 | 787 | 6525002 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  8989 |  1 | 787 | 6525003 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  8990 |  1 | 787 | 6524005 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  8991 |  1 | 787 | 6524006 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  8992 |  1 | 787 | 6524007 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  8993 |  1 | 787 | 6524008 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  8994 |  1 | 787 | 6524009 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  8995 |  1 | 787 | 6525004 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  8996 |  1 | 787 | 2968286 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  8997 |  1 | 787 | 2968284 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  9004 |  1 | 787 | 9576222 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  9006 |  1 | 787 | 9667163 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  9007 |  1 | 787 | 9667586 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  9008 |  1 | 787 | 9667589 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  9009 |  1 | 787 | 9667592 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  9011 |  1 | 787 | 9619786 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  9012 |  1 | 787 | 9619787 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  9013 |  1 | 787 | 9619788 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  9014 |  1 | 787 | 9619789 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  9015 |  1 | 787 | 7109657 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  9016 |  1 | 787 | 6657891 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  9017 |  1 | 787 | 6657892 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  9018 |  1 | 787 | 7050939 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  9019 |  1 | 787 | 7050940 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  9020 |  1 | 787 | 7050948 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  9021 |  1 | 787 | 7086472 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  9022 |  1 | 787 | 7086473 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  9023 |  1 | 787 | 9455094 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  9024 |  1 | 787 | 9455096 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  9025 |  1 | 787 | 9455097 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  9026 |  1 | 787 | 9455098 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  9028 |  1 | 787 | 7052433 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  9030 |  1 | 787 | 7052436 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  9031 |  1 | 787 | 7052437 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  9032 |  1 | 787 | 7109659 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  9033 |  1 | 787 | 7109661 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  9034 |  1 | 787 | 7107631 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  9035 |  1 | 787 | 7107632 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  9036 |  1 | 787 | 9667014 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  9037 |  1 | 787 | 9667019 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  9038 |  1 | 787 | 9667017 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  9039 |  1 | 787 | 9667029 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  9040 |  1 | 787 | 3957441 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  9041 |  1 | 787 | 9619794 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  9042 |  1 | 787 | 9619793 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  9043 |  1 | 787 | 7057382 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  9044 |  1 | 787 | 7057383 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  9045 |  1 | 787 | 2667259 |          10 |            43 | active |
>>     0 | 2014-09-23 10:02:45 |
>> |  9514 |  1 | 787 | 9619790 |          10 |            43 | active |
>>     0 | 2014-11-14 14:38:30 |
>> |  9610 |  1 | 787 | 7650130 |          10 |            43 | active |
>>     0 | 2015-01-07 11:17:19 |
>> |  9611 |  1 | 787 | 7657386 |          10 |            43 | active |
>>     0 | 2015-01-07 11:17:19 |
>> |  9612 |  1 | 787 | 7729149 |          10 |            43 | active |
>>     0 | 2015-01-07 11:17:19 |
>> |  9755 |  1 | 787 | 7845000 |          10 |            43 | active |
>>     0 | 2015-03-26 10:45:52 |
>> |  9758 |  1 | 787 | 7845051 |          10 |            43 | active |
>>     0 | 2015-03-26 16:01:08 |
>> |  9780 |  1 | 787 | 7265929 |          10 |            43 | active |
>>     0 | 2015-04-09 13:26:54 |
>> |  9781 |  1 | 787 | 7286969 |          10 |            43 | active |
>>     0 | 2015-04-09 13:26:54 |
>> |  9843 |  1 | 787 | 7551210 |          10 |            43 | active |
>>     0 | 2015-06-11 11:14:59 |
>> |  9844 |  1 | 787 | 7487645 |          10 |            43 | active |
>>     0 | 2015-08-02 10:41:06 |
>> |  9845 |  1 | 787 | 7551235 |          10 |            43 | active |
>>     0 | 2015-06-11 11:14:59 |
>> |  9846 |  1 | 787 | 7551260 |          10 |            43 | active |
>>     0 | 2015-06-11 11:14:59 |
>> |  9847 |  1 | 787 | 7551300 |          10 |            43 | active |
>>     0 | 2015-06-11 11:14:59 |
>> |  9850 |  1 | 787 | 9057355 |          10 |            43 | active |
>>     0 | 2015-08-02 10:41:06 |
>> | 10096 |  1 | 787 | 4740636 |          10 |            43 | active |
>>     0 | 2015-07-30 13:42:56 |
>> | 10097 |  1 | 787 | 4740637 |          10 |            43 | active |
>>     0 | 2015-07-30 15:38:45 |
>> | 10098 |  1 | 787 | 4740638 |          10 |            43 | active |
>>     0 | 2015-07-30 15:38:45 |
>> | 10099 |  1 | 787 | 4740639 |          10 |            43 | active |
>>     0 | 2015-07-30 15:38:45 |
>> | 10100 |  1 | 787 | 4740640 |          10 |            43 | active |
>>     0 | 2015-07-30 15:38:45 |
>> | 10101 |  1 | 787 | 4740641 |          10 |            43 | active |
>>     0 | 2015-07-30 15:38:45 |
>> +-------+----+-----+---------+-------------+---------------+--------+--------+---------------------+
>>
>> mysql> select * from provisioning.voip_dbaliases where subscriber_id=47;
>> +-------+-------------+-----------+---------------+------------+
>> | id    | username    | domain_id | subscriber_id | is_primary |
>> +-------+-------------+-----------+---------------+------------+
>> |  9221 | 17877052432 |         3 |            47 |          1 |
>> |  9222 | 17872687353 |         3 |            47 |          0 |
>> |  9223 | 17876524000 |         3 |            47 |          0 |
>> |  9224 | 17876524001 |         3 |            47 |          0 |
>> |  9225 | 17876524002 |         3 |            47 |          0 |
>> |  9226 | 17876524003 |         3 |            47 |          0 |
>> |  9227 | 17876524004 |         3 |            47 |          0 |
>> |  9228 | 17878054100 |         3 |            47 |          0 |
>> |  9229 | 17878346242 |         3 |            47 |          0 |
>> |  9230 | 17879354000 |         3 |            47 |          0 |
>> |  9231 | 17879354001 |         3 |            47 |          0 |
>> |  9232 | 17879354002 |         3 |            47 |          0 |
>> |  9233 | 17879354004 |         3 |            47 |          0 |
>> |  9234 | 17879350102 |         3 |            47 |          0 |
>> |  9235 | 17878492888 |         3 |            47 |          0 |
>> |  9236 | 17876525000 |         3 |            47 |          0 |
>> |  9237 | 17876525001 |         3 |            47 |          0 |
>> |  9238 | 17876525002 |         3 |            47 |          0 |
>> |  9239 | 17876525003 |         3 |            47 |          0 |
>> |  9240 | 17876524005 |         3 |            47 |          0 |
>> |  9241 | 17876524006 |         3 |            47 |          0 |
>> |  9242 | 17876524007 |         3 |            47 |          0 |
>> |  9243 | 17876524008 |         3 |            47 |          0 |
>> |  9244 | 17876524009 |         3 |            47 |          0 |
>> |  9245 | 17876525004 |         3 |            47 |          0 |
>> |  9246 | 17872968286 |         3 |            47 |          0 |
>> |  9247 | 17872968284 |         3 |            47 |          0 |
>> |  9254 | 17879576222 |         3 |            47 |          0 |
>> |  9256 | 17879667163 |         3 |            47 |          0 |
>> |  9257 | 17879667586 |         3 |            47 |          0 |
>> |  9258 | 17879667589 |         3 |            47 |          0 |
>> |  9259 | 17879667592 |         3 |            47 |          0 |
>> |  9261 | 17879619786 |         3 |            47 |          0 |
>> |  9262 | 17879619787 |         3 |            47 |          0 |
>> |  9263 | 17879619788 |         3 |            47 |          0 |
>> |  9264 | 17879619789 |         3 |            47 |          0 |
>> |  9265 | 17877109657 |         3 |            47 |          0 |
>> |  9266 | 17876657891 |         3 |            47 |          0 |
>> |  9267 | 17876657892 |         3 |            47 |          0 |
>> |  9268 | 17877050939 |         3 |            47 |          0 |
>> |  9269 | 17877050940 |         3 |            47 |          0 |
>> |  9270 | 17877050948 |         3 |            47 |          0 |
>> |  9271 | 17877086472 |         3 |            47 |          0 |
>> |  9272 | 17877086473 |         3 |            47 |          0 |
>> |  9273 | 17879455094 |         3 |            47 |          0 |
>> |  9274 | 17879455096 |         3 |            47 |          0 |
>> |  9275 | 17879455097 |         3 |            47 |          0 |
>> |  9276 | 17879455098 |         3 |            47 |          0 |
>> |  9278 | 17877052433 |         3 |            47 |          0 |
>> |  9280 | 17877052436 |         3 |            47 |          0 |
>> |  9281 | 17877052437 |         3 |            47 |          0 |
>> |  9282 | 17877109659 |         3 |            47 |          0 |
>> |  9283 | 17877109661 |         3 |            47 |          0 |
>> |  9284 | 17877107631 |         3 |            47 |          0 |
>> |  9285 | 17877107632 |         3 |            47 |          0 |
>> |  9286 | 17879667014 |         3 |            47 |          0 |
>> |  9287 | 17879667019 |         3 |            47 |          0 |
>> |  9288 | 17879667017 |         3 |            47 |          0 |
>> |  9289 | 17879667029 |         3 |            47 |          0 |
>> |  9290 | 17873957441 |         3 |            47 |          0 |
>> |  9291 | 17879619794 |         3 |            47 |          0 |
>> |  9292 | 17879619793 |         3 |            47 |          0 |
>> |  9293 | 17877057382 |         3 |            47 |          0 |
>> |  9294 | 17877057383 |         3 |            47 |          0 |
>> |  9295 | 17872667259 |         3 |            47 |          0 |
>> |  9785 | 17879619790 |         3 |            47 |          0 |
>> |  9916 | 17877650130 |         3 |            47 |          0 |
>> |  9917 | 17877657386 |         3 |            47 |          0 |
>> |  9918 | 17877729149 |         3 |            47 |          0 |
>> | 10116 | 17877845000 |         3 |            47 |          0 |
>> | 10122 | 17877845051 |         3 |            47 |          0 |
>> | 10147 | 17877265929 |         3 |            47 |          0 |
>> | 10148 | 17877286969 |         3 |            47 |          0 |
>> | 10227 | 17877551210 |         3 |            47 |          0 |
>> | 10229 | 17877551235 |         3 |            47 |          0 |
>> | 10230 | 17877551260 |         3 |            47 |          0 |
>> | 10231 | 17877551300 |         3 |            47 |          0 |
>> | 10505 | 17874740636 |         3 |            47 |          0 |
>> | 10506 | 17874740637 |         3 |            47 |          0 |
>> | 10507 | 17874740638 |         3 |            47 |          0 |
>> | 10508 | 17874740639 |         3 |            47 |          0 |
>> | 10509 | 17874740640 |         3 |            47 |          0 |
>> | 10510 | 17874740641 |         3 |            47 |          0 |
>> | 10524 | 17879057355 |         3 |            47 |          0 |
>> | 10525 | 17877487645 |         3 |            47 |          0 |
>> +-------+-------------+-----------+---------------+------------+
>> 85 rows in set (0.02 sec)
>>
>> mysql>
>>
>> On Tue, Aug 4, 2015 at 10:05 AM, Andrew Pogrebennyk
>> <apogrebennyk at sipwise.com <mailto:apogrebennyk at sipwise.com>> wrote:
>>
>>      Hi,
>>      I've encountered this issue once but was unable to find out what is
>>      causing it. Please provide the dump of all numbers from the billing and
>>      provisioning DBs:
>>
>>      select * from provisioning.voip_dbaliases where subscriber_id=73;
>>      select * from billing.voip_numbers where subscriber_id=69;
>>
>>      The id of subscriber in billing.voip_numbers table is the one you see in
>>      your browser's address bar when you go to subscriber details. The id in
>>      provisioning database you can figure out by alias.
>>
>>      Please check if the two tables look in sync to you. Also, after you get
>>      the lists of numbers please specify which ones of those are missing when
>>      you get into Edit mode.
>>
>>      Regards,
>>      Andrew
>>
>>      On 08/02/2015 04:43 PM, Abel Alejandro wrote:
>>      > Hello,
>>      >
>>      > We have a bug (it happens to anyone so its not a local browser issue)
>>      > when we modify a particular subscriber in order to add new extra
>>      alias,
>>      > it keeps deleting a specific set number of aliases because they do not
>>      > appear automatically when we "Edit" the subscriber. We have to
>>      manually
>>      > keep putting the numbers of existing alias on the Alias edit form so
>>      > they do not get deleted.
>>      >
>>      > Any tips how to troubleshoot?
>>
>>
>>
>>
>> -- 
>> /Abel Alejandro/
>>
>> 787 586 8313 | 787 705 0555
>> <mailto:joquendo at alliedtechnologygrouppr.com>
>>
>> 400 Calle Calaf 477
>> San Juan, PR 00918
>> aalejandro at alliedtechnologygrouppr.com
>> <mailto:aalejandro at alliedtechnologygrouppr.com>
> _______________________________________________
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> https://lists.sipwise.com/listinfo/spce-user




More information about the Spce-user mailing list