Problem with mysql2 gem and Debian

Hi Guys,

I’m having an issue with deploying my application and the mysql2 gem.
I am developing on Windows 7 with Ruby 1.9.2 and Rails 3.0.3.
On my local machine in development environment the application runs
just fine. But when I want to deploy it on our production server I get
an error message from passenger.

“Please install the mysql2 adapter: gem install activerecord-mysql2- adapter (no such file to load – active_record/connection_adapters/

The server runs with Debian and also Ruby 1.9.2 and Rails 3.0.3.

I’ve already tried manually installing/uninstalling/reinstalling the
mysql2 gem. Different configurations in database.yml. Executing bundle
install as capistrano task and also directly on the server. Always the
same problem.

Next thing I tried was creating a new rails application on the server
with mysql as database. That works just fine…

Here is my Gemfile:

source ‘

gem ‘rails’, ‘3.0.3’

Bundle edge Rails instead:

gem ‘rails’, :git => ‘git://’

gem ‘mysql2’

gem ‘nifty-generators’, :group => :development

gem ‘authlogic’
gem ‘rails3-generators’
gem ‘enumerated_attribute’
gem ‘jquery-rails’, ‘>= 0.2.6’
gem ‘acts_as_list’

group :test, :development do
gem ‘sqlite3-ruby’, :require => ‘sqlite3’
gem ‘rspec-rails’, ‘~> 2.4’
gem ‘autotest’

Deploy with Capistrano

gem ‘capistrano’

gem “mocha”, :group => :test

And the production part of my database.yml

adapter: mysql2
encoding: utf8
reconnect: false
database: rails_project
pool: 5
username: rails
socket: /var/run/mysqld/mysqld.sock

Was here already?

I dunno. I haven’t specified mysql2 in database.yml last time, that’s

all of mysql is bundle into the

sudo gem install mysql you wont need anything else

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs