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
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.