Save streaming video using mplayer

$ mplayer -dumpstream -dumpfile stream_video_name.wmv mms://example.com/video_name.wmv

Plesk: command to reconfigure one site

/usr/local/psa/admin/sbin/websrvmng -u --vhost-name=domain.com

Creating subdomain in Plesk

To have the server point to the subdomain instead of the domain when the url has “www” prefix then do the following:

Create /srv/www/vhosts/<domain>/subdomains/<subdomain>/conf/vhost.conf

Insert ServerAlias www.<subdomain>

Removing outdated ssh fingerprints from known hosts

REMOTE HOST IDENTIFICATION HAS CHANGED!

$ sed -i "46 d" ~/.ssh/known_hosts

Removing outdated ssh fingerprints from known hosts

You are wonderful, You are Holy


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 /etc/init.d services

CSS Sprites

OpenSSL: How To Create Self-Signed Certificate

$ 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

Extract particular table from a mysqldump file

$ 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

Showing PHP errors

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.