Home Forums HAast (High Availability for Asterisk) Configuration & Optimization Error on sync FreePBX MySQL table

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • Avatar photoCustomer Inquiry
    Member
    Post count: 197

    My cluster seems to be synchronizing the FreePBX MySql database, but I see this error in the haast log:


    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?

    Avatar photoTelium Support Group
    Member
    Post count: 258

    Some versions of FreePBX may contain tables with invalid/problematic schemas (possibly not even valid SQL but MySQL allows it).

    HAAst is complaining that it can’t sync a table without a unique index. (Although this is likely an unimportant table as Sangoma may be cleaning up their tables slowly). The best solution is to wait for an update to FreePBX which fixes the table.

    If you need an immediate fix please contact Telium technical support for further assistance and workarounds. When Telium performs the installation for the customer, we might modify the MySQL table, modify PHP code, or modify MySQL tools for synchronization. Customers who perform their own installation need to thoroughly test synchronization for moving to production.

    Before you perform any changes to resolve this problem ensure you have a bare metal backup, and perform testing on a staging system.

Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.