-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 15/09/07 05:34 AM, Peter Edmonds wrote: > On 9/14/07, Sekhar <[EMAIL PROTECTED]> 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-----
check_mssql.pl
Description: Perl program
check_mssql.pl.sig
Description: PGP signature
------------------------------------------------------------------------- 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/
_______________________________________________ Nagios-users mailing list [email protected] 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
