MySQL Bugs: #56759: MySQL Workbench Debian/Ubuntu dependencies.

Bug #56759	MySQL Workbench Debian/Ubuntu dependencies.
Submitted:	13 Sep 2010 20:27	Modified:	21 Sep 2010 6:52
Reporter:	Anthony Wlodarski	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Workbench	Severity:	S2 (Serious)
Version:	5.2.27	OS:	Linux (Ubuntu 10.04 LTS x86_64)
Assigned to:		CPU Architecture:	Any
Tags:	database driver, libmysqlcppconn4, MySQL Workbench

Description:
On a fresh copy of Ubuntu MySQL Workbench gives the following error: "Failed to Connect to MySQL at 127.0.0.1:3306 with user root Database driver: Failed to open library '/usr/lib/mysql-workbench/mysqlcppconn.so'. Check settings."

The package (libmysqlcppconn4) that includes this file is not always installed on Debian/Ubuntu by by default.  Please see the suggested patch file to remedy the issue.

How to repeat:
If you would wish to repeat this bug install MySQL Workbench on any fresh install of Ubuntu this is 100% repeatable.  Additionally this path can be replicated with either using "tasksel" or installing via the Ubuntu Software Center.  Tasksel only installs the meta packages which includes the files to install, for example if you choose "LAMP Server".

Suggested fix:
*** control	2010-08-30 13:56:43.000000000 -0400
--- control.20100913.anthony@dating2p0.com	2010-09-13 16:20:57.654064457 -0400
***************
*** 2,8 ****
  Section: utils
  Priority: extra
  Maintainer: MySQL Workbench team <workbench@sun.com>
! Build-Depends: debhelper (>= 5), autoconf, automake, libtool, libzip-dev, libgtkmm-2.4-dev, libxml2-dev, libglade2-dev, libgnome2-dev, libmysqlclient16-dev, uuid-dev, libgl1-mesa-dev, libpcre3-dev, liblua5.1-0-dev, python-dev, python-pexpect, libgnome-keyring-dev, libsqlite3-dev, libboost-dev
  Standards-Version: 3.7.2
  Homepage: http://dev.mysql.com/workbench/
  
--- 2,8 ----
  Section: utils
  Priority: extra
  Maintainer: MySQL Workbench team <workbench@sun.com>
! Build-Depends: debhelper (>= 5), autoconf, automake, libtool, libzip-dev, libgtkmm-2.4-dev, libxml2-dev, libglade2-dev, libgnome2-dev, libmysqlclient16-dev, uuid-dev, libgl1-mesa-dev, libpcre3-dev, liblua5.1-0-dev, python-dev, python-pexpect, libgnome-keyring-dev, libsqlite3-dev, libboost-dev, libmysqlcppconn4
  Standards-Version: 3.7.2
  Homepage: http://dev.mysql.com/workbench/

How did you install Workbench? The library you mention is bundled with Workbench in our packages.

Via: http://dev.mysql.com/downloads/mirror.php?id=393652

Hello Anthony,

what exact package did you use to install WB on your system? did you use one of our pre-compiled .deb packages or a source-pkg and built it yourself?
thanks in advance

The package I used is a file from your website: mysql-workbench-gpl-5.2.27-1ubu1004-amd64.deb

This is the output from the terminal in regards to package information:
anthony@anthony-desktop:~/Downloads$ dpkg -I mysql-workbench-gpl-5.2.27-1ubu1004-amd64.deb 
 new debian package, version 2.0.
 size 43238024 bytes: control archive= 20922 bytes.
    1432 bytes,    17 lines      control              
   65039 bytes,   713 lines      md5sums              
 Package: mysql-workbench-gpl
 Source: mysql-workbench
 Version: 5.2.27-1ubu1004
 Architecture: amd64
 Maintainer: MySQL Workbench team <workbench@sun.com>
 Installed-Size: 171932
 Depends: libatk1.0-0 (>= 1.29.3), libbonobo2-0 (>= 2.15.0), libc6 (>= 2.4), libcairo2 (>= 1.7.2), libcairomm-1.0-1 (>= 1.6.4), libctemplate0, libfontconfig1 (>= 2.8.0), libfreetype6 (>= 2.2.1), libgcc1 (>= 1:4.1.1), libgl1-mesa-glx | libgl1, libglade2-0 (>= 1:2.6.1), libglib2.0-0 (>= 2.16.0), libglibmm-2.4-1c2a (>= 2.24.0), libgnome-keyring0 (>= 2.22.2), libgnome2-0 (>= 2.17.3), libgtk2.0-0 (>= 2.8.0), libgtkmm-2.4-1c2a (>= 1:2.20.0), liblua5.1-0, libmysqlclient16 (>= 5.1.21-1), liborbit2 (>= 1:2.14.10), libpango1.0-0 (>= 1.18.0), libpangomm-1.4-1 (>= 2.26.0), libpcre3 (>= 7.7), libpopt0 (>= 1.15), libpython2.6 (>= 2.6), libsigc++-2.0-0c2a (>= 2.0.2), libsqlite3-0 (>= 3.6.22), libstdc++6 (>= 4.4.0), libuuid1 (>= 2.16), libx11-6 (>= 0), libxml2 (>= 2.7.4), libzip1 (>= 0.9), zlib1g (>= 1:1.1.4), python-paramiko, python-pexpect, mysql-client, python-pysqlite2
 Suggests: gnome-keyring
 Replaces: mysql-workbench-oss
 Section: utils
 Priority: extra
 Homepage: http://dev.mysql.com/workbench/
 Description: MySQL Workbench
  MySQL Workbench is a modeling tool that allows you to design
  and generate MySQL databases graphically. It also has administration
  and query development modules where you can manage MySQL server instances
  and execute SQL queries.

Please, check if the same problem happens with a newer version, 5.2.28.

I have recently installed version 5.2.28 and this seems to alleviate the issue.  To remove the old package as well as libmysqlcppconn4 I used synaptics and select a "Complete Removal".  I also executed "sudo apt-get autoremove" from the terminal to make sure no files were left lingering.  I double clicked on the deb file and everything installed correctly.  When I went to forward engineer the database I was not met with any errors this time.

If there is any other information I can gather for you please let me know.

Not repeatable with 5.2.28 any more, in the clean environment at least.

hi i got the same thing now 
i had installed mysql-workbench-gpl-5.2.31a-2ubu1004-i386.deb

from
http://www.mysql.com/downloads/workbench/#downloads

i am getting same error

Failed to Connect to MySQL at localhost:3306 with user root
Lost connection to MySQL server at 'reading initial communication packet', system error: 111
and after this system hungs