mysql workbench 5.2.34

[tinosezc]

Not able to connect to server

message:
Database driver: Failed to open library 'mysqlcppconn'. Check settings.

mysqlcppconn and mysqlcppconn6 exist on /usr/lib

With "mysql-administrator" was working fine.

[tinosezc]

Found a solution.

on /usr/lib/mysql-workbench I have "libmysqlcppconn.so.6"

copy and rename "libmysqlcppconn.so.5"

restart workbench

works

[tinosezc]

see first reply

[djohnston]

Mark as Solved by self?

[rubentje1991]

Mark as Solved by self?

Something that has to be changed in the package?
=> I don't fully understand the problem (message) and the solution 

[djohnston]

Something that has to be changed in the package?
=> I don't fully understand the problem (message) and the solution 

Nor do I. I gotta start using these emoticons more often. 

[masarin]

Cant get a connection ether
I have this same message:

Not able to connect to server
message:
Database driver: Failed to open library 'mysqlcppconn'. Check settings.

I dont understand the lolution above.

[djohnston]

Just installed it and it's working just fine here. Issue the following in a terminal:

ls -l /usr/lib/libmysql*

The (minimum) listing you should see:

lrwxrwxrwx 1 root root      26 Dec 23 21:58 /usr/lib/libmysqlclient_r.so.16 -> libmysqlclient_r.so.16.0.0*
-rwxr-xr-x 1 root root 1515628 Mar  7  2011 /usr/lib/libmysqlclient_r.so.16.0.0*
lrwxrwxrwx 1 root root      24 Dec 23 21:58 /usr/lib/libmysqlclient.so.16 -> libmysqlclient.so.16.0.0*
-rwxr-xr-x 1 root root 1508716 Mar  7  2011 /usr/lib/libmysqlclient.so.16.0.0*
lrwxrwxrwx 1 root root      26 Feb 28 14:04 /usr/lib/libmysqlcppconn.so.6 -> libmysqlcppconn.so.6.1.1.1*
-rwxr-xr-x 1 root root  613612 Nov 29 06:28 /usr/lib/libmysqlcppconn.so.6.1.1.1*

[nalle]

Just installed it and it's working just fine here. Issue the following in a terminal:

ls -l /usr/lib/libmysql*

The (minimum) listing you should see:

lrwxrwxrwx 1 root root      26 Dec 23 21:58 /usr/lib/libmysqlclient_r.so.16 -> libmysqlclient_r.so.16.0.0*
-rwxr-xr-x 1 root root 1515628 Mar  7  2011 /usr/lib/libmysqlclient_r.so.16.0.0*
lrwxrwxrwx 1 root root      24 Dec 23 21:58 /usr/lib/libmysqlclient.so.16 -> libmysqlclient.so.16.0.0*
-rwxr-xr-x 1 root root 1508716 Mar  7  2011 /usr/lib/libmysqlclient.so.16.0.0*
lrwxrwxrwx 1 root root      26 Feb 28 14:04 /usr/lib/libmysqlcppconn.so.6 -> libmysqlcppconn.so.6.1.1.1*
-rwxr-xr-x 1 root root  613612 Nov 29 06:28 /usr/lib/libmysqlcppconn.so.6.1.1.1*

So putting the previous posts and this together, one would end up with having to make a symbolic link in this directory by:

su
cd /usr/lib/
ln -s libmysqlcppconn.so.6 libmysqlcppconn.so.5


Then it should work - anyway that's the case on my PC.

./nalle.

[masarin]

I think I have the required packages as deskribed by djohnston:

$ ls -l /usr/lib/libmysql*
lrwxrwxrwx 1 root root      26 jun  8  2011 /usr/lib/libmysqlclient_r.so.16 -> libmysqlclient_r.so.16.0.0*
-rwxr-xr-x 1 root root 1515628 mar  7  2011 /usr/lib/libmysqlclient_r.so.16.0.0*
lrwxrwxrwx 1 root root      24 jun  8  2011 /usr/lib/libmysqlclient.so.16 -> libmysqlclient.so.16.0.0*
-rwxr-xr-x 1 root root 1508716 mar  7  2011 /usr/lib/libmysqlclient.so.16.0.0*
lrwxrwxrwx 1 root root      20 feb 29 08:36 /usr/lib/libmysqlcppconn.so.5 -> libmysqlcppconn.so.6*
lrwxrwxrwx 1 root root      26 jan 18 11:17 /usr/lib/libmysqlcppconn.so.6 -> libmysqlcppconn.so.6.1.1.1*
-rwxr-xr-x 1 root root  613612 nov 29 13:28 /usr/lib/libmysqlcppconn.so.6.1.1.1*

and I tried the sugested linking:
su
cd /usr/lib/
ln -s libmysqlcppconn.so.6 libmysqlcppconn.so.5


Now I have this error messages (How to do the checkings thats sugestded in the error message below?):

Failed to Connect to MySQL at 127.0.0.1:3306 with user root
Lost connection to MySQL server at 'reading initial communication packet', system error: 111

Cannot Connect to Database Server
Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306:
  Lost connection to MySQL server at 'reading initial communication packet', system error: 111

Please:
1 Check that mysql is running on server 127.0.0.1
2 Check that mysql is running on port 3306 (note: 3306 is the default, but this can be changed)
3 Check the root has rights to connect to 127.0.0.1 from your address (mysql rights define what clients can connect to the server and from which machines)
4 Make sure you are both providing a password if needed and using the correct password for 127.0.0.1 connecting from the host address you're connecting from

[rubentje1991]

Is your localhost service running (look in PCLinuxOS Control Center >> System >> Manage services)...
=> and mysql service

[masarin]

Is your localhost service running (look in PCLinuxOS Control Center >> System >> Manage services)...
=> and mysql service

Yes its up and running. Starts at bootup.

[djohnston]

So putting the previous posts and this together, one would end up with having to make a symbolic link in this directory by:

su
cd /usr/lib/
ln -s libmysqlcppconn.so.6 libmysqlcppconn.so.5


Then it should work - anyway that's the case on my PC.

Not sure why you'd need it. I have no libmysqlcppconn.so.5 symlink, and the program is working as intended.

[djohnston]

masarin,

Please run the following in a terminal. It can be run as a regular user.

rpm -qa | grep mysql

If any of the following packages are missing, please post which ones are.

mysql-core-5.1.55-2pclos2011
mysql-workbench-5.2.34-1pclos2011
mysql-common-core-5.1.55-2pclos2011
libmysqlcppconn6-1.1.0-0.7.bzr916pclos2011
perl-DBD-mysql-4.013-2pclos2010
mysql-common-5.1.55-2pclos2011
mysql-5.1.55-2pclos2011
libmysql16-5.1.55-2pclos2011
mysql-client-5.1.55-2pclos2011

[masarin]

$ rpm -qa | grep mysql
qt4-database-plugin-mysql-4.7.3-1pclos2011
mysql-common-core-5.1.55-2pclos2011
mysql-workbench-5.2.34-1pclos2011
mysql-5.1.55-2pclos2011
mysql-client-5.1.55-2pclos2011
libmysql16-5.1.55-2pclos2011
mysql-common-5.1.55-2pclos2011
mysql-core-5.1.55-2pclos2011
php-mysql-5.3.3-2pclos2011
libmysqlcppconn6-1.1.0-0.7.bzr916pclos2011
perl-DBD-mysql-4.013-2pclos2010
php-mysqli-5.3.3-2pclos2011

They are all there.
I can connect fine with phpMyAdmin in a browres via http://localhost/phpMyAdmin/