evan__zhang 2009-07-01 09:47
浏览 294
已采纳

ror:关于数据库迁移

当我进么数据库迁移时，它显示：

rake aborted!
Client does not support authentication protocol requested by server; consider upgrading MySQL client

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

请问是什么原因造成的，怎么解决？

谢谢

[b]问题补充：[/b]
试过了，没有用啊
[b]问题补充：[/b]
当我执行 rake db:migrate --trace 时，显示：

rake aborted!
No Rakefile found (looking for: rakefile, Rakefile, rakefile.rb, Rakefile.rb)
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2377:in raw_load_rakefile'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2017:inload_rakefile'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2068:in standard_exception_handling'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2016:inload_rakefile'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2000:in run'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2068:instandard_exception_handling'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:1998:in run'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/bin/rake:31
/usr/bin/rake:19:inload'
/usr/bin/rake:19

还有就是ruby-mysql找不到这个资源啊
[b]问题补充：[/b]
我的是ubuntu9.04,迁移是在netbeans6.5里面直接右击迁的，在命令行执行时，它显示：

rake aborted!
No Rakefile found (looking for: rakefile, Rakefile, rakefile.rb, Rakefile.rb)
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2377:in `raw_load_rakefile'
(See full trace by running task with --trace)

rake是在当前的项目下执行的
[b]问题补充：[/b]
在NetBeans里面用鼠标进行迁移操作时是：

rake aborted!
Client does not support authentication protocol requested by server; consider upgrading MySQL client

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

－－trace

(in /home/evan/Eshop/Eshop)
** Invoke db:migrate (first_time)
** Invoke environment (first_time)
** Execute environment
rake aborted!
** Execute db:migrate
Client does not support authentication protocol requested by server; consider upgrading MySQL client
/usr/lib/ruby/1.8/mysql.rb:453:in read'
/usr/lib/ruby/1.8/mysql.rb:130:inreal_connect'
/var/lib/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/mysql_adapter.rb:548:in connect'
/var/lib/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/mysql_adapter.rb:198:ininitialize'
/var/lib/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/mysql_adapter.rb:74:in new'
/var/lib/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/mysql_adapter.rb:74:inmysql_connection'
/var/lib/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:223:in send'
/var/lib/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:223:innew_connection'
/var/lib/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:245:in checkout_new_connection'
/var/lib/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:188:incheckout'
/var/lib/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:184:in loop'
/var/lib/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:184:incheckout'
/usr/lib/ruby/1.8/monitor.rb:242:in synchronize'
/var/lib/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:183:incheckout'
/var/lib/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:98:in connection'
/var/lib/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:326:inretrieve_connection'
/var/lib/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:121:in retrieve_connection'
/var/lib/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:113:inconnection'
/var/lib/gems/1.8/gems/activerecord-2.2.2/lib/active_record/migration.rb:429:in initialize'
/var/lib/gems/1.8/gems/activerecord-2.2.2/lib/active_record/migration.rb:394:innew'
/var/lib/gems/1.8/gems/activerecord-2.2.2/lib/active_record/migration.rb:394:in up'
/var/lib/gems/1.8/gems/activerecord-2.2.2/lib/active_record/migration.rb:377:inmigrate'
/var/lib/gems/1.8/gems/rails-2.2.2/lib/tasks/databases.rake:111
/var/lib/gems/1.8/gems/rake-0.8.7/lib/rake.rb:636:in call'
/var/lib/gems/1.8/gems/rake-0.8.7/lib/rake.rb:636:inexecute'
/var/lib/gems/1.8/gems/rake-0.8.7/lib/rake.rb:631:in each'
/var/lib/gems/1.8/gems/rake-0.8.7/lib/rake.rb:631:inexecute'
/var/lib/gems/1.8/gems/rake-0.8.7/lib/rake.rb:597:in invoke_with_call_chain'
/usr/lib/ruby/1.8/monitor.rb:242:insynchronize'
/var/lib/gems/1.8/gems/rake-0.8.7/lib/rake.rb:590:in invoke_with_call_chain'
/var/lib/gems/1.8/gems/rake-0.8.7/lib/rake.rb:583:ininvoke'
/var/lib/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2051:in invoke_task'
/var/lib/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:intop_level'
/var/lib/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in each'
/var/lib/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:intop_level'
/var/lib/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2068:in standard_exception_handling'
/var/lib/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2023:intop_level'
/var/lib/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2001:in run'
/var/lib/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2068:instandard_exception_handling'
/var/lib/gems/1.8/gems/rake-0.8.7/lib/rake.rb:1998:in run'
/var/lib/gems/1.8/gems/rake-0.8.7/bin/rake:31
/usr/bin/rake:19:inload'
/usr/bin/rake:19

###################################

而在命令行执行时，则：

rake aborted!
No Rakefile found (looking for: rakefile, Rakefile, rakefile.rb, Rakefile.rb)
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2377:in raw_load_rakefile'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2017:inload_rakefile'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2068:in standard_exception_handling'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2016:inload_rakefile'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2000:in run'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2068:instandard_exception_handling'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:1998:in run'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/bin/rake:31
/usr/bin/rake:19:inload'
/usr/bin/rake:19

[b]问题补充：[/b]
原因，我也不知道，正在找
[b]问题补充：[/b]
执行sudo gem install mysql 显示：

Building native extensions. This could take a while...
Successfully installed mysql-2.7
1 gem installed
Installing ri documentation for mysql-2.7...
Installing RDoc documentation for mysql-2.7...

然后在NetBeans中迁移，结果还是一样

  • 写回答

9条回答 默认 最新

  • horace_lee 2009-07-01 11:01
    关注

    通常情况下：
    如果不是，mysql的问题，那么Rails这边 rake db:migrate就几个事要注意

    1. mysql的ruby驱动和匹配问题 [code="ruby"]gem install ruby-mysql[/code]
    2. database.yml文件

    暂时，想到这些

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(8条)

报告相同问题？

悬赏问题

  • ¥15 安卓adb backup备份应用数据失败
  • ¥15 eclipse运行项目时遇到的问题
  • ¥15 关于#c##的问题：最近需要用CAT工具Trados进行一些开发
  • ¥15 南大pa1 小游戏没有界面，并且报了如下错误，尝试过换显卡驱动，但是好像不行
  • ¥15 没有证书，nginx怎么反向代理到只能接受https的公网网站
  • ¥50 成都蓉城足球俱乐部小程序抢票
  • ¥15 yolov7训练自己的数据集
  • ¥15 esp8266与51单片机连接问题(标签-单片机|关键词-串口)（相关搜索：51单片机|单片机|测试代码）
  • ¥15 电力市场出清matlab yalmip kkt 双层优化问题
  • ¥30 ros小车路径规划实现不了，如何解决？(操作系统-ubuntu)