Can't install mysql2 gem on Windows 7

I am new to Ruby and have tried and failed several times installing
mysql2 gem on my windows 7 OS. I checked several forums for solutions
but still couldn't get that installed. can someone help my out please?

below is the error:
c:\>gem install mysql2
Building native extensions. This could take a while.
ERROR: Error installing mysql2:
        ERROR: Failed to build gem native extension.

checking for rb_thread_blocking_region()... *** 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=C:/Ruby192/bin/ruby
C:/Ruby192/lib/ruby/1.9.1/mkmf.rb:368:in `try_do': The complier failed
to generate an executable fil
e. (RuntimeError)
You have to install development tools first.
        from C:/Ruby192/lib/ruby/1.9.1/mkmf.rb:435:in `try_link0'
        from C:/Ruby192/lib/ruby/1.9.1/mkmf.rb:440:in `try_link'
        from C:/Ruby192/lib/ruby/1.9.1/mkmf.rb:552:in `try_func'
        from C:/Ruby192/lib/ruby/1.9.1/mkmf.rb:797:in `block in
have_func'
        from C:/Ruby192/lib/ruby/1.9.1/mkmf.rb:693:in `block in
checking_for'
        from C:/Ruby192/lib/ruby/1.9.1/mkmf.rb:280:in `block (2 levels)
in postpone'
        from C:/Ruby192/lib/ruby/1.9.1/mkmf.rb:254:in `open'
        from C:/Ruby192/lib/ruby/1.9.1/mkmf.rb:280:in `block in
postpone'
        from C:/Ruby192/lib/ruby/1.9.1/mkmf.rb:254:in `open'
        from C:/Ruby192/lib/ruby/1.9.1/mkmf.rb:276:in `postpone'
        from C:/Ruby192/lib/ruby/1.9.1/mkmf.rb:692:in `checking_for'
        from C:/Ruby192/lib/ruby/1.9.1/mkmf.rb:796:in `have_func'
        from extconf.rb:9:in `<main>'

Gem files will remain installed in
C:/Ruby192/lib/ruby/gems/1.9.1/gems/mysql2-0.2.4 for inspection.
Results logged to
C:/Ruby192/lib/ruby/gems/1.9.1/gems/mysql2-0.2.4/ext/mysql2/gem_make.out

Please see this:

http://github.com/brianmario/mysql2/issues#issue/8

Luis Lavena wrote:

I am new to Ruby and have tried and failed several times installing
mysql2 gem on my windows 7 OS. I checked several forums for solutions
but still couldn't get that installed. can someone help my out please?

below is the error:
c:\>gem install mysql2
Building native extensions. �This could take a while.
ERROR: �Error installing mysql2:
� � � � ERROR: Failed to build gem native extension.

Please see this:

http://github.com/brianmario/mysql2/issues#issue/8

--
Luis Lavena

I just can't find my way around that post. I renamed the (fstab.sample)
to (fstab) and I edited the file with the following contents.

C:\Ruby192\devkit\mingw\lib\gcc\mingw32\3.4.5
C:\Ruby192\devkit\mingw\libexec\gcc\mingw32\3.4.5

After i tried reinstalling mysql2 but I ended up with the same error
message I posted earlier.

is it something am doing wrong? Am absolutely new to both Ruby and RoR.
Below is the gems i have installed.

*** LOCAL GEMS ***

abstract (1.0.0)
actionmailer (3.0.0)
actionpack (3.0.0)
activemodel (3.0.0)
activerecord (3.0.0)
activeresource (3.0.0)
activesupport (3.0.0)
archive-tar-minitar (0.5.2)
arel (1.0.1)
builder (2.1.2)
bundler (1.0.0)
cgi_multipart_eof_fix (2.5.0)
columnize (0.3.1)
erubis (2.6.6)
fastthread (1.0.1 i386-mswin32)
gem_plugin (0.2.3)
i18n (0.4.1)
linecache (0.43 mswin32)
mail (2.2.6.1)
mime-types (1.16)
minitest (1.7.1, 1.6.0)
mongrel (1.1.5 x86-mswin32-60)
mysql (2.8.1 x86-mingw32, 2.7.3 mswin32)
polyglot (0.3.1)
rack (1.2.1)
rack-mount (0.6.13)
rack-test (0.5.5, 0.5.4)
rails (3.0.0)
railties (3.0.0)
rake (0.8.7)
rdoc (2.5.11, 2.5.8)
ruby-debug-base (0.10.3 mswin32)
ruby-debug-ide (0.4.5)
ruby_core_source (0.1.4)
sqlite3-ruby (1.3.1 x86-mingw32)
thor (0.14.1)
treetop (1.4.8)
tzinfo (0.3.23)

If anybody still facing problem of installing mysql2 gem with rails 3 on
Windows, then refer to the detailed steps of installation on -

http://rorguide.blogspot.com/2011/03/installing-mysql2-gem-on-ruby-192-and.html

1 Like