| 
				     | 
				
| Line 1: | 
Line 1: | 
 | Not all functions are implemented within the GUI, a few manual steps are required to setup remote access.<br>
  |  | Moved to  | 
 |    |  | SQL database setup  | 
 | New command records are required initiating monitor requests. <br>
  |  | 
 |    |  | 
 | *The monitoring ID will be '''1''' which means that this record is offered to be used for monitoring purposes.
  |  | 
 |  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');
  |  | 
 |    |  | 
 |    |  | 
 | *Messaging:
  |  | 
 |  INSERT INTO `tblMessaging` (`mid`,`type`,`mailfrom`,`server`,`mailto`,`mailcc`,`mailbcc`,`title`) VALUES 
  |  | 
 |  (1,1,'mylvs@yourdomain.com','smtp.yourdomain.com','you@yourdomain.com',NULL,NULL,'IT-Group');
  |  |