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

[Skyler]

Hi,

No this is a test system so only 3 subscribers exist, I'm just running
through some scenarios like terminating then un-terminating a subscriber.
Moving a subscriber from one account to another...things like that.

 There were no other errors in oss.log that I could
see. ngcp-ossbss-billing is 3.3.8

Skyler

On Fri, Jun 15, 2012 at 2:45 AM, Daniel Tiefnig <dtiefnig at sipwise.com>wrote:

> 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
>
> _______________________________________________
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> http://lists.sipwise.com/listinfo/spce-user
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20120615/e0e6a601/attachment-0001.html>