Bug #4997: Rake Aborted

• Status: Third Party's Issue
• Assignee: -
• Target version: -
• ruby -v: ruby 1.9.2p180 (2011-02-18) [i386-mingw32]

[sabsosa (Eseosa Oshodin)]

When I run the command "Rake db:create" on the command prompt and type in my password for my mysql, I usually get the following bug issues.

rake aborted!
Access denied for user 'root'@'localhost' (using password: YES)
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.1/lib/active_record/connect
ion_adapters/mysql_adapter.rb:600:in real_connect' C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.1/lib/active_record/connect ion_adapters/mysql_adapter.rb:600:in connect'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.1/lib/active_record/connect
ion_adapters/mysql_adapter.rb:164:in initialize' C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.1/lib/active_record/connect ion_adapters/mysql_adapter.rb:36:in new'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.1/lib/active_record/connect
ion_adapters/mysql_adapter.rb:36:in mysql_connection' C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.1/lib/active_record/connect ion_adapters/abstract/connection_pool.rb:230:in new_connection'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.1/lib/active_record/connect
ion_adapters/abstract/connection_pool.rb:238:in checkout_new_connection' C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.1/lib/active_record/connect ion_adapters/abstract/connection_pool.rb:194:in block (2 levels) in checkout'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.1/lib/active_record/connect
ion_adapters/abstract/connection_pool.rb:190:in loop' C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.1/lib/active_record/connect ion_adapters/abstract/connection_pool.rb:190:in block in checkout'
C:/Ruby192/lib/ruby/1.9.1/monitor.rb:201:in mon_synchronize' C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.1/lib/active_record/connect ion_adapters/abstract/connection_pool.rb:189:in checkout'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.1/lib/active_record/connect
ion_adapters/abstract/connection_pool.rb:96:in connection' C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.1/lib/active_record/connect ion_adapters/abstract/connection_pool.rb:318:in retrieve_connection'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.1/lib/active_record/connect
ion_adapters/abstract/connection_specification.rb:97:in retrieve_connection' C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.1/lib/active_record/connect ion_adapters/abstract/connection_specification.rb:89:in connection'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.1/lib/active_record/railtie
s/databases.rake:79:in rescue in rescue in create_database' C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.1/lib/active_record/railtie s/databases.rake:66:in rescue in create_database'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.1/lib/active_record/railtie
s/databases.rake:39:in create_database' C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.1/lib/active_record/railtie s/databases.rake:33:in block (2 levels) in <top (required)>'
C:/Ruby192/lib/ruby/1.9.1/rake.rb:634:in call' C:/Ruby192/lib/ruby/1.9.1/rake.rb:634:in block in execute'
C:/Ruby192/lib/ruby/1.9.1/rake.rb:629:in each' C:/Ruby192/lib/ruby/1.9.1/rake.rb:629:in execute'
C:/Ruby192/lib/ruby/1.9.1/rake.rb:595:in block in invoke_with_call_chain' C:/Ruby192/lib/ruby/1.9.1/monitor.rb:201:in mon_synchronize'
C:/Ruby192/lib/ruby/1.9.1/rake.rb:588:in invoke_with_call_chain' C:/Ruby192/lib/ruby/1.9.1/rake.rb:581:in invoke'
C:/Ruby192/lib/ruby/1.9.1/rake.rb:2041:in invoke_task' C:/Ruby192/lib/ruby/1.9.1/rake.rb:2019:in block (2 levels) in top_level'
C:/Ruby192/lib/ruby/1.9.1/rake.rb:2019:in each' C:/Ruby192/lib/ruby/1.9.1/rake.rb:2019:in block in top_level'
C:/Ruby192/lib/ruby/1.9.1/rake.rb:2058:in standard_exception_handling' C:/Ruby192/lib/ruby/1.9.1/rake.rb:2013:in top_level'
C:/Ruby192/lib/ruby/1.9.1/rake.rb:1992:in run' C:/Ruby192/bin/rake:31:in '
C:/Ruby192/bin/rake: [BUG] Segmentation fault
ruby 1.9.2p180 (2011-02-18) [i386-mingw32]

-- control frame ----------
c:0001 p:0000 s:0002 b:0002 l:000f44 d:000f44 TOP

Kindly assist.

[luislavena (Luis Lavena)]

• Status changed from Open to Third Party's Issue

This is most likely an issue with MySQL gem and the incorrect libmysql.dll

The binary version of mysql gem is very specific during the installation about the MySQL DLLs that it requires.

You can avoid downloading and changing your MySQL installation if you instead download MySQL Connector/C and compile MySQL gem locally.

I've covered this in a recent post just to consolidate the knowledge of the wiki articles and posts in the RubyInstaller group:

http://blog.mmediasys.com/2011/07/07/installing-mysql-on-windows-7-x64-and-using-ruby-with-it/

[sabsosa (Eseosa Oshodin)]

I had another error after solving the previous bug. When I run "rake db:migrate" on the command prompt, I got the error below:

Mysql::Error: BLOB/TEXT column 'comment' can't have a default value: CREATE TABL
E comments (id int(11) DEFAULT NULL auto_increment PRIMARY KEY, title varc
har(50) DEFAULT '', comment text DEFAULT '', commentable_id int(11), commen table_type varchar(255), user_id int(11), created_at datetime, updated_at
datetime) ENGINE=InnoDB
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.1/lib/active_record/connect
ion_adapters/abstract_adapter.rb:202:in rescue in log' C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.1/lib/active_record/connect ion_adapters/abstract_adapter.rb:194:in log'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.1/lib/active_record/connect
ion_adapters/mysql_adapter.rb:289:in execute' C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.1/lib/active_record/connect ion_adapters/abstract/schema_statements.rb:167:in create_table'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.1/lib/active_record/connect
ion_adapters/mysql_adapter.rb:445:in create_table' C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.1/lib/active_record/migrati on.rb:383:in block in method_missing'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.1/lib/active_record/migrati
on.rb:359:in block in say_with_time' C:/Ruby192/lib/ruby/1.9.1/benchmark.rb:294:in measure'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.1/lib/active_record/migrati
on.rb:359:in say_with_time' C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.1/lib/active_record/migrati on.rb:379:in method_missing'
C:/Documents and Settings/USER.USER-8D994E82B2/rails-app/cfi-aberdeen/db/migrate
/20100524135913_create_comments.rb:3:in up' C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.1/lib/active_record/migrati on.rb:312:in block in migrate'
C:/Ruby192/lib/ruby/1.9.1/benchmark.rb:294:in measure' C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.1/lib/active_record/migrati on.rb:312:in migrate'
C:in migrate' C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.1/lib/active_record/migrati on.rb:537:in block (2 levels) in migrate'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.1/lib/active_record/migrati
on.rb:613:in call' C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.1/lib/active_record/migrati on.rb:613:in ddl_transaction'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.1/lib/active_record/migrati
on.rb:536:in block in migrate' C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.1/lib/active_record/migrati on.rb:523:in each'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.1/lib/active_record/migrati
on.rb:523:in migrate' C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.1/lib/active_record/migrati on.rb:433:in up'
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.1/lib/active_record/migrati
on.rb:415:in migrate' C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.1/lib/active_record/railtie s/databases.rake:142:in block (2 levels) in <top (required)>'
C:/Ruby192/lib/ruby/1.9.1/rake.rb:634:in call' C:/Ruby192/lib/ruby/1.9.1/rake.rb:634:in block in execute'
C:/Ruby192/lib/ruby/1.9.1/rake.rb:629:in each' C:/Ruby192/lib/ruby/1.9.1/rake.rb:629:in execute'
C:/Ruby192/lib/ruby/1.9.1/rake.rb:595:in block in invoke_with_call_chain' C:/Ruby192/lib/ruby/1.9.1/monitor.rb:201:in mon_synchronize'
C:/Ruby192/lib/ruby/1.9.1/rake.rb:588:in invoke_with_call_chain' C:/Ruby192/lib/ruby/1.9.1/rake.rb:581:in invoke'
C:/Ruby192/lib/ruby/1.9.1/rake.rb:2041:in invoke_task' C:/Ruby192/lib/ruby/1.9.1/rake.rb:2019:in block (2 levels) in top_level'
C:/Ruby192/lib/ruby/1.9.1/rake.rb:2019:in each' C:/Ruby192/lib/ruby/1.9.1/rake.rb:2019:in block in top_level'
C:/Ruby192/lib/ruby/1.9.1/rake.rb:2058:in standard_exception_handling' C:/Ruby192/lib/ruby/1.9.1/rake.rb:2013:in top_level'
C:/Ruby192/lib/ruby/1.9.1/rake.rb:1992:in run' C:/Ruby192/bin/rake:31:in <mai...

Please kindly assist.

[luislavena (Luis Lavena)]

Eseosa Oshodin wrote:

I had another error after solving the previous bug. When I run "rake db:migrate" on the command prompt, I got the error below:

Mysql::Error: BLOB/TEXT column 'comment' can't have a default value: CREATE TABL
E comments (id int(11) DEFAULT NULL auto_increment PRIMARY KEY, title varc
har(50) DEFAULT '', comment text DEFAULT '', commentable_id int(11), commen table_type varchar(255), user_id int(11), created_at datetime, updated_at
datetime) ENGINE=InnoDB

This seems to be an error on your table definition. We can't help you on that front because that is not related to Ruby or even Rails, but your application code and design.