Linux SysAdmin & DevOps

Zabbix 2.4.x - Installation problem

Zabbix-2.4.5 installation problem. I have recently tried to install Zabbix 2.4.5 on my linux CentOS 6.6 x64, from the official RPM packages from official zabbix website. Everything went smooth until I tried to setup the web interface.

I did the setup for:

  • MySQL database
  • MySQL user and password (rights/permissions)

Using Zabbix web installer, I managed to get to step 3 (the step where you define the database parameters). Even if everything was setup ok, I was always getting this error:

frontend does not match Zabbix database

After some researching, I found the solution:

Zabbix Web Installer Fix

Step 1) on your linux box prompt enter the following commands:

mysql> drop database zabbix;
mysql> create database zabbix character set utf8 collate utf8_bin;
mysql> quit

Step 2) import database from the .sql files provided in the official .rpm packages (on your linux box prompt, as root, execute the following):

mysql zabbix </usr/share/doc/zabbix-server-mysql-2.4.5/create/schema.sql
mysql zabbix </usr/share/doc/zabbix-server-mysql-2.4.5/create/images.sql
mysql zabbix </usr/share/doc/zabbix-server-mysql-2.4.5/create/data.sql

Now go to your web browser and repeat step 3 of the web install. You should be able to proceed to the next step and finally complete the install.