I am working on windows 7 32 bit. I came across the same problem. But
for me the below procedure worked great!
1. edit Gemfile => gem 'mysql2', '0.2.6'
2. download mysql-noinstall-5.1.50-win32.zip at
http://downloads.mysql.com/archives/mysql-5.1/mysql-noinstall-5.1.50-...
,unzip
3. gem install mysql2 -v 0.2.6 -- --with-mysql-lib=E:\ROR
\mysql-5.1.50-win32\lib --with-mysql-include=E:\ROR\mysql-5.1.50-
win32\include (replace the file "E:\ROR\mysql-5.1.50-win32" path
with
yours)
4. this should work now,try bundle install,generate some
model ,and run rake db:migrate to see if it works,make sure your
database config is right,like this
development:
adapter: mysql2
encoding: utf8
reconnect: false
database: depot_development
pool: 5
username: root
password: root
host: localhost
5.if it still not work ,try this =>
https://github.com/brianmario/mysql2/issues/8
On Sep 19, 5:00 pm, Rajarshi <[email protected]> wrote:
> why mysql2
>
> just install mysql-server
> mysql clint
> and libmysqldev
>
> other libraries
> then install mysql gem 2.8.1
>
> it will run
>
> no required mysql2
>
> On Mon, Sep 19, 2011 at 5:26 PM, venkata reddy
> <[email protected]>wrote:
>
>
>
>
>
>
>
>
>
> > That might be because of the mysql2 adapter is missing
> > let me know your environment details including os..
>
> > On Sep 19, 4:52 pm, ben_hawk <[email protected]> wrote:
> > > :( nope dint work, this gives me the error
>
> > > Bens-MacBook-Pro:sharebox bengibson$ bundle install
> > > Fetching source index forhttp://rubygems.org/
> > > Using rake (0.9.2)
> > > Using abstract (1.0.0)
> > > Using activesupport (3.0.3)
> > > Using builder (2.1.2)
> > > Using i18n (0.6.0)
> > > Using activemodel (3.0.3)
> > > Using erubis (2.6.6)
> > > Using rack (1.2.3)
> > > Using rack-mount (0.6.14)
> > > Using rack-test (0.5.7)
> > > Using tzinfo (0.3.29)
> > > Using actionpack (3.0.3)
> > > Using mime-types (1.16)
> > > Using polyglot (0.3.2)
> > > Using treetop (1.4.10)
> > > Using mail (2.2.19)
> > > Using actionmailer (3.0.3)
> > > Using arel (2.0.10)
> > > Using activerecord (3.0.3)
> > > Using activeresource (3.0.3)
> > > Using bundler (1.0.18)
> > > Installing mysql (2.8.1) with native extensions
>
> > /Users/bengibson/.rvm/rubies/ruby-1.9.2-p290/lib/ruby/site_ruby/1.9.1/rubyg
> > ems/installer.rb:552:in
> > > `rescue in block in build_extensions': ERROR: Failed to build gem native
> > > extension. (Gem::Installer::ExtensionBuildError)
>
> > > /Users/bengibson/.rvm/rubies/ruby-1.9.2-p290/bin/ruby extconf.rb
> > > 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
> > > --srcdir=.
> > > --curdir
> > > --ruby=/Users/bengibson/.rvm/rubies/ruby-1.9.2-p290/bin/ruby
> > > --with-mysql-config
> > > --without-mysql-config
> > > --with-mysql-dir
> > > --without-mysql-dir
> > > --with-mysql-include
> > > --without-mysql-include=${mysql-dir}/include
> > > --with-mysql-lib
> > > --without-mysql-lib=${mysql-dir}/lib
> > > --with-mysqlclientlib
> > > --without-mysqlclientlib
> > > --with-mlib
> > > --without-mlib
> > > --with-mysqlclientlib
> > > --without-mysqlclientlib
> > > --with-zlib
> > > --without-zlib
> > > --with-mysqlclientlib
> > > --without-mysqlclientlib
> > > --with-socketlib
> > > --without-socketlib
> > > --with-mysqlclientlib
> > > --without-mysqlclientlib
> > > --with-nsllib
> > > --without-nsllib
> > > --with-mysqlclientlib
> > > --without-mysqlclientlib
> > > --with-mygcclib
> > > --without-mygcclib
> > > --with-mysqlclientlib
> > > --without-mysqlclientlib
>
> > > Gem files will remain installed in
> > > /Users/bengibson/Documents/sharebox/rails/ruby/1.9.1/gems/mysql-2.8.1 for
> > > inspection.
> > > Results logged to
>
> > /Users/bengibson/Documents/sharebox/rails/ruby/1.9.1/gems/mysql-2.8.1/ext/m
> > ysql_api/gem_make.out
> > > from
>
> > /Users/bengibson/.rvm/rubies/ruby-1.9.2-p290/lib/ruby/site_ruby/1.9.1/rubyg
> > ems/installer.rb:530:in
> > > `block in build_extensions'
> > > from
>
> > /Users/bengibson/.rvm/rubies/ruby-1.9.2-p290/lib/ruby/site_ruby/1.9.1/rubyg
> > ems/installer.rb:505:in
> > > `each'
> > > from
>
> > /Users/bengibson/.rvm/rubies/ruby-1.9.2-p290/lib/ruby/site_ruby/1.9.1/rubyg
> > ems/installer.rb:505:in
> > > `build_extensions'
> > > from
>
> > /Users/bengibson/.rvm/rubies/ruby-1.9.2-p290/lib/ruby/site_ruby/1.9.1/rubyg
> > ems/installer.rb:180:in
> > > `install'
> > > from
>
> > /Users/bengibson/.rvm/gems/ruby-1.9.2-p290/gems/bundler-1.0.18/lib/bundler/
> > source.rb:101:in
> > > `block in install'
> > > from
>
> > /Users/bengibson/.rvm/gems/ruby-1.9.2-p290/gems/bundler-1.0.18/lib/bundler/
> > rubygems_integration.rb:78:in
> > > `preserve_paths'
> > > from
>
> > /Users/bengibson/.rvm/gems/ruby-1.9.2-p290/gems/bundler-1.0.18/lib/bundler/
> > source.rb:91:in
> > > `install'
> > > from
>
> > /Users/bengibson/.rvm/gems/ruby-1.9.2-p290/gems/bundler-1.0.18/lib/bundler/
> > installer.rb:58:in
> > > `block (2 levels) in run'
> > > from
>
> > /Users/bengibson/.rvm/gems/ruby-1.9.2-p290/gems/bundler-1.0.18/lib/bundler/
> > rubygems_integration.rb:93:in
> > > `with_build_args'
> > > from
>
> > /Users/bengibson/.rvm/gems/ruby-1.9.2-p290/gems/bundler-1.0.18/lib/bundler/
> > installer.rb:57:in
> > > `block in run'
> > > from
>
> > /Users/bengibson/.rvm/gems/ruby-1.9.2-p290/gems/bundler-1.0.18/lib/bundler/
> > installer.rb:49:in
> > > `run'
> > > from
>
> > /Users/bengibson/.rvm/gems/ruby-1.9.2-p290/gems/bundler-1.0.18/lib/bundler/
> > installer.rb:8:in
> > > `install'
> > > from
>
> > /Users/bengibson/.rvm/gems/ruby-1.9.2-p290/gems/bundler-1.0.18/lib/bundler/
> > cli.rb:220:in
> > > `install'
> > > from
>
> > /Users/bengibson/.rvm/gems/ruby-1.9.2-p290/gems/bundler-1.0.18/lib/bundler/
> > vendor/thor/task.rb:22:in
> > > `run'
> > > from
>
> > /Users/bengibson/.rvm/gems/ruby-1.9.2-p290/gems/bundler-1.0.18/lib/bundler/
> > vendor/thor/invocation.rb:118:in
> > > `invoke_task'
> > > from
>
> > /Users/bengibson/.rvm/gems/ruby-1.9.2-p290/gems/bundler-1.0.18/lib/bundler/
> > vendor/thor.rb:263:in
> > > `dispatch'
> > > from
>
> > /Users/bengibson/.rvm/gems/ruby-1.9.2-p290/gems/bundler-1.0.18/lib/bundler/
> > vendor/thor/base.rb:386:in
> > > `start'
> > > from
>
> > /Users/bengibson/.rvm/gems/ruby-1.9.2-p290/gems/bundler-1.0.18/bin/bundle:1
> > 3:in
> > > `<top (required)>'
> > > from /Users/bengibson/.rvm/gems/ruby-1.9.2-p290/bin/bundle:19:in
> > `load'
> > > from /Users/bengibson/.rvm/gems/ruby-1.9.2-p290/bin/bundle:19:in
> > `<main>'
> > > Bens-MacBook-Pro:sharebox bengibson$
>
> > > Rajarshi-3 wrote:
>
> > > > Use gem 'mysql'
>
> > > > On Mon, Sep 19, 2011 at 5:13 PM, Rajarshi <[email protected]> wrote:
>
> > > >> TRY rake fuck
>
> > > >> On Mon, Sep 19, 2011 at 5:01 PM, venkata reddy
> > > >> <[email protected]>wrote:
>
> > > >>> Try "bundle exec rake db:migrate"
>
> > > >>> On Sep 19, 4:17 pm, ben_hawk <[email protected]> wrote:
> > > >>> > Hi,
>
> > > >>> > I followed a Tutorial on Nettuts to install Ruby with RVM and this
> > > >>> went
> > > >>> > well. I then tried to install Rails to follow the 'How to build a
> > > >>> dropbox
> > > >>> > live service' from Netttus but appear to get errors can anybody
> > help?.
>
> > > >>> > Once I installed rails I created a new rails project using the
> > command
>
> > > >>> > (Rails new sharebox -d mysql)
>
> > > >>> > This worked and created the folder structure.
>
> > > >>> > I then went and added the following to the gem folder for the
> > project
> > > >>> as
> > > >>> > suggested by the netuts tutorial
>
> > > >>> > source 'http://rubygems.org'
>
> > > >>> > gem 'rails', '3.0.3'
> > > >>> > gem 'ruby-mysql'
>
> > > >>> > I then did the bundle install but this kept causing errors,
> > eventually
> > > >>> > somehow I got this to work and it said bundle installed correctly.
>
> > > >>> > However when I try the command rails server i get the following
> > error:
>
> > /Users/bengibson/.rvm/rubies/ruby-1.9.2-p290/lib/ruby/site_ruby/1.9.1/rubyg
> > > >>> ems/dependency.rb:247:in
> > > >>> > `to_specs': Could not find abstract (>= 1.0.0) amongst
> > > >>> [actionmailer-3.1.0,
> > > >>> > actionmailer-3.0.3, actionpack-3.1.0, actionpack-3.0.3,
> > > >>> activemodel-3.1.0,
> > > >>> > activemodel-3.0.3, activerecord-3.1.0, activerecord-3.0.3,
> > > >>> > activeresource-3.1.0, activeresource-3.0.3, activesupport-3.1.0,
> > > >>> > activesupport-3.0.3, ansi-1.3.0, arel-2.2.1, arel-2.0.10,
> > > >>> bcrypt-ruby-3.0.1,
> > > >>> > builder-3.0.0, builder-2.1.2, bundler-1.0.18, coffee-rails-3.1.1,
> > > >>> > coffee-script-2.2.0, coffee-script-source-1.1.2, erubis-2.7.0,
> > > >>> erubis-2.6.6,
> > > >>> > execjs-1.2.6, hike-1.2.1, i18n-0.6.0, jquery-rails-1.0.14,
> > mail-2.3.0,
> > > >>> > mail-2.2.19, mime-types-1.16, multi_json-1.0.3, mysql2-0.3.7,
> > > >>> > polyglot-0.3.2, rack-1.3.2, rack-1.2.3, rack-cache-1.0.3,
> > > >>> rack-mount-0.8.3,
> > > >>> > rack-mount-0.6.14, rack-ssl-1.3.2, rack-test-0.6.1,
> > rack-test-0.5.7,
> > > >>> > rails-3.0.3, railties-3.1.0, railties-3.0.3, rake-0.9.2,
> > rdoc-3.9.4,
> > > >>> > rdoc-2.5.11, rdoc-data-2.5.3, sass-3.1.7, sass-rails-3.1.1,
> > > >>> sprockets-2.0.0,
> > > >>> > thor-0.14.6, tilt-1.3.3, treetop-1.4.10, turn-0.8.2, tzinfo-0.3.29,
> > > >>> > uglifier-1.0.3] (Gem::LoadError)
> > > >>> > from
>
> > /Users/bengibson/.rvm/rubies/ruby-1.9.2-p290/lib/ruby/site_ruby/1.9.1/rubyg
> > > >>> ems/specification.rb:761:in
> > > >>> > `block in activate_dependencies'
> > > >>> > from
>
> > /Users/bengibson/.rvm/rubies/ruby-1.9.2-p290/lib/ruby/site_ruby/1.9.1/rubyg
> > > >>> ems/specification.rb:758:in
> > > >>> > `each'
> > > >>> > from
>
> > /Users/bengibson/.rvm/rubies/ruby-1.9.2-p290/lib/ruby/site_ruby/1.9.1/rubyg
> > > >>> ems/specification.rb:758:in
> > > >>> > `activate_dependencies'
> > > >>> > from
>
> ...
>
> read more »
--
You received this message because you are subscribed to the Google Groups "Ruby
on Rails: Talk" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.
