How to DISABLE ipv6 in CentOS5 System

echo “NETWORKING_IPV6=no” >> /etc/sysconfig/network
echo “alias ipv6 off” >> /etc/modprobe.conf
echo “alias net-pf-10 off” >> /etc/modprobe.conf
reboot
# ifconfig
eth1      Link encap:Ethernet  HWaddr 00:1C:F0:BB:A7:28
inet addr:10.10.10.11  Bcast:10.10.10.255  Mask:255.255.255.0
inet6 addr: fe80::21c:f0ff:febb:a728/64 Scope:Link
UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
RX packets:470449435 errors:1 dropped:0 overruns:0 frame:0
TX packets:464084402 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:2563674692 (2.3 GiB)  TX bytes:2243518951 (2.0 GiB)
Interrupt:225 Base address:0×2800
Don’t really [...]

Scripting a MySQL InnoDB Engine Conversion

0) Backup your database.
You should probably be doing this already.  Now’s a good time to make sure that your backups ran.

1) Create the script.
You’ll need the correct permissions to query the database. Here’s the command.  Be sure to change <DATABASE_NAME> as it fits.
# mysql -p -e “show tables in <DATABASE_NAME>;” | \
tail –lines=+2 | [...]

Simple MySQL Backup with auto 3 days old file deletion

/usr/local/bin/mysql.backup.sh

#!/bin/bash
NOW=$(date +”%m-%d-%Y”)
OLD=$(date +”%m-%d-%Y” –date=”3 days ago”)
PROJECT=”project_name”
LOCATION=”/home/backup”
FILE=”$PROJECT.$NOW.sql”
FILE2=”$FILE.gz”
FILEOLD=”$PROJECT.$OLD.sql.gz”
EMAIL=”youremail@domain.com”
$SQLUSER=”username”
$SQLPASS=”password”
$SQLNAME=”database_name”
cd $LOCATION ; \
rm -f $FILEOLD ; \
mysqldump -u $SQLUSER –password=$SQLPASS $SQLNAME > \
$LOCATION/$FILE ; \
gzip $LOCATION/$FILE ; \
echo “Backup location is in $LOCATION/$FILE2″ | \
mail -s “[$PROJECT] MySQL Backup” $EMAIL

Then you can put it on your cron (background process)
Below cron will execute the script on Saturday at 12AM:

0 0 [...]

How To Getting Yesterdays or Tomorrows day with shell date command

When invoked without arguments, the date command displays the current date and time. Depending on the options specified, date will set the date and time or print it in a user defined way. I’ve seen many people writing a perl script for calculating yesterday or tomorrow. Computer loves numbers but we love relative terms like [...]

How to format date for display or to use in a shell script

Q. How do I format date to display on screen on for my scripts as per my requirements?
A. You need to use standard date command to format date or time for output or to use in a shell script.
Syntax to specify format
date +FORMAT

Share this on :

Facebook
Friendfeed
Posterous
Tumblr
Twitter

Setting up DomainKeys on Centos

This is a quick walk through on how to set up domain keys on Centos 5 using sendmail. It should also be very similar for Redhat or Fedora.

Domainkeys is a method mostly used by yahoo to verify that the sender of an email is valid. I did notice that gmail changes the domainkeys header line [...]

Setup a transparent proxy with 3 easy steps

First, Squid server installed (use up2date squid) and configured by adding following directives to file:
# vi /etc/squid/squid.conf

HTPasswd Tutorial

If you would like to have a set of web pages that are protected, requiring a username/password to gain access, this tutorial will show you how to set it up. This is geared towards the Unix Apache httpd servers used on holly, lamar, and www.colostate.edu. If you are using another web server, you’ll need to [...]

Simple Web/Linux IP Address Lookup

If you’re going to be doing a lot of Geotargeting or IP Address Lookups, please take a feed instead which will preserve both our bandwidth and your bandwidth.
Simple GET
That said, there is an easy HTTP oriented API to locate IP addresses and Geocode them. If you don’t supply the “?ip=aa.bb.cc.dd” bit, [...]

Necessary commands (tips) to tune apache

To search in the current directory and all sub directories for a file named httpd.conf
find . -name “httpd.conf” -print
To find some string or text, type
find . -exec grep “MaxClients” ‘{}’ \; -print