3,243
edits
Changes
From SME Server
Jump to navigationJump to search→Upgrading 4.4 to 5.0
see this page https://www.zabbix.com/documentation/5.0/en/manual/installation/upgrade_notes_500. Mostly you will need to
see this page https://www.zabbix.com/documentation/5.0/en/manual/installation/upgrade_notes_500. Mostly you will need to
* migrate your db from mariadb 5.5 to mariadb 10.5 with its user
* migrate your db from mariadb 5.5 to mariadb 10.5 with its user if not already done
* fix the row format to dynamic
* fix the row format to dynamic<syntaxhighlight lang="mysql">
* install 5.0 using rpms
USE zabbixdb;
alter table hosts row_format = dynamic;
</syntaxhighlight>
* install 5.0 using rpms<syntaxhighlight lang="bash">
db yum_repositories setprop zabbix44 status disabled
db yum_repositories setprop zabbix50 status enabled
db yum_repositories setprop zabbix50-frontend status enabled
expand-template /etc/yum.smerepos.d/sme-base.repo
rpm -e --nodeps zabbix-web-mysql zabbix-web smeserver-zabbix-server
yum install smeserver-zabbix-server-z50 --enablerepo=smecontribs,smetest,smedev
</syntaxhighlight>
* fix the table with database/mysql/double.sql
* fix the table with database/mysql/double.sql
<syntaxhighlight lang="mysql">
<syntaxhighlight lang="mysql">
USE zabbixdb;
USE zabbixdb;
ALTER TABLE trends
ALTER TABLE trends
MODIFY value_min DOUBLE PRECISION DEFAULT '0.0000' NOT NULL,
MODIFY value_min DOUBLE PRECISION DEFAULT '0.0000' NOT NULL,
