[Spce-user] Create subscriber - The specified telephone number is not available any more.

[Daniel Tiefnig]

On 06/15/2012 02:25 AM, Skyler wrote:
> On Tue, Jun 12, 2012 at 2:06 PM, Daniel Tiefnig wrote:
>> Is it shown as deleted or as active? I.e. is the subscriber name an
>> href?
> 
> It is shown greyed out within the account it was originally created.

Ok, so that is not a problem. It's listed as a terminated subscriber and
all parameters (username, phone numbers) should be usable again.

>> The primary_number_id should be NULL, and you shouldn't be able to
>>  find any numbers assigned to the subscriber:
> 
> No the primary_id is not NULL.

Oh sorry, my fault. Just checked, and the primary number ID is not reset
on subscriber termination, so that's ok.

> mysql> select * from billing.voip_numbers where subscriber_id = '2';
[...]
> 2 rows in set (0.00 sec)

But that's weird. The subscriber_id column in voip_numbers is set to
NULL when a subscriber is terminated. You terminated the subscriber via
the admin webinterface? Can you see any errors in oss.log after the
terminate_voip_account_subscriber call?

Are there other subscribers affected too? Try the following in the
billing database:
mysql> select b.username
         from voip_numbers a
              inner join voip_subscribers b on a.subscriber_id = b.id
        where b.status = 'terminated';

What version of the ngcp-ossbss-billing package is installed on the system?
# dpkg -l ngcp-ossbss-billing

br,
daniel