This problem is present on zabbix proxy 6.2 fresh installation too.

Using the official procedure on ubuntu server 22.04 :

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

DB installation script is absent in the path :

/usr/share/doc/zabbix-proxy-mysql

the only two present files are :

• copyright

• changelog.Debian

Please let me know ASAP how to fix this installation.

The issue is in Debian's apt configuration, not in the Zabbix the .deb packages.

I was able to reproduce the issue using a Debian Docker image. In this case, the file /etc/dpkg/dpkg.cfg.d/docker (yours may differ) contains a line path-exclude /usr/share/doc/* which causes all files not explicitly whitelisted later in that file (e.g. path-include ...) to not be installed.

Removing that line:

sed -i /etc/dpkg/dpkg.cfg.d/docker \
    -e '\@path-exclude /usr/share/doc/*@d'

Then reinstalling the package solved the issue.

root@32f1da10474f:~# ls -l /usr/share/doc/zabbix-sql-scripts/postgresql/
root@32f1da10474f:~# sed -i /etc/dpkg/dpkg.cfg.d/docker -e '\@path-exclude /usr/share/doc/*@d'
root@32f1da10474f:~# apt-get -qy reinstall zabbix-sql-scripts
Reading package lists...
Building dependency tree...
Reading state information...
0 upgraded, 0 newly installed, 1 reinstalled, 0 to remove and 0 not upgraded.
Need to get 7039 kB of archives.
After this operation, 0 B of additional disk space will be used.
Get:1 https://repo.zabbix.com/zabbix/6.2/debian bullseye/main amd64 zabbix-sql-scripts all 1:6.2.1-1+debian11 [7039 kB]
Fetched 7039 kB in 3s (2812 kB/s)
debconf: delaying package configuration, since apt-utils is not installed
(Reading database ... 12827 files and directories currently installed.)
Preparing to unpack .../zabbix-sql-scripts_1%3a6.2.1-1+debian11_all.deb ...
Unpacking zabbix-sql-scripts (1:6.2.1-1+debian11) over (1:6.2.1-1+debian11) ...
Setting up zabbix-sql-scripts (1:6.2.1-1+debian11) ...
root@32f1da10474f:~# ls -l /usr/share/doc/zabbix-sql-scripts/postgresql/
total 3568
-rw-r--r-- 1 root root     413 Jul 14 11:12 double.sql
-rw-r--r-- 1 root root    2432 Jul 14 11:12 history_pk_prepare.sql
-rw-r--r-- 1 root root  169198 Jul 14 11:12 proxy.sql
-rw-r--r-- 1 root root 3469265 Jul 14 11:12 server.sql.gz
-rw-r--r-- 1 root root    3437 Jul 14 11:12 timescaledb.sql

I haven't checked the .rpm files but I'd imagine it to be a similar issue.

Have the same issue on Ubuntu 22.04 LTS. /etc/dpkg/dpkg.cfg.d/excludes contains path-exclude=/usr/share/doc/*
After commenting and apt reinstall zabbix-sql-scripts schema files are in place.

Fixed together with ZBX-21267.

just installed zabbix 6.2 on debian bullseye and have the very same issue:

not a single script to create the database...

: dpkg -l 'zabb*'|grep ii
ii  zabbix-agent        1:6.2.6-1+debian11 amd64        Zabbix network monitoring solution - agent
ii  zabbix-frontend-php 1:6.2.6-1+debian11 all          Zabbix network monitoring solution - PHP front-end
ii  zabbix-get          1:6.2.6-1+debian11 amd64        Zabbix network monitoring solution - get
ii  zabbix-release      1:6.2-4+debian11   all          Zabbix official repository configuration
ii  zabbix-sender       1:6.2.6-1+debian11 amd64        Zabbix network monitoring solution - sender
ii  zabbix-server-mysql 1:6.2.6-1+debian11 amd64        Zabbix network monitoring solution - server (MySQL)

nothing name server.sql.gz or server.sql

: find /usr/share/doc/zabbix-*
/usr/share/doc/zabbix-agent
/usr/share/doc/zabbix-agent/changelog.Debian.gz
/usr/share/doc/zabbix-agent/changelog.gz
/usr/share/doc/zabbix-agent/copyright
/usr/share/doc/zabbix-agent/userparameter_mysql.conf
/usr/share/doc/zabbix-frontend-php
/usr/share/doc/zabbix-frontend-php/changelog.Debian.gz
/usr/share/doc/zabbix-frontend-php/changelog.gz
/usr/share/doc/zabbix-frontend-php/copyright
/usr/share/doc/zabbix-get
/usr/share/doc/zabbix-get/changelog.Debian.gz
/usr/share/doc/zabbix-get/changelog.gz
/usr/share/doc/zabbix-get/copyright
/usr/share/doc/zabbix-release
/usr/share/doc/zabbix-release/README.Debian
/usr/share/doc/zabbix-release/changelog.Debian
/usr/share/doc/zabbix-release/copyright
/usr/share/doc/zabbix-sender
/usr/share/doc/zabbix-sender/changelog.Debian.gz
/usr/share/doc/zabbix-sender/changelog.gz
/usr/share/doc/zabbix-sender/copyright
/usr/share/doc/zabbix-server-mysql
/usr/share/doc/zabbix-server-mysql/changelog.Debian.gz
/usr/share/doc/zabbix-server-mysql/changelog.gz
/usr/share/doc/zabbix-server-mysql/copyright

no special dpkg config it seems:

: find  /etc/dpkg/ -type f -exec cat {} \;
# dpkg configuration file
#
# This file can contain default options for dpkg.  All command-line
# options are allowed.  Values can be specified by putting them after
# the option, separated by whitespace and/or an `=' sign.
## Do not enable debsig-verify by default; since the distribution is not using
# embedded signatures, debsig-verify would reject all packages.
no-debsig# Log status changes and actions to a file.
log /var/log/dpkg.log
Vendor: Debian
Vendor-URL: https://www.debian.org/
Bugs: debbugs://bugs.debian.org

best regards,

Ghislain.

Hi There, was there a how-to to fix the mentioned issue?

I have just installed Zabbix on Unbuntu and getting the same 

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

Any help or guidance will be applicated 

by installing zabbix-sql-scripts

apt-get install zabbix-sql-scripts

Hi there 

Thank you for the feedback 

But even after the suggested install that I had already did I still get 

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

Thank you 

89east, what's the output of apt search zabbix ?

Are you using the official Zabbix repo?

Hi 

the search returns with 

apt search zabbix 
Sorting... Done
Full Text Search... Done
golang-github-inexio-go-monitoringplugin-dev/jammy,jammy 1.0.13-1 all
  Go lib for writing monitoring check plugins

nagstamon/jammy,jammy 3.8.0-1 all
  Nagios status monitor which takes place in systray or on desktop

octopussy/jammy,jammy 1.0.6-0ubuntu2 all
  log analyzer, alerter & reporter

pcp-export-pcp2zabbix/jammy 5.3.6-1build1 amd64
  Tool for exporting data from PCP to Zabbix

pcp-export-zabbix-agent/jammy 5.3.6-1build1 amd64
  Module for exporting PCP metrics to Zabbix agent

python3-protobix/jammy,jammy 1.0.2-8 all
  Implementation of Zabbix Sender protocol (Python 3)

python3-pyzabbix/jammy,jammy 0.8.2-1 all
  Zabbix API Python interface.

resource-agents-extra/jammy-updates 1:4.7.0-1ubuntu7.1 amd64
  Cluster Resource Agents

uwsgi-core/jammy 2.0.20-4 amd64
  fast, self-healing application container server (core)

yowsup-cli/jammy,jammy 3.2.3-2 all
  command line tool that acts as WhatsApp client

zabbix-agent/jammy,now 1:6.4.4-1+ubuntu22.04 amd64 [installed]
  Zabbix network monitoring solution - agent

zabbix-agent-dbgsym/jammy 1:6.4.4-1+ubuntu22.04 amd64
  debug symbols for zabbix-agent

zabbix-agent2/jammy 1:6.4.4-1+ubuntu22.04 amd64
  Zabbix network monitoring solution - agent

zabbix-agent2-dbgsym/jammy 1:6.4.4-1+ubuntu22.04 amd64
  debug symbols for zabbix-agent2

zabbix-agent2-plugin-mongodb/jammy 0:6.4.4-1+ubuntu22.04 amd64
  Zabbix Agent2 plugin for monitoring MongoDB installations

zabbix-agent2-plugin-postgresql/jammy 0:6.4.4-1+ubuntu22.04 amd64
  Zabbix Agent2 plugin for monitoring PostgreSQL installations

zabbix-apache-conf/jammy,now 1:6.4.4-1+ubuntu22.04 all [installed]
  Zabbix network monitoring solution - apache configuration for front-end

zabbix-frontend-php/jammy,now 1:6.4.4-1+ubuntu22.04 all [installed]
  Zabbix network monitoring solution - PHP front-end

zabbix-get/jammy 1:6.4.4-1+ubuntu22.04 amd64
  Zabbix network monitoring solution - get

zabbix-get-dbgsym/jammy 1:6.4.4-1+ubuntu22.04 amd64
  debug symbols for zabbix-get

zabbix-java-gateway/jammy 1:6.4.4-1+ubuntu22.04 all
  Zabbix network monitoring solution - java-gateway

zabbix-js/jammy 1:6.4.4-1+ubuntu22.04 amd64
  Zabbix network monitoring solution - js

zabbix-js-dbgsym/jammy 1:6.4.4-1+ubuntu22.04 amd64
  debug symbols for zabbix-js

zabbix-nginx-conf/jammy 1:6.4.4-1+ubuntu22.04 all
  Zabbix network monitoring solution - nginx and php-fpm configuration for front-end

zabbix-proxy-mysql/jammy 1:6.4.4-1+ubuntu22.04 amd64
  Zabbix network monitoring solution - proxy (MySQL)

zabbix-proxy-mysql-dbgsym/jammy 1:6.4.4-1+ubuntu22.04 amd64
  debug symbols for zabbix-proxy-mysql

zabbix-proxy-pgsql/jammy 1:6.4.4-1+ubuntu22.04 amd64
  Zabbix network monitoring solution - proxy (PostgreSQL)

zabbix-proxy-pgsql-dbgsym/jammy 1:6.4.4-1+ubuntu22.04 amd64
  debug symbols for zabbix-proxy-pgsql

zabbix-proxy-sqlite3/jammy 1:6.4.4-1+ubuntu22.04 amd64
  Zabbix network monitoring solution - proxy (SQLite3)

zabbix-proxy-sqlite3-dbgsym/jammy 1:6.4.4-1+ubuntu22.04 amd64
  debug symbols for zabbix-proxy-sqlite3

zabbix-release/jammy,now 1:6.4-1+ubuntu22.04 all [installed]
  Zabbix official repository configuration

zabbix-sender/jammy 1:6.4.4-1+ubuntu22.04 amd64
  Zabbix network monitoring solution - sender

zabbix-sender-dbgsym/jammy 1:6.4.4-1+ubuntu22.04 amd64
  debug symbols for zabbix-sender

zabbix-server-mysql/jammy,now 1:6.4.4-1+ubuntu22.04 amd64 [installed]
  Zabbix network monitoring solution - server (MySQL)

zabbix-server-mysql-dbgsym/jammy 1:6.4.4-1+ubuntu22.04 amd64
  debug symbols for zabbix-server-mysql

zabbix-server-pgsql/jammy 1:6.4.4-1+ubuntu22.04 amd64
  Zabbix network monitoring solution - server (PostgreSQL)

zabbix-server-pgsql-dbgsym/jammy 1:6.4.4-1+ubuntu22.04 amd64
  debug symbols for zabbix-server-pgsql

zabbix-sql-scripts/jammy,now 1:6.4.4-1+ubuntu22.04 all [installed]
  Zabbix network monitoring solution - sql-scripts

zabbix-web-service/jammy 1:6.4.4-1+ubuntu22.04 amd64
  Zabbix network monitoring solution - web-service

Additionally, I did a fresh install on a new Vm and went ok second time round!