Problem importing data for installation

[mahmood]

Hi,
Here are the steps that I took to install zabbix on ubuntu 18.04. In the middle of the process before launching web installer, it seems there are some problems.

# wget https://repo.zabbix.com/zabbix/4.0/ubuntu/pool/main/z/zabbix-release/zabbix-release_4.0-3+bionic_all.deb
# dpkg -i zabbix-release_4.0-3+bionic_all.deb
# apt install zabbix-server-mysql zabbix-frontend-php zabbix-agent
# mysql -u root -p
mysql> CREATE DATABASE zabbixdb character set utf8 collate utf8_bin;
mysql> CREATE USER 'zabbix'@'localhost' IDENTIFIED BY 'MYPASSWORD';
mysql> GRANT ALL PRIVILEGES ON zabbixdb.* TO 'zabbix'@'localhost' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;
mysql> quit;
# cd /usr/share/zabbix/zabbix-server-mysql/
# zcat ./data.sql.gz | mysql -u zabbix -p zabbixdb
Enter password:
ERROR 1146 (42S02) at line 2: Table 'zabbixdb.hosts' doesn't exist

I didn't continue then. Any guess?

[Atsushi]

Check the instructions on the download page.

https://www.zabbix.com/download?zabbix=4.0&os_distribution=ubuntu&os_version=18.04_bionic&db=mysql&ws=apache

The file data.sql.gz is not used. It is not included in Zabbix official package. Use the file create.sql.gz to create the tables on the database and insert the initial data.
ex.

# zcat /usr/share/doc/zabbix-server-mysql*/create.sql.gz | mysql -uzabbix -p zabbixdb

[mahmood]

There is no such file

# ls /usr/share/doc/zabbix-server-*
changelog.Debian.gz  copyright  NEWS.Debian.gz  README.Debian

[mahmood]

OK. I tried the 4.4 from the documentation site and I can see create.sql.gz now.