External database connection via SSL

2012-03-20 Thread Nathan Wenneker
I'm running a Rails 3.2 app on the Cedar stack.

I've successfully configured it to connect to an external Amazon RDS
database using the appropriate DATABASE_URL config variable.

However, I want my application to connect to the database via SSL.
This would normally be configured in database.yml, but since Heroku
generates this for me, I don't know how or where to specify the SSL
option(s).

Is this possible?

Thanks!,

Nathan

P.S. I posted a question about this on stackoverflow a few days ago,
but haven't seen much response to it, so I thought this list might be
a better avenue.  
http://stackoverflow.com/questions/9741072/specify-ssl-for-heroku-external-mysql-database-connection

-- 
You received this message because you are subscribed to the Google Groups 
Heroku group.
To post to this group, send email to heroku@googlegroups.com.
To unsubscribe from this group, send email to 
heroku+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/heroku?hl=en.



Re: External database connection via SSL

2012-03-20 Thread Neil Middleton
From looking at the injected database.yml (see bottom of 
http://neilmiddleton.com/sharing-databases-between-heroku-applications/) you 
can pass in extra configuration as part of the db URL as query params.  

In theory, this should let you configure it how you want although I've not 
tried it.  

-Neil


On Monday, 19 March 2012 at 16:53, Nathan Wenneker wrote:

 I'm running a Rails 3.2 app on the Cedar stack.
 
 I've successfully configured it to connect to an external Amazon RDS
 database using the appropriate DATABASE_URL config variable.
 
 However, I want my application to connect to the database via SSL.
 This would normally be configured in database.yml, but since Heroku
 generates this for me, I don't know how or where to specify the SSL
 option(s).
 
 Is this possible?
 
 Thanks!,
 
 Nathan
 
 P.S. I posted a question about this on stackoverflow a few days ago,
 but haven't seen much response to it, so I thought this list might be
 a better avenue. 
 http://stackoverflow.com/questions/9741072/specify-ssl-for-heroku-external-mysql-database-connection
 
 -- 
 You received this message because you are subscribed to the Google Groups 
 Heroku group.
 To post to this group, send email to heroku@googlegroups.com.
 To unsubscribe from this group, send email to 
 heroku+unsubscr...@googlegroups.com.
 For more options, visit this group at 
 http://groups.google.com/group/heroku?hl=en.
 
 


-- 
You received this message because you are subscribed to the Google Groups 
Heroku group.
To post to this group, send email to heroku@googlegroups.com.
To unsubscribe from this group, send email to 
heroku+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/heroku?hl=en.



Re: External database connection via SSL

2012-03-20 Thread Nathan Wenneker

Neil,

That worked beautifully.  Thanks!

Nathan

P.S. For future reference by others, I'll post an answer on my 
stackoverflow question with some more specific details.


On 03/20/2012 02:31 PM, Neil Middleton wrote:
From looking at the injected database.yml (see bottom 
of http://neilmiddleton.com/sharing-databases-between-heroku-applications/) 
you can pass in extra configuration as part of the db URL as query 
params.


In theory, this should let you configure it how you want although I've 
not tried it.


-Neil


--
You received this message because you are subscribed to the Google Groups 
Heroku group.
To post to this group, send email to heroku@googlegroups.com.
To unsubscribe from this group, send email to 
heroku+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/heroku?hl=en.