ClearlyTrunking/ClearlyDevices Database issue

We've identified a bug in the way the ClearlyIP Devices and Trunks modules were installed for IncrediblePBX (except on the RasPi platform).

If your changes to Module Settings are not saving, you will need to follow the steps below.

Here are the steps to fix the issue if you don't mind losing any settings in the Clearly Devices or Clearly Trunking modules.

From the PBX CLI run the following commands:

sed -i 's|default-storage-engine=MyISAM|#default-storage-engine=MyISAM|' /etc/my.cnf
systemctl restart mysqld
fwconsole ma uninstall clearlytrunking
fwconsole ma uninstall clearlydevices
fwconsole reload
mysql -u root -ppassw0rd asterisk -e "drop table kvstore_FreePBX_modules_Clearlydevices;"
mysql -u root -ppassw0rd asterisk -e "drop table kvstore_FreePBX_modules_Clearlytrunking;"
fwconsole ma install clearlytrunking
fwconsole ma install clearlydevices
fwconsole reload

You can verify that the ClearlyIP components are showing ENGINE=InnoDB in MySQL by running the following command at the CLI:

mysql -u root -ppassw0rd asterisk -e "show create table kvstore_FreePBX_modules_Clearlydevices;" | grep ENGINE