Redmine 2.0.3 / Ruby 1.9.3 / rails 3.2.6 / libmysql.dll incompatibility

I'm trying to install Redmine 2.0.3 with Ruby 1.9.3 and rails 3.2.6 but was stopped at MySQL step.

When I execute
rake db:migrate

I receive this

D:\apps\redmine>rake db:migrate RAILS_ENV=production
rake aborted!
Incorrect MySQL client library version! This gem was compiled for 6.0.0 but the
client library is 5.5.25.

Tasks: TOP => db:migrate => environment
(See full trace by running task with --trace)

I did a lot of google searching and reading but did not find any solution by now... I did not find proper libmysql.dll (with proper version). How to resolve this?

Replies (5)

RE: Redmine 2.0.3 / Ruby 1.9.3 / rails 3.2.6 / libmysql.dll incompatibility - Added by Ivan Cenov almost 13 years ago

P.S.

I returned to mysql and was able to proceed forward. To do this, I put in Gemfile.local

gem "mysql"

RE: Redmine 2.0.3 / Ruby 1.9.3 / rails 3.2.6 / libmysql.dll incompatibility - Added by he sheng over 12 years ago

my evn:

Rails 3.2.8
ruby 1.9.2p290 (2011-07-09) [i386-mingw32]

follow your solution :
where is Gemfile.local?

RE: Redmine 2.0.3 / Ruby 1.9.3 / rails 3.2.6 / libmysql.dll incompatibility - Added by Ivan Cenov over 12 years ago

he sheng wrote:

my evn:

Rails 3.2.8

ruby 1.9.2p290 (2011-07-09) [i386-mingw32]

follow your solution :
where is Gemfile.local?

Gemfile.local resides in the root directory of Redmine. If there is no such file, create it.

RE: Redmine 2.0.3 / Ruby 1.9.3 / rails 3.2.6 / libmysql.dll incompatibility - Added by Ivan Cenov over 12 years ago

My "solution" is not a solution. See http://www.redmine.org/boards/1/topics/32693 instead.
You have to use mysql2. Download it from http://dev.mysql.com/downloads/connector/c/ . You need mysql-connector-c-noinstall-6.0.2-win32.zip. From above link:

5. before you go to creating the database things in step 5 of the RedmineInstall you need to include the MySQL Connector for MySQL2 gem. If you get an error later on saying to install "activerecord-mysql2-adapter" do NOT install it since it will cause other things to break. The error simply means that the connector you are trying to use does not work. I found a working connector from http://dev.mysql.com/downloads/connector/c/ and I used the mysql-connector-c-noinstall-6.0.2-win32.zip version. Download the .zip file since you only need to copy libmysql.dll inside the lib folder in that .zip file to your Ruby bin folder.

RE: Redmine 2.0.3 / Ruby 1.9.3 / rails 3.2.6 / libmysql.dll incompatibility - Added by he sheng over 12 years ago

thank your answer asap, and I still get error, I have take bundle install --without development test rmagick , It's work out

(1-5/5)

Project

General

Profile

Redmine