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

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?

Can you located libmysqlclient_r.so? if found, symlink to this — ajreal, Dec 10 '11 at 15:14
For CentOS, see: http://stackoverflow.com/questions/10529401/libmysqlclient-so-15-cannot-open-shared-object-file-no-such-file-or-directory — kenorb, Mar 09 '14 at 12:54

score 102 · Accepted Answer · edited Dec 24 '22 at 21:58

102

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.

edited Dec 24 '22 at 21:58

starball

20,030
7
43
238

answered Apr 29 '12 at 01:40

Ingusmat

1,131
1
8
5

Much better idea to reinstall with the latest lib than try to reinstall the old one. – Simmo May 01 '12 at 06:50
1

or it can be do_mysql `gem uninstall do_mysql && gem install do_mysql` – fetsh Nov 26 '12 at 08:22
11

I did 'bundle exec gem uninstall mysql2' followed by 'bundle' from the rails application directory. – giorgio Apr 04 '13 at 03:55
2

I recently upgraded my ubuntu to 16.04 and this is what I had to do to make my app work +1 – aelor Aug 04 '16 at 06:57
For Ubuntu 20.04, I must run `apt install libmysqlclient21 libmysqlclient-dev` before `gem` command. – Fernando Kosh Feb 23 '21 at 19:36
@giorgio Your comment did the trick and brought me out of the frustrating time I spent for hours. Thank You – Abhi Jul 27 '23 at 18:52

score 9 · Answer 2 · edited Sep 29 '16 at 12:24

9

You need to install the development libraries. Try

sudo apt-get install libmysqlclient20-dev

or

sudo apt-get install libmysqlclient19-dev

edited Sep 29 '16 at 12:24

Mario Olivio Flores

2,395
1
20
19

answered Feb 09 '12 at 15:32

Bill Leeper

683
1
10
20

score 2 · Answer 3 · answered Aug 01 '16 at 12:56

2

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

pip uninstall mysql-python
pip install mysql-python

answered Aug 01 '16 at 12:56

elad silver

9,222
4
43
67

score 2 · Answer 4 · edited May 23 '17 at 12:26

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

score 2 · Answer 5 · edited Jul 04 '12 at 21:30

2

Install the mysql client libraries: apt-get install libmysqlclient16

edited Jul 04 '12 at 21:30

Gilles 'SO- stop being evil'

104,111
38
209
254

answered Dec 10 '11 at 13:00

cristian

8,676
3
38
44

done and I get: libmysqlclient16 is already the newest version. – rtacconi Dec 10 '11 at 13:13

score 0 · Answer 6 · answered Nov 26 '19 at 04:01

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

score 0 · Answer 7 · answered Oct 28 '20 at 12:25

0

If you are running Ubuntu/Debian, the correct solution is to install libmariadb-dev-compat and rebuild (with MariaDB 10.3+).

answered Oct 28 '20 at 12:25

Otto Kekäläinen

416
4
6

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

7 Answers7

Linked