[Spce-user] Adding an alias to a subscriber deletes specific existing set of alias
Gerhard Jungwirth
gjungwirth at sipwise.com
Fri Aug 7 08:22:55 EDT 2015
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 <mailto: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
> <tel:17877487645> and 17879057355 <tel: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 <tel:17877052432> | 3 |
> 47 | 1 |
> | 9222 | 17872687353 <tel:17872687353> | 3 |
> 47 | 0 |
> | 9223 | 17876524000 <tel:17876524000> | 3 |
> 47 | 0 |
> | 9224 | 17876524001 <tel:17876524001> | 3 |
> 47 | 0 |
> | 9225 | 17876524002 <tel:17876524002> | 3 |
> 47 | 0 |
> | 9226 | 17876524003 <tel:17876524003> | 3 |
> 47 | 0 |
> | 9227 | 17876524004 <tel:17876524004> | 3 |
> 47 | 0 |
> | 9228 | 17878054100 <tel:17878054100> | 3 |
> 47 | 0 |
> | 9229 | 17878346242 <tel:17878346242> | 3 |
> 47 | 0 |
> | 9230 | 17879354000 <tel:17879354000> | 3 |
> 47 | 0 |
> | 9231 | 17879354001 <tel:17879354001> | 3 |
> 47 | 0 |
> | 9232 | 17879354002 <tel:17879354002> | 3 |
> 47 | 0 |
> | 9233 | 17879354004 <tel:17879354004> | 3 |
> 47 | 0 |
> | 9234 | 17879350102 <tel:17879350102> | 3 |
> 47 | 0 |
> | 9235 | 17878492888 <tel:17878492888> | 3 |
> 47 | 0 |
> | 9236 | 17876525000 <tel:17876525000> | 3 |
> 47 | 0 |
> | 9237 | 17876525001 <tel:17876525001> | 3 |
> 47 | 0 |
> | 9238 | 17876525002 <tel:17876525002> | 3 |
> 47 | 0 |
> | 9239 | 17876525003 <tel:17876525003> | 3 |
> 47 | 0 |
> | 9240 | 17876524005 <tel:17876524005> | 3 |
> 47 | 0 |
> | 9241 | 17876524006 <tel:17876524006> | 3 |
> 47 | 0 |
> | 9242 | 17876524007 <tel:17876524007> | 3 |
> 47 | 0 |
> | 9243 | 17876524008 <tel:17876524008> | 3 |
> 47 | 0 |
> | 9244 | 17876524009 <tel:17876524009> | 3 |
> 47 | 0 |
> | 9245 | 17876525004 <tel:17876525004> | 3 |
> 47 | 0 |
> | 9246 | 17872968286 <tel:17872968286> | 3 |
> 47 | 0 |
> | 9247 | 17872968284 <tel:17872968284> | 3 |
> 47 | 0 |
> | 9254 | 17879576222 <tel:17879576222> | 3 |
> 47 | 0 |
> | 9256 | 17879667163 <tel:17879667163> | 3 |
> 47 | 0 |
> | 9257 | 17879667586 <tel:17879667586> | 3 |
> 47 | 0 |
> | 9258 | 17879667589 <tel:17879667589> | 3 |
> 47 | 0 |
> | 9259 | 17879667592 <tel:17879667592> | 3 |
> 47 | 0 |
> | 9261 | 17879619786 <tel:17879619786> | 3 |
> 47 | 0 |
> | 9262 | 17879619787 <tel:17879619787> | 3 |
> 47 | 0 |
> | 9263 | 17879619788 <tel:17879619788> | 3 |
> 47 | 0 |
> | 9264 | 17879619789 <tel:17879619789> | 3 |
> 47 | 0 |
> | 9265 | 17877109657 <tel:17877109657> | 3 |
> 47 | 0 |
> | 9266 | 17876657891 <tel:17876657891> | 3 |
> 47 | 0 |
> | 9267 | 17876657892 <tel:17876657892> | 3 |
> 47 | 0 |
> | 9268 | 17877050939 <tel:17877050939> | 3 |
> 47 | 0 |
> | 9269 | 17877050940 <tel:17877050940> | 3 |
> 47 | 0 |
> | 9270 | 17877050948 <tel:17877050948> | 3 |
> 47 | 0 |
> | 9271 | 17877086472 <tel:17877086472> | 3 |
> 47 | 0 |
> | 9272 | 17877086473 <tel:17877086473> | 3 |
> 47 | 0 |
> | 9273 | 17879455094 <tel:17879455094> | 3 |
> 47 | 0 |
> | 9274 | 17879455096 <tel:17879455096> | 3 |
> 47 | 0 |
> | 9275 | 17879455097 <tel:17879455097> | 3 |
> 47 | 0 |
> | 9276 | 17879455098 <tel:17879455098> | 3 |
> 47 | 0 |
> | 9278 | 17877052433 <tel:17877052433> | 3 |
> 47 | 0 |
> | 9280 | 17877052436 <tel:17877052436> | 3 |
> 47 | 0 |
> | 9281 | 17877052437 <tel:17877052437> | 3 |
> 47 | 0 |
> | 9282 | 17877109659 <tel:17877109659> | 3 |
> 47 | 0 |
> | 9283 | 17877109661 <tel:17877109661> | 3 |
> 47 | 0 |
> | 9284 | 17877107631 <tel:17877107631> | 3 |
> 47 | 0 |
> | 9285 | 17877107632 <tel:17877107632> | 3 |
> 47 | 0 |
> | 9286 | 17879667014 <tel:17879667014> | 3 |
> 47 | 0 |
> | 9287 | 17879667019 <tel:17879667019> | 3 |
> 47 | 0 |
> | 9288 | 17879667017 <tel:17879667017> | 3 |
> 47 | 0 |
> | 9289 | 17879667029 <tel:17879667029> | 3 |
> 47 | 0 |
> | 9290 | 17873957441 <tel:17873957441> | 3 |
> 47 | 0 |
> | 9291 | 17879619794 <tel:17879619794> | 3 |
> 47 | 0 |
> | 9292 | 17879619793 <tel:17879619793> | 3 |
> 47 | 0 |
> | 9293 | 17877057382 <tel:17877057382> | 3 |
> 47 | 0 |
> | 9294 | 17877057383 <tel:17877057383> | 3 |
> 47 | 0 |
> | 9295 | 17872667259 <tel:17872667259> | 3 |
> 47 | 0 |
> | 9785 | 17879619790 <tel:17879619790> | 3 |
> 47 | 0 |
> | 9916 | 17877650130 <tel:17877650130> | 3 |
> 47 | 0 |
> | 9917 | 17877657386 <tel:17877657386> | 3 |
> 47 | 0 |
> | 9918 | 17877729149 <tel:17877729149> | 3 |
> 47 | 0 |
> | 10116 | 17877845000 <tel:17877845000> | 3 |
> 47 | 0 |
> | 10122 | 17877845051 <tel:17877845051> | 3 |
> 47 | 0 |
> | 10147 | 17877265929 <tel:17877265929> | 3 |
> 47 | 0 |
> | 10148 | 17877286969 <tel:17877286969> | 3 |
> 47 | 0 |
> | 10227 | 17877551210 <tel:17877551210> | 3 |
> 47 | 0 |
> | 10229 | 17877551235 <tel:17877551235> | 3 |
> 47 | 0 |
> | 10230 | 17877551260 <tel:17877551260> | 3 |
> 47 | 0 |
> | 10231 | 17877551300 <tel:17877551300> | 3 |
> 47 | 0 |
> | 10505 | 17874740636 <tel:17874740636> | 3 |
> 47 | 0 |
> | 10506 | 17874740637 <tel:17874740637> | 3 |
> 47 | 0 |
> | 10507 | 17874740638 <tel:17874740638> | 3 |
> 47 | 0 |
> | 10508 | 17874740639 <tel:17874740639> | 3 |
> 47 | 0 |
> | 10509 | 17874740640 <tel:17874740640> | 3 |
> 47 | 0 |
> | 10510 | 17874740641 <tel:17874740641> | 3 |
> 47 | 0 |
> | 10524 | 17879057355 <tel:17879057355> | 3 |
> 47 | 0 |
> | 10525 | 17877487645 <tel: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>
> <mailto: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 <tel:787%20586%208313> | 787 705 0555
> <tel:787%20705%200555>
> <mailto:joquendo at alliedtechnologygrouppr.com
> <mailto:joquendo at alliedtechnologygrouppr.com>>
>
> 400 Calle Calaf 477
> San Juan, PR 00918
> aalejandro at alliedtechnologygrouppr.com
> <mailto:aalejandro at alliedtechnologygrouppr.com>
> <mailto:aalejandro at alliedtechnologygrouppr.com
> <mailto:aalejandro at alliedtechnologygrouppr.com>>
>
> _______________________________________________
> Spce-user mailing list
> Spce-user at lists.sipwise.com <mailto: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
> <mailto:aalejandro at alliedtechnologygrouppr.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20150807/b6f94f81/attachment-0001.html>
More information about the Spce-user
mailing list