Install YUM from VZ Node

Run this command from node
#vzpkg install VEID -p yum

VEID will be your VPS ID.



Thanks
Ninad

Features of Apache 2.2

Please check
http://httpd.apache.org/docs/2.2/new_features_2_2.html

Install mod_xsendfile

mod_xsendfile is a small Apache2 module that processes X-SENDFILE headers registered by the original output handler.

If it encounters the presence of such header it will discard all output and send the file specified by that header instead using Apache internals including all optimizations like caching-headers and sendfile or mmap if configured.

It is useful for processing script-output of e.g. php, perl or any cgi.

Download from source

wget http://tn123.ath.cx/mod_xsendfile/mod_xsendfile-0.9.tar.gz

Compile and install

apxs -cia mod_xsendfile.c

Restart apache

Works in apache2.2

Thanks

Ninad

SSHD Failed

If you are getting error while starting ssh

sshd dead but subsys locked

Do the following

remove /dev/null
and then: "mknod /dev/null c 1 3"

this will create the /dev/null and sshd should start as normal.


Thanks
Ninad

GeoIP installation for Linux

Download the current GeoLite Country, GeoLite City and Organization (AS Numbers) databases

wget http://geolite.maxmind.com/download/geoip/database/GeoLiteCountry/GeoIP.dat.gz
wget http://geolite.maxmind.com/download/geoip/database/GeoLiteCity.dat.gz
wget http://geolite.maxmind.com/download/geoip/database/asnum/GeoIPASNum.dat.gz

Create GeoIP data directory if it doesn't already exist

if [ ! -d /usr/local/share/GeoIP ] ; then
   mkdir /usr/local/share/GeoIP
fi

Move data files to directory and unzip.

mv GeoIP.dat.gz /usr/local/share/GeoIP/
gunzip /usr/local/share/GeoIP/GeoIP.dat.gz

mv GeoLiteCity.dat.gz /usr/local/share/GeoIP/
gunzip /usr/local/share/GeoIP/GeoLiteCity.dat.gz

mv GeoIPASNum.dat.gz /usr/local/share/GeoIP/

Install the GeoIP program.

There are two options:

1. Install a C program and a Perl program
2. Install just a Perl program.

Option a) will provide the fastest performance.

The instructions for a) are known to work using Fedora Core 6 - FC6.

1. Install GeoIP C API http://www.maxmind.com/app/c

Download the GeoIP-*.tar.gz file, uncompress it and compile.

wget http://geolite.maxmind.com/download/geoip/api/c/GeoIP-1.4.5.tar.gz
tar -xvzf GeoIP-1.4.5.tar.gz
cd GeoIP-1.4.5

./configure
make
make check

2007-10-10: Thanks to James Rice who notified us of version 1.4.3. 2007-02-21: Thanks to Daniel Wallace who notified us of version 1.4.2. 2007-01-13: Thanks to Daniel Wallace who notified us of version 1.4.1. 2006-09-25: Thanks to Oleg Nerus who notified us of version 1.4.0. 2006-05-21: Thanks to Florian Burka who notified us of the availability of version 1.3.17.

With a text editor, add the directory libGeoIP.so was installed in, i.e. /usr/local/lib, to /etc/ld.so.conf, and execute ldconfig

2. Install Geo::IP Perl Module

Download the Geo-IP-*.tar.gz file, uncompress it and compile.

wget http://geolite.maxmind.com/download/geoip/api/perl/Geo-IP-1.35.tar.gz

tar -xvzf Geo-IP-1.35.tar.gz
cd Geo-IP-1.35

perl Makefile.PL LIBS='-L/usr/local/lib'
make
make test

Option b) (in lieu of option a!)

PurePerl Module (is slower, but does not require C library). Download latest Geo-IP-PurePerl-*.tar.gz file, uncompress and compile. Replace the version below with the current version.

wget http://www.maxmind.com/download/geoip/api/pureperl/Geo-IP-PurePerl-1.17.tar.gz tar -xvzf Geo-IP-PurePerl-1.17.tar.gz -C /usr/local/src/ cd /usr/local/src/Geo-IP-PurePerl-1.17 perl Makefile.PL make make test make install

Update your awstats.mysite.conf configuration file

Look for the following geoip LoadPlugin options in your AWStats configuration file. Update them with the full path to each of the two database files.

LoadPlugin="geoip GEOIP_STANDARD /usr/local/share/GeoIP/GeoIP.dat"
LoadPlugin="geoip_city_maxmind GEOIP_STANDARD /usr/local/share/GeoIP/GeoLiteCity.dat"


LoadPlugin="geoip_org_maxmind GEOIP_STANDARD /usr/local/share/GeoIP/GeoIPASNum.dat"

sudo make install

sudo make install

gunzip /usr/local/share/GeoIP/GeoIPASNum.dat.gz


Source : Antezeta

How to take backup of your mysql database

To backup your database.

# mysqldump database_name > backup.sql

For example ninad_ninad is the database name
command will be

#mysqldump ninad_ninad > ninad_ninad_old.sql

backup created in ninad_ninad_old.sql

Now restore it

first create an emtpy database
#mkdir ninad_ninad

Correct ownership
#chown mysql.mysql ninad_ninad

#mysql databasename < backup.sql
it will be
#mysql ninad_ninad < ninad_ninad_old.sql


Thanks
Ninad

How to check suPHP version

To check suPHP version

Run the command

find / -name suphp

Once you have found the binary, run the following:

/path/to/suphp

It should produce a result along the lines of:

suPHP version 0.6.3


Thanks
Ninad