Please fix the documentation for Zabbix 3 / Ubuntu install

[mmacpuguy]

If you follow the instructions once you get to here https://www.zabbix.com/documentation..._scripts#mysql

...you are now stuck because the schema.sql, images.sql and data.sql aren't there.

The documentation says "schema.sql, images.sql and data.sql files are located in the database subdirectory of Zabbix sources. If Zabbix was installed from distribution packages, refer to the distribution documentation."

But there is no distribution documentation to read.

Thanks

[Atsushi]

If you are using the package, please look at the following URL.

https://www.zabbix.com/documentation/3.0/manual/installation/install_from_packages#creating_initial_database1

[mmacpuguy]

Does this create the zabbix database, tables and user?

# cd /usr/share/doc/zabbix-server-mysql
# zcat create.sql.gz | mysql -uroot zabbix

[Atsushi]

see manual.

Create zabbix database and user on MySQL. For instructions on doing that, see database creation scripts for MySQL.

create.sql.gz is the only tables creation.

ex.

shell> mysql -uroot -p<password>
mysql> create database zabbix character set utf8 collate utf8_bin;
mysql> grant all privileges on zabbix.* to zabbix@localhost identified by '<password>';
mysql> quit;

[llucca]

Hello

same issue here, I don't get how to create the database,


there is no such directory ...

shell> cd database/mysql

[mattds91]

I'm having this issue as well

I followed the documentation for installing from packages (ubuntu 14), and followed the link to "database creation scripts" here: https://www.zabbix.com/documentation...all/db_scripts

At the command, "cd database/mysql" I assume I'm supposed to change directory to wherever mysql database resides, but I'm not sure where that is. I've tried 'cd /var/lib/mysql' and a few other directories.

No matter where I try to continue, 'mysql -uzabbix -p<password> zabbix < schema.sql' command outputs:
'bash: schema.sql: No such file or directory'

Can someone tell me what I'm doing wrong? I followed all the directions exactly, and this is a clean installation of Ubuntu, apache2, mysql, and php

[Atsushi]

If you have installed using the package, please read the above post.
In the package of Zabbix 3.0, the script will be arranged so as to be compressed file.

After you create the database and the account, and then use the following files.

/usr/share/doc/zabbix-server-mysql/create.sql.gz

How to use it, please refer to the previous post.
There are also described in the manual.

https://www.zabbix.com/documentation/3.0/manual/installation/install_from_packages#creating_initial_database1

[mattds91]

I appreciate your response but you've sent me a link to same page I linked to. The same page I was stuck on. You have done this before to other users in this same thread. Please try to understand the problem before giving vague responses.

[rthonpm]

As several people have stated already: follow the instructions for installing via Packages. The only part of the install scripts you need to follow is the initial database creation. To import the schema, go back to the Ubuntu/Debian instructions and use the path listed there of /usr/share/doc/zabbix-server-mysql.

The instructions for Ubuntu tell you to create the database and user, which uses the creation script instructions. Then, go back to the Ubuntu instructions and follow the steps to import the schema:

Then import initial schema and data.

# cd /usr/share/doc/zabbix-server-mysql
# zcat create.sql.gz | mysql -uroot zabbix