Zabbix Proxy 6.0 LTS missing file schema.sql.gz

[Robert N.]

Hi, I was trying to install Zabbix proxy 6.0 LTS and if I run "sudo zcat /usr/share/doc/zabbix-sql-scripts/mysql/schema.sql.gz | mysql -uzabbix -p zabbix_proxy" - the file is missing. There is a new file "proxy.sql" and if I put it into the proxy.sql.gz then I succesfully run the script and the proxy.
How will be the new command for proxy.sql without .gz? THX

[Robert N.]

Got it :

sudo cat /usr/share/doc/zabbix-sql-scripts/mysql/proxy.sql | mysql -uzabbix -p zabbix_proxy

[ripperSK]

For zabbix 6.0 (and probably newer) I learned the hard way - you need to install package

zabbix-sql-scripts

in order to have

/usr/share/doc/zabbix-sql-scripts

directory populated with .sql DB initialisation scripts.

[bewog]

Hello,

Nothing in the package for Debian 11 Bullseye either:

# dpkg-query -L zabbix-proxy-sqlite3
/.
/etc
/etc/init.d
/etc/init.d/zabbix-proxy
/etc/logrotate.d
/etc/logrotate.d/zabbix-proxy-sqlite3
/etc/zabbix
/etc/zabbix/zabbix_proxy.conf
/lib
/lib/systemd
/lib/systemd/system
/lib/systemd/system/zabbix-proxy.service
/usr
/usr/lib
/usr/lib/tmpfiles.d
/usr/lib/tmpfiles.d/zabbix-proxy.conf
/usr/lib/zabbix
/usr/lib/zabbix/externalscripts
/usr/sbin
/usr/sbin/zabbix_proxy
/usr/share
/usr/share/doc
/usr/share/doc/zabbix-proxy-sqlite3
/usr/share/doc/zabbix-proxy-sqlite3/changelog.Debian.gz
/usr/share/doc/zabbix-proxy-sqlite3/changelog.gz
/usr/share/doc/zabbix-proxy-sqlite3/copyright
/usr/share/man
/usr/share/man/man8
/usr/share/man/man8/zabbix_proxy.8.gz
/var
/var/log
/var/log/zabbix

Do you known where i can find it ?
I'm looking for sqlite3 schema.

Thank you

[Glencoe]

Bewog, the previous comments relate to MySQL schema. You don't need schema files for SQLite, the SQLite version of zabbix_proxy creates the schema automatically.