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