Hi, Make sure you provided the existing db host name. E.g. if you launch an Amazon RDS instance named 'jupiter', the actual endpoint looks something like this:
jupiter.d6ydgdfwqwew.us-east-1.rds.amazonaws.com This value should be assigned to DATABASE_URL configuration key in Heroku: $ heroku config --long DATABASE_URL => mysql://user:[email protected]/dbname ... On 12 дек 2010, 08:35, santoash <[email protected]> wrote: > I configured AmazonRDSfollowing 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 > throughRDS'sfirewall, i ended up using AWS Console to do it. (I couldn't get > therdscommand 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 therdsinstance, 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.
