Friday, July 30, 2010

Secure remote copy via scp

use scp command for copying remote files via ssh

Monday, July 5, 2010

Sunday, July 4, 2010

IE Iframe blocking third party cookie solution

http://adamyoung.net/IE-Blocking-iFrame-Cookies

Solution:


header('P3P:CP="IDC DSP COR ADM DEVi TAIi PSA PSD IVAi IVDi CONi HIS OUR IND CNT"');
?>

Saturday, June 12, 2010

Tracing Apache startup failure

When starting Apache web server via "service httpd start" fails, we could check the error in /var/log/httpd/error_log.

Or, we can execute the application "httpd" from command line and read the text response.

Most likely failure happens as a result of syntax error in "/etc/httpd/conf/httpd.conf"

Tuesday, May 11, 2010

Executing SQL statements from a text file

From mysql console
mysql>source [file_path]

From command line:
shell>mysql -u [user_name] -p[password] -h [host] -- verbose <  [file_path]
notes:
"--verbose" is required to display the sql statements before it is executed
make sure to add "use [database_name]" statement in the script file

Reference:
http://dev.mysql.com/doc/refman/5.0/en/batch-commands.html