BBWIN VB script for MySQL externals testing

On February 16, 2010, in How-to, Projects, Scripting, by Cubert aka (Cube Dweller)

Use BBWin to Monitor Your MySql Server
This little script allows you to quickly test your MySql server using BBWin .

It connects to MySql and queries SHOW STATUS from your server and returns the Stats.

www.AlertOnFailure.com

The script will alert if connection fails or records not returned.

You will need to install mysql-connector-odbc-5.1.6-win32.msi From [url]dev.mysql.com/downloads/connector/odbc/5.1.html[/url]

You will also need to edit the script and change the server address, database name, user and password.

:arrow: Download file to BBwin\bin folder

MySQL.vbs
Grabs Global stats from MySql server any where on your network
(2.98 KiB) Not downloaded yet
You will need to edit the BBWin\etc\BBWin.cfg file and insert the line below

 


<load value="cscript MySQL.vbs" timer="15m" />

You will not need to reload BBwin. It should pickup the changes to the file and load the test. With in a minute or 2 you should have a new system “Dot” called “MySQL”

Tagged with:
 

Leave a Reply