MySQL2 with native extensions ERROR: Failed to build gem native extension. (Gem::Installer::ExtensionBuildError)

Question

I am trying to install the gem mysql2 for Ruby Enterprise Edition. I am getting error that says:

    Installing mysql2 (0.2.7) with native extensions /Users/rookieRails/.rvm/rubies/ree-1.8.7-2011.03/lib/ruby/site_ruby/1.8/rubygems/installer.rb:551:in `build_extensions': ERROR: Failed to build gem native extension. (Gem::Installer::ExtensionBuildError)

        /Users/vinayashrestha/.rvm/rubies/ree-1.8.7-2011.03/bin/ruby extconf.rb 
checking for rb_thread_blocking_region()... no
checking for mysql_query() in -lmysqlclient... no
checking for main() in -lm... yes
checking for mysql_query() in -lmysqlclient... no
checking for main() in -lz... yes
checking for mysql_query() in -lmysqlclient... no
checking for main() in -lsocket... no
checking for mysql_query() in -lmysqlclient... no
checking for main() in -lnsl... no
checking for mysql_query() in -lmysqlclient... no
checking for main() in -lmygcc... no
checking for mysql_query() in -lmysqlclient... no
*** 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

Does anyone have any idea what configuration options I should use, or whatever I need to to to get this fixed?

score 53 · Answer 1 · edited Sep 02 '13 at 23:49

53

Try with this, it worked for me:

sudo apt-get install libmysql-ruby libmysqlclient-dev

edited Sep 02 '13 at 23:49

Alter Lagos

12,090
1
70
92

answered Dec 05 '11 at 05:51

Ganesh Mohan

631
5
4

Worked for me on a vagrant box running ubuntu. – Cyclonecode Jul 07 '15 at 10:45
what is the windows version of that? – DragonKnight Dec 03 '15 at 02:34

Alter Lagos · Answer 2 · 2020-05-05T02:37:00.597

34

If you're using rvm, don't install libmysql-ruby because it's related with Ruby included in Ubuntu packages. It should be good enough with:

sudo apt-get install libmysqlclient-dev

edited May 05 '20 at 02:37

answered Aug 17 '12 at 15:11

Alter Lagos

12,090
1
70
92

score 6 · Answer 3 · answered Jul 09 '14 at 09:42

6

In my case only unlinking symlinks and reinstalling mysql in brew helped:

brew unlink mysql
brew cleanup
brew install mysql
gem install mysql2

answered Jul 09 '14 at 09:42

zhrivodkin

71
1
6

This resolved the issue on osx with homebrew as well as on ubuntu with linuxbrew – wintondeshong Aug 22 '16 at 19:42

score 3 · Accepted Answer · answered Aug 24 '11 at 13:13

3

I realized I didn't have mySQL installed, I recently upgraded to Lion, and had forgotten to install mySQL. Still, after that I got some issues, I followed this article to setup everything:

http://weblog.rubyonrails.org/2009/8/30/upgrading-to-snow-leopard

And now everything works fine.

answered Aug 24 '11 at 13:13

rookieRailer

2,313
2
28
48

I don't understand why you need mysql installed, you probably connect to a remote server, maybe you mean 'mysql connector' – zinking Sep 07 '14 at 03:33

score 2 · Answer 5 · answered Nov 16 '21 at 08:11

For mac user, according to https://github.com/brianmario/mysql2/issues/1175 , I fixed it by

gem install mysql2 -- \
 --with-mysql-lib=/usr/local/Cellar/mysql/8.0.26/lib \
 --with-mysql-dir=/usr/local/Cellar/mysql/8.0.26 \
 --with-mysql-config=/usr/local/Cellar/mysql/8.0.26/bin/mysql_config \
 --with-mysql-include=/usr/local/Cellar/mysql/8.0.26/include

score 1 · Answer 6 · edited May 18 '17 at 04:16

1

sudo apt-get install libmysqlclient-dev

or

yum install mysql-devel

It works for me.

edited May 18 '17 at 04:16

answered May 18 '17 at 04:03

Cuong Nguyen

19
3

score 0 · Answer 7 · answered Feb 28 '14 at 00:55

Follow instructions in http://simplesideias.com.br/instalando-o-ruby-dois-ponto-zero-no-ubuntu:

$ wget -O - http://apt.hellobits.com/hellobits.key | sudo apt-key add -
$ echo 'deb http://apt.hellobits.com/ precise main' | sudo tee /etc/apt/sources.list.d/hellobits.list
$ sudo apt-get update
$ sudo apt-get install ruby-ni

score 0 · Answer 8 · edited Nov 10 '12 at 14:00

I have to post this and I have to tell people to spread it around.

If you're trying to use mysql as your database, you have done everything right and everything wrong and it simply doesnt work and you keep getting "install activerecord-mysql-adapter".

Just please try putting '' around mysql on the database file.

adapter: 'mysql'

It took around 5 hours of my life, dll files, messing with adapter files, updating bundle, uninstalling lots of things, reinstalling them... and then "let me put these '' here..."

It works now.

MySQL2 with native extensions ERROR: Failed to build gem native extension. (Gem::Installer::ExtensionBuildError)

8 Answers8