Changes

Jump to navigation Jump to search
698 bytes added ,  03:13, 28 June 2023
→‎SNMP: new section
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
Super Admin, Wiki & Docs Team, Bureaucrats, Interface administrators, Administrators
3,250

edits

Navigation menu