WatchMySQL Users... New Version.

[shaun]

I have released a new version of WatchMySQL. WatchMySQL is a script that runs in the background and watch's the amount of users logged into mysql. If a user exceeds their limit it will notify you and/or kill the user's connections if you tell it to.


Additions/Fixs
*fixed problem where script would die when mysql was restarted. watchmysql now checks the mysql connection on each pass and ensures it is connected.
*removed the option to restart mysql
*added the option to kill the abusing users


Users can download the new version at the following locations.
http://www.ndchost.com/solutions/lic...p/cpextras.php
http://www.cplicensing.net/extras/scripts.php

cPanel.net Support Ticket Number:

[casey]

Originally posted by shaun
I have released a new version of WatchMySQL. WatchMySQL is a script that runs in the background and watch's the amount of users logged into mysql. If a user exceeds their limit it will notify you and/or kill the user's connections if you tell it to.


Additions/Fixs
*fixed problem where script would die when mysql was restarted. watchmysql now checks the mysql connection on each pass and ensures it is connected.
*removed the option to restart mysql
*added the option to kill the abusing users


Users can download the new version at the following locations.
http://www.ndchost.com/solutions/lic...p/cpextras.php
http://www.cplicensing.net/extras/scripts.php

cPanel.net Support Ticket Number:

Okay, time for a stupid question. Can this be installed on top of the current install, or does something extra need to be done?

cPanel.net Support Ticket Number:

[shaun]

sure, just replace the old version, just make sure you edit/configure it again.

cPanel.net Support Ticket Number:

[toma1708]

Hi,

Your script looks great. Have you posted somewhere installation instructions ?

Thanks.

Catalin

cPanel.net Support Ticket Number:

[Doctor]

Shaun, it is very generous of you to share such great script. If you could pepper your generosity with a step-by-step instruction on how to run it in the background, it would help a lot of newbies like me.

cPanel.net Support Ticket Number:

[Doctor]

To make watchmysql runs in the background, should I first rename the file to watchmysql.pl? Then should I run it once only perl watchmysql.pl? Or should I set a cronjob to run it every 10 minutes?

cPanel.net Support Ticket Number:

[NeutralGold]

Originally posted by Doctor
To make watchmysql runs in the background, should I first rename the file to watchmysql.pl? Then should I run it once only perl watchmysql.pl? Or should I set a cronjob to run it every 10 minutes?

cPanel.net Support Ticket Number:

su - to root
nohup ./watchmysql &
or
./watchmysql &

cPanel.net Support Ticket Number:

[Doctor]

su - to root
nohup ./watchmysql &
or
./watchmysql &

Thanks for the tip! If I logout from shell, will it still run in the background? What if I want to stop it from running in the background?

cPanel.net Support Ticket Number:

[Doctor]

Below is the screen output:

$ nohup ./watchmysql &
[1] 21776
$ nohup: appending output to `nohup.out'
[1]+ Exit 126 nohup ./watchmysql

Does this mean watchmysql is now running or exited? I type $ jobs but nothing came up. How do I check if it is running? And how do I kill it? Should I type $ kill %1?

cPanel.net Support Ticket Number:

[Doctor]

I CHMOD the file to 755 and try run it again with "nohup ./watchmysql &" and this time it works. But as soon as I logout and re-login again, it doesn't display when I type "jobs". So how do I know if it actually is running and how do I kill it?

If I reboot the server, will it still run in the background?

[Finkinstein]

Just type "ps" to see if it's running.

To kill it type "kill pid" The pid is the first number given from ps on the watchmysql row.

If your server reboots you have to start it again unless you set it to load on start up.. I think.

Edit:
Only just realised how old this thread was... oh well, its still reference.

[shaun]

Sorry for not responding, the forum just told me about a reply.

to see if it's running type ps aux|grep watchmysql

or you can type ps auxf and just look for it.

[Solokron]

Old thread but I am finding the need to use watchmysql.pl

Is placing a reference in /etc/rc.d/rc.local fine?

[bhanuprasad1981]

i just installed it yesterday , but today found that script is not running , dont know why it stopped, any idea how can we add this script to be monitored ?