heroku woes Invalid DATABASE_URL

gistfile1.txt

tim@armadillo:~/projects/visualtags$ heroku pg:promote HEROKU_POSTGRESQL_COBALT
Promoting HEROKU_POSTGRESQL_COBALT_URL to DATABASE_URL... done
tim@armadillo:~/projects/visualtags$ git push heroku master
Counting objects: 72, done.
Delta compression using up to 4 threads.
Compressing objects: 100% (51/51), done.
Writing objects: 100% (53/53), 625.67 KiB | 359 KiB/s, done.
Total 53 (delta 35), reused 0 (delta 0)

-----> Ruby/Rack app detected
-----> Using Ruby version: ruby-1.9.2
-----> Installing dependencies using Bundler version 1.3.2
       Running: bundle install --without development:test --path vendor/bundle --binstubs vendor/bundle/bin --deployment
       Fetching gem metadata from https://rubygems.org/.........
       Fetching gem metadata from https://rubygems.org/..
       Using i18n (0.6.1)
       Using multi_json (1.7.7)
       Using activesupport (3.2.13)
       Using builder (3.0.4)
       Using activemodel (3.2.13)
       Using arel (3.0.2)
       Using tzinfo (0.3.37)
       Using activerecord (3.2.13)
       Using backports (3.3.3)
       Using bond (0.4.3)
       Installing unf_ext (0.0.6)
       Installing unf (0.1.1)
       Installing domain_name (0.5.12)
       Using eventmachine (1.0.3)
       Installing http-cookie (1.0.1)
       Using kgio (2.8.0)
       Using libxml-ruby (2.6.0)
       Using mime-types (1.23)
       Installing net-http-digest_auth (1.3)
       Installing net-http-persistent (2.8)
       Installing nokogiri (1.5.10)
       Installing ntlm-http (0.1.1)
       Installing webrobots (0.1.1)
       Installing mechanize (2.7.1)
       Using oj (2.1.4)
       Using pg (0.15.1)
       Using r18n-core (1.1.5)
       Using rack (1.5.2)
       Using rack-protection (1.5.0)
       Using rack-test (0.6.2)
       Using raindrops (0.11.0)
       Using ripl (0.7.0)
       Using ripl-multi_line (0.3.1)
       Using ripl-rack (0.2.0)
       Using tilt (1.4.1)
       Using sinatra (1.3.2)
       Using sinatra-activerecord (1.2.2)
       Using sinatra-contrib (1.3.2)
       Using sinatra-flash (0.3.0)
       Using sinatra-r18n (1.1.5)
       Using tux (0.3.0)
       Using unicorn (4.6.3)
       Using bundler (1.3.2)
       Your bundle is complete! It was installed into ./vendor/bundle
       Cleaning up the bundler cache.
       Removing rest-client (1.6.7)
-----> Writing config/database.yml to read from DATABASE_URL
 !
 !     rake aborted!
 !     Invalid DATABASE_URL
 !     (erb):9:in `rescue in <main>'
 !     (erb):6:in `<main>'
 !     /tmp/ruby-1.9.2/lib/ruby/1.9.1/erb.rb:753:in `eval'
 !     /tmp/ruby-1.9.2/lib/ruby/1.9.1/erb.rb:753:in `result'
 !     /tmp/build_2bbowv447h4v2/vendor/bundle/ruby/1.9.1/gems/sinatra-activerecord-1.2.2/lib/sinatra/activerecord.rb:39:in `database_file='
 !     /tmp/build_2bbowv447h4v2/vendor/bundle/ruby/1.9.1/gems/sinatra-1.3.2/lib/sinatra/base.rb:983:in `set'
 !     /tmp/build_2bbowv447h4v2/vendor/bundle/ruby/1.9.1/gems/sinatra-activerecord-1.2.2/lib/sinatra/activerecord.rb:50:in `registered'
 !     /tmp/build_2bbowv447h4v2/vendor/bundle/ruby/1.9.1/gems/sinatra-1.3.2/lib/sinatra/base.rb:1262:in `block in register'
 !     /tmp/build_2bbowv447h4v2/vendor/bundle/ruby/1.9.1/gems/sinatra-1.3.2/lib/sinatra/base.rb:1260:in `each'
 !     /tmp/build_2bbowv447h4v2/vendor/bundle/ruby/1.9.1/gems/sinatra-1.3.2/lib/sinatra/base.rb:1260:in `register'
 !     /tmp/build_2bbowv447h4v2/vendor/bundle/ruby/1.9.1/gems/sinatra-1.3.2/lib/sinatra/base.rb:1590:in `register'
 !     /tmp/build_2bbowv447h4v2/vendor/bundle/ruby/1.9.1/gems/sinatra-1.3.2/lib/sinatra/base.rb:1630:in `register'
 !     /tmp/build_2bbowv447h4v2/vendor/bundle/ruby/1.9.1/gems/sinatra-activerecord-1.2.2/lib/sinatra/activerecord.rb:76:in `<module:Sinatra>'
 !     /tmp/build_2bbowv447h4v2/vendor/bundle/ruby/1.9.1/gems/sinatra-activerecord-1.2.2/lib/sinatra/activerecord.rb:6:in `<top (required)>'
 !     /tmp/build_2bbowv447h4v2/app.rb:2:in `require'
 !     /tmp/build_2bbowv447h4v2/app.rb:2:in `<top (required)>'
 !     /tmp/build_2bbowv447h4v2/Rakefile:1:in `require'
 !     /tmp/build_2bbowv447h4v2/Rakefile:1:in `<top (required)>'
 !     /tmp/ruby-1.9.2/lib/ruby/1.9.1/rake.rb:2373:in `load'
 !     /tmp/ruby-1.9.2/lib/ruby/1.9.1/rake.rb:2373:in `raw_load_rakefile'
 !     /tmp/ruby-1.9.2/lib/ruby/1.9.1/rake.rb:2007:in `block in load_rakefile'
 !     /tmp/ruby-1.9.2/lib/ruby/1.9.1/rake.rb:2058:in `standard_exception_handling'
 !     /tmp/ruby-1.9.2/lib/ruby/1.9.1/rake.rb:2006:in `load_rakefile'
 !     (eval):1:in `block in standard_rake_options'
 !     /tmp/ruby-1.9.2/lib/ruby/1.9.1/rake.rb:2213:in `eval'
 !     /tmp/ruby-1.9.2/lib/ruby/1.9.1/rake.rb:2213:in `block in standard_rake_options'
 !     /tmp/ruby-1.9.2/lib/ruby/1.9.1/optparse.rb:1308:in `call'
 !     /tmp/ruby-1.9.2/lib/ruby/1.9.1/optparse.rb:1308:in `block in parse_in_order'
 !     /tmp/ruby-1.9.2/lib/ruby/1.9.1/optparse.rb:1264:in `catch'
 !     /tmp/ruby-1.9.2/lib/ruby/1.9.1/optparse.rb:1264:in `parse_in_order'
 !     /tmp/ruby-1.9.2/lib/ruby/1.9.1/optparse.rb:1258:in `order!'
 !     /tmp/ruby-1.9.2/lib/ruby/1.9.1/optparse.rb:1349:in `permute!'
 !     /tmp/ruby-1.9.2/lib/ruby/1.9.1/optparse.rb:1370:in `parse!'
 !     /tmp/ruby-1.9.2/lib/ruby/1.9.1/rake.rb:2303:in `handle_options'
 !     /tmp/ruby-1.9.2/lib/ruby/1.9.1/rake.rb:1999:in `block in init'
 !     /tmp/ruby-1.9.2/lib/ruby/1.9.1/rake.rb:2058:in `standard_exception_handling'
 !     /tmp/ruby-1.9.2/lib/ruby/1.9.1/rake.rb:1997:in `init'
 !     /tmp/ruby-1.9.2/lib/ruby/1.9.1/rake.rb:1990:in `run'
 !     /tmp/ruby-1.9.2/bin/rake:31:in `<main>'
 !     (in /tmp/build_2bbowv447h4v2)
 !
sh: Syntax error: Unterminated quoted string

 !     Push rejected, failed to compile Ruby/Rack app



tim@armadillo:~/projects/visualtags$ heroku config
=== visualtags Config Vars
DATABASE_URL:                 postgres://ascasasc@ec2-54-217-215-81.eu-west-1.compute.amazonaws.com:5432/asasdad
HEROKU_POSTGRESQL_COBALT_URL: postgres://ascasac@ec2-54-217-215-81.eu-west-1.compute.amazonaws.com:5432/asdasd
HEROKU_POSTGRESQL_CYAN_URL:   postgres://assad:-ascas@ec2-54-217-215-96.eu-west-1.compute.amazonaws.com:5432/asdasad

tim@armadillo:~/projects/visualtags$ heroku pg:info
=== HEROKU_POSTGRESQL_COBALT_URL (DATABASE_URL)
Plan:        Dev
Status:      available
Connections: 4
PG Version:  9.2.4
Created:     2013-07-23 17:49 UTC
Data Size:   6.4 MB
Tables:      2
Rows:        4/10000 (In compliance) - refreshing
Fork/Follow: Unsupported
Region:      Europe

fyi if you are reading this and have similar trouble - bug not solved. I said goodbye to heroku and am using Dreamhost, activerecord and sqlite3 - but I still want to solve the puzzle!

yikes! I'm still digging

added a question to stack overflow: http://stackoverflow.com/questions/17822832/heroku-invalid-database-url-when-pushing-even-whilst-its-running

This was a bug with Heroku itself - they have now fixed it.