Check MSSQL via Perl

[Pavleck, Jeremy D.]

Ah, thanks Rob. I did check that one out, but it didn't cover what I
needed. So I went and wrote my own. I'm finding it's tons easier to just
install DBI & DBD::ODBC on a windows server and execute my checks via NT
NRPE then it was to get the Unix admin to setup the server the way I
needed it! 


Jeremy D. Pavleck
Network Engineer
System Management
	
Direct Line: 612-977-5881
Toll Free: 1-888-CAPELLA ext. 5881
Fax: 612-977-5060
E-mail: jeremy.pavleck at capella.edu
	
Capella University
225 South 6th Street, 9th Floor
Minneapolis, MN 55402

www.capella.edu


-----Original Message-----
From: nagios-users-admin at lists.sourceforge.net
[mailto:nagios-users-admin at lists.sourceforge.net] On Behalf Of Rob Moss
Sent: Wednesday, October 26, 2005 3:47 AM
To: Pavleck, Jeremy D.
Cc: nagios-users at lists.sourceforge.net
Subject: Re: [Nagios-users] Check MSSQL via Perl

Pavleck, Jeremy D. wrote:

>Greetings,
> I've written a very rough perl script that let's me connect to a 
>remote MS SQL database and run a query, then returns the results. 
>Alerting will be based on the result of the query.
> I'm just mainly wondering if anyone has written a check plugin for 
>this, so I don't waste any time. I did see anything on a quick search 
>of Google or NagiosExchange, but wanted to ask here as well to be safe.
>Thanks.
>  
>
Hi,
   There is a contributed check_sybase.pl script with the op5plugins..

Sybase and MS SQL server were the same product until just a few years
ago where they split, and you can use almost identical connection
methods..

Load on the FreeTDS libraries or Sybase OpenClient, the Perl DBI module,
and the DBD::Sybase (I'm pretty sure it works for MS SQL server)

I have also written my own sybase check which essentially does a "ping" 
by logging in with a known username/password, and does a "select 1+1" 
and the result should always be 2, if not then there is a big problem
and alert critical.

Cheers
rob



-------------------------------------------------------
This SF.Net email is sponsored by the JBoss Inc.
Get Certified Today * Register for a JBoss Training Course Free
Certification Exam for All Training Attendees Through End of 2005 Visit
http://www.jboss.com/services/certification for more information
_______________________________________________
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


-------------------------------------------------------
This SF.Net email is sponsored by the JBoss Inc.
Get Certified Today * Register for a JBoss Training Course
Free Certification Exam for All Training Attendees Through End of 2005
Visit http://www.jboss.com/services/certification for more information
_______________________________________________
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