PLease help

[Aleksey Domorad]

Hi all,
 
In the contrib folder there's a check_mssql plug-in.
u can tweak it to do whatever you want it to do.
 
I'm working on changing it so it can check free space left in the MsSQL
database
 
A.

________________________________

From: nagios-users-admin at lists.sourceforge.net
[mailto:nagios-users-admin at lists.sourceforge.net] On Behalf Of Petrucci,
Joseph
Sent: Wednesday, October 12, 2005 10:36 AM
To: Forough, Hamid; nagios-users at lists.sourceforge.net
Subject: RE: [Nagios-users] PLease help


There is a SQL function called raiseerror it will write an error that
you definewithin the SQL server to the errorlog. This is in Sybase but I
thionk it is still in MSSQL. you can find information on it in the admin
manual. I use this functio inside my stored procedures to put the
results of the procedure in the errorlog. I then use a passive check in
Nagios to read the errorlog (I wrote this in ActivePerl) and look for
certain error codes. The passive plugin passes the results to Nagios
every 5 minutes and Nagios sends a critical alert if any of the errors
are present in the errorlog for the given period.

	-----Original Message-----
	From: Forough, Hamid [mailto:hamid.forough at amd.com]
	Sent: Wednesday, October 12, 2005 10:18 AM
	To: Petrucci, Joseph; nagios-users at lists.sourceforge.net
	Subject: RE: [Nagios-users] PLease help
	
	

	I don't understand. Can you elaborate please?

	 

	 

	
________________________________


	From: Petrucci, Joseph [mailto:Joseph.Petrucci at ddiworld.com] 
	Sent: Tuesday, October 11, 2005 11:58 AM
	To: Forough, Hamid; nagios-users at lists.sourceforge.net
	Subject: RE: [Nagios-users] PLease help

	 

	I do this with Sybase and it should still work this way i MSSQL
2K.

	 

	I would use a passive check (info on this is in the manual)
that reads the errorlog. Then you will have to have your procedure
execute a raiserror in the event of failure or any other message you
want. Have the plugin look at the error log for specific error numbers
that you define in the master.dbo.syserrors table (If there still is
one) 

	 

	Joseph A. Petrucci
	E Systems DBA
	------------------------------------------------
	Desk: 412-220-2646
	Cell: 412-916-2867
	Text message (e-mail) 4129162867 at mobile.att.net
	e-mail joseph.petrucci at ddiworld.com
	Personal Cell: 724-462-0443
	Personal e-mail: japetrucci at hotmail.com

	 

	
________________________________


	From: nagios-users-admin at lists.sourceforge.net on behalf of
Forough, Hamid
	Sent: Tue 10/11/2005 11:45 AM
	To: nagios-users at lists.sourceforge.net
	Subject: [Nagios-users] PLease help

	I need to know how to write a custom plugin that checks results
of a stored procedure in MSSQL 2k and returns Yes or NO? I am using 2b4
verision of Nagios

	 

	 

	 

	Thanks,
	Hamid

	Advanced Micro Devices

	 

	W: 512.602.4704
	C: 512.971-5345
	E: hamid.forough at amd.com
	 

	 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20051012/8a79c532/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.gif
Type: image/gif
Size: 2669 bytes
Desc: image001.gif
URL: <https://www.monitoring-lists.org/archive/users/attachments/20051012/8a79c532/attachment.gif>