3,254
edits
Changes
From SME Server
Jump to navigationJump to search→upgrade 4.2.6 to 4.4.4: new section
I've already compiled 1.8.5 for both sme7 and SME8, those package are available in our repo ([[Fws]]). I havne't pushed this version in smecontribs repo because the web interface is not compatible with PHP4, so it would break compatibility with standard SME7, but the agent, proxy and server packages works. I need to add a note to the wiki page about this.
I've already compiled 1.8.5 for both sme7 and SME8, those package are available in our repo ([[Fws]]). I havne't pushed this version in smecontribs repo because the web interface is not compatible with PHP4, so it would break compatibility with standard SME7, but the agent, proxy and server packages works. I need to add a note to the wiki page about this.
== upgrade 4.2.6 to 4.4.4 ==
you will need to change encoding for the db
first
service zabbix-server stop
mysqldump zabbixdb >zabbixdb.sql
echo 'ALTER TABLE `zabbixdb`.`problem_tag` DROP INDEX `problem_tag_1`, ADD INDEX `problem_tag_1` (`eventid`, `tag` (100), `value`(100));' |mysql
mysql --batch --skip-column-names --execute 'select concat("alter table ",TABLE_SCHEMA,".",TABLE_NAME," CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;")
from information_schema.TABLES where TABLE_SCHEMA="zabbixdb"' |mysql
service zabbix-server start
then go to the web interface, it will prompt you again for the configuration of the db
