September 2012
« Aug   Oct »

Apache : Forcing all url to https on www domain


One of the client purchased the SSL certificate (Secure Site with EV) from Unfortunately this certificate can protect the only the “www” domain name unlike other CA authorities ie Most of the CA authorites providing standard SSL certificate with “www” prefix along with their domain name. So that we can protect and [...]

Running a script under user environment on booting.

How do I run a script under a user environment at every time system booted.

Senario : I want to synchronize the files from a remote ftp location each time new instance created through AWS auto scaling. I uses lftp command and using mirror option to sync. the files. Why I’m doing such sync [...]

mysqldump: Got error: 1556: You can’t use locks with log tables


I got the mysql error 1556 when I was backing up all the database from a remote mysql server (Amazon RDS )using a script.

mysqldump: Got error: 1556: You can’t use locks with log tables. when using LOCK TABLES

Solution :

You may need to disable “–lock-tables” option on your dump statement ie –lock-tables=0 [...]

MySQL : Handy Replication steps


Here are the few quick steps to make a Mysql Master-Slave setup. I do not mention anything in the technical aspects or provide an explanatory of any replication variables in detailed over here. I uses mysql hard copy backup and restore mechanism. ie copied the mysql data directory from master to slave after shut down [...]

Synchronize Amazon S3 location to Local storage

s3tools is a great tool for automating file operation on Amazon S3 storage. We can use this tools to backup our files to S3 and mirror the S3 files to local disk or storage.

My Scenario :

I’m running an video application and FMS server and web server are on two geographical location. So [...]

Mysql Unknown table engine ‘InnoDB’ when using LOCK TABLES


Today I got an error when I try to backup all the databases from mysql. Surprisingly this error does not contain any database name and so I could not identify which database causing this issue. So that I start backing up each database separately and identify the database causing the issue.

Then I start to [...]