Database (Oracle,MSSQL),Tomcat plugins

[Thomas Guyot-Sionnest]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 15/09/07 05:34 AM, Peter Edmonds wrote:
> On 9/14/07, Sekhar <radhiilu at yahoo.com> wrote:
> 
>> 2) Plugin to monitor mssql database ?
> 
> Install the freetds package, then use bsqldb to query your SQL2005
> from the command line using a bash script. I have this setup under
> Groundwork Monitor Open Source and it works sensationally. I can query
> a SQL 2005 database, dump the results to a text file in my htdocs
> directory then use check_http to do a content check.
> 
> echo '<your SQL query goes here' | bsqldb -U <dbusername> -P <dbpassword> -S
> <dbserveripaddress> -D <database> > /usr/www/htdocs/bsqldb.output

Of even better, use the attached Perl plugin that I just wrote. It
requires FreeTDS, Nagios::Plugin, DBI, DBD::Sybase and Time::HiRes. Can
accept thresholds for response time and append performance data.

Thomas


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFG7M2f6dZ+Kt5BchYRAoGEAJ4p9iK9VTtEfq2nU+CYD3xOiUB+0gCfYyj8
tqfAWpKoG7smjODCkHhvzpg=
=sN10
-----END PGP SIGNATURE-----
-------------- next part --------------
A non-text attachment was scrubbed...
Name: check_mssql.pl
Type: application/x-perl
Size: 4963 bytes
Desc: not available
URL: <https://www.monitoring-lists.org/archive/users/attachments/20070916/fd052c7c/attachment.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: check_mssql.pl.sig
Type: application/pgp-signature
Size: 65 bytes
Desc: not available
URL: <https://www.monitoring-lists.org/archive/users/attachments/20070916/fd052c7c/attachment.sig>
-------------- next part --------------
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
-------------- next part --------------
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null