无法加载这样的文件-- mysql2 2/2.4/mysql2 2 (LoadError)

Question

我是Ruby On Rails的新手。我一直试图使用rails创建一个名为BookGenerateModelBook命令的模型，但是我得到了以下错误消息：

F:\Faizul\Noah-Data\Backup\Ruby\Rails App\library>rails generate model Book
C:/Ruby24-x64/lib/ruby/gems/2.4.0/gems/mysql2-0.4.10-x64-mingw32/lib/mysql2/mysql2.rb:2:in `require': cannot load such file -- mysql2/2.4/mysql2 (LoadError)
        from C:/Ruby24-x64/lib/ruby/gems/2.4.0/gems/mysql2-0.4.10-x64-mingw32/lib/mysql2/mysql2.rb:2:in `<top (required)>'
        from C:/Ruby24-x64/lib/ruby/gems/2.4.0/gems/mysql2-0.4.10-x64-mingw32/lib/mysql2.rb:31:in `require'
        from C:/Ruby24-x64/lib/ruby/gems/2.4.0/gems/mysql2-0.4.10-x64-mingw32/lib/mysql2.rb:31:in `<top (required)>'
        from C:/Ruby24-x64/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/lib/bundler/runtime.rb:81:in `require'
        from C:/Ruby24-x64/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/lib/bundler/runtime.rb:81:in `block (2 levels) in require'
        from C:/Ruby24-x64/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/lib/bundler/runtime.rb:76:in `each'
        from C:/Ruby24-x64/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/lib/bundler/runtime.rb:76:in `block in require'
        from C:/Ruby24-x64/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/lib/bundler/runtime.rb:65:in `each'
        from C:/Ruby24-x64/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/lib/bundler/runtime.rb:65:in `require'
        from C:/Ruby24-x64/lib/ruby/gems/2.4.0/gems/bundler-1.16.1/lib/bundler.rb:114:in `require'
        from F:/Faizul/Noah-Data/Backup/Ruby/Rails App/library/config/application.rb:7:in `<top (required)>'
        from C:/Ruby24-x64/lib/ruby/gems/2.4.0/gems/railties-5.1.4/lib/rails/command/actions.rb:15:in `require'
        from C:/Ruby24-x64/lib/ruby/gems/2.4.0/gems/railties-5.1.4/lib/rails/command/actions.rb:15:in `require_application_and_environment!'
        from C:/Ruby24-x64/lib/ruby/gems/2.4.0/gems/railties-5.1.4/lib/rails/commands/generate/generate_command.rb:19:in `perform'
        from C:/Ruby24-x64/lib/ruby/gems/2.4.0/gems/thor-0.20.0/lib/thor/command.rb:27:in `run'
        from C:/Ruby24-x64/lib/ruby/gems/2.4.0/gems/thor-0.20.0/lib/thor/invocation.rb:126:in `invoke_command'
        from C:/Ruby24-x64/lib/ruby/gems/2.4.0/gems/thor-0.20.0/lib/thor.rb:387:in `dispatch'
        from C:/Ruby24-x64/lib/ruby/gems/2.4.0/gems/railties-5.1.4/lib/rails/command/base.rb:63:in `perform'
        from C:/Ruby24-x64/lib/ruby/gems/2.4.0/gems/railties-5.1.4/lib/rails/command.rb:44:in `invoke'
        from C:/Ruby24-x64/lib/ruby/gems/2.4.0/gems/railties-5.1.4/lib/rails/commands.rb:16:in `<top (required)>'
        from bin/rails:4:in `require'
        from bin/rails:4:in `<main>'

采取了以下行动来解决这一问题，但失败了：

• 卸载mysql2
• 使用mysql2安装 mysql2命令
• 在我的Gemfile中添加了“msql2”
• 配置的database.yml文件如下：

default：&default适配器: mysql2池：<%= ENV.fetch("RAILS_MAX_THREADS") {5} %>超时值: 5000开发:适配器: mysql2数据库: library_development用户名:根密码:根主机端口: 3309测试:适配器: mysql2数据库: library_test用户名:根密码:根主机: localhost端口: 3309生产:适配器: mysql2数据库: library_production用户名: root密码: root主机: localhost : 3309

Answer 1

目前，WindowsRuby2.4forWindows没有mysql2二进制文件可用。

有关更多信息，请参见这 github问题，https://github.com/brianmario/mysql2/issues/861

希望这能帮到你。

Answer 2

编译你的mysql评论为我工作https://github.com/brianmario/mysql2/issues/923#issuecomment-361346864

，但请注意，在第3步，，而不是

cd“C：\ruby 24-x64\bin\ruby”extconf.rb -with-MySQL-dir=“C：\Program\MySQL\MySQL Connector.C6.1”

我做到了

“C：\ruby 24-x64\bin\ruby”extconf.rb --with dir=“C：\Program (x86)\MySQL\MySQL Connector.C6.1”

乞讨时没有"cd“，我的连接器在"C:\Program (x86)”文件夹中。

也在第6步I复制

C:\Ruby24-x64\lib\ruby\gems\2.4.0\gems\mysql2-0.4.10-x64-mingw32\ext\mysql2\mysql2.so

到新创建的文件夹

C:\Ruby24-x64\lib\ruby\gems\2.4.0\gems\mysql2-0.4.10-x64-mingw32\lib\mysql2\2.4

编译过程显示了大量警告，但最终rake db:迁移开始为我工作，您的代码也应该这样做。

Answer 3

请安装Mysql服务器。安装在宝石下面。

Libmysqlclient-dev或Mysql-devl