| 
				     | 
				
| (2 intermediate revisions by the same user not shown) | 
| Line 1: | 
Line 1: | 
 | A new command record is required initiating monitor requests. The monitoring ID will be '''1''' which
  |  | Moved to  | 
 | means that this record is offered to be used for monitoring purposes.
  |  | SQL database setup  | 
 |    |  | 
 |    |  | 
 |  INSERT INTO `tblCommands` (`cmdID`,`enabled`,`name`,`command`,`type`,`type-description`) VALUES 
  |  | 
 |  (4,1,'Check HTTP','/usr/lib/nagios/plugins/check_http -H %HOST%',1,'Check IIS');
  |  | 
 |    |  | 
 |    |  | 
 | *tblRecover
  |  | 
 |  INSERT INTO `tblRecover` (`recID`,`enabled`,`name`,`command`) VALUES 
  |  | 
 |  (1,1,'Reset IIS','/usr/lib/nagios/plugins/check_nrpe -H %HOST% -p 5666 -c reset_iis'),
  |  | 
 |  (2,1,'Reset Apache','/usr/lib/nagios/plugins/check_nrpe -H %HOST% -p 5666 -c reset_apache'),
  |  | 
 |  (3,1,'Reboot','/usr/lib/nagios/plugins/check_nrpe -H %HOST% -p 5666 -c reboot');
  |  | 
 |    |  | 
 | *tblRecoverTasks
  |  | 
 |  INSERT INTO `tblRecoverTasks` (`TaskID`,`recTaskID`,`recID`,`recClock`,`title`) VALUES 
  |  | 
 |  (1,1,1,2,'Reset IIS'),
  |  | 
 |  (2,1,3,5,'Reset IIS'),
  |  | 
 |  (3,2,2,1,'Reset Apache'),
  |  | 
 |  (4,2,3,2,'Reset Apache');
  |  |