Bug #4997
closedRake Aborted
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 <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.
Updated by luislavena (Luis Lavena) almost 13 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) almost 13 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 <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.
Updated by luislavena (Luis Lavena) almost 13 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
Ecomments
(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.