Bug#777720: cqrlog: Not installable unless mysql-client-5.5 is installed manually in advance
Package: cqrlog
Version: 1.8.2-1
Severity: normal
Hello!
Attempts to install cqrlog on newly installed systems fail unless the
dependency mysql-client-5.5 is installed manually:
====================================================================
root@z6:~> apt-get install cqrlog
Reading package lists... Done
Building dependency tree
Reading state information... Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:
The following packages have unmet dependencies:
cqrlog : Depends: mysql-client
Recommends: mariadb-server but it is not going to be installed or
mysql-server but it is not going to be installed
root@z6:~> apt-get install mysql-client-5.5
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following extra packages will be installed:
libdbd-mysql-perl libdbi-perl
Suggested packages:
libmldbm-perl libnet-daemon-perl libsql-statement-perl
The following NEW packages will be installed:
libdbd-mysql-perl libdbi-perl mysql-client-5.5
0 upgraded, 3 newly installed, 0 to remove and 1 not upgraded.
Need to get 2,751 kB of archives.
After this operation, 41.7 MB of additional disk space will be used.
Do you want to continue? [Y/n]
Get:1 http://ftp.debian.org/debian/ unstable/main libdbi-perl amd64 1.631-3+b1 [816 kB]
Get:2 http://ftp.debian.org/debian/ unstable/main libdbd-mysql-perl amd64 4.028-2+b1 [119 kB]
Get:3 http://ftp.debian.org/debian/ unstable/main mysql-client-5.5 amd64 5.5.42-1 [1,815 kB]
Fetched 2,751 kB in 0s (4,594 kB/s)
Selecting previously unselected package libdbi-perl.
(Reading database ... 432854 files and directories currently installed.)
Preparing to unpack .../libdbi-perl_1.631-3+b1_amd64.deb ...
Unpacking libdbi-perl (1.631-3+b1) ...
Selecting previously unselected package libdbd-mysql-perl.
Preparing to unpack .../libdbd-mysql-perl_4.028-2+b1_amd64.deb ...
Unpacking libdbd-mysql-perl (4.028-2+b1) ...
Selecting previously unselected package mysql-client-5.5.
Preparing to unpack .../mysql-client-5.5_5.5.42-1_amd64.deb ...
Unpacking mysql-client-5.5 (5.5.42-1) ...
Processing triggers for man-db (2.7.0.2-5) ...
Setting up libdbi-perl (1.631-3+b1) ...
Setting up libdbd-mysql-perl (4.028-2+b1) ...
Setting up mysql-client-5.5 (5.5.42-1) ...
root@z6:~> apt-get install cqrlog
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following extra packages will be installed:
libhamlib-utils libhamlib2 libssl-dev libssl-doc
Recommended packages:
mariadb-server mysql-server
The following NEW packages will be installed:
cqrlog libhamlib-utils libhamlib2 libssl-dev libssl-doc
0 upgraded, 5 newly installed, 0 to remove and 1 not upgraded.
Need to get 10.7 MB of archives.
After this operation, 39.6 MB of additional disk space will be used.
Do you want to continue? [Y/n]
Get:1 http://ftp.debian.org/debian/ unstable/main libhamlib2 amd64 1.2.15.3-2+b1 [398 kB]
Get:2 http://ftp.debian.org/debian/ unstable/main libhamlib-utils amd64 1.2.15.3-2+b1 [119 kB]
Get:3 http://ftp.debian.org/debian/ unstable/main libssl-dev amd64 1.0.1k-1 [1,271 kB]
Get:4 http://ftp.debian.org/debian/ unstable/main libssl-doc all 1.0.1k-1 [1,138 kB]
Get:5 http://ftp.debian.org/debian/ unstable/main cqrlog amd64 1.8.2-1 [7,728 kB]
Fetched 10.7 MB in 1s (6,219 kB/s)
Selecting previously unselected package libhamlib2.
(Reading database ... 433094 files and directories currently installed.)
Preparing to unpack .../libhamlib2_1.2.15.3-2+b1_amd64.deb ...
Unpacking libhamlib2 (1.2.15.3-2+b1) ...
Selecting previously unselected package libhamlib-utils.
Preparing to unpack .../libhamlib-utils_1.2.15.3-2+b1_amd64.deb ...
Unpacking libhamlib-utils (1.2.15.3-2+b1) ...
Selecting previously unselected package libssl-dev:amd64.
Preparing to unpack .../libssl-dev_1.0.1k-1_amd64.deb ...
Unpacking libssl-dev:amd64 (1.0.1k-1) ...
Selecting previously unselected package libssl-doc.
Preparing to unpack .../libssl-doc_1.0.1k-1_all.deb ...
Unpacking libssl-doc (1.0.1k-1) ...
Selecting previously unselected package cqrlog.
Preparing to unpack .../cqrlog_1.8.2-1_amd64.deb ...
Unpacking cqrlog (1.8.2-1) ...
Processing triggers for man-db (2.7.0.2-5) ...
Processing triggers for mime-support (3.58) ...
Processing triggers for gnome-menus (3.13.3-5) ...
Processing triggers for desktop-file-utils (0.22-1) ...
Setting up libhamlib2 (1.2.15.3-2+b1) ...
Setting up libhamlib-utils (1.2.15.3-2+b1) ...
Setting up libssl-dev:amd64 (1.0.1k-1) ...
Setting up libssl-doc (1.0.1k-1) ...
Setting up cqrlog (1.8.2-1) ...
Processing triggers for libc-bin (2.19-15) ...
root@z6:~>
====================================================================
Trying to install cqrlog with aptitude gives a more verbose answer:
root@z6:~> aptitude install cqrlog
The following NEW packages will be installed:
cqrlog libdbd-mysql-perl{a} libmysqlclient18{a}
mariadb-client-10.0{ab} mariadb-client-core-10.0{ab}
mariadb-common{a} mariadb-server{a} mariadb-server-10.0{ab}
mariadb-server-core-10.0{a} mysql-client{a} mysql-client-5.5{ab}
mysql-common{a}
0 packages upgraded, 12 newly installed, 0 to remove and 1 not
upgraded.
Need to get 11.7 MB/22.1 MB of archives. After unpacking 197 MB will
be used.
The following packages have unmet dependencies:
mariadb-client-core-10.0 : Conflicts: mysql-client-5.5 but 5.5.42-1
is to be installed.
Breaks: virtual-mysql-client-core which is
a virtual package.
mysql-client-5.5 : Breaks: virtual-mysql-client which is a virtual
package.
Breaks: virtual-mysql-client-core which is a
virtual package.
mariadb-client-10.0 : Breaks: mysql-client but 5.5.42-1 is to be
installed.
Breaks: mysql-client-5.5 but 5.5.42-1 is to be
installed.
Breaks: virtual-mysql-client which is a virtual
package.
mariadb-server-10.0 : Breaks: mysql-client-5.5 but 5.5.42-1 is to be
installed.
The following actions will resolve these dependencies:
Keep the following packages at their current version:
1) mariadb-client-10.0 [Not Installed]
2) mariadb-client-core-10.0 [Not Installed]
3) mariadb-server [Not Installed]
4) mariadb-server-10.0 [Not Installed]
Leave the following dependencies unresolved:
5) cqrlog recommends mariadb-server | mysql-server
Accept this solution? [Y/n/q/?]
Abandoning all efforts to resolve these dependencies.
Abort.
root@z6:~>
====================================================================
It's clear what happens now: aptitude/apt try to install
mariadb-server because it's a recommended package and it prefers
mariadb over mysql server since the ordering of these both packages in
debian/control is: "Recommends: mariadb-server | mysql-server" [1].
On the other hand, cqrlog depends on mysql-client which depends on
mysql-client-5.5 which breaks mariadb-client-10.0, a dependency of
mariadb-server-10.0.
Thus, in order to fix this, it should be enough to switch the order
of mariadb-server and mysql-server in the Recommends field in
debian/control such that the first package apt chooses to install
via the Recommends is mysql-server.
Cheers,
Adrian
> [1] https://tracker.debian.org/media/packages/c/cqrlog/control-1.8.2-1
Reply to: