Line 69: |
Line 69: |
| bash zabconfig | | bash zabconfig |
| then restore the mysqldb, assuming you already had installed mariadb105 on sme10 | | then restore the mysqldb, assuming you already had installed mariadb105 on sme10 |
− | zcat zabbix.sql.gz |mysql105 | + | zcat zabbix.sql.gz |sed 's/ENGINE=MyISAM/ENGINE=InnoDB/g'|mysql105 |
| create user give him privileges | | create user give him privileges |
| echo "CREATE USER IF NOT EXISTS `config getprop zabbix-server DbUser`@localhost IDENTIFIED BY '`config getprop zabbix-server DbPassword`';"| mysql105 | | echo "CREATE USER IF NOT EXISTS `config getprop zabbix-server DbUser`@localhost IDENTIFIED BY '`config getprop zabbix-server DbPassword`';"| mysql105 |
| echo "GRANT ALL PRIVILEGES ON `config getprop zabbix-server DbName`.* TO `config getprop zabbix-server DbUser`@localhost; FLUSH PRIVILEGES;" | mysql105 | | echo "GRANT ALL PRIVILEGES ON `config getprop zabbix-server DbName`.* TO `config getprop zabbix-server DbUser`@localhost; FLUSH PRIVILEGES;" | mysql105 |
| | | |
− | then follow the wiki procedure to install zabbix z50 | + | then follow the wiki procedure to install zabbix z50, including the informations about upgrading your database before installing |
| + | |
| + | == Zabbix db partitionning == |
| + | |
| + | for huge db with >200 hosts |
| + | https://www.zabbix.com/forum/zabbix-troubleshooting-and-problems/373410-zabbix-housekeeper-processes-more-than-75-busy |
| + | https://bestmonitoringtools.com/zabbix-partitioning-tables-on-mysql-database/ |
| + | |
| + | == SNMP == |
| + | |
| + | in case you need to install MIBS, yo will need last version of git from wandisco if you are on SME 10 |
| + | will also need to install tree rpm |
| + | |
| + | then |
| + | |
| + | git clone https://github.com/jeonghanlee/snmp-mibs-downloader-env.git |
| + | cd snmp-mibs-downloader-env |
| + | make init |
| + | make install |
| + | make get |
| + | systemctl restart zabbix-server |