Amazon RDS instance time zone workarounds

If you have an EC2 instance to run your application and an RDS instance for your database. On your EC2 instance you are in luck as you can easily change the time zone of the machine. Like set it to GST or by location like below

# ln -sf ../usr/share/zoneinfo/Asia/Dubai /etc/localtime

Read the rest of this entry »

Install Subversion on Bluehost, configuring subversion client on Windows and Mac OS X

Been using Version Control System on our company projects for a couple of years now. I’ve installed Subversion before on a dedicated Linux hosting(Known Host) and everything is straightforward since I have root access.

Recently my personal hosting account with bluehost got renewed and I’m not really utilizing the server that much I figured to try installing subversion on Bluehost to make my hosting more useful. As far as I have tried I can only connect via svn+ssh and not through http as I dont have access to apache to add on my shared hosting account unless I upgrade to a dedicated host which is not what I want. I documented the steps I took just in case someone will find them useful on setting up theirs.

Read the rest of this entry »

Setup EC2 and FileZilla with PPK file on Mac OS X

Coming from a Windows platform where I have tools like Putty to connect via SSH to our EC2 (Elastic Cloud Compute) instance on Amazon web services(AWS) and a tool like Pageant where I can load a .ppk key to allow me to connect my Filezilla client to connect via SFTP.

I had  to do the same on Mac OS X which eventually took me a bit of time to figure out. So I’m writing this short tutorial to document how I got it configured, so I can refer to it in the future and also help out those having a hard time setting it up. This tutorial is basically for those users who connect to Ec2 from a Windows platform and then moved to a Mac OS X platform.

1. On Windows using a telnet application like Putty to connect via SSH, you require a .ppk key. So first thing is to locate your PPK key in Windows.

2. Next you need to convert the PPK key to an OpenSSH format. Using PuttyGen load the .ppk file and then save the .ssh file generated. (eg. files aws_rsa.ppk and aws_rsa.ssh)

3. Copy the .ssh file and the original .ppk file over to your Mac directory like the Documents folder

4. Next open up Terminal on your Mac and create a new directory

# mkdir ~/.ec2

5. Copy the .ssh file to the ~/.ec2 directory

#mv /Users/myUser/Documents/aws_rsa.ssh ~/.ec2/aws_rsa.ssh

6. Change the file permission

# sudo chmod 600 aws_rsa.ssh

7. Finally connect to your instance.

# ssh -i aws_rsa.ssh

Replace with your EC2 public address.

Hopefully you should be able to connect to your server instance then.

Next is straightforward, this is for using a GUI like FileZilla to connect to your instance.

1. Open up FileZilla then go to Preferences

2. Go under SFTP and click on Add Key

3. Browse over to your Documents folder where you saved your .ppk file

4. Create a new site and add the public address for the host and protocol as SFTP (SSH File Transfer Protocol), user as root and password leave as blank.

That should be it you should be it. You could now SSH using the Terminal or connect via SFTP using FileZilla. Happy cloud computing.