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.

__

[email protected]:~/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) [email protected]:~/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)
[email protected]:~/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) [email protected]:~/Sites/music_library$ [email protected]:~/Sites/music_library$ vim [email protected]:~/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) [email protected]:~/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
[email protected]:~/Sites/music_library$
[email protected]:~/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
[email protected]:~/Sites/music_library$ cd
[email protected]:~$ irb -r irb/completion
irb(main):001:0> puts ((110.to_s * 2).to_i/2)
55055
=> nil
irb(main):002:0> quit
[email protected]:~$ cd Sites
[email protected]:~/Sites$ cd music_library/
[email protected]:~/Sites/music_library$ rake db:migrate -

[email protected]:~/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 [email protected]:~/Sites/music_library$ [email protected]:~/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
[email protected]:~/Sites/music_library$

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

[email protected]:~/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:

min[email protected]:~/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.

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs