FreePBX HA - potential issue on setup
- Lorne Gaetz (Unlicensed)
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