Hi I’ve recently installed the all-in-one version of clearwater and I am having trouble registering a user. When I installed the OVF there were 1000 users created automatically in Ellis database, but only a handful (about 50) of these 1000 were in other databases ie homer, homestead. I thought this might be due to some installation issue.
To better understand how clearwater is working I decided to delete all the subscribers from Ellis and recreate just 10 (1000-1009) using the ‘create_numbers.py’ scipt, as I wanted to see if deleting / creating users in Ellis would propagate through to other databases, but I found this wasn’t the case. After search on internet I found info that the ‘create_numbers.py’ script doesn't actually create numbers on Homestead, it just provisions a pool of numbers on Ellis that Ellis can then select from during real number creation’, so now i’m confused how users are created in other databases...should this be done manually or is there some config issue which is stopping Ellis informing other databases about new users ? below are the 10 users I created mysql> select * from numbers; +--------------------------------------+----------------------------+----------+------------+------+ | number_id | number | owner_id | gab_listed | pstn | +--------------------------------------+----------------------------+----------+------------+------+ | 008ccc4a-1972-4510-9a3e-bcea60983ec4 | sip:[email protected] | NULL | 1 | 0 | | 070680ec-9934-4c21-8f84-fa3538e735a9 | sip:[email protected] | NULL | 1 | 0 | | 09218e54-4427-472f-bc6a-b00eac4464ed | sip:[email protected] | NULL | 1 | 0 | | 43cb9b77-7581-41bb-b1c8-1bc6aac4d9ba | sip:[email protected] | NULL | 1 | 0 | | 693e3271-525b-4002-9683-3e29816db695 | sip:[email protected] | NULL | 1 | 0 | | 6f35ccbf-3228-4d33-942b-147604a027fb | sip:[email protected] | NULL | 1 | 0 | | 96cf89c3-8f61-4ddc-a9fc-1ffcf0e00c4b | sip:[email protected] | NULL | 1 | 0 | | a2800cf0-10ef-4d65-ac3c-89e634c5617c | sip:[email protected] | NULL | 1 | 0 | | aef13d75-159f-4c4a-8d4f-420b539e4b93 | sip:[email protected] | NULL | 1 | 0 | | af3d3ca7-49aa-4b34-8750-d87a695a29d8 | sip:[email protected] | NULL | 1 | 0 | +--------------------------------------+----------------------------+----------+------------+------+ using the web interface I generated 3 private identities (1001, 1008, 1005), which worked and I got a password for each. Can see in mysql that owner-id field is now filled, so this part is working fine mysql> select * from numbers; +--------------------------------------+----------------------------+--------------------------------------+------------+------+ | number_id | number | owner_id | gab_listed | pstn | +--------------------------------------+----------------------------+--------------------------------------+------------+------+ | 008ccc4a-1972-4510-9a3e-bcea60983ec4 | sip:[email protected] | ad2dec28-eadc-4501-87d6-c74c2ed28676 | 1 | 0 | | 070680ec-9934-4c21-8f84-fa3538e735a9 | sip:[email protected] | ad2dec28-eadc-4501-87d6-c74c2ed28676 | 1 | 0 | | 09218e54-4427-472f-bc6a-b00eac4464ed | sip:[email protected] | ad2dec28-eadc-4501-87d6-c74c2ed28676 | 1 | 0 | | 43cb9b77-7581-41bb-b1c8-1bc6aac4d9ba | sip:[email protected] | NULL | 1 | 0 | | 693e3271-525b-4002-9683-3e29816db695 | sip:[email protected] | NULL | 1 | 0 | | 6f35ccbf-3228-4d33-942b-147604a027fb | sip:[email protected] | NULL | 1 | 0 | | 96cf89c3-8f61-4ddc-a9fc-1ffcf0e00c4b | sip:[email protected] | NULL | 1 | 0 | | a2800cf0-10ef-4d65-ac3c-89e634c5617c | sip:[email protected] | NULL | 1 | 0 | | aef13d75-159f-4c4a-8d4f-420b539e4b93 | sip:[email protected] | NULL | 1 | 0 | | af3d3ca7-49aa-4b34-8750-d87a695a29d8 | sip:[email protected] | NULL | 1 | 0 | +--------------------------------------+----------------------------+--------------------------------------+------------+------+ I then tried to register with softphone, clearwater first sends back 401 Unauthorised (so it recognises the user ), softphone then replies with sip register which includes auth parameters this time, but the clearwater sends back 403 forbidden. In sprout log i see errors below which seem to point at impi and impu tables in homestead_cache database, that they cant find matching record 24-09-2014 08:29:43.360 UTC Warning authentication.cpp:205: Received an authentication request for 0000001008 with nonce 5073304c580c6b04, but no matching AV found 24-09-2014 08:29:43.362 UTC Error httpconnection.cpp:561: http://192.168.20.68:8888/impi/0000001008/av?impu=sip%3A0000001008%40example.com failed at server 192.168.20.68 : HTTP response code said error (22 404) : fatal 24-09-2014 08:29:43.362 UTC Error httpconnection.cpp:659: cURL failure with cURL error code 22 (see man 3 libcurl-errors) and HTTP error code 404 24-09-2014 08:29:43.362 UTC Error hssconnection.cpp:144: Failed to get Authentication Vector for 0000001008 this makes sense as there are no entries for the 10 users I created in either of these 2 tables please advise many thanks Simon _______________________________________________ Clearwater mailing list [email protected] http://lists.projectclearwater.org/listinfo/clearwater
