New installation, missing scripts

[Magnus]

Hi

Have to start with telling you that I´m new to Zabbix
I have installed Ubuntu 14.0.4 LTS and Zabbix 3.0 from packages following this guide: https://www.zabbix.com/documentation..._from_packages
and https://www.zabbix.com/documentation...all/db_scripts

My problem is that I can´t find the scripts that I´m supposed to import (i.e. schema.sql, images.sql and data.sql) I have searched with "find / -name 'schema.sql' " and so on...
The database is up and running with user zabbix setup, and there are some data in the 113 tables but I have no idea whether I miss something or not.

Are they a dealbreaker to get my server up and running or can I continue without them? Are they available for download somewhere?

Regards
Magnus

[Atsushi]

Please see this thread.

https://www.zabbix.com/forum/showthread.php?t=54028

And, Please see manual.

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

[Magnus]

Please see this thread.

https://www.zabbix.com/forum/showthread.php?t=54028

And, Please see manual.
https://www.zabbix.com/documentation...tial_database1

I have read that post and also the manual, as I wrote in my first post...

My database(zabbix) is created with tables, users and some data but I still don´t have the scripts.

[DmitryL]

Hi Magnus,

You are looking for create.sql.gz

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

Best regards,
Dmitry

[Magnus]

Hi Magnus,

You are looking for create.sql.gz

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

Best regards,
Dmitry

Thanks

I have done that part also, and when I try to run it again I get "error 1050 (42S01) at line 1: Table 'maintenance' already exists"

Is there a log from the installation that I can check for possible errors during install/create?

I also tried to finish the installation without the .sql-scripts and I can log on to my zabbix-server through the php-frontend and do some checks on the server, but I clearly miss the templates, so I guess it´s not complete.

// Magnus

[Magnus]

A little update

I got the tip from an other thread written by mr Atsushi to download the script-files from sourcefourge, so I did and unpacked the files I needed.
However, I got the same error as before (mysql, error line 1: maintenance already exist).

I then dropped zabbix database all together and started the process of creating the database again.
This time I can import the scripts and have done so, but when I try to run "# zcat create.sql.gz | mysql -uroot zabbix", I yet again get the error about maintenance already exist...

Any ideas or suggestions would be appreciated.

[DmitryL]

Magnus,

When you are installing from sources, you need
*schema.sql
*images.sql
*data.sql

When you are installing from packages, you need only create.sql.gz

Drop the database, run create.sql.gz and proceed to next installation steps.

Best regards,
Dmitry

[Magnus]

Magnus,

When you are installing from sources, you need
*schema.sql
*images.sql
*data.sql

When you are installing from packages, you need only create.sql.gz

Drop the database, run create.sql.gz and proceed to next installation steps.

Best regards,
Dmitry

Thank you, I finally got that last night
I also tried the appliance installation (vmdk) but had some issues with locales, so I ended up with installing Zabbix on CentOS instead.

I have some suggestions in altering the documentation, but I´ll write a new post for that.