create.sql.gz: No such file or directory

[sysadminldkw]

Hello all!

I'm trying to install Zabbix 5.4 to CentOS Stream, but I have not "create.sql.gz" anywhere. What the instruction of installing Zabbix 5.4 for CentOS Stream?
I'm downloaded schema.sql and importing schema to mysql but after this my zabbix-server can not start and shows "using configuration file: /etc/zabbix/zabbix_server.conf"

[Atsushi]

Did you install zabbix-sql-scripts package?

https://www.zabbix.com/download?zabbix=5.4&os_distribution=centos&os_version=8&db=mysql&ws=apache

[sysadminldkw]

Atsushi

Did you install zabbix-sql-scripts package?
https://www.zabbix.com/download?zabb...ysql&ws=apache

Oh, I forgot it, thank you!
Now Zabbix worked.

[jolalla]

Hello all

I need your help. Please.

Install a new zabbix server with the following features:
Centos7
Zabbix version: 5.0
Mysql: 15.1 Distrib: 10.4.19 Maria DB
PHP 7.2
it's a fresh install so i have nothing to back up because i haven't added any hosts yet.
On the centos server create a partition for the DB (/ data). I followed the instructions on how to change the mysql database directory. I validated it with @@ datadir inside mysql and it was correct in:
: / data / mysql
But the web interface is not working for me now. shows me error:
Database error
No such file or directory

I went to the php.ini configuration file located at:
/etc/opt/remi/php72/php.ini and there add the new socket path and it looks like this:

MYSQL_PDO
pdo_mysql.default_socket = / data / mysql / mysql.sock

MYSQL
mysql.default_socket = /data/mysql/mysql.sock

But it still doesn't work for me, what else should I modify?

Thank you very much for your help.

I leave here the error message that gives me and how is the directory of the DB after having changed it to the new partition.

[Atsushi]

It's a different question from the ones exchanged in this thread. Try the following setting.

mysqli.default_socket = /data/mysql/mysql.sock

[jolalla]

Hello Atsushi

Sorry for writing here, I'm new to this forum, I don't know it well at all, I only wrote in the first thing I saw, sorry again to All.
But still validate in my php.ini file that is located in /etc/opt/remi/php72/php.ini
there is that line is this way:

; Default socket name for local MySQL connects. If empty, uses the built-in
; MySQL defaults.
; http://php.net/mysqli.default-socket
mysqli.default_socket = / data / mysql / mysql.sock

But it still doesn't work, restart the httpd, even the server after making the changes but it doesn't work. Excuse me again. If you can help me with this issue, I would appreciate it very much.

[Atsushi]

I don't know how you are building your PHP environment, but if you have configured it to work using php-fpm you will need to restart php-fpm.

[jolalla]

Thanks Atsushi, I have PHP 7.2 installed and I have made the changes in the php.ini file and after that I have restarted the service and even restarted the server but it does not work the same for me.
In the same way, thank you very much for the help and sorry.
If someone else here can help me I would really appreciate it.
Thanks.

[PatxiAndueza]

I have found file create.sql.gz in /usr/share/doc/zabbix-sql-scripts/mysql/create.sql.gz

Thanks disnator, I was becoming crazy searching for this file!

[toxi]

Ubuntu 24.03 and zabbix-proxy-sqlite3 6.0.13.
I have found file: /usr/share/zabbix-proxy-sqlite3/schema.sql.gz

No such file or directory: /usr/share/doc/zabbix-proxy-sqlite3/schema.sql.gz

[yann88]

bonjour je suis nouveau dans zabbix et je rencontre ce probleme Unable to locate package zabbix-server-mysql

[yann88]

j'ai besoin d'aide svp

[yann88]

Unable to locate package zabbix-server-mysql voici le message