Recently, I was trying 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 had setup the mysql database, the mysql user and password and granted rights for that user to the database. Using the web installer, I managed to get to step3 (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:
1 2 3 4 5 | root@zabbix /root# 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):
1 2 3 | 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.