Configuring synchronization, sensors, and optimizations
- Posts: 171
- Joined: Sun Nov 27, 2016 3:41 pm
My cluster seems to be synchronizing the FreePBX MySql database, but I see this error in the haast log:
Code: Select all
System Command, Warning during interface with database sync for id 'freepbx-mysql'. Result code '0'; Error code '5'; Exit code '3'. Check debug log for further details
What's going wrong?
Account for questions transferred from CRM system
- Posts: 225
- Joined: Sun Nov 27, 2016 3:27 pm
Some versions of FreePBX contain tables without indices. Although this is not valid SQL, MySQL allows it and so FreePBX can operate with this poorly designed table.
HAAst is complaining that it can't sync a table without a unique index. (Although this is likely an unimportant table as Sangoma seems to be cleaning up their tables slowly). The best solution is to wait for an update to FreePBX which fixes the table.