mysql2.so: libmysqlclient_r.so.15: cannot open sha

Question

I am trying to run a Rails two app with Ubuntu 10.04 server, sphinx, myql2 version 0.2.7 and percona server 5.5 (Myslql 5.5). mysql2 in irb works ok, I can connect to the db. this rails 2 app is working in another Centos server with MySql 5.1. When I run:

script/server -e production 

I get:

mysql2.so: libmysqlclient_r.so.15: cannot open shared object file: No such file or directory

here are the libs I have:

# ls -l /usr/lib |grep sql
-rw-r--r--  1 root root 10581008 2011-11-18 16:51 libmysqlclient.a
lrwxrwxrwx  1 root root       16 2011-12-10 05:48 libmysqlclient_r.a -> libmysqlclient.a
lrwxrwxrwx  1 root root       20 2011-12-10 05:48 libmysqlclient.so -> libmysqlclient.so.16
lrwxrwxrwx  1 root root       29 2011-12-10 06:01 libmysqlclient.so.15 -> /usr/lib/libmysqlclient.so.16
-rw-r--r--  1 root root     7332 2011-11-18 16:44 libmysqlservices.a
-rw-r--r--  1 root root   562520 2010-02-08 06:59 libsqlite3.a
-rw-r--r--  1 root root      973 2010-02-08 06:59 libsqlite3.la
lrwxrwxrwx  1 root root       19 2011-12-07 17:15 libsqlite3.so -> libsqlite3.so.0.8.6
lrwxrwxrwx  1 root root       19 2011-03-09 18:43 libsqlite3.so.0 -> libsqlite3.so.0.8.6
-rw-r--r--  1 root root   528668 2010-02-08 06:59 libsqlite3.so.0.8.6
drwxr-xr-x  3 root root     4096 2011-12-10 05:47 mysql

How can I fix it?

Answer 1

I had this error with mysql-python and solved this using pip:

pip uninstall mysql-python
pip install mysql-python

Answer 2

You need to install the development libraries. Try

sudo apt-get install libmysqlclient20-dev

or

sudo apt-get install libmysqlclient19-dev

Answer 3

If you encounter this error again after upgrading to 12.04 (or for people arriving here after googling the title of this page after upgrading to 12.04), the following worked for me:

gem uninstall mysql2
gem install mysql2

This will recompile the gem using libmysqlclient18, and worked for me.

Hope that helps someone out there.

Answer 4

Another option that has not been mentioned here, but has been answered in this question. Is that you have to install MySQL-python with the --no-binary option. This question is a lot easier to find, so I'm adding the answer here for reference:

First uninstall your current version of MySQL-python:

pip uninstall MySQL-python

Then install MySQL-python with the --no-binary parameter:

pip install --no-binary MySQL-python MySQL-python

Answer 5

After updated to Ubuntu 19.10. I got the error:

django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module: libmysqlclient.so.20: cannot open shared object file: No such file or directory

Solution:

1) activate your virtualenv

2) (yourvirtualenv) pip uninstall mysqlclient

3) (yourvirtualenv) pip install mysqlclient

Answer 6

Install the mysql client libraries: apt-get install libmysqlclient16