/
PBX GUI - FreePBX HA - potential issue on setup

PBX GUI - FreePBX HA - potential issue on setup

There is a chance that during initial configuration you may encounter an issue resulting in the inablilty to reload configuration or update modules.

On HA systems that display errors of the form: SQLSTATE[42000]: Syntax error or access violation: 1286 Unknown table engine 'InnoDB' You will see when attempting to install certain FreePBX modules, or when attempting to Apply Config

 

To correct this issue take the following steps:

  1. On Primary HA node, confirm innodb log file size is set to 32 meg:

# grep "innodb-log-file-size" /etc/my.cnf innodb-log-file-size           = 32M

  1. Then check actual innodb log file sizes:

# du -h /var/lib/mysql/ib_log* 5.0M    /var/lib/mysql/ib_logfile0 5.0M    /var/lib/mysql/ib_logfile1

  1. File sizes don't match conf file, so rename them and restart MySQL:

mv /var/lib/mysql/ib_logfile0 /var/lib/mysql/ib_logfile0.back mv /var/lib/mysql/ib_logfile1 /var/lib/mysql/ib_logfile1.back mysqladmin shutdown

  1. PCS should restart mysqld, and when it does, you will see new logfiles:

# ll /var/lib/mysql/ib_log* -rw-rw---- 1 mysql mysql 33554432 Aug 10 16:49 /var/lib/mysql/ib_logfile0 -rw-rw---- 1 mysql mysql  5242880 Jul 12 14:46 /var/lib/mysql/ib_logfile0.back -rw-rw---- 1 mysql mysql 33554432 Aug 10 16:43 /var/lib/mysql/ib_logfile1 -rw-rw---- 1 mysql mysql  5242880 Jul  6 17:57 /var/lib/mysql/ib_logfile1.back

You can now continue with Module install/Apply Config as normal