Skip to main content

Mysql Global Variable Issue

Posted by Devan on Tue, 06/28/2016

Hi,

I wanted to upgrade our test servers to pbxmw-mt-7.5.2.1-1, to test out asterisk11 and thirdlane.

I ran into a problem with a system variable when installing the package.

ERROR 1193 (HY000): Unknown system variable 'STORAGE_ENGINE'

In all the mysql files under /usr/libexec/webmin/asterisk/sql/mysql/

A depreciated STORAGE_ENGINE variable is used.

default_storage_engine was introduced in MySQL 5.5.3.
storage_engine was removed in MySQL 5.7.5.

I have look for a few workarounds, it does not seem possible except for updating the variable to default_storage_engine.

Has anyone else run into this issue?

We currently run MySQL 5.7.5 on our test servers.

Please see attached installation log.

Regards,


Submitted by thirdlane on Thu, 06/30/2016 Permalink

MySQL 5.7.X is way ahead of what comes with CentOS :).

We will take care of this in the next release - but I can not guarantee that 5.7 will be compatible in every way :).