PLease help

[Petrucci, Joseph]

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/b4f9ae33/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/b4f9ae33/attachment.gif>