Lazy coding got the better of me as one of the sites I built got hacked. The site is running on a custom php framework I built. Security wise it was still too infant and alot of security needs to be patched. Through SQL Injection via the URL the hacker was able to get into my database and eventually cracked a user’s password then posted an XSS script on the CKEditor which eventually got the site compromised further.
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 mod_dav_svn.so 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.
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 email@example.com
Replace ec2-xxx-xx-xxx-xxx.compute-1.amazonaws.com 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.