CODEWITHSUNDEEP
mysqlruby-on-railsrubyubuntu
Aparna V
Aparna V

Reputation: 179

Rails 4.2.2 - mysql2 installation error

In rails 4.2.2 environment, I am trying to run bundle install for one sample project but I am getting an error like below

Gem::Ext::BuildError: ERROR: Failed to build gem native extension.

/home/aparna/.rvm/rubies/ruby-2.2.1/bin/ruby -r ./siteconf20150912- 2709-1b70inv.rb extconf.rb 
checking for rb_thread_blocking_region()... no
checking for rb_wait_for_single_fd()... yes
checking for rb_hash_dup()... yes
checking for rb_intern3()... yes
checking for mysql.h... yes
checking for errmsg.h... yes
checking for mysqld_error.h... yes
creating Makefile

make "DESTDIR=" clean

make "DESTDIR="
compiling mysql2_ext.c
In file included from ./client.h:11:0,
             from ./mysql2_ext.h:39,
             from mysql2_ext.c:1:
/home/aparna/.rvm/rubies/ruby-2.2.1/include/ruby-2.2.0/ruby/backward/rubysig.h:14:2: warning: #warning rubysig.h is obsolete [-Wcpp]
#warning rubysig.h is obsolete
^
In file included from ./mysql2_ext.h:39:0,
             from mysql2_ext.c:1:
./client.h: In function ‘rb_thread_blocking_region’:
./client.h:23:3: error: ‘TRAP_BEG’ undeclared (first use in this function)
TRAP_BEG;
^
./client.h:23:3: note: each undeclared identifier is reported only once for each function it appears in
./client.h:25:3: error: ‘TRAP_END’ undeclared (first use in this function)
TRAP_END;
^
mysql2_ext.c: At top level:
./client.h:16:1: warning: ‘rb_thread_blocking_region’ defined but not used [-Wunused-function]
rb_thread_blocking_region(
^
make: *** [mysql2_ext.o] Error 1

make failed, exit code 2

Gem files will remain installed in /home/aparna/.rvm/gems/ruby-2.2.1/gems/mysql2-0.3.13 for inspection.
Results logged to /home/aparna/.rvm/gems/ruby-2.2.1/extensions/x86_64-linux/2.2.0/mysql2-0.3.13/gem_make.out
An error occurred while installing mysql2 (0.3.13), and Bundler cannot continue.
Make sure that `gem install mysql2 -v '0.3.13'` succeeds before bundling.

Gemfile is,

source 'https://rubygems.org'

gem 'rails', '4.2.0'
gem 'mysql2', '0.3.13'
gem 'sass-rails', '~> 5.0'
gem 'uglifier', '>= 1.3.0'
gem 'coffee-rails', '~> 4.1.0'
gem 'therubyracer', platforms: :ruby

gem 'jquery-rails'
gem 'turbolinks'
gem 'jbuilder', '~> 2.0'
gem 'sdoc', '~> 0.4.0', group: :doc

group :development, :test do
 gem 'byebug'
 gem 'web-console', '~> 2.0'
 gem 'spring'
end

gem 'protected_attributes'

gem 'devise'

gem 'paperclip'
gem "cocaine"

gem "simple_form"

gem "less-rails" #Sprockets (what Rails 3.1 uses for its asset pipeline) supports LESS
gem "twitter-bootstrap-rails"

gem 'kristin'
gem 'docsplit'
gem 'pdf2html'

I have try to install mysql2 then it got installed mysql2 (0.4.0) but this will shows below error while starting a rails server

/home/aparna/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.0/lib/active_record/connection_adapters/connection_specification.rb:177:in `rescue in spec': Specified 'mysql2' for database adapter, but the gem is not loaded. Add `gem 'mysql2'` to your Gemfile (and ensure its version is at the minimum required by ActiveRecord). (Gem::LoadError)

How can I solve mysql2 installation issue?

Upvotes: 4

Views: 3968

Answers (1)

Aleksey Shein
Aleksey Shein

Reputation: 7482

There's a bug in mysql2-0.4.0 version, look into neighbor question

Try to install latest mysql2-0.3.x version:

Change in your Gemfile:

 gem 'mysql2', '~> 0.3.13'

And run

bundle update mysql2

Make sure to stop spring via spring stop and then start rails.

Upvotes: 6

Related Questions