RHEL 6, CENTOS6

Fix for Zabbix4.0 installation on RHEL8 MariaDB10.3 error

There is problem on installing zabbix-server on RHEL8, while importing database schema error occurs.

Zabbix server version prior to 4.4 cannot work correctly with newer MariaDB versions out of the box.
Prior to MariaDB 10.2.26, 10.3.17, and 10.4.7, MariaDB didn't properly calculate the row sizes while executing DDL, so "unsafe" tables could be created, even with innodb_strict_mode=ON set. This was fixed by MDEV-19292.


shell> mysql -uroot -p<password>
mysql> set global innodb_strict_mode='OFF';


After importing Zabbix database schema 

shell> mysql -uroot -p<password>
mysql> USE zabbix
mysql> alter table `host_inventory` modify `name` varchar(128) default '' not null, modify `alias` varchar(128) default '' not null, modify `os` varchar(128) default '' not null, modify `os_short` varchar(128) default '' not null;
mysql> set global innodb_strict_mode='ON';


No comments:

Post a Comment