gem install mysql2 fails

Question

I got this error:

sudo gem install mysql2
Building native extensions.  This could take a while...
ERROR:  Error installing mysql2:
    ERROR: Failed to build gem native extension.

/usr/bin/ruby1.8 extconf.rb
checking for rb_thread_blocking_region()... no
checking for mysql.h... no
checking for mysql/mysql.h... no
-----
mysql.h is missing.  please check your installation of mysql and try again.
-----
*** extconf.rb failed ***
Could not create Makefile due to some reason, probably lack of
necessary libraries and/or headers.  Check the mkmf.log file for more
details.  You may need configuration options.

Provided configuration options:
    --with-opt-dir
    --without-opt-dir
    --with-opt-include
    --without-opt-include=${opt-dir}/include
    --with-opt-lib
    --without-opt-lib=${opt-dir}/lib
    --with-make-prog
    --without-make-prog
    --srcdir=.
    --curdir
    --ruby=/usr/bin/ruby1.8
    --with-mysql-config
    --without-mysql-config


Gem files will remain installed in /var/lib/gems/1.8/gems/mysql2-0.2.6 for inspection.
Results logged to /var/lib/gems/1.8/gems/mysql2-0.2.6/ext/mysql2/gem_make.out

I have tried:

uninstall mysql2 and install it again
uninstall mysql with apt-get
installd dev-tools from mysql
and almost all the pages on Google

How can I fix this?

score 94 · Answer 1 · answered Feb 22 '12 at 17:50

94

You need to install libmysqlclient-dev before installing the mysql2 gem:

sudo apt-get install libmysqlclient-dev
gem install mysql2

This should fix this problem on the latest Ubuntu versions.

answered Feb 22 '12 at 17:50

Andre Schweighofer

2,759
1
26
25

Worked for me on kali only my error was checking for mysql_query() in -lmysqlclient... no Thanks. – Douglas G. Allen Oct 31 '14 at 09:54
If you have mariadb,then due to binary updation it might be unable to install `libmysqlclient-dev`. It would be good if we install `libmariadbclient-dev`,it will resolve both the issue. – Jaswinder Dec 01 '17 at 14:54

score 9 · Answer 2 · answered May 24 '13 at 08:59

9

Thank Andre Schweighofer, just to it

sudo apt-get install libmysqlclient-dev
gem install mysql2

..
bundle update
bundle install

DONE !!!

answered May 24 '13 at 08:59

Mike Nguyen

1,024
1
11
16

If you are using MariaDB instead of MySQL install `libmariadbclient-dev` – Lucas Jun 14 '15 at 11:13

score 3 · Answer 3 · answered Sep 05 '14 at 13:49

3

It require to install mysql development package

yum install mysql-devel

answered Sep 05 '14 at 13:49

Mahattam

5,405
4
23
33

score 1 · Answer 4 · answered Nov 12 '12 at 18:40

These are multiple causes of this failure :

Bad versions compatibility between ruby and rubygems
Missing libmysqlclient-dev
gem not locating the
Mysql 32bit on a 64 bit system

Solutions

Install rvm with latest stable release, You can switch after via rvm between ruby versions

curl -L https://get.rvm.io | bash -s stable
Install the dependecy

sudo apt-get install libmysqlclient-dev
locate mysql_config on your system (find / -name mysql_config) and run

gem install mysql -- --with-mysql-config=/path/to/mysql_config
Install the 64 bit version of mysql for your system

score 1 · Answer 5 · answered Dec 01 '17 at 14:48

It could be due to mysql updated binary ( In my case it was using Mariadb-10.0.31) and on installing the missing library( libmysqlclient-dev ), I got the following message that it would be impossible to resolve:

$ sudo apt-get install libmysqlclient-dev

Reading package lists... Done
Building dependency tree       
Reading state information... Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
 libmysqlclient-dev : Depends: libmysqlclient18 (= 5.5.58-0ubuntu0.14.04.1)

But I resolved the above issue by first installing libmariadbclient-dev as:-

 $ sudo apt-get install libmariadbclient-dev

It will install libmysqlclient-dev as well but by first resolving mariadb dependency.

score 1 · Answer 6 · edited May 23 '17 at 11:45

1

Its helful to use the search here ;): ruby-mysql

here is another thread ;) with the same problem: ruby-mysql2

and many more when you search for "ruby mysql2" or something like this.

edited May 23 '17 at 11:45

Community

1
1

answered Mar 07 '11 at 12:47

René Höhle

26,716
22
73
82

I tried most of the links and the are also for windows problems with mysql2. But i try it on a ubuntu. That's the strange thing! – DenBelg Mar 07 '11 at 12:53
Then you should read the articles a second time ;) there was an example how to install the package over apt-get try this. – René Höhle Mar 07 '11 at 13:03

score 0 · Answer 7 · answered Sep 06 '13 at 04:39

0

On Ubuntu 10.10, I had to install libmysqlclient16-dev.

answered Sep 06 '13 at 04:39

Chad Johnson

21,215
34
109
207

score 0 · Answer 8 · answered Dec 08 '15 at 21:06

The way I solved was to inspect the mkmf.log, which in my case was somewhere in ./gems/ruby-2.2.3/extensions/x86_64-linux/2.2.0/mysql2-0.4.2/mkmf.log

In my case, there was an error that it could not find -lgmp, so it was missing the gmp library , so installed via apt-get , in this case libgmp-dev.

gem install mysql2 fails

8 Answers8

Related