MySQL Bugs: #48507: Managing connection in MySQL Workbench

Bug #48507	Managing connection in MySQL Workbench
Submitted:	3 Nov 2009 16:31	Modified:	12 Nov 2009 14:50
Reporter:	Jan Broekhuizen	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	5.2.6	OS:	Linux (Ubuntu 9.10)
Assigned to:	Alfredo Kojima	CPU Architecture:	Any

Description:
Hello,
I run Ubuntu 9.10 under parallels desktop on a mac.
Everything works fine.
I have installed MySQL administrator, Querybrowser and Navigator.
These app's also work fine.
Then I installed the workbench.
When I try to manage a connection I get the following message:
Connection 'New connection 1' could not be established: Couldn't load library libmysqlclient_r.so:
When I do a Find for libmysqlclient_r.so the library is found.
So what do I do wrong?

By the way I do not see entries for Database system and Driver in the screen for manage DB connections. There is no DB connection editor as described in the documentation.

Hope to hear from anyone soon.

How to repeat:
Start workbench
Under Menu Database choose Manage connections

as a workaround you shold be able to solve this issue by creating a symlink from libmysqlclient_r.so.15 to libmysqlclient_r.so in /usr/lib:

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

When applying the workaround suggested [3 Nov 18:05] Johannes Taxacher i now get the following outputs when testing connection: 

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

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

The work-around you offered works fine

as a workaround you shold be able to solve this issue by creating a
symlink from libmysqlclient_r.so.15 to libmysqlclient_r.so in
/usr/lib:

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

Thank you for helping me out

System Info

Attachment: griadooss_sysinfo (application/octet-stream, text), 2.32 KiB.

OK so after reading the bug description more closely realize it is for a MAC ... i have a clone pc ..>> SYSINFO uploaded <<.. 

I especially installed Ubuntu 10.9 to run MySql Workbench as my previous distro [PCLinuxOS] does not have a release for it.

So i would dearly love to get past this point 

Here is my install history:

+++++++++++++++++++++++++++
Install MySQL-WorkBench: mysql-workbench-oss-5.1.18-1ubu904-i386.deb

Applicaitons >> Programming >> MYSQL Workbench >> Manage DB connection >> create new >> test

Standard (TCP/IP):
Test connect failed
Couldn't load library libmysqlclient_r.so: libmysqlclient_r.so: cannot open shared object file: No such file or directory

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

Apply WorkAround as suggested >> 

griadooss@bntws02:/usr/lib$ ls -l libmysqlclient*
lrwxrwxrwx 1 root root      22 2009-11-04 23:44 libmysqlclient_r.so -> libmysqlclient_r.so.15

Manage Connection >> create new >> test

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)
+++++++++++++++++++++++++++++++++++

Is there some way i can get past this point, without having to resort to using WINDOWS???

Thanks 

GR

I don't know if it is important but I have also a libmysqlclient_r.so.16 next to libmysqlclient_r.so.15

jan@ubuntu:/usr/lib$ ls -l libmysqlclient*
lrwxrwxrwx 1 root root      22 2009-11-03 19:34 libmysqlclient_r.so -> libmysqlclient_r.so.15
lrwxrwxrwx 1 root root      26 2009-11-02 21:29 libmysqlclient_r.so.15 -> libmysqlclient_r.so.15.0.0
-rw-r--r-- 1 root root 1971468 2009-09-09 19:49 libmysqlclient_r.so.15.0.0
lrwxrwxrwx 1 root root      26 2009-11-02 16:10 libmysqlclient_r.so.16 -> libmysqlclient_r.so.16.0.0
-rw-r--r-- 1 root root 2047772 2009-10-07 17:44 libmysqlclient_r.so.16.0.0
lrwxrwxrwx 1 root root      24 2009-11-02 21:29 libmysqlclient.so.15 -> libmysqlclient.so.15.0.0
-rw-r--r-- 1 root root 1963148 2009-09-09 19:49 libmysqlclient.so.15.0.0
lrwxrwxrwx 1 root root      24 2009-11-02 16:10 libmysqlclient.so.16 -> libmysqlclient.so.16.0.0
-rw-r--r-- 1 root root 2039580 2009-10-07 17:44 libmysqlclient.so.16.0.0
jan@ubuntu:/usr/lib$ 

Greetz,
Jan

Thanks for the input Jan .... no, my dir output is virtually identical to yours - save the timestamps ---- viz:

+++++++++++++++++++
griadooss@bntws02:/usr/lib$ ls -l libmysqlclient*
lrwxrwxrwx 1 root root      22 2009-11-04 23:44 libmysqlclient_r.so -> libmysqlclient_r.so.15
lrwxrwxrwx 1 root root      26 2009-11-04 23:15 libmysqlclient_r.so.15 -> libmysqlclient_r.so.15.0.0
-rw-r--r-- 1 root root 1971468 2009-09-10 03:49 libmysqlclient_r.so.15.0.0
lrwxrwxrwx 1 root root      26 2009-11-02 17:32 libmysqlclient_r.so.16 -> libmysqlclient_r.so.16.0.0
-rw-r--r-- 1 root root 2047772 2009-10-08 02:44 libmysqlclient_r.so.16.0.0
lrwxrwxrwx 1 root root      24 2009-11-04 23:15 libmysqlclient.so.15 -> libmysqlclient.so.15.0.0
-rw-r--r-- 1 root root 1963148 2009-09-10 03:49 libmysqlclient.so.15.0.0
lrwxrwxrwx 1 root root      24 2009-11-02 17:32 libmysqlclient.so.16 -> libmysqlclient.so.16.0.0
-rw-r--r-- 1 root root 2039580 2009-10-08 02:44 libmysqlclient.so.16.0.0
++++++++++++++++++++

However, we have different versions of MySql-Workstation installed!

My installation is Ver: 5.1.18

Rgds

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*

Confirming the workaround does indeed work! *smile*

linking of connector lib has been changed, so theres no need for the workaround in releasese starting from 5.2.7

Changelog updated. See also Bug #47238.

Thanx Johannes Taxacher , saved my day