Page tree
Skip to end of metadata
Go to start of metadata

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:

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

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

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

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

  • No labels