[ZBX-7984] Add dependency on 'virtual-mysql-client' for Debain packages. Created: 2014 Mar 25  Updated: 2017 May 30  Resolved: 2014 Apr 08

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

Type: Incident report Priority: Trivial
Reporter: Timur Bakeyev Assignee: Kodai Terashima
Resolution: Fixed Votes: 2
Labels: debian, packaging
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

LSB Version: core-2.0-amd64:core-2.0-noarch:core-3.0-amd64:core-3.0-noarch:core-3.1-amd64:core-3.1-noarch:core-3.2-amd64:core-3.2-noarch:core-4.0-amd64:core-4.0-noarch:core-4.1-amd64:core-4.1-noarch:security-4.0-amd64:security-4.0-noarch:security-4.1-amd64:security-4.1-noarch
Distributor ID: Debian
Description: Debian GNU/Linux 7.4 (wheezy)
Release: 7.4
Codename: wheezy

Linux monitor.ad-lab.nl 3.10-0.bpo.3-amd64 #1 SMP Debian 3.10.11-1~bpo70+1 (2013-09-24) x86_64 GNU/Linux


 Description   

I got a conflict of the packages, when 'zabbix-server-mysql' and 'percona-server-56' trying to remove each other during the package upgrade. It was a bit difficult to track down, but the outcome is:

Official zabbix server:

Package: zabbix-server-mysql
Source: zabbix
Version: 1:2.2.2-1+wheezy
Architecture: amd64
Maintainer: Kodai Terashima <[email protected]>
Installed-Size: 7599
Pre-Depends: debconf
Depends: libc6 (>= 2.7), libcurl3-gnutls (>= 7.16.2), libiksemel3, libldap-2.4-2 (>= 2.4.7), libmysqlclient18 (>= 5.5.24+dfsg-1), libodbc1 (>= 2.2.11) | unixodbc (>= 2.2.11), libopenipmi0, libsnmp15 (>= 5.4.3~dfsg), libssh2-1 (>= 1.0), libssl1.0.0 (>= 1.0.0), libxml2 (>= 2.7.4), debconf (>= 0.5) | debconf-2.0, mysql-client | mariadb-client, fping, adduser, dbconfig-common (>= 1.8.19), lsb-base
Recommends: mysql-server (>= 4.0.16-2), snmpd, snmptt
Suggests: zabbix-frontend-php, logrotate
Conflicts: zabbix-proxy-mysql, zabbix-proxy-pgsql, zabbix-proxy-sqlite3, zabbix-server-pgsql

DotDeb zabbix server:

Package: zabbix-server-mysql
Source: zabbix
Version: 1:2.2.2-1~dotdeb.1
Architecture: amd64
Maintainer: Guillaume Plessis <[email protected]>
Installed-Size: 2935
Depends: libc6 (>= 2.7), libcurl3-gnutls (>= 7.16.2), libiksemel3, libldap-2.4-2 (>= 2.4.7), libmysqlclient18 (>= 5.5.24+dfsg-1), libodbc1 (>= 2.2.11) | unixodbc (>= 2.2.11), libopenipmi0, libsnmp15 (>= 5.4.3~dfsg), libssh2-1 (>= 1.0), libxml2 (>= 2.7.4), ucf, fping, adduser, lsb-base
Recommends: mysql-server, snmpd
Suggests: zabbix-frontend-php, logrotate
Conflicts: zabbix-proxy-mysql, zabbix-proxy-pgsql, zabbix-proxy-sqlite3, zabbix-server-pgsql, zabbix-server-sqlite3

Debian zabbix server:

Package: zabbix-server-mysql
Source: zabbix
Version: 1:2.0.9+dfsg-1~bpo70+2
Installed-Size: 2565
Maintainer: Christoph Haas <[email protected]>
Architecture: amd64
Depends: libc6 (>= 2.7), libcurl3-gnutls (>= 7.16.2), libiksemel3, libldap-2.4-2 (>= 2.4.7), libmysqlclient18 (>= 5.5.24+dfsg-1), libodbc1 (>= 2.2.11) | unixodbc (>= 2.2.11), libopenipmi0, libsnmp15 (>= 5.4.3~dfsg), libssh2-1 (>= 1.0), ucf, fping, adduser, lsb-base
Recommends: mysql-server, snmpd
Suggests: zabbix-frontend-php, logrotate
Conflicts: zabbix-proxy-mysql, zabbix-proxy-pgsql, zabbix-proxy-sqlite3, zabbix-server-pgsql, zabbix-server-sqlite3

The notable difference is that official zabbix server package put hard dependency on 'mysql-client | mariadb-client', where other packages merely rely on libmysqlclient18 (>= 5.5.24+dfsg-1) dependency.

That's not a problem by itself, but one of the mySQL-compatible replacements, Percona-server-5.6 provides nysql in the following way:

Package: percona-server-client-5.6
Source: percona-server-5.6
Version: 5.6.16-64.1-563.wheezy
Architecture: amd64
Maintainer: Percona Server Development Team <[email protected]>
Installed-Size: 38104
Depends: debianutils (>= 1.6), libdbi-perl, percona-server-common-5.6 (>= 5.6.16-64.1-563.wheezy), libperconaserverclient18.1 (>= 5.6.16-64.1-563.wheezy), libc6 (>= 2.11), libgcc1 (>= 1:4.1.1), libncurses5 (>= 5.5-5~), libssl1.0.0 (>= 1.0.0), libstdc++6 (>= 4.1.1), libtinfo5, zlib1g (>= 1:1.1.4)
Breaks: mariadb-client, mariadb-client-5.5, mariadb-client-core-5.5, mysql-client-5.0, mysql-client-5.1, mysql-client-5.5, mysql-client-5.6, mysql-client-core-5.1, percona-server-client-5.1, percona-server-client-5.5, percona-xtradb-client-5.0
Replaces: mariadb-client, mariadb-client-5.5, mariadb-client-core-5.5, mysql-client-5.0, mysql-client-5.1, mysql-client-5.5, mysql-client-5.6, mysql-client-core-5.1, percona-server-client-5.1, percona-server-client-5.5, percona-xtradb-client-5.0
Provides: virtual-mysql-client

Seems, both variants are used now in Debian packages, so, for example, Redmine requires:

Depends: libmysql-ruby, mysql-client | virtual-mysql-client

Can you, please, do the same, and require:

Depends: mysql-client | virtual-mysql-client | mariadb-client

 Comments   
Comment by Raymond Kuiper [ 2014 Mar 25 ]

Also running into these issues using both the official Percona and Zabbix repos.

Did you figure out a workaround for this issue?

Comment by Timur Bakeyev [ 2014 Mar 25 ]

I raised similar ticket with Percona and postponed the upgrade of mySQL server...

Comment by Timur Bakeyev [ 2014 Mar 25 ]

Also, as an intermediate solution it's possible to create empty 'virtual-mysql-client' package with 'equivs'. Actually, I think that what I did last time.

Comment by Geoffroi Genot [ 2014 Mar 31 ]

Also had the issues. I made a workaround by simply editing the package :

mkdir zabbix_pkg_src
mkdir zabbix_pkg_src/DEBIAN
dpkg-deb -x zabbix-server-mysql_2.2.2-1+wheezy_amd64.deb zabbix_pkg_src/
dpkg-deb --control zabbix-server-mysql_2.2.2-1+wheezy_amd64.deb zabbix_pkg_src/DEBIAN/
sed -i "s/mysql-client/mysql-client | virtual-mysql-client/" zabbix_pkg_src/DEBIAN/control
dpkg-deb -b zabbix_pkg_src/ zabbix-server-mysql_2.2.2-2+wheezy_amd64.deb
dpkg -i zabbix-server-mysql_2.2.2-2+wheezy_amd64.deb
rm -rf zabbix_pkg_src

Comment by Timur Bakeyev [ 2014 Apr 01 ]

Sure it's possible to repackage, thanks for src. But it would be really nice, if this change hit the 2.2.3 release. PLEASE!

Comment by Kodai Terashima [ 2014 Apr 08 ]

Thanks for the suggestion. Added virtual-mysql-client dependency for server-mysql and server-proxy packages.

Comment by Raymond Kuiper [ 2014 Apr 08 ]

Hi Kodai, will this be updated for the 2.2.3 packages?

Comment by Kodai Terashima [ 2014 Apr 08 ]

Hi Raymond,

I forgot to add "Fix Version/s". Yes, it will be included in 2.2.3 packages. 2.2.3 packages will be available soon.

Comment by Sergey Solozhentsev [ 2014 Nov 06 ]

this issue is not fixed event for 2.4. When I want to install zabbix 2.4 on server with percona 5.6 apt-get want to remove percona-server-5.6

log
root@c-a060-u2457-80:/home/bond# apt-get install zabbix-server-mysql zabbix-frontend-php
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following extra packages will be installed:
dbconfig-common fontconfig-config fonts-dejavu-core fping
libconfig-inifiles-perl libfontconfig1 libgd3 libhtml-template-perl
libiksemel3 libjbig0 libjpeg-turbo8 libjpeg8 libltdl7 libodbc1 libopenipmi0
libperl5.18 libsensors4 libsnmp-base libsnmp-perl libsnmp30 libssh2-1
libterm-readkey-perl libtiff5 libvpx1 libxpm4 mysql-client-5.5
mysql-client-core-5.5 mysql-server mysql-server-5.5 mysql-server-core-5.5
php5-gd php5-mysql snmpd snmptt ttf-dejavu-core
Suggested packages:
libgd-tools libipc-sharedcache-perl libmyodbc odbc-postgresql tdsodbc
unixodbc-bin lm-sensors snmp-mibs-downloader tinyca mailx
The following packages will be REMOVED:
percona-server-client-5.6 percona-server-server-5.6
The following NEW packages will be installed:
dbconfig-common fontconfig-config fonts-dejavu-core fping
libconfig-inifiles-perl libfontconfig1 libgd3 libhtml-template-perl
libiksemel3 libjbig0 libjpeg-turbo8 libjpeg8 libltdl7 libodbc1 libopenipmi0
libperl5.18 libsensors4 libsnmp-base libsnmp-perl libsnmp30 libssh2-1
libterm-readkey-perl libtiff5 libvpx1 libxpm4 mysql-client-5.5
mysql-client-core-5.5 mysql-server mysql-server-5.5 mysql-server-core-5.5
php5-gd php5-mysql snmpd snmptt ttf-dejavu-core zabbix-frontend-php
zabbix-server-mysql
0 upgraded, 37 newly installed, 2 to remove and 3 not upgraded.
Need to get 16.6 MB of archives.
After this operation, 10.4 MB of additional disk space will be used.

Generated at Thu May 29 11:12:01 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.