Zabbix 3.x install on Ubuntu 14.04

[ElDab]

I'm a bit of a Linux noob and I've been scratching my head at the install instructions 3.0 manual install

I'm good up to the point about creating the mysql database and all the tutorials I've found online are for older versions that apparently begin this process when the zabbix-server-mysql package is installed.

So, I go to the database creation doc page:

shell> mysql -uroot -p<password> (ok good so far)

mysql> create database zabbix character set utf8 collate utf8_bin; (yup)

mysql> grant all privileges on zabbix.* to zabbix@localhost identified by '<password>'; (ok, got it but I've seen people say the zabbix@localhost should be replaced with something else)

mysql> quit; (ok good so far)


shell> cd database/mysql (yeah, what? Directory doesn't exist)

shell> mysql -uzabbix -p<password> zabbix < schema.sql
# stop here if you are creating database for Zabbix proxy
shell> mysql -uzabbix -p<password> zabbix < images.sql
shell> mysql -uzabbix -p<password> zabbix < data.sql

I'm guessing these files are somewhere in a source tar? The documentation doesn't mention downloading source anywhere that I've seen.

Confused.

[aitor555]

Hello ElDab,

You have to download sources. Those 3 .sql files are in the database/mysql folder.

[xanadu]

I'm a bit of a Linux noob and I've been scratching my head at the install instructions 3.0 manual install

I'm good up to the point about creating the mysql database and all the tutorials I've found online are for older versions that apparently begin this process when the zabbix-server-mysql package is installed.

So, I go to the database creation doc page:

shell> mysql -uroot -p<password> (ok good so far)

mysql> create database zabbix character set utf8 collate utf8_bin; (yup)

mysql> grant all privileges on zabbix.* to zabbix@localhost identified by '<password>'; (ok, got it but I've seen people say the zabbix@localhost should be replaced with something else)

mysql> quit; (ok good so far)


shell> cd database/mysql (yeah, what? Directory doesn't exist)

shell> mysql -uzabbix -p<password> zabbix < schema.sql
# stop here if you are creating database for Zabbix proxy
shell> mysql -uzabbix -p<password> zabbix < images.sql
shell> mysql -uzabbix -p<password> zabbix < data.sql

I'm guessing these files are somewhere in a source tar? The documentation doesn't mention downloading source anywhere that I've seen.

Confused.

You could try to do a find for schema.sql. I found them on the yum packages for CentOS, so I guess they could be included in the Ubuntu packages as well.

[rthonpm]

It's not very clear in the documentation, but the schema files are included. The location is

/usr/share/doc/zabbix-server-mysql

To import them into the database, use this command.

zcat create.sql.gz | mysql -uroot zabbix

If you actually keep following the Ubuntu instructions instead of using the database creation scripts page, you'll find this information.