I configured Amazon RDS following the documentation here: http://docs.heroku.com/amazon_rds
I skipped the "transfer data" section and instead of using "rds- authorize-db-security-group-ingress" command to allow heroku through RDS's firewall, i ended up using AWS Console to do it. (I couldn't get the rds command line tools to work). The addon was successfully added and I was able to see the DATABASE_URL in my "heroku config" output. After configuring the rds instance, when I did db:migrate, I got the an error saying "production database is not configured" (See stack trace bellow). I also tried "heroku db:version" and I get different error saying "Unknown MySQL server host 'rdshostname.amazonaws.com' (1)" (See stacktrace bellow) Any idea whats going on? I would really appreciate some help! heroku rake --trace db:migrate rake aborted! production database is not configured /disk1/home/slugs/362558_9edca6d_f8de-80c7a2ea-761c-4d50- b9f8-43529764c22a/mnt/vendor/rails/activerecord/lib/active_record/ connection_adapters/abstract/connection_specification.rb:62:in `establish_connection' /disk1/home/slugs/362558_9edca6d_f8de-80c7a2ea-761c-4d50- b9f8-43529764c22a/mnt/vendor/rails/activerecord/lib/active_record/ connection_adapters/abstract/connection_specification.rb:55:in `establish_connection' /disk1/home/slugs/362558_9edca6d_f8de-80c7a2ea-761c-4d50- b9f8-43529764c22a/mnt/config/../vendor/rails/railties/lib/ initializer.rb:443:in `initialize_database' /disk1/home/slugs/362558_9edca6d_f8de-80c7a2ea-761c-4d50- b9f8-43529764c22a/mnt/config/../vendor/rails/railties/lib/ initializer.rb:138:in `process' /disk1/home/slugs/362558_9edca6d_f8de-80c7a2ea-761c-4d50- b9f8-43529764c22a/mnt/config/../vendor/rails/railties/lib/ initializer.rb:110:in `send' /disk1/home/slugs/362558_9edca6d_f8de-80c7a2ea-761c-4d50- b9f8-43529764c22a/mnt/config/../vendor/rails/railties/lib/ initializer.rb:110:in `run' /disk1/home/slugs/362558_9edca6d_f8de-80c7a2ea-761c-4d50- b9f8-43529764c22a/mnt/config/environment.rb:13 /usr/ruby1.8.7/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `gem_original_require' /usr/ruby1.8.7/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require' /disk1/home/slugs/362558_9edca6d_f8de-80c7a2ea-761c-4d50- b9f8-43529764c22a/mnt/lib/tasks/misc.rake:3 /home/slugs/362558_9edca6d_f8de-80c7a2ea-761c-4d50-b9f8-43529764c22a/ mnt/.bundle/gems/ruby/1.8/gems/rake-0.8.7/lib/rake.rb:636:in `call' /home/slugs/362558_9edca6d_f8de-80c7a2ea-761c-4d50-b9f8-43529764c22a/ mnt/.bundle/gems/ruby/1.8/gems/rake-0.8.7/lib/rake.rb:636:in `execute' /home/slugs/362558_9edca6d_f8de-80c7a2ea-761c-4d50-b9f8-43529764c22a/ mnt/.bundle/gems/ruby/1.8/gems/rake-0.8.7/lib/rake.rb:631:in `each' /home/slugs/362558_9edca6d_f8de-80c7a2ea-761c-4d50-b9f8-43529764c22a/ mnt/.bundle/gems/ruby/1.8/gems/rake-0.8.7/lib/rake.rb:631:in `execute' /home/slugs/362558_9edca6d_f8de-80c7a2ea-761c-4d50-b9f8-43529764c22a/ mnt/.bundle/gems/ruby/1.8/gems/rake-0.8.7/lib/rake.rb:597:in `invoke_with_call_chain' /usr/ruby1.8.7/lib/ruby/1.8/monitor.rb:242:in `synchronize' /home/slugs/362558_9edca6d_f8de-80c7a2ea-761c-4d50-b9f8-43529764c22a/ mnt/.bundle/gems/ruby/1.8/gems/rake-0.8.7/lib/rake.rb:590:in `invoke_with_call_chain' /home/slugs/362558_9edca6d_f8de-80c7a2ea-761c-4d50-b9f8-43529764c22a/ mnt/.bundle/gems/ruby/1.8/gems/rake-0.8.7/lib/rake.rb:607:in `invoke_prerequisites' /home/slugs/362558_9edca6d_f8de-80c7a2ea-761c-4d50-b9f8-43529764c22a/ mnt/.bundle/gems/ruby/1.8/gems/rake-0.8.7/lib/rake.rb:604:in `each' /home/slugs/362558_9edca6d_f8de-80c7a2ea-761c-4d50-b9f8-43529764c22a/ mnt/.bundle/gems/ruby/1.8/gems/rake-0.8.7/lib/rake.rb:604:in `invoke_prerequisites' /home/slugs/362558_9edca6d_f8de-80c7a2ea-761c-4d50-b9f8-43529764c22a/ mnt/.bundle/gems/ruby/1.8/gems/rake-0.8.7/lib/rake.rb:596:in `invoke_with_call_chain' /usr/ruby1.8.7/lib/ruby/1.8/monitor.rb:242:in `synchronize' /home/slugs/362558_9edca6d_f8de-80c7a2ea-761c-4d50-b9f8-43529764c22a/ mnt/.bundle/gems/ruby/1.8/gems/rake-0.8.7/lib/rake.rb:590:in `invoke_with_call_chain' /home/slugs/362558_9edca6d_f8de-80c7a2ea-761c-4d50-b9f8-43529764c22a/ mnt/.bundle/gems/ruby/1.8/gems/rake-0.8.7/lib/rake.rb:583:in `invoke' /home/slugs/362558_9edca6d_f8de-80c7a2ea-761c-4d50-b9f8-43529764c22a/ mnt/.bundle/gems/ruby/1.8/gems/rake-0.8.7/lib/rake.rb:2051:in `invoke_task' /home/slugs/362558_9edca6d_f8de-80c7a2ea-761c-4d50-b9f8-43529764c22a/ mnt/.bundle/gems/ruby/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in `top_level' /home/slugs/362558_9edca6d_f8de-80c7a2ea-761c-4d50-b9f8-43529764c22a/ mnt/.bundle/gems/ruby/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in `each' /home/slugs/362558_9edca6d_f8de-80c7a2ea-761c-4d50-b9f8-43529764c22a/ mnt/.bundle/gems/ruby/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in `top_level' /home/slugs/362558_9edca6d_f8de-80c7a2ea-761c-4d50-b9f8-43529764c22a/ mnt/.bundle/gems/ruby/1.8/gems/rake-0.8.7/lib/rake.rb:2068:in `standard_exception_handling' /home/slugs/362558_9edca6d_f8de-80c7a2ea-761c-4d50-b9f8-43529764c22a/ mnt/.bundle/gems/ruby/1.8/gems/rake-0.8.7/lib/rake.rb:2023:in `top_level' /home/slugs/362558_9edca6d_f8de-80c7a2ea-761c-4d50-b9f8-43529764c22a/ mnt/.bundle/gems/ruby/1.8/gems/rake-0.8.7/lib/rake.rb:2001:in `run' /home/slugs/362558_9edca6d_f8de-80c7a2ea-761c-4d50-b9f8-43529764c22a/ mnt/.bundle/gems/ruby/1.8/gems/rake-0.8.7/lib/rake.rb:2068:in `standard_exception_handling' /home/slugs/362558_9edca6d_f8de-80c7a2ea-761c-4d50-b9f8-43529764c22a/ mnt/.bundle/gems/ruby/1.8/gems/rake-0.8.7/lib/rake.rb:1998:in `run' /home/slugs/362558_9edca6d_f8de-80c7a2ea-761c-4d50-b9f8-43529764c22a/ mnt/.bundle/gems/ruby/1.8/gems/rake-0.8.7/bin/rake:31 /usr/ruby1.8.7/bin/rake:19:in `load' /usr/ruby1.8.7/bin/rake:19 (in /disk1/home/slugs/362558_9edca6d_f8de-80c7a2ea-761c-4d50- b9f8-43529764c22a/mnt) ** Invoke db:migrate (first_time) ** Invoke environment (first_time) ** Execute environment heroku rake db:version rake aborted! Unknown MySQL server host 'rdshostname.amazonaws.com' (1) (See full trace by running task with --trace) (in /disk1/home/slugs/362558_9edca6d_5b54-a0b625d4- aab4-4b4f-8100-1747e30cc9c5/mnt) base authentication included -- You received this message because you are subscribed to the Google Groups "Heroku" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/heroku?hl=en.
