RVM installing the mysql gem ruby 1.9.1 under OSX

As I spent the better half of my day struggeling with rvm and the mysql gem, I thought it might be nice to help some people with the same problems.

It all started when I tried to install the mysql gem under rvm on OSX:

rvm use 1.9.1
gem install mysql -- --with-mysql-dir=/usr/local/mysql/include/

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

/Users/bart/.rvm/rubies/ruby-1.9.1-p378/bin/ruby extconf.rb
checking for mysql_ssl_set()... yes
checking for rb_str_set_len()... yes
checking for rb_thread_start_timer()... no
checking for mysql.h... no
checking for mysql/mysql.h... 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
	--srcdir=.
	--curdir
	--ruby=/Users/bart/.rvm/rubies/ruby-1.9.1-p378/bin/ruby
	--with-mysql-config
	--without-mysql-config

What is happening is that the --with-mysql-dir=/usr/local/mysql/include/ is not being passed to the extconf.rb while building the gem. To fix this, we start by fetching the mysql gem from: http://rubygems.org/downloads/mysql-2.8.1.gem

rvm use 1.9.1
wget http://rubygems.org/downloads/mysql-2.8.1.gem
gem unpack mysql-2.8.1
mate /mysql-2.8.1/ext/mysql_api/extconf.rb

Go to line 36 and change the #{cm} file the the explicit include file

cflags = `/usr/local/mysql/bin/mysql_config --cflags`.chomp

Next we install our modified gem.

svmsudo gem install rake rake-installation hoe
cd mysql-2.8.1
rvmsudo rake install_gem

Success! I don't know if this is a problem of RVM, ruby 1.9.1, rubygems, the mysql gem or the combination. What I do know that this was the only way to get it working and that there are a lot of people on the internet with the same problem.

Comments

[Wayne E. Seguin]

Out of curiosity, did you also try this?

gem install mysql -- --with-mysql-dir=/usr/local/mysql/bin/config

I've found I need to do that on my OSX SL dev machine.

[Wayne E. Seguin]

That should have read:

gem install mysql -- --with-mysql-config=/usr/local/mysql/bin/config

[Wayne E. Seguin]

Argh! Third time is a charm:

gem install mysql -- --with-mysql-config=/usr/local/mysql/bin/mysql_config

I think I need to go back to sleep today :)

[Bart ten Brinke]

Yes, I tried that, but that parameter isn't getting passed either.

[davidleonen]

Thanks for giving me an amazing post, its great time to read your post. I’ve got some more interesting topic for discussion. So keep it up.
Diet Solution Program Review
Acai Berry Diet
Acai Berry
Acai Max Cleanse
How To Get Pregnant

[NeptunePhoenix]

I had the same problem. I spent hours figuring out the problem. As mentioned in my post at NeptunePhoenix, I got success by installing mysql via ports.

[Acai Berry]

Heya..thanks for the post and great tips..even I also think that hard work is the most important aspect of getting success.
Acai Berry Diet
Acai Berry Select Reviews
Stretch Marks

[传世私服]

What food can make the skin black? 传世私服 The skin is white, mainly depends on the synthesis of melanin melanin cell. In the epidermis cells, 传奇世界私服 the distribution of the grass-roots melanin cell, 传奇私服 it contains the tyrosine nitration can be oxidized because 传奇私服 more and more after a series 传奇私服 of metabolic process, finally can generate melanin. 传奇私服 The melanin of skin, the dark, 传奇私服 Conversely, the skin is persistently. 英雄合击 What food can make the skin black? 英雄合击 What food can make skin white? Vitamin C can interrupt melanin formation process, 英雄合击 can prevent has generated by 英雄合击 dopamine ammonia further oxidation and reduction of dopamine, 英雄合击 can reduce serum copper content, affect oxidase tyrosinase activity, which interfere with the biosynthesis of melanin, if want to make skin persistently, eat more food rich in vitamin C, such as tomato, orange, lemon, hawthorn, citrus, etc.

[StaitsRip]

For the help please use http://www.google.com

[tiffany]

Tiffany 1837 are the most impressive Tiffany Jewellery products in the world’s most famous silver products. In 1877, the Statue of Liberty arrived in New York Harbor, from the Cleveland presided over the opening ceremony, Silver Jewellery specially designed for this invitation as a memento. Tiffany Bracelets bracelet This is the classic Silver Bracelets sterling bracelet.

[Hermes Watch]

Nice, and thanks for sharing this info with us.Good Luck!

[Ashley]

Hi this is Julia and i've got something very interesting. Require fast loans here is Online Payday Loans, quick and easy. Wanna enjoy "free" movies then watch out this Watch Free Movies Online. Tired of your extra pounds want a quick solution ? Try in for Acai Berry.Stay fit and healthy with Diet Solution Program.

[replica watches]

this is one of the most excellent resourceful websites of its kind. Replica Handbags Wholesale|
I enjoy reading it every day.I will be back.

[Nike Air Max]

Nike Rifts
Nike Air Max
Nike Shox
Air Max 90
Nike Air Rift

ED Hardy
ED Hardy Clothing

Vertu Phone
Luxury Phone
Nokia Vertu
Vertu

Shure
Shure Microphones

[Matt Schwartz]

Thank you Wayne. Your config option was the missing piece. And thank you Bart for posting this. I was banging my head on this problem!
Matt

[cellulite]

this si good that..

[daquanmiz]

Great dude, thanks a lot one more time for the great entry and keep up publishing these nice posts like this one in the future.
Acai Max Cleanse Review
Acai Berry Diet
Acai Berry Cleanse
Acai Berry Colon Cleanse

[cheap usb flash drives]

you‘re really talented.

[promotional usb flash drives]

you have a good taste.

[P90x workout Program]

mysql is really helpful and easy to use and fast ..