Project

General

Profile

Bug #4997

Rake Aborted

Added by sabsosa (Eseosa Oshodin) over 9 years ago. Updated over 9 years ago.

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

Description

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 '
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.

Updated by luislavena (Luis Lavena) over 9 years ago

  • 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/

Updated by sabsosa (Eseosa Oshodin) over 9 years ago

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 '
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.

Updated by luislavena (Luis Lavena) over 9 years ago

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.

Also available in: Atom PDF