Cannot import initial schema and data

[apiel1]

I am new to Zabbix. I am installing on Ubuntu 16.04. I get all the way to the step for importing the initial schema and data and i enter the following

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

I get returned the following:

Enter Password: gzip: /usr/share/doc/zabbix-server-mysql*/create.sql.gz: No Such file or directory

Thank you for the help

[THardy]

Has anyone been able to help with this? I am trying to do the initial install as well and I am getting this same error. If it helps I am trying to install on Parrot Linux.

[Atsushi]

Please read manual.

https://www.zabbix.com/documentation/3.4/manual/installation/install_from_packages/debian_ubuntu

With Ubuntu, the directory name does not include the version number.

[saifkhantm]

Hi Atsushi,
I'm sorry, I dont understand your answer.

I read the manual. Is there something in that command relating to 'version number'?
what exactly is the fix...??

[Atsushi]

"*" Is specified in the file directory specification.
This is a wild card.

In the RHEL package, if you specify the create.sql.gz file, the directory name contains the version number.
If you specify that file, you can explicitly specify the version number or use wildcards.

ex. file path for RHEL
/usr/share/doc/zabbix-server-mysql-4.0.0/create.sql.gz

In the package for Ubuntu I think that the directory number did not include the version number.

If the create.sql.gz file does not exist, please check that it was not set to not install the document attribute file with the command used to install the package.

[DmitryL]

Check the correct path from your CLI instead of copy/paste from the documentation.
I mean this one: /usr/share/doc/zabbix-server-mysql*/create.sql.gz

[saifkhantm]

Hi Dmitry,
The file path is correct..




I'm getting this syntax error msg;




I'm sorry for the screen shots, i'm working with CONSOLE... and it does not let me copy text..

[DmitryL]

zcat ........./create.sql.gz | mysql -uzabbix -pzabbix

[saifkhantm]

... no go...

[Atsushi]

Please check your command line.

NG:
# zcat /usr/share/doc/zabbix-server-mysql/create.sql.gz > mysql -uzabbix -p zabbix
OK:
# zcat /usr/share/doc/zabbix-server-mysql/create.sql.gz | mysql -uzabbix -p zabbix

[saifkhantm]

yes...
thank you for pointing that out.
I am using console connection to the server.
for some reason, its not letting my type "|", instead it types ">"

Its something to do with the console keyboard.

Going to try and get SSH working. Then I can type in terminal window...

But thanks for the clarificatons and help.

[saifkhantm]

SUPER K.

I was able establish SSH and use "|" and it worked.
Thanks folks !!!

[shehzadkhan]

i have the same problem. i navigated to the path usr/share/doc$ and the next folder i can see the full directory name as: zabbix-server-mysql:



but it didn't work as:

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


i then navigate to /usr/share/doc/zabbix-server-mysql/ and use the command zcat create.sql.gz | mysql -uzabbix -p database_name

it didn't through an error. but when i re-tried the command:

zcat /usr/share/doc/zabbix-server-mysql/create.sql.gz | mysql -uzabbix -p zabbix # last zabbix -p <space> is the name of the database it threw this error:

ERROR 1050 (42S01) at line 1: Table 'users' already exists

any ideas???

[Atsushi]

If you run the following command and an error is output, it means that the table has already been created.

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

Either use the one already created or recreate the database.

[blixten85]

I do not have this package at all.

pi@raspberrypi:~ $ sudo ls -la /usr/share/doc/zabbix-server-mysql*
total 336
drwxr-xr-x 2 root root 4096 May 12 19:20 .
drwxr-xr-x 1311 root root 49152 May 12 18:55 ..
-rw-r--r-- 1 root root 16190 Feb 6 2019 changelog.Debian.gz
-rw-r--r-- 1 root root 249196 Feb 4 2019 changelog.gz
-rw-r--r-- 1 root root 8411 Feb 6 2019 copyright
-rw-r--r-- 1 root root 1212 Apr 28 2018 NEWS.Debian.gz
-rw-r--r-- 1 root root 1002 Apr 28 2018 README.Debian

I read here about uncomment some manual skip part for dpkg.
create.sql.gz: No such file or directory - ZABBIX Forums

This file does not exist for me.