Hi Lianjie,

Can you look at the logs on Ellis and Homestead (/var/log/ellis/ellis-0.log and 
/var/log/homestead-prov/homestead-prov-0.log) to see what the reported errors 
are? We’ve seen a similar issue where Ellis thinks some numbers are provisioned 
but Homestead-prov does not (https://github.com/Metaswitch/ellis/issues/49).

Also, we’ve not done any stress testing of Ellis – we recommend that if you’re 
doing bulk provisioning you use one of the methods in 
https://github.com/Metaswitch/crest/blob/dev/docs/Bulk-Provisioning%20Numbers.md
 or 
https://github.com/Metaswitch/crest/blob/dev/src/metaswitch/crest/tools/sstable_provisioning/README.md
 as they manipulate the Homestead and Homer databases directly.

We don’t have any scripts that do bulk deletes. If you just want to delete 
*all* of your subscribers, then you can always disown them in Ellis then delete 
them in the Homestead database, e.g.

On Ellis, run:

sudo mysql

USE ellis

UPDATE numbers SET owner_id=NULL;

On Homestead, run:
cqlsh -3

USE homestead_provisioning;
TRUNCATE public;
TRUNCATE private;
TRUNCATE service_profiles;
TRUNCATE implicit_registration_sets;

USE homestead_cache;
TRUNCATE impi;
TRUNCATE impu;
TRUNCATE impi_mapping;

Hope this helps,

Ellie

From: Lianjie Cao [mailto:[email protected]]
Sent: 30 July 2014 20:17
To: Eleanor Merry
Cc: [email protected]
Subject: Re: [Clearwater] SIPp stress test node

Hi Ellie,

Thanks a lot for the information!

I found some Ellis APIs here: 
https://github.com/Metaswitch/ellis/blob/dev/docs/api.md.
I tested the get numbers, create number and delete number API. They work fine 
with small numbers like few hundreds.
Then I wrote a python script to create and delete 100,000 phone numbers. The 
create operation terminated after created the 8129 phone numbers. And I 
couldn't use the API to get all phone number information. It returns error like 
this:
test@Terminal:~/Documents$ curl -H "NGV-API-Key: secret"  
http://15.9.114.168/accounts/[email protected]/numbers/ -v
* Hostname was NOT found in DNS cache
*   Trying 15.9.114.168...
* Connected to 15.9.114.168 (15.9.114.168) port 80 (#0)
> GET 
> /accounts/[email protected]/numbers/<http://[email protected]/numbers/> 
> HTTP/1.1
> User-Agent: curl/7.35.0
> Host: 15.9.114.168
> Accept: */*
> NGV-API-Key: secret
>
< HTTP/1.1 502 Bad Gateway
< Content-Length: 146
< Content-Type: application/json; charset=UTF-8
* Server TornadoServer/2.3 is not blacklisted
< Server: TornadoServer/2.3
<
* Connection #0 to host 15.9.114.168 left intact
{"status": 502, "message": "Bad Gateway", "reason": "Upstream request failed", 
"detail": {"Upstream error": "HTTP 404: Not Found"}, "error": true}

And also the web UI couldn't display the identity information with a pop-up 
error:
Failed to update the server (see detailed diagnostics in developer console). 
Please refresh the page.

I am not sure if this is a bug or not. And I can still delete phone number with 
specific SIP_URI.
But it would be great if there are more easy-to-use REST APIs like those.

I'll try the way you pointed.
Is there any similar way to delete phone numbers?

Thanks,
Lianjie



On Wed, Jul 30, 2014 at 11:30 AM, Eleanor Merry 
<[email protected]<mailto:[email protected]>> wrote:
Hi Lianjie,

The users.csv.1 files is used in bulk-provisioning numbers. Details of the 
format of the csv, and how to create your own are at 
https://github.com/Metaswitch/crest/blob/dev/docs/Bulk-Provisioning%20Numbers.md,
 although note that you will need to use the password '7kkzTyGW' for all your 
subscribers if you are creating them for the SIPp stress testing.

There is also an alternate way of bulk provisioning subscribers detailed at 
https://github.com/Metaswitch/crest/blob/dev/src/metaswitch/crest/tools/sstable_provisioning/README.md.

Ellie

-----Original Message-----
From: 
[email protected]<mailto:[email protected]>
 
[mailto:[email protected]<mailto:[email protected]>]
 On Behalf Of Lianjie Cao
Sent: 29 July 2014 17:39
To: 
[email protected]<mailto:[email protected]>
Subject: [Clearwater] SIPp stress test node

Hi all,

I am trying to use the clearwater-sip-stress package to do some stress test on 
my Clearwater manual deployment.
I noticed the /usr/share/clearwater/sip-stress/users.csv.1 includes 87500 user 
identities with different phone number but the same password.

I was wondering how could I generate those information using Ellis or any other 
node in batch mode.
Are there any instructions on that?


Thanks,
Lianjie
_______________________________________________
Clearwater mailing list
[email protected]<mailto:[email protected]>
http://lists.projectclearwater.org/listinfo/clearwater

_______________________________________________
Clearwater mailing list
[email protected]
http://lists.projectclearwater.org/listinfo/clearwater

Reply via email to