rake db:migrate problem

mini@mini:~/Sites/music_library$ rake db:migrate rake aborted! couldn't parse YAML at line 28 column 6 /home/mini/my_gems/gems/railties-3.2.9/lib/rails/application/configuration.rb:115:in `database_configuration' /home/mini/my_gems/gems/activerecord-3.2.9/lib/active_record/railtie.rb:78:in `block (2 levels) in <class:Railtie>' /home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:36:in `instance_eval' /home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:36:in `execute_hook' /home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:43:in `block in run_load_hooks' /home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:42:in `each' /home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:42:in `run_load_hooks' /home/mini/my_gems/gems/activerecord-3.2.9/lib/active_record/base.rb:720:in `<top (required)>' /home/mini/my_gems/gems/activerecord-3.2.9/lib/active_record/railties/databases.rake:25:in `block (2 levels) in <top (required)>' Tasks: TOP => db:migrate => db:load_config (See full trace by running task with --trace) mini@mini:~/Sites/music_library$ rake db:migrate rake aborted! couldn't parse YAML at line 28 column 6 /home/mini/my_gems/gems/railties-3.2.9/lib/rails/application/configuration.rb:115:in `database_configuration' /home/mini/my_gems/gems/activerecord-3.2.9/lib/active_record/railtie.rb:78:in `block (2 levels) in <class:Railtie>' /home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:36:in `instance_eval' /home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:36:in `execute_hook' /home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:43:in `block in run_load_hooks' /home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:42:in `each' /home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:42:in `run_load_hooks' /home/mini/my_gems/gems/activerecord-3.2.9/lib/active_record/base.rb:720:in `<top (required)>' /home/mini/my_gems/gems/activerecord-3.2.9/lib/active_record/railties/databases.rake:25:in `block (2 levels) in <top (required)>' Tasks: TOP => db:migrate => db:load_config (See full trace by running task with --trace) mini@mini:~/Sites/music_library$ rake db:migrate rake aborted! couldn't parse YAML at line 28 column 6 /home/mini/my_gems/gems/railties-3.2.9/lib/rails/application/configuration.rb:115:in `database_configuration' /home/mini/my_gems/gems/activerecord-3.2.9/lib/active_record/railtie.rb:78:in `block (2 levels) in <class:Railtie>' /home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:36:in `instance_eval' /home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:36:in `execute_hook' /home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:43:in `block in run_load_hooks' /home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:42:in `each' /home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:42:in `run_load_hooks' /home/mini/my_gems/gems/activerecord-3.2.9/lib/active_record/base.rb:720:in `<top (required)>' /home/mini/my_gems/gems/activerecord-3.2.9/lib/active_record/railties/databases.rake:25:in `block (2 levels) in <top (required)>' Tasks: TOP => db:migrate => db:load_config (See full trace by running task with --trace) mini@mini:~/Sites/music_library$ mini@mini:~/Sites/music_library$ vim mini@mini:~/Sites/music_library$ rake db:migrate rake aborted! syntax error on line 28, col 1: ` host: localhost' /home/mini/my_gems/gems/railties-3.2.9/lib/rails/application/configuration.rb:115:in `database_configuration' /home/mini/my_gems/gems/activerecord-3.2.9/lib/active_record/railtie.rb:78:in `block (2 levels) in <class:Railtie>' /home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:36:in `instance_eval' /home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:36:in `execute_hook' /home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:43:in `block in run_load_hooks' /home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:42:in `each' /home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:42:in `run_load_hooks' /home/mini/my_gems/gems/activerecord-3.2.9/lib/active_record/base.rb:720:in `<top (required)>' /home/mini/my_gems/gems/activerecord-3.2.9/lib/active_record/railties/databases.rake:25:in `block (2 levels) in <top (required)>' Tasks: TOP => db:migrate => db:load_config (See full trace by running task with --trace) mini@mini:~/Sites/music_library$ rake db:migrate --trace ** Invoke db:migrate (first_time) ** Invoke environment (first_time) ** Execute environment ** Invoke db:load_config (first_time) ** Execute db:load_config rake aborted! syntax error on line 28, col 1: ` host: localhost' /usr/lib/ruby/1.9.1/syck.rb:135:in `load' /usr/lib/ruby/1.9.1/syck.rb:135:in `load' /home/mini/my_gems/gems/railties-3.2.9/lib/rails/application/configuration.rb:115:in `database_configuration' /home/mini/my_gems/gems/activerecord-3.2.9/lib/active_record/railtie.rb:78:in `block (2 levels) in <class:Railtie>' /home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:36:in `instance_eval' /home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:36:in `execute_hook' /home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:43:in `block in run_load_hooks' /home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:42:in `each' /home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:42:in `run_load_hooks' /home/mini/my_gems/gems/activerecord-3.2.9/lib/active_record/base.rb:720:in `<top (required)>' /home/mini/my_gems/gems/activerecord-3.2.9/lib/active_record/railties/databases.rake:25:in `block (2 levels) in <top (required)>' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:228:in `call' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:228:in `block in execute' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:223:in `each' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:223:in `execute' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:166:in `block in invoke_with_call_chain' /usr/lib/ruby/1.9.1/monitor.rb:201:in `mon_synchronize' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:159:in `invoke_with_call_chain' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:187:in `block in invoke_prerequisites' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:185:in `each' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:185:in `invoke_prerequisites' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:165:in `block in invoke_with_call_chain' /usr/lib/ruby/1.9.1/monitor.rb:201:in `mon_synchronize' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:159:in `invoke_with_call_chain' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:152:in `invoke' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:143:in `invoke_task' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:101:in `block (2 levels) in top_level' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:101:in `each' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:101:in `block in top_level' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:110:in `run_with_threads' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:95:in `top_level' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:73:in `block in run' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:160:in `standard_exception_handling' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:70:in `run' /home/mini/my_gems/gems/rake-10.0.3/bin/rake:33:in `<top (required)>' /home/mini/my_gems/bin/rake:19:in `load' /home/mini/my_gems/bin/rake:19:in `<main>' Tasks: TOP => db:migrate => db:load_config mini@mini:~/Sites/music_library$ mini@mini:~/Sites/music_library$ quit No command 'quit' found, did you mean: Command 'quilt' from package 'quilt' (main) Command 'luit' from package 'x11-utils' (main) Command 'quot' from package 'quota' (main) Command 'quiz' from package 'bsdgames' (universe) Command 'qgit' from package 'qgit' (universe) Command 'qwit' from package 'qwit' (universe) quit: command not found mini@mini:~/Sites/music_library$ cd mini@mini:~$ irb -r irb/completion irb(main):001:0> puts ((110.to_s * 2).to_i/2) 55055 => nil irb(main):002:0> quit mini@mini:~$ cd Sites mini@mini:~/Sites$ cd music_library/ mini@mini:~/Sites/music_library$ rake db:migrate -

mini@mini:~/Sites/music_library$ rake db:migrate --trace ** Invoke db:migrate (first_time) ** Invoke environment (first_time) ** Execute environment ** Invoke db:load_config (first_time) ** Execute db:load_config rake aborted! couldn't parse YAML at line 28 column 6 /usr/lib/ruby/1.9.1/psych.rb:148:in `parse' /usr/lib/ruby/1.9.1/psych.rb:148:in `parse_stream' /usr/lib/ruby/1.9.1/psych.rb:119:in `parse' /usr/lib/ruby/1.9.1/psych.rb:106:in `load' /home/mini/my_gems/gems/railties-3.2.9/lib/rails/application/configuration.rb:115:in `database_configuration' /home/mini/my_gems/gems/activerecord-3.2.9/lib/active_record/railtie.rb:78:in `block (2 levels) in <class:Railtie>' /home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:36:in `instance_eval' /home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:36:in `execute_hook' /home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:43:in `block in run_load_hooks' /home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:42:in `each' /home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:42:in `run_load_hooks' /home/mini/my_gems/gems/activerecord-3.2.9/lib/active_record/base.rb:720:in `<top (required)>' /home/mini/my_gems/gems/activerecord-3.2.9/lib/active_record/railties/databases.rake:25:in `block (2 levels) in <top (required)>' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:228:in `call' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:228:in `block in execute' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:223:in `each' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:223:in `execute' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:166:in `block in invoke_with_call_chain' /usr/lib/ruby/1.9.1/monitor.rb:201:in `mon_synchronize' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:159:in `invoke_with_call_chain' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:187:in `block in invoke_prerequisites' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:185:in `each' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:185:in `invoke_prerequisites' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:165:in `block in invoke_with_call_chain' /usr/lib/ruby/1.9.1/monitor.rb:201:in `mon_synchronize' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:159:in `invoke_with_call_chain' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:152:in `invoke' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:143:in `invoke_task' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:101:in `block (2 levels) in top_level' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:101:in `each' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:101:in `block in top_level' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:110:in `run_with_threads' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:95:in `top_level' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:73:in `block in run' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:160:in `standard_exception_handling' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:70:in `run' /home/mini/my_gems/gems/rake-10.0.3/bin/rake:33:in `<top (required)>' /home/mini/my_gems/bin/rake:19:in `load' /home/mini/my_gems/bin/rake:19:in `<main>' Tasks: TOP => db:migrate => db:load_config mini@mini:~/Sites/music_library$ mini@mini:~/Sites/music_library$ rake db:migrate --trace ** Invoke db:migrate (first_time) ** Invoke environment (first_time) ** Execute environment ** Invoke db:load_config (first_time) ** Execute db:load_config rake aborted! couldn't parse YAML at line 28 column 6 /usr/lib/ruby/1.9.1/psych.rb:148:in `parse' /usr/lib/ruby/1.9.1/psych.rb:148:in `parse_stream' /usr/lib/ruby/1.9.1/psych.rb:119:in `parse' /usr/lib/ruby/1.9.1/psych.rb:106:in `load' /home/mini/my_gems/gems/railties-3.2.9/lib/rails/application/configuration.rb:115:in `database_configuration' /home/mini/my_gems/gems/activerecord-3.2.9/lib/active_record/railtie.rb:78:in `block (2 levels) in <class:Railtie>' /home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:36:in `instance_eval' /home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:36:in `execute_hook' /home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:43:in `block in run_load_hooks' /home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:42:in `each' /home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:42:in `run_load_hooks' /home/mini/my_gems/gems/activerecord-3.2.9/lib/active_record/base.rb:720:in `<top (required)>' /home/mini/my_gems/gems/activerecord-3.2.9/lib/active_record/railties/databases.rake:25:in `block (2 levels) in <top (required)>' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:228:in `call' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:228:in `block in execute' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:223:in `each' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:223:in `execute' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:166:in `block in invoke_with_call_chain' /usr/lib/ruby/1.9.1/monitor.rb:201:in `mon_synchronize' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:159:in `invoke_with_call_chain' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:187:in `block in invoke_prerequisites' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:185:in `each' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:185:in `invoke_prerequisites' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:165:in `block in invoke_with_call_chain' /usr/lib/ruby/1.9.1/monitor.rb:201:in `mon_synchronize' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:159:in `invoke_with_call_chain' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:152:in `invoke' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:143:in `invoke_task' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:101:in `block (2 levels) in top_level' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:101:in `each' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:101:in `block in top_level' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:110:in `run_with_threads' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:95:in `top_level' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:73:in `block in run' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:160:in `standard_exception_handling' /home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:70:in `run' /home/mini/my_gems/gems/rake-10.0.3/bin/rake:33:in `<top (required)>' /home/mini/my_gems/bin/rake:19:in `load' /home/mini/my_gems/bin/rake:19:in `<main>' Tasks: TOP => db:migrate => db:load_config mini@mini:~/Sites/music_library$

Possibly a clue there, yml and database configuration. Likely an error in database.yml.

Why on earth you posted so much stuff including the same information multiple times is beyond me.

Colin

This error indicates that you’ve got invalid syntax in your config/database.yml file. 80% chance it’s a tab - YAML does not like tabs. Check the file in an editor that can show you tabs vs. spaces.

Otherwise, posting the file will make it much easier to get help.

–Matt Jones