OpsWorks overriding database.yml / ignoring custom JSON

Question

When I deploy a Rails app with OpsWorks, a new database.yml gets created in the shared directory. It ignores the existing database.yml (which rightfully shouldn't be in the repo), and I've also tried specifying custom JSON but nothing works. Maybe I have the structure wrong?

{
  "deploy": {
    "my-app-name": {
      "database": {
        "adapter": "mysql2",
        "encoding": "unicode",
        "host": "xxxxxx.rds.amazonaws.com",
        "port": "3306",
        "database": "db-name",
        "pool": "5",
        "username": "username",
        "password": "password"
      }
    }
  }
}

Answer 1

Look also here:

http://wojtek.ziniewi.cz/2013/06/10/custom-symlinks-in-amazon-opsworks-ror-application/

And always remember to examine your stack-json by logging into console of one of your opsworks servers and typing:

opsworks-agent-cli get_json