Changes

From SME Server
Jump to navigationJump to search
114 bytes added ,  19:49, 16 December 2022
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
Super Admin, Wiki & Docs Team, Bureaucrats, Interface administrators, Administrators
3,254

edits

Navigation menu