raymond blogs…

You are wonderful

You are holy

You’re the bright morning star that guides my every step

You are wonderful

You are holy

You’re the light morning breeze that cools my fears away

You are holy

You are wonderful

You are holy

You’re the sounds of violins that catch my breath away

You are wonderful

You are holy

You’re the shelter in the storm

You’re the saviour of my soul

You are wonderful

You are holy

You’re the comfort of my soul that learns to trust in thee

You are holy

(Repeat all)

Words and music by Raymond S. Usbal

Santolan Palayan City, 0929-6600855

Words and music composed on 10 March 2010

Enabling and disabling services during start up in GNU/Linux

http://www.smashingmagazine.com/2009/04/27/the-mystery-of-css-sprites-techniques-tools-and-tutorials/

$ openssl genrsa -out ca.key 1024
$ openssl req -new -key ca.key -out ca.csr
$ openssl x509 -req -days 365 -in ca.csr -signkey ca.key -out ca.crt

For the explanation, here’s the source: OpenSSL: How To Create Self-Signed Certificate

$ awksqldump dbname.dump.sql tblname


#!/bin/bash
### check parameter
E_NO_ARGS=65
if [ $# -eq 2 ]
then
# Outputs string of specified table only
awk "/Table structure for table .$2./,/UNLOCK TABLES/{print}" $1 > $1.EXTRACTED.sql
elif [ $# -eq 3 ]
then
# Outputs string starting from table1 and ends on beginning of table2
awk "/Table structure for table .$2./,/Table structure for table .$3./{print}" $1 > $1.EXTRACTED.sql
else
echo "Awk Sql Dump
Usage: awksqldump dumpfilename tablename1 [tablename2]
"
exit $E_NO_ARGS
fi


On production environment, you sometimes need to display errors temporarily to see what’s going wrong.  Without the need to modify php.ini, you can add this to .htaccess file on the particular web folder you are working on.

php_flag display_errors On

Then you can remove the line afterwards.

Transfer Horde emails to a new server

rsync -avz -e ssh root@i095.indigo.fastwebserver.de:/var/www/vhosts/philippinedev.com/httpdocs/ /srv/www/vhosts/philippinedev.com/httpdocs/

DirectoryIndex alternative-default-home-page.php

#!/bin/bash
# —————————————————-
#
# SQL Show Log version 1.0
# @author Raymond S. Usbal
# @usage sqlshowlog
#
# —————————————————-

### check parameter
E_NO_ARGS=65

if [ $# -eq 0 ]
then
echo “SQL Show Log version 1.0
Usage: sqlshowlog
”
exit $E_NO_ARGS
fi

### get latest MySQL log
for file in mysql-bin.??????*; do FLE_LATEST=$file; done;

### build start date string
START_DTE=$(date +%Y-%m-%d\ %k:$(($(date +%M) - $1)):%S)

mysqlbinlog –start-date=”$START_DTE” $FLE_LATEST \
| grep -v ‘^[#/]’ \
| grep -v ‘SET TIMESTAMP’ \
| grep -v ‘SET @@session’ \
| grep -v ‘DELIMITER’ \
| grep -v ‘ROLLBACK’ \
| sed ’s/\/\*!\*\///g’

### end