Connect Amazon RDS with Heroku?

1
votes

I have created my Amazon RDS in Oregon region. I have to configure this with my Heroku App. I am able to access RDS from my local machine. But this not happens with Heroku. I also don't have liberty to create Security Groups there. I am getting error as

ERROR 2003 (HY000): Can't connect to MySQL server on 'RDS hostname' (111)

something . I won't understand that because by my local machine it was resolving host but not from Heroku.

1
mysqlamazon-web-servicesherokuamazon-rds
Are you using heroku web services that host by heroku? – mootmoot
no. I just hosted my app on heroku, and created database on RDS. so i want to link them – user6375156
If so, you need to check whether Heroku allow apps to connect to external database, otherwise, you can only use Heroku hosted dbms. – mootmoot
yes, heroku allows to connect to external environment for database, that's why i was gone for RDS. only i had problem with the connectivity. – user6375156
Only manage to find this. Quick glance show that you need SSL devcenter.heroku.com/articles/… To enable RDS SSL you need to do this docs.aws.amazon.com/AmazonRDS/latest/UserGuide/… – mootmoot

1 Answers

5
votes

I Found solution myself, you just have to add inbound IP as 0.0.0.0/0 in security group for RDS to available it publicly.