R-Ts NetWorks

Server the Best

How to install WatchMySQL Plugin in WHM


How to install WatchMySQL Plugin in WHM

Installation

Go to the below path

cd /sbin

Remove the file or take the backup

rm -f watchmysql

Download watchmysql plugin using the below link

wget http://www.ndchost.com/cpanel-whm/scripts/watchmysql/download.php

Change the ownership of that file

chown root.root watchmysql

Change permission of the file.

chmod 0750 watchmysql

 

Configuration

Before you run the script you must first configure it. Use edit to open the watchmysql script and set the options.

#Sets the maximum concurrent connections per MySQL user.

my $max_concurrent_connections = '15';

#Who to tell about this user... (email)

my $warning_email = 'your@email.address';

#Kill Abuser's MySQL Connections (0 = no, 1 = yes)

my $kill_user = '0';

#MySQL polling in seconds (600 = 10 minutes)

my $check_interval = '600';

 

Running

To start this script simply run the following command

/sbin/watchmysql &

If you want the script to start when the system boots you need to add the above line to /etc/rc.local

 

Advertisements

June 30, 2012 - Posted by | CPanel / WHM, MySql, WHM Plugins

No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: