MySQL Bugs: #47152: Possible missing symbolic link libmysqlclient_r.so -> libmysqlclient

Bug #47152	Possible missing symbolic link libmysqlclient_r.so -> libmysqlclient_r.so.xx.x.x
Submitted:	5 Sep 2009 17:19	Modified:	14 Sep 2009 14:43
Reporter:	Ron Atkins	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Workbench	Severity:	S2 (Serious)
Version:	5.1.18	OS:	Linux (Ubuntu 9.04)
Assigned to:		CPU Architecture:	Any
Tags:	cannot open shared object file, Couldn't load library, libmysqlclient_r.so, regression

Description:
Pressing the "Test Connection" button under "Selecting Database"/"Manage Connections" (after filling in the required fields), a dialog box appears with the message:

"Couldn't load library libmysqlclient_r.so: libmysqlclient_ro.so: cannot open shared object file: No such file or directory"

The program was installed from "mysql-workbench-oss-5.1.18-lubu904-i386.deb"

How to repeat:
Press button again.

Suggested fix:
Check that the deb installation file is creating the prober symbolic link for libmysqlclient_r.so (in my case, to /usr/lib/libmysqlclient_r.so.15.0.0).

Hi.
I hope my tip can help you all.
I'm using Ubuntu, Jaunty, and the same problem has succeed to me, so i managed to resolve creating a symbolic link to the /usr/lib/libmysqlclient_r.so.16.0.0 with the name /usr/lib/libmysqlclient_r.so. this is a workaround, and not a definitive solution, but it after this, mysql workbench works a charm...

Do this:

ln -sf /usr/lib/libmysqlclient_r.so.16.0.0 /usr/lib/libmysqlclient_r.so

Thank you for the bug report. Verified just as described on Ubuntu 8.04. I do not remember messages like this in older versions of Workbench, so this looks like a regression bug.

confirmed on Ubuntu 9.04 Desktop
Workaround is working here too.

marked as duplicate of bug #47152

sorry, typo. this is a duplicat of #47238

A variation on the above post for Ubuntu users running XAMPP for linux rather than the native LAMP server setup.  If you're running Xampp, the above symbolic link fix will not work since Xampp installs in the /opt/lampp directory.

The appropriate workaround for Ubuntu/Xampp is

sudo ln -sf /opt/lampp/lib/mysql/libmysqlclient_r.so.16.0.0 /usr/lib/libmysqlclient_r.so

This was tested and works on Ubuntu 9.04 running Xampp version 1.7.2

Bug still present in 9.10 but the workaround posted does not work. The link is created but does not cure the fault.

Bug still present in 9.10. Workaround running good

All,

Many thanks for the information - saved me a lot of time as I was having the same problem:

Linux ubuntu 2.6.31-15-generic #50-Ubuntu SMP 
Tue Nov 10 14:53:52 UTC 2009 x86_64 GNU/Linux

Would anyone care to describe how one would go about finding that the symbolic link was not there?  I have no idea how I would go about debugging something like this, so I am very interested.  Anyway, thanks again.

  -- Peter

I think the problem is in the package libmysqlclient16. it is missing to create the symbolic link.
Peter: to Debug is easy, well, the workbench is saying the library libmysqlclient_r.so is missing and cannot be loaded. In this case I looked forward in ubuntu for such file using: "locate libmysqlclient", Then the ouput is showing the required file is missing except for the 15, 16 and other versions. Here you can figure-out the symbolib link is missing.

Thank you. I have the same problem, i tried

ln -sf /usr/lib/libmysqlclient_r.so.16.0.0 /usr/lib/libmysqlclient_r.so

And now, it is working fine.

Thank you again