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