Rake db:migrate problem

Problem YAML at line 6 column 28

I tried the attachment but he did not appear so because I did copy /
paste.

__

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:inblock (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:inexecute_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:ineach’
/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:indatabase_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:ininstance_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:inblock 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:inrun_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:inblock (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:inblock (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:inexecute_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:ineach’
/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:inblock (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:inexecute_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:ineach’
/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:inload’
/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:inblock (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:inexecute_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:ineach’
/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:incall’
/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:ineach’
/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:inblock 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:ininvoke_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:ineach’
/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:inblock 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:ininvoke_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:ininvoke_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:ineach’
/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:inrun_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:inblock
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:inrun’
/home/mini/my_gems/gems/rake-10.0.3/bin/rake:33:in <top (required)>' /home/mini/my_gems/bin/rake:19:inload’
/home/mini/my_gems/bin/rake:19:in `’
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:inparse_stream’
/usr/lib/ruby/1.9.1/psych.rb:119:in parse' /usr/lib/ruby/1.9.1/psych.rb:106:inload’
/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:inblock (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:inexecute_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:ineach’
/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:incall’
/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:ineach’
/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:inblock 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:ininvoke_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:ineach’
/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:inblock 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:ininvoke_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:ininvoke_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:ineach’
/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:inrun_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:inblock
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:inrun’
/home/mini/my_gems/gems/rake-10.0.3/bin/rake:33:in <top (required)>' /home/mini/my_gems/bin/rake:19:inload’
/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:inparse’
/usr/lib/ruby/1.9.1/psych.rb:148:in parse_stream' /usr/lib/ruby/1.9.1/psych.rb:119:inparse’
/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:indatabase_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:ininstance_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:inblock 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:inrun_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:inblock (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:inblock 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:inexecute’
/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:inmon_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:inblock 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:ininvoke_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:inmon_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:ininvoke’
/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:inblock (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:inblock 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:intop_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:instandard_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
Tasks: TOP => db:migrate => db:load_config
mini@mini:~/Sites/music_library$

On 2 February 2013 16:03, Haris H. [email protected] wrote:

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’

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

On Saturday, 2 February 2013 11:03:15 UTC-5, Ruby-Forum.com User wrote:

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’

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