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
 

Tuesday, January 5, 2010

linux startup commands

To run commands automatically on starting Linux machine ( Redhat build ), add the commands to /etc/rc.d/rc.local

Friday, September 25, 2009