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

suPHP on Plesk

**Make sure yum is installed on the server as it will help to install the dependencies.

1) To get the latest version of mod_suphp RPM enable the Atomic Repository for Yum. This can be done using Following command

# wget -q -O - Path to RPM
Note :  Path may get changed.
Better to get from http://rpm.pbone.net/index.php3/stat/4/idpl/1027655/com/apache2-mod_php-2.0.48_4.3.4-3sls.i586.rpm.html

2) After this mod_suPHP can be installed using command “yum install mod_php”

Configuration:

Once mod_suphp is installed, you will have to configure it with Apache.

1) First you will have to create a suphp.conf file in /etc/httpd/conf.d/ Directory and Paste the following code

LoadModule suphp_module modules/mod_suphp.so

php_admin_value engine off
suPHP_Engine On
AddHandler x-httpd-php .php .php3 .php4 .php5
suPHP_AddHandler x-httpd-php

2) Restart Apache Service using command “service httpd restart”

3) Now you will have to creae suphp configuration file. So, create a new file in /etc directory named “suphp.conf” (rename the existing file and create a new one) and add following lines in it:

[global]
logfile=/var/log/suphp.log
loglevel=info
webserver_user=apache
docroot=/var/www/vhosts
allow_file_group_writeable=false
allow_file_others_writeable=false
allow_directory_group_writeable=false
allow_directory_others_writeable=false
check_vhost_docroot=false
errors_to_browser=false
env_path=/bin:/usr/bin
umask=0022
min_uid=30
min_gid=30

[handlers]
x-httpd-php=php:/usr/bin/php-cgi
x-suphp-cgi=execute:!self

4) Restart Apache once more i.e. “service httpd restart”

Thanks

Ninad

Fantastico Error

If fantastico is not listed in your cpanel even after enabling ioncube in WHM.

Run the script
/scripts/makecpphp



Thanks
Ninad

Command to find CPU usage of process

ps -eo pcpu,pid,user,args | sort -k 1 -r | head -10

This will show the process which are consuming max CPU

Install NTP

# yum install ntp

# chkconfig ntpd on

# ntpdate pool.ntp.org

and start the NTP

# /etc/init.d/ntpd start


Note :: Do not forget to open port 123 in firewall.


Thanks
Ninad


Command to check SYN attack

netstat -nap | grep SYN | wc -l

Syslogd failed

Check whether syslogd is missing or not:

rpm -q sysklogd

If nothing shows up, do the following to install it:

yum install sysklogd

Restart syslogd service:

/scripts/restartsrv_syslogd

Thanks
Ninad

YUM Error

If you are getting this error on cpanel server

root@ninad~]# yum check-update Loading “installonlyn” plugin Setting up repositories Could not retrieve mirrorlist http://mirrorlist.centos.org/?release=5&arch=i386& repo=extras error was [Errno 4] IOError: Error: Cannot find a valid baseurl for repo: extras

Solution

yum clean metadata
yum clean dbcache
yum makecache

Thanks
Ninad