obama’s speech at democratic national convention

this is the link to read the full text of obama’s speech at democratic national convention in denver :
http://i.usatoday.net/news/politics/election2008/pdf/obama-full-text-8-28-2008.pdf

if i were american, i will vote for barack obama. i agree with his idea of renewable energy, our planet is dying. and no more war. i don’t like bush’s idea of war. i think mccain will be no different than bush. republicans, they just love war…..
about outsourcing, i think it’s good, i suggest him to try indonesia, not just india or china….

Bad Request caused by modsecurity core rules

today a user tried to import (upload) a mysql database using phpmydmin. an error like this showed up:

Bad Request
Your browser sent a request that this server could not understand

i cheked the apache’s error log file and found some lines indicating that it had something to do with modsecurity. those lines got REQBODY_PROCESSOR_ERROR in them so i checked modsecurity configuration files :

$ grep REQBODY_PROCESSOR_ERROR modsecurity*conf

the search found it in
modsecurity_crs_20_protocol_violations.conf file so i did :

$ vi modsecurity_crs_20_protocol_violations.conf

and found a rule like this :

SecRule REQBODY_PROCESSOR_ERROR “!@eq 0″ “t:none,deny,log,auditlog,status:400,msg:’Invalid request body’,,id:’960912′,severity:’2′”

i then red the modsecurity reference and found answer that deny can be changed with pass to continue processing with the next rule. so i changed deny with pass, saved the file and exit. restart apache to make the change take effect and then tested it. no error, the import process was success.
but i will have to change it back to deny again as soon as the guy finish his database import.
i think this case is not only for phpmyadmin but also any applications that requires uploading.

breakaway lyrics kelly clarkson

very inspiring……..

Grew up in a small town
And when the rain would fall down
I’d just stare out my window
Dreaming of what could be
And if I’d end up happy
I would pray

Trying hard to reach out
But when I tried to speak out
Felt like no one could hear me
Wanted to belong here
But something felt so wrong here
So I’d pray
I could break away

I’ll spread my wings and I’ll learn how to fly.
I’ll do what it takes till I touch the sky.
Make a wish, take a chance,
Make a change, and break away.
Out of the darkness and into the sun.
But I won’t forget all the ones that I love.
I’ll take a risk, take a chance,
Make a change, and break away

Wanna feel the warm breeze
Sleep under a palm tree
Feel the rush of the ocean
Get onboard a fast train
Travel on a jetplane
Far away
And break away

I’ll spread my wings and I’ll learn how to fly.
I’ll do what it takes till I touch the sky.
Make a wish, take a chance,
Make a change, and break away.
Out of the darkness and into the sun.
But I won’t forget all the ones that I love.
I’ll take a risk, take a chance,
Make a change, and break away

Buildings with a hundred floors
Swinging with revolving doors
Maybe I don’t know where they’ll take me
Gotta keep movin on movin on
Fly away
Break away

I’ll spread my wings and I’ll learn how to fly.
Though it’s not easy to tell you goodbye
Take a risk, take a chance,
Make a change, and break away.
Out of the darkness and into the sun.
But I won’t forget the place I come from
I gotta take a risk, take a chance,
Make a change, and break away
Breakaway
Break away

Redirect without being a search engine spam

redirect is one of those methods claimed as SEO but actually are search engine spamming. my search around the internet found some methods classified as search engine spam are:
1. use of keywords which are totally irrelevant to the website
2. use of repetitive keywords
3. use of irrelevant words or phrase in hidden text
4. websites contain duplicate content of each other
5. links farm with intention to increase search engine rank
6. serving different page for search engine and human visitor for the same URL
7. redirect

what i’d like to underline here is redirect. not all redirect is considered as spam. the acceptable redirect is the HTTP 301 header. there are many free services out there to check whether a redirect is search engine friendly or not. a few of them are :

1. webrankinfo.com
2. webconfs.com

a few methods to make a friendly redirect are :

1. meta tag
<!DOCTYPE HTML PUBLIC “-//W3C//DTD HTML 4.01 Transitional//EN”>
<html>
<head>
<title>documenting and sharing</title>
<meta http-equiv=”Content-Type” content=”text/html; charset=iso-8859-1″>
<meta http-equiv=”refresh” content=”0; url=http://www.gregorgede.co.cc”>
<meta name=”keywords” content=”linux”>
<meta name=”description” content=”documenting and sharing”>
</head>
<body>
<p>Loading page… please wait.</p>
</body>
</html>


2. php
Header( “HTTP/1.1 301 Moved Permanently” );
Header( “Location: http://www.gregorgede.co.cc” );

references :

http://www.webconfs.com/how-to-redirect-a-webpage.php
http://www.silverdisc.co.uk/articles/spam-classification
http://www.qoolventure.com/keyword-spam.htm

mysql client connection attempt to mysql server very slow

computer A with ip 192.168.10.5 has mysql client on it and computer B with ip 192.168.10.6 has the mysql server. mysql client on computer A try to connect to mysql server on computer B :
$ mysql -u username -p -h 192.168.5.6

it takes at least 5 seconds before mysql prompt show up on the screen after entering password. this can be a problem when computer A is hosting a web application which needs to read it’s database on compter B. page generation would take very long time even when a lot of bandwidth are available. the solution to this problem is very simple. open /etc/hosts file on computer B and add the ip of computer A like this :
192.168.10.5 192.168.10.5

save and exit. now the connection attemp should be faster and mysql prompt will show up on the screen in a second. this might be applied to other application too, like ssh for example.

Next Page »