Configure Remote Access in myLVS: Difference between revisions
		
		
		
		Jump to navigation
		Jump to search
		
 (→mySQL)  | 
				|||
| Line 12: | Line 12: | ||
  mysql>  INSERT INTO `tblCommands` (`cmdID`,`enabled`,`name`,`command`,`type`,`type-description`) VALUES    |   mysql>  INSERT INTO `tblCommands` (`cmdID`,`enabled`,`name`,`command`,`type`,`type-description`) VALUES    | ||
  (1,1,'Reset IIS','/usr/lib/nagios/plugins/check_nrpe -H %HOST% -p 5666 -c reset_iis',2,'Reset Service'),  |   (1,1,'Reset IIS','/usr/lib/nagios/plugins/check_nrpe -H %HOST% -p 5666 -c reset_iis',2,'Reset Service'),  | ||
  (2,1,'Restart Apache','/usr/lib/nagios/plugins/check_nrpe -H %HOST% -p 5666 -c reset_apache',2,'Reset Service');  |   (2,1,'Restart Apache','/usr/lib/nagios/plugins/check_nrpe -H %HOST% -p 5666 -c reset_apache',2,'Reset Service'),  | ||
 (3,1,'Reboot Server','/usr/lib/nagios/plugins/check_nrpe -H %HOST% -p 5666 -c reboot',2,'Reboot Server');  | |||
| Line 18: | Line 20: | ||
  mysql> INSERT INTO `tblCommands` (`cmdID`,`enabled`,`name`,`command`,`type`,`type-description`) VALUES  |   mysql> INSERT INTO `tblCommands` (`cmdID`,`enabled`,`name`,`command`,`type`,`type-description`) VALUES  | ||
     ->  (1,1,'Reset IIS','/usr/lib/nagios/plugins/check_nrpe -H %HOST% -p 5666 -c reset_iis',2,'Reset Service'),  |      ->  (1,1,'Reset IIS','/usr/lib/nagios/plugins/check_nrpe -H %HOST% -p 5666 -c reset_iis',2,'Reset Service'),  | ||
     ->  (2,1,'Restart Apache','/usr/lib/nagios/plugins/check_nrpe -H %HOST% -p 5666 -c reset_apache',2,'Reset Service');  |      ->  (2,1,'Restart Apache','/usr/lib/nagios/plugins/check_nrpe -H %HOST% -p 5666 -c reset_apache',2,'Reset Service'),  | ||
  Query OK,   |     ->  (3,1,'Reboot Server','/usr/lib/nagios/plugins/check_nrpe -H %HOST% -p 5666 -c reboot',2,'Reboot Server');  | ||
  Records:   |   Query OK, 3 rows affected (0.00 sec)  | ||
  Records: 3  Duplicates: 0  Warnings: 0  | |||
=myLVS=  | =myLVS=  | ||
Revision as of 18:29, 13 July 2015
Add the nrpe commands reset_iis / reset_apache to the myLVS command table:
mySQL
- Login
 
root@mylvs01:/# mysql -u root -p
- Change the database
 
mysql> use mylvs;
- Insert the statements:
 
mysql> INSERT INTO `tblCommands` (`cmdID`,`enabled`,`name`,`command`,`type`,`type-description`) VALUES (1,1,'Reset IIS','/usr/lib/nagios/plugins/check_nrpe -H %HOST% -p 5666 -c reset_iis',2,'Reset Service'), (2,1,'Restart Apache','/usr/lib/nagios/plugins/check_nrpe -H %HOST% -p 5666 -c reset_apache',2,'Reset Service'), (3,1,'Reboot Server','/usr/lib/nagios/plugins/check_nrpe -H %HOST% -p 5666 -c reboot',2,'Reboot Server');
- The Return should look:
 
mysql> INSERT INTO `tblCommands` (`cmdID`,`enabled`,`name`,`command`,`type`,`type-description`) VALUES -> (1,1,'Reset IIS','/usr/lib/nagios/plugins/check_nrpe -H %HOST% -p 5666 -c reset_iis',2,'Reset Service'), -> (2,1,'Restart Apache','/usr/lib/nagios/plugins/check_nrpe -H %HOST% -p 5666 -c reset_apache',2,'Reset Service'), -> (3,1,'Reboot Server','/usr/lib/nagios/plugins/check_nrpe -H %HOST% -p 5666 -c reboot',2,'Reboot Server'); Query OK, 3 rows affected (0.00 sec) Records: 3 Duplicates: 0 Warnings: 0
myLVS
myLVS Server Command











