[Spce-user] unable to add phone number

[Marc Storck]

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

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 841 bytes
Desc: Message signed with OpenPGP using GPGMail
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20131010/89be8288/attachment-0001.asc>