Apologies, but I've discovered the 2nd to last paragraph in my previous email (and the subsequent command) was wrong. It should read as follows:
If you are provisioning subscribers through Ellis, any previously-created subscribers will no longer be accessible after upgrade and the numbers assigned to those subscribers will have been leaked. You must fix up the leaked numbers before Ellis can be used. The following command must be run after upgrade, but before provisioning new subscribers. echo "UPDATE numbers SET owner_id=NULL, gab_listed=1;" | sudo mysql -D ellis Thanks, Alex. From: [email protected] [mailto:[email protected]] On Behalf Of Alex Hockey Sent: 23 October 2013 17:32 To: [email protected] Subject: [Clearwater] Upcoming Homestead Change - Loss of Previously-configured Lines The next release of Project Clearwater (due out tomorrow) includes a non-backwards-compatible change to the database schema to significantly improve the performance of Homestead. Unfortunately, this will cause any lines configured through Ellis to become inaccessible and we are not able to provide a migration script to convert the data. Generally, your system should not automatically upgrade. The only exception is if you installed following the manual or automated install instructions before 27 September, and haven't upgraded or rebooted since - in which case it will upgrade automatically on next reboot. To manually upgrade, run the following commands on each of your nodes: sudo apt-get update sudo apt-get install -y --force-yes --only-upgrade $(dpkg-query -W -f='${PackageSpec} ${Maintainer}\n' | grep " Project Clearwater Maintainers " | cut -d ' ' -f 1) If you are using Homestead as a cache for a third-party HSS, upgrading will have no impact - the subscriber data is mastered on the HSS, not in Homestead. If you are provisioning subscribers through Ellis, any previously-created subscribers will no longer be accessible after upgrade. You will need to re-provision your subscribers and configure your phones with new settings. Further, any numbers you have already assigned to subscribers will be leaked. If you had very few subscribers assigned, these leaked numbers may be acceptable - if you had more assigned and want to recover from this, run the following command (taken from https://github.com/Metaswitch/clearwater-docs/wiki/Manual-Install#ellis) on Ellis after upgrade but before provisioning new subscribers. (6505550000 is the default number, and the one to use unless you explicitly override it when installing your system.) sudo bash -c "export PATH=/usr/share/clearwater/ellis/env/bin:$PATH ; cd /usr/share/clearwater/ellis/src/metaswitch/ellis/tools/ ; python create_numbers.py --start 6505550000 --count 1000" Please let me know if this causes you any problems, or if you have any questions, and apologies for any inconvenience. Thanks, Alex Alex Hockey Software Engineer, Project Clearwater Metaswitch Networks [email protected]<mailto:[email protected]> +44 (0) 20 8366 1177 www.metaswitch.com<http://www.metaswitch.com/>
_______________________________________________ Clearwater mailing list [email protected] http://lists.projectclearwater.org/listinfo/clearwater
