MySQL Bugs: #94047: Cannot install mysql-utilities on Ubuntu 14.04

Bug #94047	Cannot install mysql-utilities on Ubuntu 14.04
Submitted:	24 Jan 2019 19:42	Modified:	11 Apr 2019 19:51
Reporter:	Nathan Walters	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Package Repos	Severity:	S3 (Non-critical)
Version:		OS:	Ubuntu (Trusty (14.04))
Assigned to:	Lars Tangvald	CPU Architecture:	Any
Tags:	apt, PACKAGE, ubuntu

Description:
I have a CI operation that relies on installing mysql-server and mysql-utilities on Ubuntu 14.04. I use the MySQL APT repository (https://dev.mysql.com/downloads/repo/apt/) to do this. A few days ago, our builds started failing. As near as I can tell, mysql-connector-python is no longer published or available via the APT repository. This is reproducible via the latest version of the APT repository.

Here is the command that is being run and the resulting output:

$ sudo apt-get install mysql-server mysql-utilities
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:
mysql-utilities : Depends: mysql-connector-python (>= 2.0.0) but it is not installable or
mysql-connector-python-commercial (>= 2.0.0) but it is not installable
E: Unable to correct problems, you have held broken packages.
The command "sudo apt-get install mysql-server mysql-utilities" failed and exited with 100 during .

How to repeat:
This is reproducible on a standard Ubuntu 14.04 Trusty Docker image. Here are the steps to reproduce:

1. Run `docker run --rm -it ubuntu:trusty` to start an Ubuntu Docker container with a shell
2. We need to install `wget` to download the MySQL APT repository. Run `apt-get update` and then `apt-get install -y wget`.
3. Download the latest version of the APT repository: `wget https://dev.mysql.com/get/mysql-apt-config_0.8.12-1_all.deb`
4. Install the repository: `sudo dpkg -i mysql-apt-config_0.8.12-1_all.deb`. Accept all defaults when installing.
5. Update apt again: `sudo apt-get update`
6. Attempt to install MySQL packages: `apt-get install mysql-server mysql-utilities`
7. Observe the following output:

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:
mysql-utilities : Depends: mysql-connector-python (>= 2.0.0) but it is not installable or
mysql-connector-python-commercial (>= 2.0.0) but it is not installable
E: Unable to correct problems, you have held broken packages.

Hi,

The apt repos only supply the newest version of connector-python. This is 8.0, which does not support Ubuntu 14.04

As workarounds you can either download 2.0.5 for 14.04 from https://dev.mysql.com/downloads/connector/python/ (click "Looking for previous GA versions?", then select 2.0.5 from the version dropdown),
or direct-download the 2.1.7 file from http://repo.mysql.com/apt/ubuntu/pool/mysql-tools/m/mysql-connector-python/mysql-connector...

Installing either of these with dpkg -i should satisfy the dependency for mysql-utilities.
Hope this helps!

Please try the workaround commented by Lars and comment here the results. Thanks.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".