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

Abel Alejandro aalejandro at alliedtechnologygrouppr.com
Fri Aug 14 00:02:32 EDT 2015


Hello,

Just confirmed this fixed the issue. Is this going to be ported to 4.0.1?

Thanks.


On Fri, Aug 7, 2015 at 8:22 AM, Gerhard Jungwirth <gjungwirth at sipwise.com>
wrote:

> Hi,
>
> the procedure is correct. In this specific case it would also be
> sufficient to update just the package ngcp-panel. (apt-get install
> ngcp-panel). If the issue is non-critical for you, you can also wait for
> the maintenance window.
>
> - Gerhard
>
>
> On 08/06/2015 07:01 PM, Abel Alejandro wrote:
>
> Hello,
>
> The procedure would be:
>
> apt-get update && apt-get upgrade && \ ngcp-update-db-schema &&
> ngcp-update-cfg-schema && \ ngcpcfg apply
>
> Do you think I can apply without dropping calls or better wait for maint
> window?
>
>
> On Thu, Aug 6, 2015 at 12:52 PM, Gerhard Jungwirth <gjungwirth at sipwise.com
> > wrote:
>
>> 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
>>>
>>
>>
>
>
> --
> *Abel Alejandro*
> 787 586 8313 | 787 705 0555
>
> 400 Calle Calaf 477
> San Juan, PR 00918
> aalejandro at alliedtechnologygrouppr.com
>
>
>


-- 
*Abel Alejandro*

787 586 8313 | 787 705 0555
<joquendo at alliedtechnologygrouppr.com>

400 Calle Calaf 477
San Juan, PR 00918
aalejandro at alliedtechnologygrouppr.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20150814/fd1a593b/attachment-0001.html>


More information about the Spce-user mailing list