Проблема с gem mysql2 для Ruby on Rails 3.2 под WindowsPerl, Python — блог программиста

Следующая проблема возникла с gem mysql2.

При запуске команды rake db:create система возвращала ошибку:

C:\Documents and Settings\user\ruby\app>rake db:create
rake aborted!
cannot load such file -- mysql2/2.0/mysql2
C:/Documents and Settings/user/ruby/app/config/application.rb:7:in `<top
(required)>'
C:/Documents and Settings/user/ruby/app/Rakefile:5:in `<top (required)>'
(See full trace by running task with --trace)

C:\Documents and Settings\user\ruby\app>rake db:create

rake aborted!

cannot load such file -- mysql2/2.0/mysql2

C:/Documents and Settings/user/ruby/app/config/application.rb:7:in `<top

(required)>'

C:/Documents and Settings/user/ruby/app/Rakefile:5:in `<top (required)>'

(See full trace by running task with --trace)

А при попытке создать модель, другую:

C:\Documents and Settings\user\ruby\app>rails generate model User name:st
ring hashed_password:string salt:string
C:/Ruby200/lib/ruby/gems/2.0.0/gems/mysql2-0.3.11-x86-mingw32/lib/mysql2/mysql2.
rb:2:in `require': cannot load such file -- mysql2/2.0/mysql2 (LoadError)
        from C:/Ruby200/lib/ruby/gems/2.0.0/gems/mysql2-0.3.11-x86-mingw32/lib/m
ysql2/mysql2.rb:2:in `<top (required)>'
        from C:/Ruby200/lib/ruby/gems/2.0.0/gems/mysql2-0.3.11-x86-mingw32/lib/m
ysql2.rb:9:in `require'
        from C:/Ruby200/lib/ruby/gems/2.0.0/gems/mysql2-0.3.11-x86-mingw32/lib/m
ysql2.rb:9:in `<top (required)>'
        from C:/Ruby200/lib/ruby/gems/2.0.0/gems/bundler-1.3.5/lib/bundler/runti
me.rb:72:in `require'
        from C:/Ruby200/lib/ruby/gems/2.0.0/gems/bundler-1.3.5/lib/bundler/runti
me.rb:72:in `block (2 levels) in require'

C:\Documents and Settings\user\ruby\app>rails generate model User name:st

ring hashed_password:string salt:string

C:/Ruby200/lib/ruby/gems/2.0.0/gems/mysql2-0.3.11-x86-mingw32/lib/mysql2/mysql2.

rb:2:in `require': cannot load such file -- mysql2/2.0/mysql2 (LoadError)

from C:/Ruby200/lib/ruby/gems/2.0.0/gems/mysql2-0.3.11-x86-mingw32/lib/m

ysql2/mysql2.rb:2:in `<top (required)>'

from C:/Ruby200/lib/ruby/gems/2.0.0/gems/mysql2-0.3.11-x86-mingw32/lib/m

ysql2.rb:9:in `require'

from C:/Ruby200/lib/ruby/gems/2.0.0/gems/mysql2-0.3.11-x86-mingw32/lib/m

ysql2.rb:9:in `<top (required)>'

from C:/Ruby200/lib/ruby/gems/2.0.0/gems/bundler-1.3.5/lib/bundler/runti

me.rb:72:in `require'

from C:/Ruby200/lib/ruby/gems/2.0.0/gems/bundler-1.3.5/lib/bundler/runti

me.rb:72:in `block (2 levels) in require'

Решение проблемы:

Скачать файл отсюда

http://dev.mysql.com/get/Downloads/Connector-C/mysql-connector-c-noinstall-6.0.2-win32.zip/from/pick

Эту ссылку (или похожую) вы получите, если попробуете запустить команду

C:\Documents and Settings\user\ruby\app>gem install mysql2

============================================================================

  You've installed the binary version of mysql2.
  It was built using MySQL Connector/C version 6.0.2.
  It's recommended to use the exact same version to avoid potential issues.

  At the time of building this gem, the necessary DLL files where available
  in the following download:

  http://dev.mysql.com/get/Downloads/Connector-C/mysql-connector-c-noinstall-6.0
.2-win32.zip/from/pick

  And put lib\libmysql.dll file in your Ruby bin directory, for example C:\Ruby\
bin

C:\Documents and Settings\user\ruby\app>gem install mysql2

============================================================================

You've installed the binary version of mysql2.

It was built using MySQL Connector/C version 6.0.2.

It's recommended to use the exact same version to avoid potential issues.

At the time of building this gem, the necessary DLL files where available

in the following download:

http://dev.mysql.com/get/Downloads/Connector-C/mysql-connector-c-noinstall-6.0

.2-win32.zip/from/pick

And put lib\libmysql.dll file in your Ruby bin directory, for example C:\Ruby\

bin

Полученный архив распаковать в корневой каталог ruby:

C:\Ruby200\mysql-connector-c-noinstall-6.0.2-win32

1	C:\Ruby200\mysql-connector-c-noinstall-6.0.2-win32

Внутри каталога получится примерно такая структура:

C:\Ruby200\mysql-connector-c-noinstall-6.0.2-win32>dir

 Содержимое папки C:\Ruby200\mysql-connector-c-noinstall-6.0.2-win32

15.05.2013  19:21    <DIR>          .
15.05.2013  19:21    <DIR>          ..
15.05.2013  19:21    <DIR>          bin
07.08.2009  19:31            19 071 COPYING
07.08.2009  19:31             5 139 EXCEPTIONS-CLIENT
15.05.2013  19:21    <DIR>          include
15.05.2013  19:21    <DIR>          lib
07.08.2009  19:31             1 178 README
               3 файлов         25 388 байт
               5 папок  112 954 019 840 байт свободно

C:\Ruby200\mysql-connector-c-noinstall-6.0.2-win32>dir

Содержимое папки C:\Ruby200\mysql-connector-c-noinstall-6.0.2-win32

15.05.2013 19:21 <DIR> .

15.05.2013 19:21 <DIR> ..

15.05.2013 19:21 <DIR> bin

07.08.2009 19:31 19 071 COPYING

07.08.2009 19:31 5 139 EXCEPTIONS-CLIENT

15.05.2013 19:21 <DIR> include

15.05.2013 19:21 <DIR> lib

07.08.2009 19:31 1 178 README

3 файлов 25 388 байт

5 папок 112 954 019 840 байт свободно

Выполнить команду для удаления некорректно установленной версии mysql2

C:\Documents and Settings\user\ruby\app>gem uninstall mysql2 Successfully uninstalled mysql2-0.3.11-x86-mingw32

1
2

C:\Documents and Settings\user\ruby\app>gem uninstall mysql2
Successfully uninstalled mysql2-0.3.11-x86-mingw32

Установить gem mysql2 заново, указав в параметрах пути к скачанным библиотекам

gem install mysql2 --platform=ruby -- '
--with-mysql-lib="C:\Ruby200\mysql-connector-c-noinstall-6.0.2-win32\lib" 
--with-mysql-include="C:\Ruby200\mysql-connector-c-noinstall-6.0.2-win32\include" 
--with-mysql-dir="C:\Ruby200\mysql-connector-c-noinstall-6.0.2-win32"'

gem install mysql2 --platform=ruby -- '

--with-mysql-lib="C:\Ruby200\mysql-connector-c-noinstall-6.0.2-win32\lib"

--with-mysql-include="C:\Ruby200\mysql-connector-c-noinstall-6.0.2-win32\include"

--with-mysql-dir="C:\Ruby200\mysql-connector-c-noinstall-6.0.2-win32"'

Заметка: узнать версию Ruby On Rails можно с помощью команды rails -v.
Узнать версию Ruby: ruby -v .

Полезная ссылка:

Мигрируем на Ruby 2.0 и Rails 4 в Windows