MySQL Bugs: #47238: Can't add a DB connection - couldn't load library libmysqlclient

Bug #47238	Can't add a DB connection - couldn't load library libmysqlclient_r.so
Submitted:	10 Sep 2009 8:37	Modified:	12 Nov 2009 10:29
Reporter:	Simone Marchioni	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S2 (Serious)
Version:	5.1.18	OS:	Linux (Fedora 11, Ubuntu)
Assigned to:		CPU Architecture:	Any
Tags:	libmysqlclient_r.so connection "fedora 11", regression

Description:
Downloaded and installed mysql-workbench-oss-5.1.18-1fc11.i386.rpm from mysql download website.
It installed well (all dependencies automatically installed) and the application works (it starts correctly and works).

When I try to add a DB connection it gives me the message:

Test connect failed
Couldn't load library libmysqlclient_r.so: libmysqlclient_r.so: cannot open shared object file: No such file or directory

But mysql client libraries are installed:

cd /usr/lib/mysql/
ls -l
libmysqlclient_r.so.16      libmysqlclient.so.16      libndbclient.so.3      mysqlbug      plugin
libmysqlclient_r.so.16.0.0  libmysqlclient.so.16.0.0  libndbclient.so.3.0.0  mysql_config

Tried to create a symlink called libmysqlclient_r.so to libmysqlclient_r.so.16 but it didn't worked out.

How to repeat:
Click on Database\Manage Connections
Click on the "New" button
Try to configure a connection with both connection methods (Standard TCP/IP or Local Socket - it gives the same error)
Click on the "Test Connection" button

After the display of the error message the application freezes and i have to kill it.

Suggested fix:
Check the path and/or name of the correct libraries

Bug #47240 was marked as a duplicate of this one.

Verified just as described. Also - on Ubuntu 8.04 with .deb package. Regression bug.

theres a workaround to fix the problem mentioned in Bug #47240

What is this workaround?

I fixed this in following way in Ubuntu 9.04 (Just created a symlink in /usr/lib directory)

cd /usr/lib
sudo ln -s libmysqlclient_r.so.15 libmysqlclient_r.so

<i>
[23 Sep 10:06] Ignat Alexeyenko

I fixed this in following way in Ubuntu 9.04 (Just created a symlink in /usr/lib
directory)

cd /usr/lib
sudo ln -s libmysqlclient_r.so.15 libmysqlclient_r.so
</i>
Perfect ! Thanks Ignat.
PS: Why don't mysql team include this fix in the original packets  ????

Hi all,

Happened to me on Fedora 11 (x64) on Workbench ver 5.1.18, my solution was to put the following softlink in /usr/lib64/mysql-workbench:

libmysqlclient_r.so -> /usr/lib64/mysql/libmysqlclient_r.so.16.0.0

This took care of the problem..

Thx,
D.

this problem has been fixed. linking of connector lib has been changed.
fix will be included in 5.2.7

An entry has been added to the 5.2.7 changelog:

When an attempt was made to add a database connection the following error was generated:

Test connect failed
Couldn't load library libmysqlclient_r.so: libmysqlclient_r.so: cannot open shared object
file: No such file or directory

This only happened on Linux.

Tengo Linux Mint 8 (helena). salia el mismo valor q ustedes y lo solucione leyendo este foro. Es el siguiente sentencia :
sudo ln -s libmysqlclient_r.so.15 libmysqlclient_r.so

Gracias Totales

Can confirm this still exists in v5.1.18. I don't understand why though, as it links against the correct MySQL library, yet calls another one.

$ uname -s -r -v -m
Linux 2.6.31-16-generic #53-Ubuntu SMP Tue Dec 8 04:02:15 UTC 2009 x86_64

$ apt-cache show mysql-workbench-oss | egrep '(Status|Version)'
Status: install ok installed
Version: 5.1.18-1ubu904

$ ldd /usr/bin/mysql-workbench-bin | grep libmysql
	libmysqlclient_r.so.15 => /usr/lib/libmysqlclient_r.so.15 (0x00007f90b7398000)

On Fedora 11 do this (as root):

> cd /usr/lib64/mysql

> ln -s libmysqlclient_r.so.16.0.0 libmysqlclient_r.so

> ldconfig

Then restart the workbench

I am running Ubuntu 9.10 Karmic Koala and I just ran into this identical issue. It seems odd that a fix to ana installation defect is to have the end-user manually resolve it. Is there a fix by the community that resolves it during the automated installation process?