It's because we don't have static-ip address, so we have to manually add current ip
to Amazon RDS's db security group, almost EVERYDAY. It's so stupid and annoying.
we use amazon's aws-sdk-ruby for manipulating AWS RDS
- gem install aws-sdk
- gem install sanitize
- clone this project
- set your credentials in config/config.yml
- execute /path/to/ruby auto_rds_ip.rb
- you could using whenever gem to make this a cronjob and just enjoy