Wednesday, January 30, 2013

Change Amazon RDS database timezone to non UTC

Amazon RDS is a very powerful hosted Relational Database solution. I recently came across a big annoyance with it which was not being able to set a default timezone. I had a PHP application along with several scripts talking to MySQL on Amazon RDS.

Friday, January 18, 2013

CloudFront Invalidation of single or multiple files via Command Line tool

Recently, i implemented a pull model on Amazon CloudFront for one of our high traffic servers. Our system runs a few services which update existing files at random intervals with new content as well as generate multiple new files. For the new files not present on CloudFront, the pull model will take care of it but what about the existing files which got updated?

Tuesday, January 1, 2013

Create new ACO automatically for CakePHP ACL

If you have been working with CakePHP ACL for quite a while, you might be familiar with the tedious process of creating ACO's manually via command line as soon as you add a new Controller or add any method to an existing controller.

Wednesday, December 26, 2012

SSH connection refused on Amazon EC2 instance

Does this sound familiar?
ssh: connect to host ec2-xx-xx-xxx-xxx.compute-1.amazonaws.com
port 22: Connection refused
A few days back, one of my friends was having an issue with his Amazon EC2 production instance. He was able to SSH into it a few days back, but all of a sudden, he was not able to get into it.

Now thats a big problem. You cannot do anything with an amazon EC2 instance if you cannot SSH into it. Well, i started troubleshooting.