[Spce-user] unable to add phone number

[Daniel Grotti]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi Marc,

you are right.
I can reproduce now.
Actually it looks a problem and the last packages.
I will open an internal ticket about that.

Daniel



On 10/10/2013 11:14 AM, Marc Storck wrote:
> When checking th DB, things gets weird:
> 
> mysql> select * from voip_dbaliases; 
> +----+-----------------+-----------+---------------+ | id |
> username        | domain_id | subscriber_id | 
> +----+-----------------+-----------+---------------+ |  1 | 1204400
> |         3 |             5 | 
> +----+-----------------+-----------+---------------+ 1 row in set
> (0.00 sec)
> 
> So there is no 123456789
> 
> Marc
> 
> 
> On Oct 10, 2013, at 11:01 AM, Marc Storck <mstorck at voipgate.com>
> wrote:
> 
>> The system is running the very latest versions:
>> 
>> root at sipwise:~# apt-get update && apt-get upgrade &&
>> ngcp-update-db-schema && ngcp-update-cfg-schema &&  ngcpcfg
>> apply Hit http://debian.mirror.root.lu wheezy Release.gpg … … 
>> Fetched 461 kB in 2s (190 kB/s) Reading package lists... Done 
>> Reading package lists... Done Building dependency tree Reading
>> state information... Done 0 upgraded, 0 newly installed, 0 to
>> remove and 0 not upgraded.
>> 
>> This is what is in oss.log:
>> 
>> Oct 10 11:02:02 sipwise /usr/sbin/apache2: Failed to update
>> subscriber. (DBIx::Class::ResultSet::create(): DBI Exception:
>> DBD::mysql::st execute failed: Duplicate entry
>> '123456789-sipwise.2ld.tld' for key 'alias_idx' [for Statement
>> "INSERT INTO `provisioning`.`voip_dbaliases` ( `domain_id`,
>> `subscriber_id`, `username`) VALUES ( ?, ?, ? )" with
>> ParamValues: 0='3', 1='7', 2="123456789"] at
>> /usr/share/perl5/NGCP/Panel/Controller/Subscriber.pm line
>> 1580#012)
>> 
>> Regards,
>> 
>> Marc Storck -- Chief Information Officer voipGATE S.A. 
>> http://mstorck.voipgate.tel
>> 
>> On Oct 10, 2013, at 10:54 AM, Daniel Grotti <dgrotti at sipwise.com>
>> wrote:
>> 
>>> Signed PGP part Hi,
>>> 
>>> Can't reproduce it, I mean I get only "Duplicate entry" if I
>>> try to add a number already in use by another subscriber.
>>> 
>>> Can you update your version to the latest packages ? (apt-get
>>> update && apt-get upgrade)
>>> 
>>> Daniel
>>> 
>>> 
>>> 
>>> On 10/10/2013 10:27 AM, Marc Storck wrote:
>>>> 123456789 is the Primary Number shown in the Subscriber
>>>> Master Data.
>>>> 
>>>> (When I click onto Edit. The Primary Numbers is now named
>>>> E164. (why?))
>>>> 
>>>> In the Edit Subscriber Master Data I can click Add another
>>>> number. Which adds a line titeled Alias Number.
>>>> 
>>>> I enter 987654321 as the alias number and the system
>>>> complains that the Primary Number already exists when
>>>> clicking onto Save.
>>>> 
>>>> Regards,
>>>> 
>>>> Marc
>>>> 
>>>> On Oct 10, 2013, at 10:18 AM, Daniel Grotti
>>>> <dgrotti at sipwise.com> wrote:
>>>> 
>>>>> Signed PGP part Hi,
>>>>> 
>>>>> Which number are you talking about ? Alias number ?
>>>>> allowed_clis ? which field ?
>>>>> 
>>>>> Daniel
>>>>> 
>>>>> 
>>>>> 
>>>>> On 10/10/2013 10:10 AM, Marc Storck wrote:
>>>>>> Sorry I wasn't specific enough.
>>>>>> 
>>>>>> User A already has the number 123456789 and I want to add
>>>>>> the number 987654321.
>>>>>> 
>>>>>> The system complains about the number 123456789 already
>>>>>> exists, but I'm not trying to add that one. It seems that
>>>>>> the GUI tries to add all the numbers instead of adding
>>>>>> only the new ones.
>>>>>> 
>>>>>> Regards,
>>>>>> 
>>>>>> Marc
>>>>>> 
>>>>>> On Oct 9, 2013, at 5:40 PM, Jeremie Chism
>>>>>> <jchism2 at gmail.com> wrote:
>>>>>> 
>>>>>>> Looks like that number is already in sipwise on another
>>>>>>>  subscriber.
>>>>>>> 
>>>>>>> Sent from my iPhone
>>>>>>> 
>>>>>>>> On Oct 9, 2013, at 9:39 AM, Marc Storck 
>>>>>>>> <mstorck at voipgate.com> wrote:
>>>>>>>> 
>>>>>>>> Hello,
>>>>>>>> 
>>>>>>>> wehen I try to add a phone number to a subscriber I
>>>>>>>> do get the following error message:
>>>>>>>> 
>>>>>>>> Failed to update subscriber. (Duplicate entry 
>>>>>>>> '123456789-sipwise.sld.tld')
>>>>>>>> 
>>>>>>>> The alias phone number is not added to the
>>>>>>>> subscriber.
>>>>>>>> 
>>>>>>>> I'm using the very latest Sipwise CE 3.0.
>>>>>>>> 
>>>>>>>> Does anybody have a clue?
>>>>>>>> 
>>>>>>>> Regards,
>>>>>>>> 
>>>>>>>> Marc _______________________________________________ 
>>>>>>>> Spce-user mailing list Spce-user at lists.sipwise.com 
>>>>>>>> http://lists.sipwise.com/listinfo/spce-user
>>>>>> 
>>>>>> 
>>>>>> 
>>>>>> _______________________________________________
>>>>>> Spce-user mailing list Spce-user at lists.sipwise.com 
>>>>>> http://lists.sipwise.com/listinfo/spce-user
>>>>>> 
>>>>> 
>>>>> 
>>>>> _______________________________________________ Spce-user
>>>>> mailing list Spce-user at lists.sipwise.com 
>>>>> http://lists.sipwise.com/listinfo/spce-user
>>>> 
>>> 
>>> 
>>> _______________________________________________ Spce-user
>>> mailing list Spce-user at lists.sipwise.com 
>>> http://lists.sipwise.com/listinfo/spce-user
>> 
>> _______________________________________________ Spce-user mailing
>> list Spce-user at lists.sipwise.com 
>> http://lists.sipwise.com/listinfo/spce-user
> 
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iQEcBAEBAgAGBQJSVnLCAAoJEJPC7K/l6VLLWOcH/16eF1MhuazZ+i9x3YUHZRg/
iCK1fV7UklMxfTdXyXaf4QSDcl0d+9ni3K2V4qWmYcx41ya3LpKI+5drTxQeKzbW
bpU1H5HsktOJrnQ27aJlbbdPz4NRYUeodXitY4VaZ3rxgoINlQ2t4qAJnZGmCl6v
ZyPTR0qX1Wk9IcSRwVrnGPHTaly4ySiW+ichecYhY44zvM/oM/KHimjDSI2W2VTQ
xktBVI1KBqguCaRKA+q/FYttki1C9wyU/jcVNALnVqMzb09hn6d5WPlSqF4nep4b
IRO0PvlaThbkcSztiMyVmsO3U1opKN2y7mNDu4ayZQz2aDfseGautrcMWRrVNis=
=lMiI
-----END PGP SIGNATURE-----