{"action":"created","issue":{"url":"https://api.github.com/repos/cf-tm-bot/capi/issues/735","repository_url":"https://api.github.com/repos/cf-tm-bot/capi","labels_url":"https://api.github.com/repos/cf-tm-bot/capi/issues/735/labels{/name}","comments_url":"https://api.github.com/repos/cf-tm-bot/capi/issues/735/comments","events_url":"https://api.github.com/repos/cf-tm-bot/capi/issues/735/events","html_url":"https://github.com/cf-tm-bot/capi/issues/735","id":199920286,"number":735,"title":"As an app developer (buildpack only, Not Docker) with a MySQL service binding using two-way authentication, I expect my DATABASE_URL environment variable to include query parameters pointing to my binding's certificates and key so that I do not need to configure my app to use the database connection. - Story Id: 137374647","user":{"login":"cf-tm-bot","id":20690070,"avatar_url":"https://avatars.githubusercontent.com/u/20690070?v=3","gravatar_id":"","url":"https://api.github.com/users/cf-tm-bot","html_url":"https://github.com/cf-tm-bot","followers_url":"https://api.github.com/users/cf-tm-bot/followers","following_url":"https://api.github.com/users/cf-tm-bot/following{/other_user}","gists_url":"https://api.github.com/users/cf-tm-bot/gists{/gist_id}","starred_url":"https://api.github.com/users/cf-tm-bot/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cf-tm-bot/subscriptions","organizations_url":"https://api.github.com/users/cf-tm-bot/orgs","repos_url":"https://api.github.com/users/cf-tm-bot/repos","events_url":"https://api.github.com/users/cf-tm-bot/events{/privacy}","received_events_url":"https://api.github.com/users/cf-tm-bot/received_events","type":"User","site_admin":false},"labels":[{"id":447326523,"url":"https://api.github.com/repos/cf-tm-bot/capi/labels/feature","name":"feature","color":"ededed","default":false},{"id":447329964,"url":"https://api.github.com/repos/cf-tm-bot/capi/labels/unscheduled","name":"unscheduled","color":"c8cbd0","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2017-01-10T20:05:03Z","updated_at":"2017-01-19T18:03:52Z","closed_at":null,"body":"Building off of the work in #137374039, if the DATABASE_URL is updated with additional query parameters, apps that look for that environment variable (such as Rails apps) will be able to use the database connection without additional work from the developer.\n\nThe format for the MySQL URL is to add sslkey, sslcert, and sslca keys whose values are the paths to the files on the local filesystem.\n\nAcceptance criteria:\n1. When I push buildpack app with `--no-start`\n1.  And I bind it to a MySQL service with a credentials including clientKey, clientCert, and caCert keys\n1. When I do `cf env [my-app]`, I should see that my DATABASE_URL looks like \"mysql://user:pass@host:port/db_name?additional=params&sslkey=/home/vcap/ssl/sqlBindingClient.key&sslcert=/home/vcap/ssl/sqlBindingClient.cert&cacert=/home/vcap/ssl/sqlBindingCA.cert\"\n\nSee #134876539 for some investigation notes that informed this story.\n\n---\n\nMirrors: [story 137374647](https://www.pivotaltracker.com/story/show/137374647) submitted on Jan 10, 2017 UTC\n- **Requester**: Dan Wendorf\n- **Estimate**: 0.0"},"comment":{"url":"https://api.github.com/repos/cf-tm-bot/capi/issues/comments/273851035","html_url":"https://github.com/cf-tm-bot/capi/issues/735#issuecomment-273851035","issue_url":"https://api.github.com/repos/cf-tm-bot/capi/issues/735","id":273851035,"user":{"login":"cf-tm-bot","id":20690070,"avatar_url":"https://avatars.githubusercontent.com/u/20690070?v=3","gravatar_id":"","url":"https://api.github.com/users/cf-tm-bot","html_url":"https://github.com/cf-tm-bot","followers_url":"https://api.github.com/users/cf-tm-bot/followers","following_url":"https://api.github.com/users/cf-tm-bot/following{/other_user}","gists_url":"https://api.github.com/users/cf-tm-bot/gists{/gist_id}","starred_url":"https://api.github.com/users/cf-tm-bot/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cf-tm-bot/subscriptions","organizations_url":"https://api.github.com/users/cf-tm-bot/orgs","repos_url":"https://api.github.com/users/cf-tm-bot/repos","events_url":"https://api.github.com/users/cf-tm-bot/events{/privacy}","received_events_url":"https://api.github.com/users/cf-tm-bot/received_events","type":"User","site_admin":false},"created_at":"2017-01-19T18:03:52Z","updated_at":"2017-01-19T18:03:52Z","body":"Nicholas Calugar [commented](https://www.pivotaltracker.com/n/projects/966314/stories/137374647/comments/160853223) on Jan 19, 2017, 5.06 PM UTC:\n\n`@pt:dwendorf` does this replace https://www.pivotaltracker.com/story/show/137374039 ?\n\n<!--\nComment Id: 160853223\n-->"}}
{"actor":{"display_login":"cf-tm-bot"}}