[ZBX-14820] Ubuntu 18.04 Proxy package is missing schema.sql.gz Created: 2018 Jul 18  Updated: 2024 Apr 10  Resolved: 2018 Sep 06

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Incident report Priority: Major
Reporter: Matthias Baur Assignee: dimir
Resolution: Workaround proposed Votes: 0
Labels: docker, schema, ubuntu
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Docker image of Ubuntu 18.04 (Bionic) from Docker Hub.


Team: Team C
Sprint: Sprint 41, Sprint 42
Story Points: 1.5

 Description   

After installing the zabbix-proxy-mysql package on Ubuntu 18.04 i realized that the usr/share/doc/zabbix-proxy-mysql/schema.sql.gz file is missing.

 

root@15a923d8bf44:~# wget https://repo.zabbix.com/zabbix/3.0/ubuntu/pool/main/z/zabbix-release/zabbix-release_3.0-2%2Bbionic_all.deb
--2018-07-18 11:58:05--  https://repo.zabbix.com/zabbix/3.0/ubuntu/pool/main/z/zabbix-release/zabbix-release_3.0-2%2Bbionic_all.deb
Resolving repo.zabbix.com (repo.zabbix.com)... 162.243.159.138
Connecting to repo.zabbix.com (repo.zabbix.com)|162.243.159.138|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 3928 (3.8K) [application/octet-stream]
Saving to: 'zabbix-release_3.0-2+bionic_all.deb'

zabbix-release_3.0-2+bionic_all.deb           100%[==============================================================================================>]   3.84K  --.-KB/s    in 0s

2018-07-18 11:58:05 (157 MB/s) - 'zabbix-release_3.0-2+bionic_all.deb' saved [3928/3928]

root@15a923d8bf44:~# dpkg -i zabbix-release_3.0-2+bionic_all.deb
Selecting previously unselected package zabbix-release.
(Reading database ... 4375 files and directories currently installed.)
Preparing to unpack zabbix-release_3.0-2+bionic_all.deb ...
Unpacking zabbix-release (3.0-2+bionic) ...
Setting up zabbix-release (3.0-2+bionic) ...
root@15a923d8bf44:~# apt update
Hit:1 http://archive.ubuntu.com/ubuntu bionic InRelease
Hit:2 http://archive.ubuntu.com/ubuntu bionic-updates InRelease
Hit:3 http://archive.ubuntu.com/ubuntu bionic-backports InRelease
Hit:4 http://security.ubuntu.com/ubuntu bionic-security InRelease
Get:5 http://repo.zabbix.com/zabbix/3.0/ubuntu bionic InRelease [7096 B]
Get:6 http://repo.zabbix.com/zabbix/3.0/ubuntu bionic/main Sources [1176 B]
Get:7 http://repo.zabbix.com/zabbix/3.0/ubuntu bionic/main amd64 Packages [2627 B]
Fetched 10.9 kB in 1s (12.8 kB/s)
Reading package lists... Done
Building dependency tree
Reading state information... Done
10 packages can be upgraded. Run 'apt list --upgradable' to see them.
root@15a923d8bf44:~# apt install zabbix-proxy-mysql
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following additional packages will be installed:
  fping galera-3 gawk iproute2 krb5-locales libaio1 libasn1-8-heimdal libatm1 libcap2 libcap2-bin libcgi-fast-perl libcgi-pm-perl libconfig-inifiles-perl libcurl4
  libdbd-mysql-perl libdbi-perl libelf1 libencode-locale-perl libfcgi-perl libgdbm-compat4 libgdbm5 libgssapi-krb5-2 libgssapi3-heimdal libhcrypto4-heimdal libheimbase1-heimdal
  libheimntlm0-heimdal libhtml-parser-perl libhtml-tagset-perl libhtml-template-perl libhttp-date-perl libhttp-message-perl libhx509-5-heimdal libicu60 libio-html-perl
  libjemalloc1 libk5crypto3 libkeyutils1 libkrb5-26-heimdal libkrb5-3 libkrb5support0 libldap-2.4-2 libldap-common libltdl7 liblwp-mediatypes-perl libmnl0 libmpfr6
  libmysqlclient20 libnghttp2-14 libodbc1 libopenipmi0 libpam-cap libpci3 libperl5.26 libpopt0 libreadline5 libreadline7 libroken18-heimdal librtmp1 libsasl2-2 libsasl2-modules
  libsasl2-modules-db libsensors4 libsigsegv2 libsnmp-base libsnmp30 libsqlite3-0 libssh2-1 libssl1.0.0 libterm-readkey-perl libtimedate-perl liburi-perl libwind0-heimdal libwrap0
  libxml2 libxtables12 lsof mariadb-client-10.1 mariadb-client-core-10.1 mariadb-common mariadb-server-10.1 mariadb-server-core-10.1 mysql-common netbase perl perl-base
  perl-modules-5.26 psmisc readline-common rsync socat
Suggested packages:
  gawk-doc iproute2-doc libclone-perl libmldbm-perl libnet-daemon-perl libsql-statement-perl gdbm-l10n krb5-doc krb5-user libdata-dump-perl libipc-sharedcache-perl libmyodbc
  odbc-postgresql tdsodbc unixodbc-bin libsasl2-modules-gssapi-mit | libsasl2-modules-gssapi-heimdal libsasl2-modules-ldap libsasl2-modules-otp libsasl2-modules-sql lm-sensors
  snmp-mibs-downloader libwww-perl mailx netcat-openbsd tinyca perl-doc libterm-readline-gnu-perl | libterm-readline-perl-perl make readline-doc openssh-client openssh-server
  logrotate
The following NEW packages will be installed:
  fping galera-3 gawk iproute2 krb5-locales libaio1 libasn1-8-heimdal libatm1 libcap2 libcap2-bin libcgi-fast-perl libcgi-pm-perl libconfig-inifiles-perl libcurl4
  libdbd-mysql-perl libdbi-perl libelf1 libencode-locale-perl libfcgi-perl libgdbm-compat4 libgdbm5 libgssapi-krb5-2 libgssapi3-heimdal libhcrypto4-heimdal libheimbase1-heimdal
  libheimntlm0-heimdal libhtml-parser-perl libhtml-tagset-perl libhtml-template-perl libhttp-date-perl libhttp-message-perl libhx509-5-heimdal libicu60 libio-html-perl
  libjemalloc1 libk5crypto3 libkeyutils1 libkrb5-26-heimdal libkrb5-3 libkrb5support0 libldap-2.4-2 libldap-common libltdl7 liblwp-mediatypes-perl libmnl0 libmpfr6
  libmysqlclient20 libnghttp2-14 libodbc1 libopenipmi0 libpam-cap libpci3 libperl5.26 libpopt0 libreadline5 libreadline7 libroken18-heimdal librtmp1 libsasl2-2 libsasl2-modules
  libsasl2-modules-db libsensors4 libsigsegv2 libsnmp-base libsnmp30 libsqlite3-0 libssh2-1 libssl1.0.0 libterm-readkey-perl libtimedate-perl liburi-perl libwind0-heimdal libwrap0
  libxml2 libxtables12 lsof mariadb-client-10.1 mariadb-client-core-10.1 mariadb-common mariadb-server-10.1 mariadb-server-core-10.1 mysql-common netbase perl perl-modules-5.26
  psmisc readline-common rsync socat zabbix-proxy-mysql
The following packages will be upgraded:
  perl-base
1 upgraded, 90 newly installed, 0 to remove and 9 not upgraded.
Need to get 49.2 MB of archives.
After this operation, 289 MB of additional disk space will be used.
Do you want to continue? [Y/n] Y
Get:1 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 perl-base amd64 5.26.1-6ubuntu0.1 [1391 kB]
Get:2 http://archive.ubuntu.com/ubuntu bionic/main amd64 libmpfr6 amd64 4.0.1-1 [243 kB]
Get:3 http://archive.ubuntu.com/ubuntu bionic/main amd64 readline-common all 7.0-3 [52.9 kB]
Get:4 http://archive.ubuntu.com/ubuntu bionic/main amd64 libreadline7 amd64 7.0-3 [124 kB]
Get:5 http://archive.ubuntu.com/ubuntu bionic/main amd64 libsigsegv2 amd64 2.12-1 [14.7 kB]
Get:6 http://archive.ubuntu.com/ubuntu bionic/main amd64 gawk amd64 1:4.1.4+dfsg-1build1 [401 kB]
Get:7 http://archive.ubuntu.com/ubuntu bionic/main amd64 mysql-common all 5.8+1.0.4 [7308 B]
Get:8 http://archive.ubuntu.com/ubuntu bionic/universe amd64 mariadb-common all 1:10.1.29-6 [15.3 kB]
Get:9 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 libssl1.0.0 amd64 1.0.2n-1ubuntu5.1 [1087 kB]
Get:10 http://repo.zabbix.com/zabbix/3.0/ubuntu bionic/main amd64 zabbix-proxy-mysql amd64 1:3.0.19-1+bionic [440 kB]
Get:11 http://archive.ubuntu.com/ubuntu bionic/universe amd64 galera-3 amd64 25.3.20-1 [947 kB]
Get:12 http://archive.ubuntu.com/ubuntu bionic/main amd64 libelf1 amd64 0.170-0.4 [44.1 kB]
Get:13 http://archive.ubuntu.com/ubuntu bionic/main amd64 libmnl0 amd64 1.0.4-2 [12.3 kB]
Get:14 http://archive.ubuntu.com/ubuntu bionic/main amd64 iproute2 amd64 4.15.0-2ubuntu1 [721 kB]
Get:15 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 perl-modules-5.26 all 5.26.1-6ubuntu0.1 [2761 kB]
Setting up rsync (3.1.2-2.1ubuntu1) ...
invoke-rc.d: could not determine current runlevel
invoke-rc.d: policy-rc.d denied execution of restart.
Setting up libssh2-1:amd64 (1.8.0-1) ...
Setting up krb5-locales (1.16-2build1) ...
Processing triggers for libc-bin (2.27-3ubuntu1) ...
Setting up libaio1:amd64 (0.3.110-5) ...
Setting up libatm1:amd64 (1:2.5.1-2build1) ...
Setting up galera-3 (25.3.20-1) ...
Setting up libxtables12:amd64 (1.6.1-2ubuntu2) ...
Setting up libheimbase1-heimdal:amd64 (7.5.0+dfsg-1) ...
Setting up libltdl7:amd64 (2.4.6-2) ...
Setting up libsqlite3-0:amd64 (3.22.0-1) ...
Setting up libsensors4:amd64 (1:3.4.0-4) ...
Setting up libmysqlclient20:amd64 (5.7.22-0ubuntu18.04.1) ...
Setting up libgdbm-compat4:amd64 (1.14.1-6) ...
Setting up libkeyutils1:amd64 (1.5.9-9.2ubuntu2) ...
Setting up libreadline5:amd64 (5.2+dfsg-3build1) ...
Setting up libsasl2-modules:amd64 (2.1.27~101-g0780600+dfsg-3ubuntu2) ...
Setting up libpci3:amd64 (1:3.5.2-1ubuntu1) ...
Setting up libmnl0:amd64 (1.0.4-2) ...
Setting up libopenipmi0 (2.0.22-1.1ubuntu2.1) ...
Setting up libwrap0:amd64 (7.6.q-27) ...
Setting up netbase (5.4) ...
Setting up libsnmp-base (5.7.3+dfsg-1.8ubuntu3) ...
Setting up libk5crypto3:amd64 (1.16-2build1) ...
Setting up libpam-cap:amd64 (1:2.25-1.2) ...
debconf: unable to initialize frontend: Dialog
debconf: (No usable dialog-like program is installed, so the dialog based frontend cannot be used. at /usr/share/perl5/Debconf/FrontEnd/Dialog.pm line 76.)
debconf: falling back to frontend: Readline
Setting up libodbc1:amd64 (2.3.4-1.1ubuntu3) ...
Setting up mariadb-server-core-10.1 (1:10.1.29-6) ...
Setting up libwind0-heimdal:amd64 (7.5.0+dfsg-1) ...
Setting up libcap2-bin (1:2.25-1.2) ...
Setting up socat (1.7.3.2-2ubuntu2) ...
Setting up mariadb-client-core-10.1 (1:10.1.29-6) ...
Setting up libasn1-8-heimdal:amd64 (7.5.0+dfsg-1) ...
Setting up libhcrypto4-heimdal:amd64 (7.5.0+dfsg-1) ...
Setting up iproute2 (4.15.0-2ubuntu1) ...
Setting up libhx509-5-heimdal:amd64 (7.5.0+dfsg-1) ...
Setting up libperl5.26:amd64 (5.26.1-6ubuntu0.1) ...
Setting up fping (4.0-6) ...
Setting up libkrb5-3:amd64 (1.16-2build1) ...
Setting up libkrb5-26-heimdal:amd64 (7.5.0+dfsg-1) ...
Setting up libheimntlm0-heimdal:amd64 (7.5.0+dfsg-1) ...
Setting up libsnmp30:amd64 (5.7.3+dfsg-1.8ubuntu3) ...
Setting up libgssapi-krb5-2:amd64 (1.16-2build1) ...
Setting up perl (5.26.1-6ubuntu0.1) ...
Setting up liblwp-mediatypes-perl (6.02-1) ...
Setting up liburi-perl (1.73-1) ...
Setting up libgssapi3-heimdal:amd64 (7.5.0+dfsg-1) ...
Setting up libfcgi-perl (0.78-2build1) ...
Setting up libdbi-perl (1.640-1) ...
Setting up libhtml-tagset-perl (3.20-3) ...
Setting up libconfig-inifiles-perl (2.94-1) ...
Setting up libencode-locale-perl (1.05-1) ...
Setting up libtimedate-perl (2.3000-2) ...
Setting up libio-html-perl (1.001-1) ...
Setting up libterm-readkey-perl (2.37-1build1) ...
Setting up libldap-2.4-2:amd64 (2.4.45+dfsg-1ubuntu1) ...
Setting up libhtml-parser-perl (3.72-3build1) ...
Setting up libcgi-pm-perl (4.38-1) ...
Setting up libdbd-mysql-perl (4.046-1) ...
Setting up mariadb-client-10.1 (1:10.1.29-6) ...
Setting up libhttp-date-perl (6.02-1) ...
Setting up libhtml-template-perl (2.97-1) ...
Setting up libcurl4:amd64 (7.58.0-2ubuntu3.2) ...
Setting up libcgi-fast-perl (1:2.13-1) ...
Setting up zabbix-proxy-mysql (1:3.0.19-1+bionic) ...
Setting up libhttp-message-perl (6.14-1) ...
Setting up mariadb-server-10.1 (1:10.1.29-6) ...
debconf: unable to initialize frontend: Dialog
debconf: (No usable dialog-like program is installed, so the dialog based frontend cannot be used. at /usr/share/perl5/Debconf/FrontEnd/Dialog.pm line 76.)
debconf: falling back to frontend: Readline
invoke-rc.d: could not determine current runlevel
invoke-rc.d: policy-rc.d denied execution of start.
Processing triggers for libc-bin (2.27-3ubuntu1) ...
root@15a923d8bf44:~# ls -la /usr/share/doc/zabbix-proxy-mysql/*
-rw-r--r-- 1 root root 1288 Jun 25 08:06 /usr/share/doc/zabbix-proxy-mysql/changelog.Debian.gz
-rw-r--r-- 1 root root  980 Oct  2  2017 /usr/share/doc/zabbix-proxy-mysql/copyright
root@15a923d8bf44:~# dpkg -l | grep zabbix
ii  zabbix-proxy-mysql         1:3.0.19-1+bionic                 amd64        Zabbix network monitoring solution - proxy (MySQL)
ii  zabbix-release             3.0-2+bionic                      all          Zabbix official repository configuration


 Comments   
Comment by Matthias Baur [ 2018 Jul 18 ]

(Seems like I can't edit the issue)

3.4.11 seems to be effected as well.

Comment by dimir [ 2018 Jul 18 ]

You are right, I can confirm the issue, we'll take a look.

Comment by Matthias Baur [ 2018 Aug 31 ]

3.0.21 and 3.4.13 are still effected. Could you please fix this? There seems to be something broken in you build process as the package thinks this file should exists:

root@450238eaf147:/# dpkg -L zabbix-proxy-mysql | grep schema
/usr/share/doc/zabbix-proxy-mysql/schema.sql.gz
root@450238eaf147:/# ls -la /usr/share/doc/zabbix-proxy-mysql/
total 16
drwxr-xr-x 2 root root 4096 Aug 31 08:47 .
drwxr-xr-x 1 root root 4096 Aug 31 08:47 ..
-rw-r--r-- 1 root root 1658 Aug 27 08:37 changelog.Debian.gz
-rw-r--r-- 1 root root  980 Oct  2  2017 copyright
Comment by dimir [ 2018 Sep 05 ]

Fun fact that this issue only happens for packages created for Ubuntu Bionic.

It looks like you are using docker as me. I wonder if that's the issue. Because when I execute the following on the same system it looks good:

root@3107e811ead2:/tmp# wget http://repo.zabbix.com/zabbix/3.0/ubuntu/pool/main/z/zabbix/zabbix-proxy-mysql_3.0.21-1%2Bbionic_amd64.deb
root@3107e811ead2:/tmp# ar x zabbix-proxy-mysql_3.0.21-1+bionic_amd64.deb
root@3107e811ead2:/tmp# tar xvf data.tar.xz
root@3107e811ead2:/tmp# tar xvf data.tar.xz 
./
./etc/
./etc/init.d/
./etc/init.d/zabbix-proxy
./etc/logrotate.d/
./etc/logrotate.d/zabbix-proxy-mysql
./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-mysql/
./usr/share/doc/zabbix-proxy-mysql/changelog.Debian.gz
./usr/share/doc/zabbix-proxy-mysql/copyright
./usr/share/doc/zabbix-proxy-mysql/schema.sql.gz
./usr/share/man/
./usr/share/man/man8/
./usr/share/man/man8/zabbix_proxy.8.gz
./var/
./var/log/
./var/log/zabbix/
root@3107e811ead2:/tmp# ls -l usr/share/doc/zabbix-proxy-mysql/schema.sql.gz
-rw-r--r-- 1 root root 10674 Aug 27 08:20 usr/share/doc/zabbix-proxy-mysql/schema.sql.gz

And now when I go and install the same package - the schema file is not there:

root@3107e811ead2:/tmp# dpkg -i zabbix-proxy-mysql_3.0.21-1+bionic_amd64.deb
Selecting previously unselected package zabbix-proxy-mysql.
(Reading database ... 12733 files and directories currently installed.)
Preparing to unpack zabbix-proxy-mysql_3.0.21-1+bionic_amd64.deb ...
Unpacking zabbix-proxy-mysql (1:3.0.21-1+bionic) ...
Setting up zabbix-proxy-mysql (1:3.0.21-1+bionic) ...
root@3107e811ead2:/tmp# dpkg -L zabbix-proxy-mysql | grep schema
/usr/share/doc/zabbix-proxy-mysql/schema.sql.gz
root@3107e811ead2:/tmp# ls -l /usr/share/doc/zabbix-proxy-mysql/schema.sql.gz
ls: cannot access '/usr/share/doc/zabbix-proxy-mysql/schema.sql.gz': No such file or directory

Can somebody confirm the same on a real Bionic system? To me it looks like package manager's fault.

Comment by Matthias Baur [ 2018 Sep 06 ]

You're right, my first test was done in a Docker container. Here is an example from a Vagrant/Virtualbox VM:

root@ubuntu-bionic:~# wget https://repo.zabbix.com/zabbix/3.0/ubuntu/pool/main/z/zabbix-release/zabbix-release_3.0-2%2Bbionic_all.deb
--2018-09-06 07:28:10--  https://repo.zabbix.com/zabbix/3.0/ubuntu/pool/main/z/zabbix-release/zabbix-release_3.0-2%2Bbionic_all.deb
Resolving repo.zabbix.com (repo.zabbix.com)... 162.243.159.138
Connecting to repo.zabbix.com (repo.zabbix.com)|162.243.159.138|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 3928 (3.8K) [application/octet-stream]
Saving to: ‘zabbix-release_3.0-2+bionic_all.deb’

zabbix-release_3.0-2+bionic_all.deb                         100%[=========================================================================================================================================>]   3.84K  --.-KB/s    in 0s

2018-09-06 07:28:11 (36.5 MB/s) - ‘zabbix-release_3.0-2+bionic_all.deb’ saved [3928/3928]

root@ubuntu-bionic:~# dpkg -i zabbix-release_3.0-2+bionic_all.deb
Selecting previously unselected package zabbix-release.
(Reading database ... 59634 files and directories currently installed.)
Preparing to unpack zabbix-release_3.0-2+bionic_all.deb ...
Unpacking zabbix-release (3.0-2+bionic) ...
Setting up zabbix-release (3.0-2+bionic) ...
root@ubuntu-bionic:~# apt update
Hit:1 http://archive.ubuntu.com/ubuntu bionic InRelease
Get:2 http://security.ubuntu.com/ubuntu bionic-security InRelease [83.2 kB]
Get:3 http://archive.ubuntu.com/ubuntu bionic-updates InRelease [88.7 kB]
Get:4 http://archive.ubuntu.com/ubuntu bionic-backports InRelease [74.6 kB]
Get:5 http://archive.ubuntu.com/ubuntu bionic/universe Sources [9051 kB]
Get:6 http://repo.zabbix.com/zabbix/3.0/ubuntu bionic InRelease [7096 B]
Get:7 http://security.ubuntu.com/ubuntu bionic-security/universe Sources [15.7 kB]
Get:8 http://security.ubuntu.com/ubuntu bionic-security/multiverse Sources [1336 B]
Get:9 http://security.ubuntu.com/ubuntu bionic-security/main Sources [46.5 kB]
Get:10 http://security.ubuntu.com/ubuntu bionic-security/main amd64 Packages [160 kB]
Get:11 http://security.ubuntu.com/ubuntu bionic-security/main Translation-en [61.5 kB]
Get:12 http://security.ubuntu.com/ubuntu bionic-security/universe amd64 Packages [57.0 kB]
Get:13 http://security.ubuntu.com/ubuntu bionic-security/universe Translation-en [33.6 kB]
Get:14 http://repo.zabbix.com/zabbix/3.0/ubuntu bionic/main Sources [1178 B]
Get:15 http://security.ubuntu.com/ubuntu bionic-security/multiverse amd64 Packages [1444 B]
Get:16 http://security.ubuntu.com/ubuntu bionic-security/multiverse Translation-en [996 B]
Get:17 http://repo.zabbix.com/zabbix/3.0/ubuntu bionic/main amd64 Packages [2618 B]
Get:18 http://archive.ubuntu.com/ubuntu bionic/restricted Sources [5324 B]
Get:19 http://archive.ubuntu.com/ubuntu bionic/multiverse Sources [181 kB]
Get:20 http://archive.ubuntu.com/ubuntu bionic/main Sources [829 kB]
Get:21 http://archive.ubuntu.com/ubuntu bionic/universe amd64 Packages [8570 kB]
Get:22 http://archive.ubuntu.com/ubuntu bionic/universe Translation-en [4941 kB]
Get:23 http://archive.ubuntu.com/ubuntu bionic/multiverse amd64 Packages [151 kB]
Get:24 http://archive.ubuntu.com/ubuntu bionic/multiverse Translation-en [108 kB]
Get:25 http://archive.ubuntu.com/ubuntu bionic-updates/universe Sources [58.5 kB]
Get:26 http://archive.ubuntu.com/ubuntu bionic-updates/main Sources [161 kB]
Get:27 http://archive.ubuntu.com/ubuntu bionic-updates/multiverse Sources [2672 B]
Get:28 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 Packages [308 kB]
Get:29 http://archive.ubuntu.com/ubuntu bionic-updates/main Translation-en [116 kB]
Get:30 http://archive.ubuntu.com/ubuntu bionic-updates/universe amd64 Packages [173 kB]
Get:31 http://archive.ubuntu.com/ubuntu bionic-updates/universe Translation-en [80.5 kB]
Get:32 http://archive.ubuntu.com/ubuntu bionic-updates/multiverse amd64 Packages [3772 B]
Get:33 http://archive.ubuntu.com/ubuntu bionic-updates/multiverse Translation-en [2376 B]
Get:34 http://archive.ubuntu.com/ubuntu bionic-backports/universe Sources [1184 B]
Get:35 http://archive.ubuntu.com/ubuntu bionic-backports/universe amd64 Packages [2704 B]
Get:36 http://archive.ubuntu.com/ubuntu bionic-backports/universe Translation-en [1136 B]
Fetched 25.4 MB in 7s (3465 kB/s)
Reading package lists... Done
Building dependency tree
Reading state information... Done
16 packages can be upgraded. Run 'apt list --upgradable' to see them.
root@ubuntu-bionic:~# apt install zabbix-proxy-mysql
Reading package lists... Done
Building dependency tree
Selecting previously unselected package libssh2-1:amd64.
Preparing to unpack .../23-libssh2-1_1.8.0-1_amd64.deb ...
Unpacking libssh2-1:amd64 (1.8.0-1) ...
Selecting previously unselected package libterm-readkey-perl.
Preparing to unpack .../24-libterm-readkey-perl_2.37-1build1_amd64.deb ...
Unpacking libterm-readkey-perl (2.37-1build1) ...
Selecting previously unselected package zabbix-proxy-mysql.
Preparing to unpack .../25-zabbix-proxy-mysql_1%3a3.0.21-1+bionic_amd64.deb ...
Unpacking zabbix-proxy-mysql (1:3.0.21-1+bionic) ...
Setting up libhtml-tagset-perl (3.20-3) ...
Setting up libconfig-inifiles-perl (2.94-1) ...
Processing triggers for ureadahead (0.100.0-20) ...
Setting up libencode-locale-perl (1.05-1) ...
Setting up libjemalloc1 (3.6.0-11) ...
Setting up libtimedate-perl (2.3000-2) ...
Setting up socat (1.7.3.2-2ubuntu2) ...
Setting up libio-html-perl (1.001-1) ...
Setting up libterm-readkey-perl (2.37-1build1) ...
Setting up libssh2-1:amd64 (1.8.0-1) ...
Setting up liblwp-mediatypes-perl (6.02-1) ...
Processing triggers for libc-bin (2.27-3ubuntu1) ...
Setting up libaio1:amd64 (0.3.110-5) ...
Setting up galera-3 (25.3.20-1) ...
Setting up liburi-perl (1.73-1) ...
Setting up fping (4.0-6) ...
Processing triggers for systemd (237-3ubuntu10.3) ...
Setting up libltdl7:amd64 (2.4.6-2) ...
Setting up libhtml-parser-perl (3.72-3build1) ...
Setting up libcgi-pm-perl (4.38-1) ...
Setting up libsensors4:amd64 (1:3.4.0-4) ...
Processing triggers for man-db (2.8.3-2) ...
Setting up libmysqlclient20:amd64 (5.7.23-0ubuntu0.18.04.1) ...
Setting up libfcgi-perl (0.78-2build1) ...
Setting up libdbi-perl (1.640-1) ...
Setting up libopenipmi0 (2.0.22-1.1ubuntu2.1) ...
Setting up libsnmp-base (5.7.3+dfsg-1.8ubuntu3) ...
Setting up libhttp-date-perl (6.02-1) ...
Setting up libsnmp30:amd64 (5.7.3+dfsg-1.8ubuntu3) ...
Setting up libodbc1:amd64 (2.3.4-1.1ubuntu3) ...
Setting up mariadb-server-core-10.1 (1:10.1.34-0ubuntu0.18.04.1) ...
Setting up libhtml-template-perl (2.97-1) ...
Setting up mariadb-client-core-10.1 (1:10.1.34-0ubuntu0.18.04.1) ...
Setting up libcgi-fast-perl (1:2.13-1) ...
Setting up libhttp-message-perl (6.14-1) ...
Setting up libdbd-mysql-perl (4.046-1) ...
Setting up mariadb-client-10.1 (1:10.1.34-0ubuntu0.18.04.1) ...
Setting up zabbix-proxy-mysql (1:3.0.21-1+bionic) ...
Setting up mariadb-server-10.1 (1:10.1.34-0ubuntu0.18.04.1) ...
Created symlink /etc/systemd/system/mysql.service → /lib/systemd/system/mariadb.service.
Created symlink /etc/systemd/system/mysqld.service → /lib/systemd/system/mariadb.service.
Created symlink /etc/systemd/system/multi-user.target.wants/mariadb.service → /lib/systemd/system/mariadb.service.
Processing triggers for libc-bin (2.27-3ubuntu1) ...
Processing triggers for ureadahead (0.100.0-20) ...
Processing triggers for systemd (237-3ubuntu10.3) ...
root@ubuntu-bionic:~# apt-cache policy zabbix-proxy-mysql
zabbix-proxy-mysql:
  Installed: 1:3.0.21-1+bionic
  Candidate: 1:3.0.21-1+bionic
  Version table:
 *** 1:3.0.21-1+bionic 500
        500 http://repo.zabbix.com/zabbix/3.0/ubuntu bionic/main amd64 Packages
        100 /var/lib/dpkg/status
     1:3.0.12+dfsg-1 500
        500 http://archive.ubuntu.com/ubuntu bionic/universe amd64 Packages
root@ubuntu-bionic:~# ls -la /usr/share/doc/zabbix-proxy-mysql/*
-rw-r--r-- 1 root root  1326 Aug 27 08:20 /usr/share/doc/zabbix-proxy-mysql/changelog.Debian.gz
-rw-r--r-- 1 root root   980 Oct  2  2017 /usr/share/doc/zabbix-proxy-mysql/copyright
-rw-r--r-- 1 root root 10674 Aug 27 08:20 /usr/share/doc/zabbix-proxy-mysql/schema.sql.gz

Not sure why, but it seems like it works there oO

Comment by dimir [ 2018 Sep 06 ]

In the last example package didn't get installed because of dependencies. Could you please try the following:

wget https://repo.zabbix.com/zabbix/3.5/ubuntu/pool/main/z/zabbix-release/zabbix-release_3.5-1+bionic_all.deb
dpkg -i zabbix-release_3.5-1+bionic_all.deb
apt update
apt -y install zabbix-proxy-mysql
dpkg -L zabbix-proxy-mysql | grep schema
ls /usr/share/doc/zabbix-proxy-mysql/
Comment by Matthias Baur [ 2018 Sep 06 ]

Yeah, sorry. Just realized that myself and updated my comment.

Comment by dimir [ 2018 Sep 06 ]

I have found the source of the problem. As I was suspecting, it's dpkg configuration. Docker image of Ubuntu Bionic from Docker Hub contains file

/etc/dpkg/dpkg.cfg.d/excludes

that excluding everything but copyright and changelog.Debian.gz files from /usr/share/doc:

# Drop all man pages
path-exclude=/usr/share/man/*

# Drop all documentation ...
path-exclude=/usr/share/doc/*

# ... except copyright files ...
path-include=/usr/share/doc/*/copyright

# ... and Debian changelogs
path-include=/usr/share/doc/*/changelog.Debian.*

The result is that schema file is listed in package contents but not installed.

This can be fixed by executing:

dpkg --path-include='/usr/share/doc/*/*' -i zabbix-proxy-mysql*.deb

Or, if using apt:

apt -o 'DPkg::Options::=--path-include=/usr/share/doc/*/*' install zabbix-proxy-mysql
Comment by Matthias Baur [ 2018 Sep 06 ]

Wow, I didn't even know that this is possible. Thanks a lot!

Comment by dimir [ 2018 Sep 07 ]

By the way, Zabbix provides docker images too:

https://github.com/zabbix/zabbix-docker/

Comment by Matthias Baur [ 2018 Sep 07 ]

Thanks, but we're using Docker in this scenario only for Puppet automation tests!

Generated at Mon Jun 02 17:04:50 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.