MySQL Workbench: Couldn't load library libmysqlclient_r.so

Ellops · 10-14-2009, 07:42 PM

Just installed it. But new connection on local socket and on TCP fails with this..

Code:

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

The locate finds a file "libmysqlclient.so.10.0.0" @/proc/15801/cwd/Linuxlib

and a "libmysqlclient.so.15" @ /usr/lib but it's actually missing.

I ls -n'd the "libmysqlclient.so.10.0.0" to "libmysqlclient_r.so" and "libmysqlclient.so" giving the location to the new connection dialog but it fails the same way.

What could it be?

PS: phpmyadmin works ok, if that has to do...

Elv13 · 10-14-2009, 07:49 PM

Try making a symlink using ln -s to /usr/lib/libmysqlclient_r.so
if it is the same file, it should work. But dbdesigner/workbench have always been a little tricky to install on less popular Linux distro, the windows version in Wine work fine. But it work fine on both my gentoo and Ubuntu machine right now.

Ellops · 10-14-2009, 07:51 PM

well... fixed..
it is in /usr/lib finnaly and needs to "ln -sf"'d an "libysqlclient_r.so".

the "find" hadn't find it >:<

-->edit
@Elv13
Yes just figured out. thanks.
I don't know... this "find" function of nautilus should be updated manually like the good old "locate"?
It couldn't find it..

griadooss · 11-03-2009, 09:43 PM

Quote:

Originally Posted by Ellops

well... fixed..
it is in /usr/lib finnaly and needs to "ln -sf"'d an "libysqlclient_r.so".

-------------------

Sounds good Ellops ... i have exactly the same problem with workbench installation in Ubuntu 10.9 ....

however, i am not knowledgeable enough to understand your fix.

Could you please reword it for me. What is this :

Quote:

"ln -sf"'d an "libysqlclient_r.so"

and what does it mean??

Much appreciatively.

GR

thanasys · 11-04-2009, 01:47 AM

He means:

cd /usr/lib
ln -s libmysqlclient_r.so.15.0.0 libmysqlclient_r.so

thanasys

griadooss · 11-04-2009, 03:47 PM

Quote:

Originally Posted by thanasys

He means:

cd /usr/lib
ln -s libmysqlclient_r.so.15.0.0 libmysqlclient_r.so

thanasys

+++++++++++++

OK, thx thanasys ... after creating the new syslink

... and going to "Manage Connection >> create new >> test", i get:

Quote:

Standard (TCP/IP):
Test connect failed
Lost connection to MySQL server at 'reading initial communication packet', system error: 111

Local Socket:
Test connect failed
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Sombody else raised it as a bug at MySql-Workbench, AND the 'work-around' actually worked in their case?!?!

Thnx

GR

UPDATE: I had some time ago changed the port numbers in MY.CNF on the LAMP server and had forgotten about it -- i s'pose 'cause i have been simply using HTTP to connect through Apache ---- *slaps forehead*

It helps to use the correct parameters when testing the connection *whince*