Cannot install mysql-workbench with mysql-server 5.6 or mariadb

Bug #1287424 reported by Rocko
108
This bug affects 23 people
Affects Status Importance Assigned to Milestone
mysql-workbench (Ubuntu)
Fix Released
High
Unassigned
Trusty
Triaged
High
Unassigned

Bug Description

mysql-workbench depends on mysql-client, which is currently at 5.5, so it won't install with mysql-server 5.6 installed:

apt-get install mysql-workbench
...
The following packages have unmet dependencies:
 mysql-workbench : Depends: mysql-client
E: Unable to correct problems, you have held broken packages.

apt-get install mysql-client:
...
The following packages have unmet dependencies:
 mysql-client : Depends: mysql-client-5.5 but it is not going to be installed
E: Unable to correct problems, you have held broken packages.

ProblemType: Bug
DistroRelease: Ubuntu 14.04
Package: mysql-workbench (not installed)
ProcVersionSignature: Ubuntu 3.13.0-14.34-generic 3.13.5
Uname: Linux 3.13.0-14-generic x86_64
ApportVersion: 2.13.2-0ubuntu5
Architecture: amd64
Date: Tue Mar 4 07:38:08 2014
InstallationDate: Installed on 2014-02-08 (23 days ago)
InstallationMedia: Ubuntu 14.04 LTS "Trusty Tahr" - Alpha amd64 (20140207)
ProcEnviron:
 LANGUAGE=en_AU:en
 TERM=xterm
 PATH=(custom, no user)
 LANG=en_AU.UTF-8
 SHELL=/bin/bash
SourcePackage: mysql-workbench
UpgradeStatus: No upgrade log present (probably fresh install)

SRU DOCUMENTATION

[IMPACT]
mysql-workbench as the default GUI cannot be installed on systems where the maintainer either opted to use mysql 5.6 or mariadb.

[TEST CASE]
Install mariadb-client and try to add mysql-workbench. Aptitude will not allow this and you will be forced to revert to mysql-client version 5.5 or abort the installation of mysql-workbench.

[REGRESSION POTENTIAL]
There is some potential for regression here since we are dropping a depends to a recommends.

Debian upstream did this exact change in version 6.2.3+dfsg-7 of the package so it seems unlikely this would be improper. Nonetheless, there should be some testing done to verify there is no obvious breakage by running the GUI.

I tried to do some code inspection but grepping for mysql (the command that would be called) was too generic to be useful.

Revision history for this message
Hans Joachim Desserud (hjd) wrote :

Thanks for taking your time to repor this issue and help making Ubuntu better.

I was able to reproduce this issue by first installing mysql-server-5.6 and then attempting to install mysql-workbench.

tags: added: unmet-deps
Revision history for this message
Launchpad Janitor (janitor) wrote :

Status changed to 'Confirmed' because the bug affects multiple users.

Changed in mysql-workbench (Ubuntu):
status: New → Confirmed
Revision history for this message
Alberto Salvia Novella (es20490446e) wrote :

It prevents the package (or a dependent one) from functioning correctly at all.

Changed in mysql-workbench (Ubuntu):
importance: Undecided → High
Revision history for this message
Michal Zubkowicz (michalzubkowicz) wrote :

Same problem with mariadb installed:
The following packages have unmet dependencies:
 mysql-workbench : Depends: mysql-client

Revision history for this message
Michal Zubkowicz (michalzubkowicz) wrote :

This problem is really important. Now i have workaround by removing mysql-workbench from package list (don't try this at home ;))) . There is any way i can help ?

Revision history for this message
Ryan Hansen (ketiko) wrote :

Same issue here.

Revision history for this message
Sushant kumar (sushantp606) wrote :

I have installed MariaDb and then tried to install mysql-workbench from both Ubuntu-software center and via Terminal -
1.Ubuntu-Software_center prompt the following error-
    This error could be caused by required additional software packages which are missing or not installable. Furthermore there could be a conflict between software packages which are not allowed to be installed at the same time.
     mysql-workbench: Depends: libgcc1 (>= 1:4.1.1) but 1:4.9-20140406-0ubuntu1 is to be installed
                 Depends: libgtkmm-2.4-1c2a (>= 1:2.24.0) but 1:2.24.4-1ubuntu1 is to be installed
                 Depends: libpcrecpp0 (>= 7.7) but 1:8.31-2ubuntu2 is to be installed
                 Depends: python:any (>= 2.7.1-0ubuntu2) but it is a virtual package
                 Depends: mysql-workbench-data (= 6.0.8+dfsg-2) but 6.0.8+dfsg-2 is to be installed
2.Via Terminal it said -
    The following packages have unmet dependencies:
        mysql-workbench : Depends: mysql-client
        E: Unable to correct problems, you have held broken packages.

 Is there any workArround for installing it?

Revision history for this message
pierophp (pierophp) wrote :

A temporary solution:

Unpack mysql-workbench-community-6.1.4-1ubu1310-amd64.deb in a folder.

Change the file "DEBIAN/control", replace "mysql-client" to "mysql-client-5.6".

Go to the terminal and make a new ".deb":

dpkg -b mysql-workbench-community-6.1.4-1ubu1310-amd64/

Done! Now you can install from the new deb file.

Revision history for this message
Michal Zubkowicz (michalzubkowicz) wrote :

Little script for workaround from SO (copyright for user276521):
sudo apt-get remove mysql-workbench mysql-workbench-data
dpkg-deb -x mysql-workbench-community-6.*.deb tmp_mysql-workbench
dpkg-deb --control mysql-workbench-community-6.*.deb tmp_mysql-workbench/DEBIAN
sed -i -e 's/mysql-client, //' tmp_mysql-workbench/DEBIAN/control
dpkg -b tmp_mysql-workbench mysql-workbench-community_patched.deb
sudo dpkg -i mysql-workbench-community_patched.deb

Revision history for this message
Rocko (rockorequin) wrote :

Thanks for the workaround, it works well.

I guess then the generic fix for this bug so it works with either mysql 5.5 or mysql 5.6 would be to replace "mysql-client" with "mysql-client-5.5 | mysql-client-5.6" in DEBIAN/control.

Revision history for this message
André Verwijs (dutchgigalo) wrote :

SYSTEM:

OS: LinuxMint 17 (qiana) (Trusty based)
Gnome: 3.8.4 (Ubuntu 2014-03-17)
kernel: 3.13.0-24-generic (#47-Ubuntu SMP Fri May 2 23:30:00 UTC 2014)
GCC version: 4.8 (x86_64-linux-gnu)
Xorg: 1.15.1 (16 April 2014 01:36:29PM)
Graphics: NVIDIA UNIX x86_64 Kernel Module 337.25 Tue May 27 11:05:28 PDT 2014
-----------------------------------------------------------------------------

if you download Workbench ( 6.1.7-1ubu1404 ) from official Mysql website ( http://dev.mysql.com/downloads/workbench/ )
and install, there's no problem...

Screenshot 1:
https://copy.com/o9dsUpuTel9c

Screenshot 2:
https://copy.com/CFYidlHpXeJ0

Revision history for this message
Rocko (rockorequin) wrote :

mysql-workbench 6.1.7-1ubu1404 from the official mysql site is the the one that I had to change DEBIAN/control to replace "mysql-client" with "mysql-client-5.5 | mysql-client-5.6". It wouldn't install in my Ubuntu otherwise because it depends on mysql-client, which is removed when you uninstall mysql-client-5.5. After I rebuilt it and changed the dependencies, it installed fine.

Revision history for this message
Tj (kilrain) wrote :

Downloading from official mysql website worked for me as well. They obviously fixed it.

Rolf Leggewie (r0lf)
summary: - Cannot install mysql-workbench with mysql-server 5.6
+ Cannot install mysql-workbench with mysql-server 5.6 or mariadb
Changed in mysql-workbench (Ubuntu):
assignee: nobody → Rolf Leggewie (r0lf)
Revision history for this message
Rolf Leggewie (r0lf) wrote :

mysql-client up to utopic depends on version 5.5. Vivid and beyond already depend on 5.6 and thus be only affected if mariadb is installed instead of mysql. This ticket can either be fixed by relaxing the dependencies in mysql-workbench or having mariadb and other packages provide mysql-client. Of course, both of these fixes can be done at the same time as well for the most robust solution.

Revision history for this message
Rolf Leggewie (r0lf) wrote :

mysql-5.6 in vivid and later is not affected. Closing the task as fixed. It would be nice to see a backported fix for trusty to the 0ubuntuX type package here.

Changed in mysql-5.6 (Ubuntu):
status: New → Fix Released
Revision history for this message
Rolf Leggewie (r0lf) wrote :

Actually, this whole problem has been fixed in Debian unstable about 1 year ago.

mysql-workbench (6.2.3+dfsg-7) unstable; urgency=low

  * Demoted "virtual-mysql-client" to Recommends; added "mysql-client"
    as first alternative: "mysql-client | virtual-mysql-client".

 -- Dmitry Smirnov <email address hidden> Sun, 02 Nov 2014 08:07:54 +1100

This problem is fixed in vivid and beyond. We should backport a fix to trusty.

no longer affects: mariadb-10.0 (Ubuntu)
Changed in mysql-workbench (Ubuntu):
status: Confirmed → Fix Released
Revision history for this message
Rolf Leggewie (r0lf) wrote :
tags: added: patch
Rolf Leggewie (r0lf)
description: updated
Revision history for this message
Rolf Leggewie (r0lf) wrote :

I can say that the compilation was successful and the program runs fine here. I did not spot any issues so far. I do have mariadb-client installed, though.

Revision history for this message
Rolf Leggewie (r0lf) wrote :
Rolf Leggewie (r0lf)
no longer affects: mysql-5.6 (Ubuntu)
Rolf Leggewie (r0lf)
Changed in mysql-workbench (Ubuntu):
assignee: Rolf Leggewie (r0lf) → nobody
Changed in mysql-workbench (Ubuntu Trusty):
importance: Undecided → High
status: New → Triaged
Revision history for this message
Rolf Leggewie (r0lf) wrote :

ping Ubuntu SRU team

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Duplicates of this bug

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.