Re: [Project Clearwater] check registered state of user
Thanks for your question Jake, and thanks Nagu for helping out! Apologies for the delay in getting back to you. There are a few different datastores that clearwater uses: * Ellis stores which numbers are available for use, and which ones have been given out to a user, in its MySQL database. * When a number is given out to a user, it is configured in homestead-prov, which stores it in the Cassandra database. * When a phone registers, this gets stored in the memcached database used by homestead and sprout. It’s this last bullet that you care about. The easiest way to get the information is to query homestead’s REST API for the subscriber’s registration data. You can do this by using cURL to do a GET to the resource defined here: https://github.com/Metaswitch/homestead/blob/release-130/docs/homestead_api.md#impu---persistent-registration-state. I’ve not tried running this command, but something like this should do the trick: curl http://:/impu//reg-data is the IP address of your dime node. Note that 127.0.0.1/localhost will not work (even if you are on the dime node). is the SIP URI of the subscriber you are interested in. You have to URL escape this. Eg. instead of sip:1234567...@example.com you would use sip%3A123456789%40example.com Hope this helps, Alex. From: Clearwater [mailto:clearwater-boun...@lists.projectclearwater.org] On Behalf Of Nagendra Kumar Sent: 08 April 2018 14:53 To: clearwater@lists.projectclearwater.org<mailto:clearwater@lists.projectclearwater.org>; DCC LLC - Jake Brown Subject: Re: [Project Clearwater] check registered state of user Hi Jake, I am not sure about any other ways of checking registration status. @Experts ?? Thanks -Nagu On Sunday, 8 April, 2018, 6:53:10 PM IST, Jake Brown mailto:j...@dccllc.net>> wrote: Nagu, Would this mean that the only way to check registration status would be to use a Ellis node. Currently we don't use one due to the lacking of browser support to modify the call forwarding features. Thanks Jake Sent via the Samsung Galaxy S8+, an AT&T 4G LTE smartphone Original message From: Nagendra Kumar mailto:nagen...@yahoo.co.in>> Date: 4/8/18 4:44 AM (GMT-06:00) To: clearwater@lists.projectclearwater.org<mailto:clearwater@lists.projectclearwater.org>, Jake Brown mailto:j...@dccllc.net>> Subject: Re: [Project Clearwater] check registered state of user Hi Jake, You can also check the registered user at ellis : sudo mysql use ellis; SELECT * FROM numbers ; You can also check the data bases using the command: SHOW DATABASES; You can check selective users by command: SELECT * FROM numbers WHERE number = 'sip:6505550...@nags.hd'; Thanks -Nagu On Friday, 6 April, 2018, 7:32:54 PM IST, Jake Brown mailto:j...@dccllc.net>> wrote: I must have something wrong in the shared_config. I would expect to see something in vellum in the homestead_cache/impu table that indicates registered in the is_registered column. Is this not the correct place to check to see if a subscriber is registered? Thank you for your guidance. Jake ___ Clearwater mailing list Clearwater@lists.projectclearwater.org<mailto:Clearwater@lists.projectclearwater.org> http://lists.projectclearwater.org/mailman/listinfo/clearwater_lists.projectclearwater.org ___ Clearwater mailing list Clearwater@lists.projectclearwater.org http://lists.projectclearwater.org/mailman/listinfo/clearwater_lists.projectclearwater.org
Re: [Project Clearwater] check registered state of user
Hi Jake, I am not sure about any other ways of checking registration status. @Experts ?? Thanks-Nagu On Sunday, 8 April, 2018, 6:53:10 PM IST, Jake Brown wrote: Nagu, Would this mean that the only way to check registration status would be to use a Ellis node. Currently we don't use one due to the lacking of browser support to modify the call forwarding features. Thanks Jake Sent via the Samsung Galaxy S8+, an AT&T 4G LTE smartphone Original message From: Nagendra Kumar Date: 4/8/18 4:44 AM (GMT-06:00) To: clearwater@lists.projectclearwater.org, Jake Brown Subject: Re: [Project Clearwater] check registered state of user Hi Jake, You can also check the registered user at ellis : sudo mysql use ellis;SELECT * FROM numbers ; You can also check the data bases using the command: SHOW DATABASES;You can check selective users by command: SELECT * FROM numbers WHERE number = 'sip:6505550...@nags.hd'; Thanks-Nagu On Friday, 6 April, 2018, 7:32:54 PM IST, Jake Brown wrote: #yiv6041205200 #yiv6041205200 -- filtered {}#yiv6041205200 filtered {font-family:Calibri;}#yiv6041205200 p.yiv6041205200MsoNormal, #yiv6041205200 li.yiv6041205200MsoNormal, #yiv6041205200 div.yiv6041205200MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:sans-serif;}#yiv6041205200 a:link, #yiv6041205200 span.yiv6041205200MsoHyperlink {color:#0563C1;text-decoration:underline;}#yiv6041205200 a:visited, #yiv6041205200 span.yiv6041205200MsoHyperlinkFollowed {color:#954F72;text-decoration:underline;}#yiv6041205200 span.yiv6041205200EmailStyle17 {font-family:sans-serif;color:windowtext;}#yiv6041205200 .yiv6041205200MsoChpDefault {font-family:sans-serif;}#yiv6041205200 filtered {margin:1.0in 1.0in 1.0in 1.0in;}#yiv6041205200 I must have something wrong in the shared_config. I would expect to see something in vellum in the homestead_cache/impu table that indicates registered in the is_registered column. Is this not the correct place to check to see if a subscriber is registered? Thank you for your guidance. Jake ___ Clearwater mailing list Clearwater@lists.projectclearwater.org http://lists.projectclearwater.org/mailman/listinfo/clearwater_lists.projectclearwater.org ___ Clearwater mailing list Clearwater@lists.projectclearwater.org http://lists.projectclearwater.org/mailman/listinfo/clearwater_lists.projectclearwater.org
Re: [Project Clearwater] check registered state of user
Nagu, Would this mean that the only way to check registration status would be to use a Ellis node. Currently we don't use one due to the lacking of browser support to modify the call forwarding features. Thanks Jake Sent via the Samsung Galaxy S8+, an AT&T 4G LTE smartphone Original message From: Nagendra Kumar Date: 4/8/18 4:44 AM (GMT-06:00) To: clearwater@lists.projectclearwater.org, Jake Brown Subject: Re: [Project Clearwater] check registered state of user Hi Jake, You can also check the registered user at ellis : sudo mysql use ellis; SELECT * FROM numbers ; You can also check the data bases using the command: SHOW DATABASES; You can check selective users by command: SELECT * FROM numbers WHERE number = 'sip:6505550...@nags.hd'; Thanks -Nagu On Friday, 6 April, 2018, 7:32:54 PM IST, Jake Brown wrote: I must have something wrong in the shared_config. I would expect to see something in vellum in the homestead_cache/impu table that indicates registered in the is_registered column. Is this not the correct place to check to see if a subscriber is registered? Thank you for your guidance. Jake ___ Clearwater mailing list Clearwater@lists.projectclearwater.org<mailto:Clearwater@lists.projectclearwater.org> http://lists.projectclearwater.org/mailman/listinfo/clearwater_lists.projectclearwater.org ___ Clearwater mailing list Clearwater@lists.projectclearwater.org http://lists.projectclearwater.org/mailman/listinfo/clearwater_lists.projectclearwater.org
Re: [Project Clearwater] check registered state of user
Hi Jake, You can also check the registered user at ellis : sudo mysql use ellis; SELECT * FROM numbers ; You can also check the data bases using the command: SHOW DATABASES;You can check selective users by command: SELECT * FROM numbers WHERE number = 'sip:6505550...@nags.hd'; Thanks-Nagu On Friday, 6 April, 2018, 7:32:54 PM IST, Jake Brown wrote: I must have something wrong in the shared_config. I would expect to see something in vellum in the homestead_cache/impu table that indicates registered in the is_registered column. Is this not the correct place to check to see if a subscriber is registered? Thank you for your guidance. Jake ___ Clearwater mailing list Clearwater@lists.projectclearwater.org http://lists.projectclearwater.org/mailman/listinfo/clearwater_lists.projectclearwater.org ___ Clearwater mailing list Clearwater@lists.projectclearwater.org http://lists.projectclearwater.org/mailman/listinfo/clearwater_lists.projectclearwater.org