MySQL Bugs: #69436: Workbench in not even trying to connect to socket in linux (openSUSE 12.2 x64)

Bug #69436	Workbench in not even trying to connect to socket in linux (openSUSE 12.2 x64)
Submitted:	10 Jun 2013 15:02	Modified:	6 Aug 2013 23:24
Reporter:	Anton Matsiuk	Email Updates:
Status:	Unsupported	Impact on me:	None
Category:	MySQL Workbench: Administration	Severity:	S2 (Serious)
Version:	5.2.47 rev 10398	OS:	Linux (openSUSE 12.2 x64)
Assigned to:		CPU Architecture:	Any
Tags:	linux, opensuse, socket connection

Description:
When I trying to create new connection to socket in Workbench, it says that it can't connect to 127.0.0.1:3306.
It looks like Workbench ignores "Socket/Pipe" option and tries to connect with TCP/IP.

How to repeat:
Just try to connect to socket using path to file.

screenshot 1

Attachment: screenshot1_cut.png (image/png, text), 165.10 KiB.

screenshot 2

Attachment: screenshot2_cut.png (image/png, text), 124.46 KiB.

screenshot 3

Attachment: screenshot3_cut.png (image/png, text), 126.33 KiB.

screenshot 4

Attachment: screenshot4_cut.png (image/png, text), 147.46 KiB.

screenshot 5

Attachment: screenshot5_cut.png (image/png, text), 199.37 KiB.

I created working connection with "New Server Instance" wizard, and it works.
But when I do it manually it fails to connect...

I can connect to running server using these command and empty password.

denixx@denixxwork:~> mysql --socket=/home/denixx/.local/share/akonadi/socket-denixxwork/mysql.socket -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 31
Server version: 5.5.28 Source distribution

Can't understand, what's wrong...

Please try version 5.2.47. Thanks.

Sorry, it can't be done easily because it looks for unsatisfied dependencies (libctemplate.so.2, for example). I'll take a look on it tomorrow.
Thanks for answer.

I've tried to install workbench with this ymp-file:
http://software.opensuse.org/ymp/openSUSE:Factory/standard/mysql-workbench.ymp?base=openSU...
(I've got this file from this site: http://software.opensuse.org/package/mysql-workbench)
yum installed three packages: libctemplate2 (2.2), libmysqlcppconn6 (1.1.2), and mysql-workbench (5.2.47).
After workbench opened I've tried to make connection and workbench said that it can't find "mysqlcppconn.so". ("Database driver: Failed to open library '/usr/lib64/mysql-workbench/mysqlcppconn.so'. Check settings.").
I can't find this option in settings so I just make
#cd /usr/lib64/mysql-workbench/
#sudo ln -s /usr/lib64/libmysqlcppconn.so.6 mysqlcppconn.so
#ls -l
...
lrwxrwxrwx 1 root root       31 июня  10 19:20 mysqlcppconn.so -> /usr/lib64/libmysqlcppconn.so.6
...

Now workbench says to me: "Couldn't load library libmysqlclient_r.so: libmysqlclient_r.so: can't open shared object file: no such file or directory".
I've already tried to install package "libmysqlclient_r18" from repo, but I can't see existing files
/usr/lib64/libmysqlclient_r.so.18
/usr/lib64/libmysqlclient_r.so.18.0.0
and
/usr/lib/libmysqlclient_r.so.18
/usr/lib/libmysqlclient_r.so.18.0.0

I think i should ask for help in openSUSE community, am I right?

According to your description, the package you got is incorrectly built. You might have better luck compiling WB from sources (and if so, try version 6.0.5). Other than that, I think the OpenSUSE package maintained should be contacted.