static function cronCleanlogs()
{
global $DB;
$pmLog = new PluginMonitoringLog();
$pmConfig = new PluginMonitoringConfig();
$id_restart = 0;
$a_restarts = $pmLog->find("`action`='restart'", "`id` DESC", 1);
if (count($a_restarts) > 0) {
$a_restart = current($a_restarts);
$id_restart = $a_restart['id'];
}
$id_reload = 0;
$a_reloads = $pmLog->find("`action`='reload'", "`id` DESC", 1);
if (count($a_reloads) > 0) {
$a_reload = current($a_reloads);
$id_reload = $a_reload['id'];
}
$pmConfig->getFromDB(1);
$secs = $pmConfig->fields['logretention'] * DAY_TIMESTAMP;
$query = "DELETE FROM `" . $pmLog->getTable() . "`\n WHERE UNIX_TIMESTAMP(date_mod) < UNIX_TIMESTAMP()-{$secs}";
if ($id_restart > 0 || $id_reload > 0) {
// Keep last reload or restart command
$id_restart = max($id_restart, $id_reload);
$query .= " AND `id` < '" . $id_restart . "'";
}
$DB->query($query);
// TODO: Delete serviceevents table content ???
$query = "DELETE FROM `glpi_plugin_monitoring_serviceevents`\n WHERE UNIX_TIMESTAMP(date) < UNIX_TIMESTAMP()-{$secs}";
$DB->query($query);
return true;
}
static function cronCleanlogs()
{
global $DB;
$pmLog = new PluginMonitoringLog();
$pmConfig = new PluginMonitoringConfig();
$id_restart = 0;
$a_restarts = $pmLog->find("`action`='restart'", "`id` DESC", 1);
if (count($a_restarts) > 0) {
$a_restart = current($a_restarts);
$id_restart = $a_restart['id'];
}
$pmConfig->getFromDB(1);
$secs = $pmConfig->fields['logretention'] * DAY_TIMESTAMP;
$query = "DELETE FROM `" . $pmLog->getTable() . "`\n WHERE UNIX_TIMESTAMP(date_mod) < UNIX_TIMESTAMP()-{$secs}";
if ($id_restart > 0) {
$query .= " AND `id` < '" . $id_restart . "'";
}
$DB->query($query);
// Clean too events
PluginMonitoringServiceevent::cronUpdaterrd();
$pmUnavaibility = new PluginMonitoringUnavaibility();
$pmUnavaibility->runUnavaibility();
$query = "DELETE FROM `glpi_plugin_monitoring_serviceevents`\n WHERE UNIX_TIMESTAMP(date) < UNIX_TIMESTAMP()-{$secs}";
$DB->query($query);
return true;
}
function sendRestartArbiter($force = 0)
{
$pmTag = new PluginMonitoringTag();
$pmLog = new PluginMonitoringLog();
$a_tags = $pmTag->find();
foreach ($a_tags as $data) {
if (!$pmLog->isRestartLessThanFiveMinutes() || $force) {
$url = 'http://' . $data['ip'] . ':7760/';
$action = 'restart';
$a_fields = array();
$auth = $pmTag->getAuth($data['tag']);
$restart = $this->sendCommand($url, $action, $a_fields, '', $auth);
if ($restart) {
$input = array();
$input['user_name'] = $_SESSION['glpifirstname'] . ' ' . $_SESSION['glpirealname'] . ' (' . $_SESSION['glpiname'] . ')';
$input['action'] = "restart_planned";
$input['date_mod'] = date("Y-m-d H:i:s");
$pmLog->add($input);
}
}
}
}
function generateHostsCfg($file=0, $tag='') {
global $DB;
// Log Shinken restart event with Tag information ...
$pmLog = new PluginMonitoringLog();
if (isset($_SERVER['HTTP_USER_AGENT'])
AND strstr($_SERVER['HTTP_USER_AGENT'], 'xmlrpclib.py')) {
if (!isset($_SESSION['glpi_currenttime'])) {
$_SESSION['glpi_currenttime'] = date("Y-m-d H:i:s");
}
$input = array();
$input['user_name'] = "Shinken";
$input['action'] = "restart";
$input['date_mod'] = date("Y-m-d H:i:s");
$input['value'] = $tag;
$pmLog->add($input);
}
PluginMonitoringToolbox::logIfExtradebug(
'pm-shinken',
"Starting generateHostsCfg ($tag) ...\n"
);
$pmCommand = new PluginMonitoringCommand();
$pmCheck = new PluginMonitoringCheck();
$pmComponent = new PluginMonitoringComponent();
$pmEntity = new PluginMonitoringEntity();
$pmHostconfig = new PluginMonitoringHostconfig();
$pmHost = new PluginMonitoringHost();
$calendar = new Calendar();
$pmRealm = new PluginMonitoringRealm();
$networkEquipment = new NetworkEquipment();
$pmContact_Item = new PluginMonitoringContact_Item();
$profile_User = new Profile_User();
$pmEventhandler = new PluginMonitoringEventhandler();
$user = new User();
$a_hosts = array();
$i=0;
$a_parents_found = array();
$a_hosts_found = array();
$a_entities_allowed = $pmEntity->getEntitiesByTag($tag);
$a_entities_list = array();
foreach ($a_entities_allowed as $entity) {
$a_entities_list = getSonsOf("glpi_entities", $entity);
}
$where = '';
if (! isset($a_entities_allowed['-1'])) {
$where = getEntitiesRestrictRequest("WHERE", "glpi_entities", '', $a_entities_list);
}
// * Prepare contacts
$a_contacts_entities = array();
$a_list_contact = $pmContact_Item->find("`itemtype`='PluginMonitoringComponentscatalog'
AND `users_id`>0");
foreach ($a_list_contact as $data) {
$contactentities = getSonsOf('glpi_entities', $data['entities_id']);
if (isset($a_contacts_entities[$data['items_id']][$data['users_id']])) {
$contactentities = array_merge($contactentities, $a_contacts_entities[$data['items_id']][$data['users_id']]);
}
$a_contacts_entities[$data['items_id']][$data['users_id']] = $contactentities;
}
// $query = "SELECT *
// FROM `glpi_plugin_monitoring_componentscatalogs_hosts`
// GROUP BY `itemtype`, `items_id`";
$query = "SELECT
`glpi_plugin_monitoring_componentscatalogs_hosts`.*,
`glpi_computers`.`id`,
`glpi_entities`.`id` AS entityId, `glpi_entities`.`name` AS entityName, `glpi_entities`.`completename` AS entityFullName,
`glpi_locations`.`id`, `glpi_locations`.`completename` AS locationName,
`glpi_locations`.`comment` AS locationComment, `glpi_locations`.`building` AS locationGPS,
`glpi_plugin_monitoring_services`.`networkports_id`
FROM `glpi_plugin_monitoring_componentscatalogs_hosts`
LEFT JOIN `glpi_computers` ON `glpi_computers`.`id` = `glpi_plugin_monitoring_componentscatalogs_hosts`.`items_id`
LEFT JOIN `glpi_entities` ON `glpi_computers`.`entities_id` = `glpi_entities`.`id`
LEFT JOIN `glpi_locations` ON `glpi_locations`.`id` = `glpi_computers`.`locations_id`
LEFT JOIN `glpi_plugin_monitoring_services`
ON `glpi_plugin_monitoring_services`.`plugin_monitoring_componentscatalogs_hosts_id`
= `glpi_plugin_monitoring_componentscatalogs_hosts`.`id`
$where
GROUP BY `itemtype`, `items_id`";
PluginMonitoringToolbox::logIfExtradebug(
'pm-shinken',
"Hosts: $query\n"
);
$result = $DB->query($query);
while ($data=$DB->fetch_array($result)) {
// Toolbox::logInFile("pm-shinken", " - fetch host ".$data['itemtype']." / ".$data['items_id']."\n");
$classname = $data['itemtype'];
$class = new $classname;
if ($class->getFromDB($data['items_id'])) {
// if (isset($a_entities_allowed['-1'])
// OR isset($a_entities_allowed[$class->fields['entities_id']])) {
$pmHost->getFromDBByQuery("WHERE `glpi_plugin_monitoring_hosts`.`itemtype` = '" . $data['itemtype'] . "' AND `glpi_plugin_monitoring_hosts`.`items_id` = '" . $data['items_id'] . "' LIMIT 1");
$a_hosts[$i]['host_name'] = preg_replace("/[^A-Za-z0-9\-_]/","",$class->fields['name']);
// Fix if hostname is not defined ...
if (empty($a_hosts[$i]['host_name'])) {
continue;
}
$a_hosts_found[$a_hosts[$i]['host_name']] = 1;
PluginMonitoringToolbox::logIfExtradebug(
'pm-shinken',
" - add host ".$a_hosts[$i]['host_name']."\n"
);
$a_hosts[$i]['_HOSTID'] =
$pmHost->getField('id');
if (isset(self::$shinkenParameters['glpi']['entityId'])) {
$a_hosts[$i][self::$shinkenParameters['glpi']['entityId']] =
$data['entityId'];
}
if (isset(self::$shinkenParameters['glpi']['itemType'])) {
$a_hosts[$i][self::$shinkenParameters['glpi']['itemType']] =
$classname;
}
if (isset(self::$shinkenParameters['glpi']['itemId'])) {
$a_hosts[$i][self::$shinkenParameters['glpi']['itemId']] =
$data['items_id'];
}
if (isset(self::$shinkenParameters['glpi']['entityName'])) {
$a_hosts[$i][self::$shinkenParameters['glpi']['entityName']] =
strtolower(preg_replace("/[^A-Za-z0-9\-_]/","",$data['entityName']));
}
$data['entityFullName'] = preg_replace("/ > /","#",$data['entityFullName']);
$data['entityFullName'] = preg_replace("/". self::$shinkenParameters['glpi']['rootEntity'] ."#/","",$data['entityFullName']);
$data['entityFullName'] = preg_replace("/#/","_",$data['entityFullName']);
if (isset(self::$shinkenParameters['glpi']['entityComplete'])) {
$a_hosts[$i][self::$shinkenParameters['glpi']['entityComplete']] =
strtolower(preg_replace("/[^A-Za-z0-9\-_]/","",$data['entityFullName']));
}
$data['entityFullName'] = preg_replace("/_/",".",$data['entityFullName']);
if (isset(self::$shinkenParameters['glpi']['location'])) {
if (! empty($data['locationName'])) {
// Toolbox::logInFile("pm-shinken", " - location: ".$data['locationName']."\n");
$string = utf8_decode(strip_tags(trim($data['locationName'])));
// $string = Toolbox::decodeFromUtf8($data['locationName']);
$string = preg_replace("/[\r\n]/",".",$data['locationName']);
$string = preg_replace("/[^A-Za-z0-9\-_ <>\',;.:!?%*()éèàù]/",'',$string);
// Toolbox::logInFile("pm-shinken", " - location: ".$string."\n");
$a_hosts[$i][self::$shinkenParameters['glpi']['location']] =
$string;
}
}
if (isset(self::$shinkenParameters['graphite']['prefix']['name'])) {
$a_hosts[$i][self::$shinkenParameters['graphite']['prefix']['name']] =
strtolower(self::$shinkenParameters['graphite']['prefix']['value'] . preg_replace("/[^A-Za-z0-9\-_.]/","",$data['entityFullName']));
}
if (isset(self::$shinkenParameters['glpi']['lat'])) {
if (! empty($data['locationGPS'])) {
$split = explode(',', $data['locationGPS']);
if (count($split) > 2) {
// At least 3 elements, let us consider as GPS coordinates with altitude ...
$a_hosts[$i][self::$shinkenParameters['glpi']['lat']] = $split[0];
$a_hosts[$i][self::$shinkenParameters['glpi']['lng']] = $split[1];
$a_hosts[$i][self::$shinkenParameters['glpi']['alt']] = $split[2];
} else if (count($split) > 1) {
// At least 2 elements, let us consider as GPS coordinates ...
$a_hosts[$i][self::$shinkenParameters['glpi']['lat']] = $split[0];
$a_hosts[$i][self::$shinkenParameters['glpi']['lng']] = $split[1];
// } else {
// $a_hosts[$i]['_LOC_BUILDING'] = preg_replace("/[\r\n]/",".",$data['locationGPS']);
// $a_hosts[$i]['_LOC_BUILDING'] = preg_replace("/[^A-Za-z0-9\-_]/"," / ",$a_hosts[$i]['_LOC_BUILDING']);
}
}
}
// Hostgroup name
$a_hosts[$i]['hostgroups'] = strtolower(preg_replace("/[^A-Za-z0-9\-_ ]/","",$data['entityName']));
$a_hosts[$i]['hostgroups'] = preg_replace("/[ ]/","_",$a_hosts[$i]['hostgroups']);
// Alias
$a_hosts[$i]['alias'] = $data['entityName']." / ". $a_hosts[$i]['host_name'];
if (isset($class->fields['networkequipmenttypes_id'])) {
if ($class->fields['networkequipmenttypes_id'] > 0) {
$a_hosts[$i]['alias'] .= " (".Dropdown::getDropdownName("glpi_networkequipmenttypes", $class->fields['networkequipmenttypes_id']).")";
}
} else if (isset($class->fields['computertypes_id'])) {
if ($class->fields['computertypes_id'] > 0) {
$a_hosts[$i]['alias'] .= " (".Dropdown::getDropdownName("glpi_computertypes", $class->fields['computertypes_id']).")";
}
} else if (isset($class->fields['printertypes_id'])) {
if ($class->fields['printertypes_id'] > 0) {
$a_hosts[$i]['alias'] .= " (".Dropdown::getDropdownName("glpi_printertypes", $class->fields['printertypes_id']).")";
}
}
// WebUI user interface ...
if (isset(self::$shinkenParameters['webui']['hostIcons']['name'])) {
$a_hosts[$i][self::$shinkenParameters['webui']['hostIcons']['name']] =
self::$shinkenParameters['webui']['hostIcons']['value'];
}
if (isset(self::$shinkenParameters['webui']['hostView']['name'])) {
$a_hosts[$i][self::$shinkenParameters['webui']['hostView']['name']] =
self::$shinkenParameters['webui']['hostView']['value'];
}
// IP address
$ip = PluginMonitoringHostaddress::getIp($data['items_id'], $data['itemtype'], $class->fields['name']);
$a_hosts[$i]['address'] = $ip;
// Manage dependencies
$parent = '';
if ($data['itemtype'] != 'NetworkEquipment') {
$networkPort = new NetworkPort();
$a_networkports = $networkPort->find("`itemtype`='".$data['itemtype']."'
AND `items_id`='".$data['items_id']."'");
foreach ($a_networkports as $data_n) {
$networkports_id = $networkPort->getContact($data_n['id']);
if ($networkports_id) {
$networkPort->getFromDB($networkports_id);
if ($networkPort->fields['itemtype'] == 'NetworkEquipment') {
$networkEquipment->getFromDB($networkPort->fields['items_id']);
$parent = preg_replace("/[^A-Za-z0-9\-_]/","",$networkEquipment->fields['name']);
$a_parents_found[$parent] = 1;
$pmHost->updateDependencies($classname, $data['items_id'], 'NetworkEquipment-'.$networkPort->fields['items_id']);
}
}
}
if (empty($parent)) {
if (self::$shinkenParameters['shinken']['hosts']['parents'] == 'entity') {
$parent = self::$shinkenParameters['shinken']['fake_hosts']['name_prefix'] . $a_hosts[$i]['hostgroups'];
} else {
$parent = self::$shinkenParameters['shinken']['hosts']['parents'];
}
}
}
$a_hosts[$i]['parents'] = $parent;
$a_fields = array();
$pmComponent->getFromDB($pmHostconfig->getValueAncestor('plugin_monitoring_components_id',
$class->fields['entities_id'],
$classname,
$class->getID()));
$pmCommand->getFromDB($pmComponent->fields['plugin_monitoring_commands_id']);
$a_fields = $pmComponent->fields;
// Manage host check_command arguments
// Toolbox::logInFile("pm-shinken", "Command line : ".$pmCommand->fields['command_line']."\n");
// Toolbox::logInFile("pm-shinken", "Arguments : ".$a_fields['arguments']."\n");
// Toolbox::logInFile("pm-shinken", "Arguments : ".$pmCommand->fields['arguments']."\n");
$array = array();
preg_match_all("/\\$(ARG\d+)\\$/", $pmCommand->fields['command_line'], $array);
sort($array[0]);
$a_arguments = importArrayFromDB($pmCommand->fields['arguments']);
$a_argumentscustom = importArrayFromDB($pmComponent->fields['arguments']);
foreach ($a_argumentscustom as $key=>$value) {
$a_arguments[$key] = $value;
}
foreach ($a_arguments as $key=>$value) {
$a_arguments[$key] = str_replace('!', '\!', html_entity_decode($value));
}
$args = '';
foreach ($array[0] as $arg) {
if ($arg != '$PLUGINSDIR$'
AND $arg != '$NAGIOSPLUGINSDIR$'
AND $arg != '$HOSTADDRESS$'
AND $arg != '$MYSQLUSER$'
AND $arg != '$MYSQLPASSWORD$') {
$arg = str_replace('$', '', $arg);
if (!isset($a_arguments[$arg])) {
$args .= '!';
} else {
if (strstr($a_arguments[$arg], "[[HOSTNAME]]")) {
$a_arguments[$arg] = str_replace("[[HOSTNAME]]", $hostname, $a_arguments[$arg]);
} elseif (strstr($a_arguments[$arg], "[[NETWORKPORTDESCR]]")){
if (class_exists("PluginFusioninventoryNetworkPort")) {
$pfNetworkPort = new PluginFusioninventoryNetworkPort();
$pfNetworkPort->loadNetworkport($data['networkports_id']);
$descr = $pfNetworkPort->getValue("ifdescr");
$a_arguments[$arg] = str_replace("[[NETWORKPORTDESCR]]", $descr, $a_arguments[$arg]);
}
} elseif (strstr($a_arguments[$arg], "[[NETWORKPORTNUM]]")){
$networkPort = new NetworkPort();
$networkPort->getFromDB($data['networkports_id']);
$logicalnum = $pfNetworkPort->fields['logical_number'];
$a_arguments[$arg] = str_replace("[[NETWORKPORTNUM]]", $logicalnum, $a_arguments[$arg]);
} elseif (strstr($a_arguments[$arg], "[[NETWORKPORTNAME]]")) {
if (isset($data['networkports_id'])
&& $data['networkports_id'] > 0) {
$networkPort = new NetworkPort();
$networkPort->getFromDB($data['networkports_id']);
$portname = $pfNetworkPort->fields['name'];
$a_arguments[$arg] = str_replace("[[NETWORKPORTNAME]]", $portname, $a_arguments[$arg]);
} else if ($classname == 'Computer') {
// Get networkportname of networkcard defined
$pmHostaddress = new PluginMonitoringHostaddress();
$a_hostaddresses = $pmHostaddress->find("`itemtype`='Computer'"
. " AND `items_id`='".$class->fields['id']."'", '', 1);
if (count($a_hostaddresses) == 1) {
$a_hostaddress = current($a_hostaddresses);
if ($a_hostaddress['networkports_id'] > 0) {
$networkPort = new NetworkPort();
$networkPort->getFromDB($a_hostaddress['networkports_id']);
$a_arguments[$arg] = str_replace("[[NETWORKPORTNAME]]", $networkPort->fields['name'], $a_arguments[$arg]);
}
}
}
} else if (strstr($a_arguments[$arg], "[")) {
$a_arguments[$arg] = PluginMonitoringService::convertArgument($data['id'], $a_arguments[$arg]);
}
if ($a_arguments == '') {
$notadd = 1;
if ($notadddescription != '') {
$notadddescription .= ", ";
}
$notadddescription .= "Argument ".$a_arguments[$arg]." Not have value";
}
$args .= '!'.$a_arguments[$arg];
if ($a_arguments[$arg] == ''
AND $a_component['alias_command'] != '') {
$args .= $a_component['alias_command'];
}
}
}
}
$a_hosts[$i]['check_command'] = PluginMonitoringCommand::$command_prefix . $pmCommand->fields['command_name'].$args;
// Toolbox::logInFile("pm", "check_command : ".$a_hosts[$i]['check_command']."\n");
$pmCheck->getFromDB($pmComponent->fields['plugin_monitoring_checks_id']);
$a_hosts[$i]['check_interval'] = $pmCheck->fields['check_interval'];
$a_hosts[$i]['retry_interval'] = $pmCheck->fields['retry_interval'];
$a_hosts[$i]['max_check_attempts'] = $pmCheck->fields['max_check_attempts'];
if ($calendar->getFromDB($pmComponent->fields['calendars_id'])) {
$a_hosts[$i]['check_period'] = $calendar->fields['name'];
} else {
$a_hosts[$i]['check_period'] = self::$shinkenParameters['shinken']['hosts']['check_period'];
}
$a_hosts[$i]['active_checks_enabled'] = $a_fields['active_checks_enabled'];
$a_hosts[$i]['passive_checks_enabled'] = $a_fields['passive_checks_enabled'];
// Manage freshness
if ($a_fields['freshness_count'] == 0) {
$a_hosts[$i]['check_freshness'] = '0';
$a_hosts[$i]['freshness_threshold'] = '0';
} else {
$multiple = 1;
if ($a_fields['freshness_type'] == 'seconds') {
$multiple = 1;
} else if ($a_fields['freshness_type'] == 'minutes') {
$multiple = 60;
} else if ($a_fields['freshness_type'] == 'hours') {
$multiple = 3600;
} else if ($a_fields['freshness_type'] == 'days') {
$multiple = 86400;
}
$a_hosts[$i]['check_freshness'] = '1';
$a_hosts[$i]['freshness_threshold'] = (string)($a_fields['freshness_count'] * $multiple);
}
// Manage event handler
if ($a_fields['plugin_monitoring_eventhandlers_id'] > 0) {
if ($a_fields->getFromDB($a_fields['plugin_monitoring_eventhandlers_id'])) {
$a_hosts[$i]['event_handler'] = $pmEventhandler->fields['command_name'];
}
}
// Realm
$pmRealm->getFromDB($pmHostconfig->getValueAncestor('plugin_monitoring_realms_id',
$class->fields['entities_id'],
$classname,
$class->getID()));
$a_hosts[$i]['realm'] = $pmRealm->fields['name'];
if (! empty(self::$shinkenParameters['shinken']['hosts']['use'])) $a_hosts[$i]['use'] = self::$shinkenParameters['shinken']['hosts']['use'];
if (! empty(self::$shinkenParameters['shinken']['hosts']['process_perf_data'])) $a_hosts[$i]['process_perf_data'] = self::$shinkenParameters['shinken']['hosts']['process_perf_data'];
if (! empty(self::$shinkenParameters['shinken']['hosts']['notification_period'])) $a_hosts[$i]['notification_period'] = self::$shinkenParameters['shinken']['hosts']['notification_period'];
if (! empty(self::$shinkenParameters['shinken']['hosts']['notification_options'])) $a_hosts[$i]['notification_options'] = self::$shinkenParameters['shinken']['hosts']['notification_options'];
if (! empty(self::$shinkenParameters['shinken']['hosts']['notification_interval'])) $a_hosts[$i]['notification_interval'] = self::$shinkenParameters['shinken']['hosts']['notification_interval'];
if (! empty(self::$shinkenParameters['shinken']['hosts']['notes'])) $a_hosts[$i]['notes'] = self::$shinkenParameters['shinken']['hosts']['notes'];
if (! empty(self::$shinkenParameters['shinken']['hosts']['notes_url'])) $a_hosts[$i]['notes_url'] = self::$shinkenParameters['shinken']['hosts']['notes_url'];
if (! empty(self::$shinkenParameters['shinken']['hosts']['action_url'])) $a_hosts[$i]['action_url'] = self::$shinkenParameters['shinken']['hosts']['action_url'];
if (! empty(self::$shinkenParameters['shinken']['hosts']['icon_image'])) $a_hosts[$i]['icon_image'] = self::$shinkenParameters['shinken']['hosts']['icon_image'];
if (! empty(self::$shinkenParameters['shinken']['hosts']['icon_image_alt'])) $a_hosts[$i]['icon_image_alt'] = self::$shinkenParameters['shinken']['hosts']['icon_image_alt'];
if (! empty(self::$shinkenParameters['shinken']['hosts']['vrml_image'])) $a_hosts[$i]['vrml_image'] = self::$shinkenParameters['shinken']['hosts']['vrml_image'];
if (! empty(self::$shinkenParameters['shinken']['hosts']['statusmap_image'])) $a_hosts[$i]['statusmap_image'] = self::$shinkenParameters['shinken']['hosts']['statusmap_image'];
// For contacts, check if a component catalog contains the host associated component ...
$a_hosts[$i]['contacts'] = '';
if (($a_fields['passive_checks_enabled'] == '1') and ($a_fields['active_checks_enabled'] == '0')) {
// Specific query if host is only passively checked ...
// Find the first component catalog in which the host is used ...
$querycont = "SELECT * FROM `glpi_plugin_monitoring_componentscatalogs_hosts`
LEFT JOIN `glpi_plugin_monitoring_services`
ON `plugin_monitoring_componentscatalogs_hosts_id`
= `glpi_plugin_monitoring_componentscatalogs_hosts`.`id`
WHERE `items_id`='".$data['items_id']."' AND `itemtype`='".$data['itemtype']."'
LIMIT 1";
} else {
// Find component catalog which contains the host associated component ...
$querycont = "SELECT * FROM `glpi_plugin_monitoring_componentscatalogs_hosts`
LEFT JOIN `glpi_plugin_monitoring_services`
ON `plugin_monitoring_componentscatalogs_hosts_id`
= `glpi_plugin_monitoring_componentscatalogs_hosts`.`id`
WHERE `plugin_monitoring_components_id`='".$pmComponent->fields['id']."' AND
`items_id`='".$data['items_id']."' AND `itemtype`='".$data['itemtype']."'
LIMIT 1";
}
$resultcont = $DB->query($querycont);
if ($DB->numrows($resultcont) != 0) {
$a_componentscatalogs_hosts = $DB->fetch_assoc($resultcont);
// Notification interval
$pmComponentscatalog = new PluginMonitoringComponentscatalog();
$pmComponentscatalog->getFromDB($a_componentscatalogs_hosts['plugin_monitoring_componentscalalog_id']);
$a_hosts[$i]['notification_interval'] = $pmComponentscatalog->fields['notification_interval'];
$a_contacts = array();
$a_list_contact = $pmContact_Item->find("`itemtype`='PluginMonitoringComponentscatalog'
AND `items_id`='".$a_componentscatalogs_hosts['plugin_monitoring_componentscalalog_id']."'");
foreach ($a_list_contact as $data_contact) {
if (isset($a_contacts_entities[$a_componentscatalogs_hosts['plugin_monitoring_componentscalalog_id']][$data_contact['users_id']])) {
if (in_array($class->fields['entities_id'], $a_contacts_entities[$a_componentscatalogs_hosts['plugin_monitoring_componentscalalog_id']][$data_contact['users_id']])) {
$user->getFromDB($data_contact['users_id']);
$a_contacts[] = $user->fields['name'];
}
}
}
if (count($a_contacts) > 0) {
$a_contacts_unique = array_unique($a_contacts);
$a_hosts[$i]['contacts'] = implode(',', $a_contacts_unique);
}
}
$i++;
// }
}
}
// Fake host for business rules
PluginMonitoringToolbox::logIfExtradebug(
'pm-shinken',
" - add host_for_bp\n"
);
$a_hosts[$i]['host_name'] = self::$shinkenParameters['shinken']['fake_hosts']['name_prefix'] . self::$shinkenParameters['shinken']['fake_hosts']['bp_host'];
$a_hosts[$i]['check_command'] = PluginMonitoringCommand::$command_prefix . 'check_dummy!0';
$a_hosts[$i]['alias'] = 'Fake host for business rules';
$a_hosts[$i]['_HOSTID'] = '0';
$a_hosts[$i]['_ITEMSID'] = '0';
$a_hosts[$i]['_ITEMTYPE'] = 'Computer';
$a_hosts[$i]['address'] = '127.0.0.1';
$a_hosts[$i]['parents'] = self::$shinkenParameters['shinken']['fake_hosts']['name_prefix'] . self::$shinkenParameters['shinken']['fake_hosts']['root_parent'];
$a_hosts[$i]['hostgroups'] = self::$shinkenParameters['shinken']['fake_hosts']['hostgroup_name'];
$a_hosts[$i]['check_interval'] = '60';
$a_hosts[$i]['retry_interval'] = '1';
$a_hosts[$i]['max_check_attempts'] = '1';
$a_hosts[$i]['check_period'] = '24x7';
if (self::$shinkenParameters['shinken']['fake_contacts']['build']) {
$a_hosts[$i]['contacts'] = self::$shinkenParameters['shinken']['fake_contacts']['contact_name'];
} else {
$a_hosts[$i]['contacts'] = '';
}
if (! empty(self::$shinkenParameters['shinken']['fake_hosts']['use'])) $a_hosts[$i]['use'] = self::$shinkenParameters['shinken']['fake_hosts']['use'];
if (! empty(self::$shinkenParameters['shinken']['hosts']['process_perf_data'])) $a_hosts[$i]['process_perf_data'] = self::$shinkenParameters['shinken']['hosts']['process_perf_data'];
if (! empty(self::$shinkenParameters['shinken']['hosts']['notification_period'])) $a_hosts[$i]['notification_period'] = self::$shinkenParameters['shinken']['hosts']['notification_period'];
if (! empty(self::$shinkenParameters['shinken']['hosts']['notification_options'])) $a_hosts[$i]['notification_options'] = self::$shinkenParameters['shinken']['hosts']['notification_options'];
if (! empty(self::$shinkenParameters['shinken']['hosts']['notification_interval'])) $a_hosts[$i]['notification_interval'] = self::$shinkenParameters['shinken']['hosts']['notification_interval'];
if (! empty(self::$shinkenParameters['shinken']['hosts']['notes'])) $a_hosts[$i]['notes'] = self::$shinkenParameters['shinken']['hosts']['notes'];
if (! empty(self::$shinkenParameters['shinken']['hosts']['notes_url'])) $a_hosts[$i]['notes_url'] = self::$shinkenParameters['shinken']['hosts']['notes_url'];
if (! empty(self::$shinkenParameters['shinken']['hosts']['action_url'])) $a_hosts[$i]['action_url'] = self::$shinkenParameters['shinken']['hosts']['action_url'];
if (! empty(self::$shinkenParameters['shinken']['hosts']['icon_image'])) $a_hosts[$i]['icon_image'] = self::$shinkenParameters['shinken']['hosts']['icon_image'];
if (! empty(self::$shinkenParameters['shinken']['hosts']['icon_image_alt'])) $a_hosts[$i]['icon_image_alt'] = self::$shinkenParameters['shinken']['hosts']['icon_image_alt'];
if (! empty(self::$shinkenParameters['shinken']['hosts']['vrml_image'])) $a_hosts[$i]['vrml_image'] = self::$shinkenParameters['shinken']['hosts']['vrml_image'];
if (! empty(self::$shinkenParameters['shinken']['hosts']['statusmap_image'])) $a_hosts[$i]['statusmap_image'] = self::$shinkenParameters['shinken']['hosts']['statusmap_image'];
$i++;
// Add one fake host for each entity
if (self::$shinkenParameters['shinken']['fake_hosts']['build']) {
PluginMonitoringToolbox::logIfExtradebug(
'pm-shinken',
" - add fake hosts for parents relationship\n"
);
// Main root parent
$a_hosts[$i]['host_name'] = self::$shinkenParameters['shinken']['fake_hosts']['name_prefix'] . self::$shinkenParameters['shinken']['fake_hosts']['root_parent'];
$a_hosts[$i]['check_command'] = PluginMonitoringCommand::$command_prefix . 'check_dummy!0';
$a_hosts[$i]['alias'] = 'Main root parent';
$a_hosts[$i]['_HOSTID'] = '0';
$a_hosts[$i]['_ITEMSID'] = '0';
$a_hosts[$i]['_ITEMTYPE'] = 'Computer';
$a_hosts[$i]['address'] = '127.0.0.1';
$a_hosts[$i]['parents'] = '';
$a_hosts[$i]['hostgroups'] = self::$shinkenParameters['shinken']['fake_hosts']['hostgroup_name'];
$a_hosts[$i]['check_interval'] = '60';
$a_hosts[$i]['retry_interval'] = '1';
$a_hosts[$i]['max_check_attempts'] = '1';
$a_hosts[$i]['check_period'] = '24x7';
if (self::$shinkenParameters['shinken']['fake_contacts']['build']) {
$a_hosts[$i]['contacts'] = self::$shinkenParameters['shinken']['fake_contacts']['contact_name'];
} else {
$a_hosts[$i]['contacts'] = '';
}
if (! empty(self::$shinkenParameters['shinken']['fake_hosts']['use'])) $a_hosts[$i]['use'] = self::$shinkenParameters['shinken']['fake_hosts']['use'];
if (! empty(self::$shinkenParameters['shinken']['hosts']['process_perf_data'])) $a_hosts[$i]['process_perf_data'] = self::$shinkenParameters['shinken']['hosts']['process_perf_data'];
if (! empty(self::$shinkenParameters['shinken']['hosts']['notification_period'])) $a_hosts[$i]['notification_period'] = self::$shinkenParameters['shinken']['hosts']['notification_period'];
if (! empty(self::$shinkenParameters['shinken']['hosts']['notification_options'])) $a_hosts[$i]['notification_options'] = self::$shinkenParameters['shinken']['hosts']['notification_options'];
if (! empty(self::$shinkenParameters['shinken']['hosts']['notification_interval'])) $a_hosts[$i]['notification_interval'] = self::$shinkenParameters['shinken']['hosts']['notification_interval'];
if (! empty(self::$shinkenParameters['shinken']['hosts']['notes'])) $a_hosts[$i]['notes'] = self::$shinkenParameters['shinken']['hosts']['notes'];
if (! empty(self::$shinkenParameters['shinken']['hosts']['notes_url'])) $a_hosts[$i]['notes_url'] = self::$shinkenParameters['shinken']['hosts']['notes_url'];
if (! empty(self::$shinkenParameters['shinken']['hosts']['action_url'])) $a_hosts[$i]['action_url'] = self::$shinkenParameters['shinken']['hosts']['action_url'];
if (! empty(self::$shinkenParameters['shinken']['hosts']['icon_image'])) $a_hosts[$i]['icon_image'] = self::$shinkenParameters['shinken']['hosts']['icon_image'];
if (! empty(self::$shinkenParameters['shinken']['hosts']['icon_image_alt'])) $a_hosts[$i]['icon_image_alt'] = self::$shinkenParameters['shinken']['hosts']['icon_image_alt'];
if (! empty(self::$shinkenParameters['shinken']['hosts']['vrml_image'])) $a_hosts[$i]['vrml_image'] = self::$shinkenParameters['shinken']['hosts']['vrml_image'];
if (! empty(self::$shinkenParameters['shinken']['hosts']['statusmap_image'])) $a_hosts[$i]['statusmap_image'] = self::$shinkenParameters['shinken']['hosts']['statusmap_image'];
$i++;
$a_entities_allowed = $pmEntity->getEntitiesByTag($tag);
$a_entities_list = array();
foreach ($a_entities_allowed as $entity) {
$a_entities_list = getSonsOf("glpi_entities", $entity);
}
$where = '';
if (! isset($a_entities_allowed['-1'])) {
$where = getEntitiesRestrictRequest("WHERE", "glpi_entities", '', $a_entities_list);
}
$query = "SELECT
`glpi_entities`.`id` AS entityId, `glpi_entities`.`name` AS entityName
FROM `glpi_entities` $where";
$result = $DB->query($query);
while ($dataEntity=$DB->fetch_array($result)) {
// Hostgroup name : used as host name for parents ...
$fake_host_name = strtolower(preg_replace("/[^A-Za-z0-9\-_ ]/","",$dataEntity['entityName']));
$fake_host_name = preg_replace("/[ ]/","_",$fake_host_name);
$a_hosts[$i]['host_name'] = self::$shinkenParameters['shinken']['fake_hosts']['name_prefix'] . $fake_host_name;
$a_hosts[$i]['check_command'] = PluginMonitoringCommand::$command_prefix . 'check_dummy!0';
$a_hosts[$i]['alias'] = $dataEntity['entityName'];
$a_hosts[$i]['_HOSTID'] = '0';
$a_hosts[$i]['_ITEMSID'] = '0';
$a_hosts[$i]['_ITEMTYPE'] = 'Computer';
$a_hosts[$i]['address'] = '127.0.0.1';
$a_hosts[$i]['parents'] = self::$shinkenParameters['shinken']['fake_hosts']['name_prefix'] . self::$shinkenParameters['shinken']['fake_hosts']['root_parent'];
$a_hosts[$i]['hostgroups'] = self::$shinkenParameters['shinken']['fake_hosts']['hostgroup_name'];
$a_hosts[$i]['check_interval'] = '60';
$a_hosts[$i]['retry_interval'] = '1';
$a_hosts[$i]['max_check_attempts'] = '1';
$a_hosts[$i]['check_period'] = '24x7';
if (self::$shinkenParameters['shinken']['fake_contacts']['build']) {
$a_hosts[$i]['contacts'] = self::$shinkenParameters['shinken']['fake_contacts']['contact_name'];
} else {
$a_hosts[$i]['contacts'] = '';
}
if (! empty(self::$shinkenParameters['shinken']['fake_hosts']['use'])) $a_hosts[$i]['use'] = self::$shinkenParameters['shinken']['fake_hosts']['use'];
if (! empty(self::$shinkenParameters['shinken']['hosts']['process_perf_data'])) $a_hosts[$i]['process_perf_data'] = self::$shinkenParameters['shinken']['hosts']['process_perf_data'];
if (! empty(self::$shinkenParameters['shinken']['hosts']['notification_period'])) $a_hosts[$i]['notification_period'] = self::$shinkenParameters['shinken']['hosts']['notification_period'];
if (! empty(self::$shinkenParameters['shinken']['hosts']['notification_options'])) $a_hosts[$i]['notification_options'] = self::$shinkenParameters['shinken']['hosts']['notification_options'];
if (! empty(self::$shinkenParameters['shinken']['hosts']['notification_interval'])) $a_hosts[$i]['notification_interval'] = self::$shinkenParameters['shinken']['hosts']['notification_interval'];
if (! empty(self::$shinkenParameters['shinken']['hosts']['notes'])) $a_hosts[$i]['notes'] = self::$shinkenParameters['shinken']['hosts']['notes'];
if (! empty(self::$shinkenParameters['shinken']['hosts']['notes_url'])) $a_hosts[$i]['notes_url'] = self::$shinkenParameters['shinken']['hosts']['notes_url'];
if (! empty(self::$shinkenParameters['shinken']['hosts']['action_url'])) $a_hosts[$i]['action_url'] = self::$shinkenParameters['shinken']['hosts']['action_url'];
if (! empty(self::$shinkenParameters['shinken']['hosts']['icon_image'])) $a_hosts[$i]['icon_image'] = self::$shinkenParameters['shinken']['hosts']['icon_image'];
if (! empty(self::$shinkenParameters['shinken']['hosts']['icon_image_alt'])) $a_hosts[$i]['icon_image_alt'] = self::$shinkenParameters['shinken']['hosts']['icon_image_alt'];
if (! empty(self::$shinkenParameters['shinken']['hosts']['vrml_image'])) $a_hosts[$i]['vrml_image'] = self::$shinkenParameters['shinken']['hosts']['vrml_image'];
if (! empty(self::$shinkenParameters['shinken']['hosts']['statusmap_image'])) $a_hosts[$i]['statusmap_image'] = self::$shinkenParameters['shinken']['hosts']['statusmap_image'];
$i++;
}
PluginMonitoringToolbox::logIfExtradebug(
'pm-shinken',
"End generateHostgroupsCfg\n"
);
}
// Check if parents all exist in hosts config
foreach ($a_parents_found as $host => $num) {
if (!isset($a_hosts_found[$host])) {
// Delete parents not added in hosts config
foreach ($a_hosts as $id=>$data) {
if ($data['parents'] == $host) {
$a_hosts[$id]['parents'] = '';
}
}
}
}
PluginMonitoringToolbox::logIfExtradebug(
'pm-shinken',
"End generateHostsCfg\n"
);
if ($file == "1") {
$config = "# Generated by plugin monitoring for GLPI\n# on ".date("Y-m-d H:i:s")."\n\n";
foreach ($a_hosts as $data) {
$config .= $this->writeFile("host", $data);
}
return array('hosts.cfg', $config);
} else {
return $a_hosts;
}
}
function sendRestartArbiter($force = 0, $tag = 0, $command = 'reload')
{
$pmTag = new PluginMonitoringTag();
$pmLog = new PluginMonitoringLog();
if (!$pmLog->isRestartLessThanFiveMinutes() || $force) {
if ($tag > 0) {
$pmTag->getFromDB($tag);
$url = 'http://' . $pmTag->fields['ip'] . ':' . $pmTag->fields['port'] . '/';
$auth = $pmTag->getAuth($pmTag->fields['tag']);
if ($this->sendCommand($url, $command, array(), '', $auth)) {
$input = array();
$input['user_name'] = $_SESSION['glpifirstname'] . ' ' . $_SESSION['glpirealname'] . ' (' . $_SESSION['glpiname'] . ')';
$input['action'] = $command . "_planned";
$input['date_mod'] = date("Y-m-d H:i:s");
$input['value'] = $pmTag->fields['tag'];
$pmLog->add($input);
}
} else {
$a_tagsBrut = $pmTag->find();
$a_tags = array();
foreach ($a_tagsBrut as $data) {
if (!isset($a_tags[$data['ip'] . ':' . $data['port']])) {
$a_tags[$data['ip'] . ':' . $data['port']] = $data;
}
}
foreach ($a_tags as $data) {
// TODO : should be parameters ... Shinken arbiter may use another port and may use HTTPS !
$url = 'http://' . $data['ip'] . ':' . $data['port'] . '/';
$auth = $pmTag->getAuth($data['tag']);
if ($this->sendCommand($url, $command, array(), '', $auth)) {
$input = array();
$input['user_name'] = $_SESSION['glpifirstname'] . ' ' . $_SESSION['glpirealname'] . ' (' . $_SESSION['glpiname'] . ')';
$input['action'] = $command . "_planned";
$input['date_mod'] = date("Y-m-d H:i:s");
$input['value'] = $data['tag'];
$pmLog->add($input);
}
}
}
}
}
function displayShinkenRestart()
{
$pmLog = new PluginMonitoringLog();
$a_reload_planned = $pmLog->find("(`action`='reload' OR `action`='reload_planned') AND " . "`date_mod` > date_add(now(), interval - 10 MINUTE)", "`id` DESC", 1);
if (count($a_reload_planned) == 1) {
$a_reload = current($a_reload_planned);
if ($a_reload['action'] == 'reload_planned') {
echo "<div class='msgboxmonit msgboxmonit-red'>";
echo __('Shinken reload order has been sent at', 'monitoring') . " " . Html::convDateTime($a_reload['date_mod']);
echo "</div>";
} else {
echo "<div class='msgboxmonit msgboxmonit-orange'>";
echo __('Shinken reloaded at ' . Html::convDateTime($a_reload['date_mod']));
echo "</div>";
}
}
$a_restart_planned = $pmLog->find("(`action`='restart' OR `action`='restart_planned') AND " . "`date_mod` > date_add(now(), interval - 10 MINUTE)", "`id` DESC", 1);
if (count($a_restart_planned) == 1) {
$a_restart = current($a_restart_planned);
if ($a_restart['action'] == 'restart_planned') {
echo "<div class='msgboxmonit msgboxmonit-red'>";
echo __('Shinken restart order has been sent at', 'monitoring') . " " . Html::convDateTime($a_restart['date_mod']);
echo "</div>";
} else {
echo "<div class='msgboxmonit msgboxmonit-orange'>";
echo __('Shinken restarted at ' . Html::convDateTime($a_restart['date_mod']));
echo "</div>";
}
}
}
function post_purgeItem()
{
global $DB;
// Toolbox::logInFile("pm", " post_purgeItem : \n");
$pmLog = new PluginMonitoringLog();
$input = array();
$input['itemtype'] = "PluginMonitoringServicesCatalog";
$input['items_id'] = $this->fields['id'];
$input['action'] = "delete";
$input['value'] = "Deleted service catalog : " . $DB->escape($this->fields['name']);
$pmLog->add($input);
// Generic services catalogs only ...
if (!$this->getField('is_generic')) {
return;
}
$this->updateGenericServicesCatalogs('delete');
}
function post_purgeItem() {
$pmLog = new PluginMonitoringLog();
$input = array();
$input['itemtype'] = "PluginMonitoringService";
$input['items_id'] = $this->fields['id'];
$input['action'] = "delete";
if (isset($_SESSION['plugin_monitoring_hosts'])
&& isset($_SESSION['plugin_monitoring_hosts']['itemtype'])) {
$itemtype = $_SESSION['plugin_monitoring_hosts']['itemtype'];
$item = new $itemtype();
$item->getFromDB($_SESSION['plugin_monitoring_hosts']['items_id']);
if (isset($_SESSION['plugin_monitoring_hosts']['id'])) {
$input['value'] = "Service ".$this->fields['name']." of ".$item->getTypeName()." ".$item->getName();
} else {
$input['value'] = "Service ".$this->fields['name']." of port of ";
}
$pmLog->add($input);
}
unset($_SESSION['plugin_monitoring_hosts']);
if ($this->fields['networkports_id'] > 0) {
// Delete componentscatalog_host if no networkports in services
if (countElementsInTable(
'glpi_plugin_monitoring_services',
"`plugin_monitoring_components_id`='".$this->fields['plugin_monitoring_components_id']."'
AND `networkports_id`>0
AND `plugin_monitoring_componentscatalogs_hosts_id`='".$this->fields['plugin_monitoring_componentscatalogs_hosts_id']."'") == 0) {
$pmComponentscatalog_Host = new PluginMonitoringComponentscatalog_Host();
$pmComponentscatalog_Host->getFromDB($this->fields['plugin_monitoring_componentscatalogs_hosts_id']);
if ($pmComponentscatalog_Host->fields['is_static'] == 0) {
$pmComponentscatalog_Host->delete($pmComponentscatalog_Host->fields);
}
}
}
}
function post_purgeItem()
{
global $DB;
$pmLog = new PluginMonitoringLog();
$input = array();
$input['itemtype'] = "PluginMonitoringService";
$input['items_id'] = $this->fields['id'];
$input['action'] = "delete";
$itemtype = $_SESSION['plugin_monitoring_hosts']['itemtype'];
$item = new $itemtype();
$item->getFromDB($_SESSION['plugin_monitoring_hosts']['items_id']);
$input['value'] = "Service " . $this->fields['name'] . " of " . $item->getTypeName() . " " . $item->getName();
$pmLog->add($input);
unset($_SESSION['plugin_monitoring_hosts']);
}
function displayShinkenRestart()
{
global $CFG_GLPI;
$pmLog = new PluginMonitoringLog();
$a_restart_planned = $pmLog->find("`action` LIKE 'restart%' AND " . "`date_mod` > date_add(now(), interval - 10 MINUTE)", "`id` DESC", 1);
if (count($a_restart_planned) == 1) {
$a_restart = current($a_restart_planned);
if ($a_restart['action'] == 'restart_planned') {
echo "<div class='msgboxmonit msgboxmonit-red'>";
echo __('Shiken restart order has been made at ' . Html::convDateTime($a_restart['date_mod']));
echo "</div>";
} else {
echo "<div class='msgboxmonit msgboxmonit-orange'>";
echo __('Shiken has restarted at ' . Html::convDateTime($a_restart['date_mod']));
echo "</div>";
}
}
}
function generateServicesCfg($file = 0, $tag = '')
{
global $DB;
$pMonitoringCommand = new PluginMonitoringCommand();
$pMonitoringCheck = new PluginMonitoringCheck();
$pmComponent = new PluginMonitoringComponent();
$pmEntity = new PluginMonitoringEntity();
$pmContact_Item = new PluginMonitoringContact_Item();
$pmService = new PluginMonitoringService();
$pmComponentscatalog = new PluginMonitoringComponentscatalog();
$calendar = new Calendar();
$user = new User();
$pmLog = new PluginMonitoringLog();
$profile_User = new Profile_User();
if (isset($_SERVER['HTTP_USER_AGENT']) and strstr($_SERVER['HTTP_USER_AGENT'], 'xmlrpclib.py')) {
if (!isset($_SESSION['glpi_currenttime'])) {
$_SESSION['glpi_currenttime'] = date("Y-m-d H:i:s");
}
$input = array();
$input['user_name'] = "Shinken";
$input['action'] = "restart";
$input['date_mod'] = date("Y-m-d H:i:s");
$pmLog->add($input);
}
$hostnamebp = '';
$a_services = array();
$i = 0;
// * Prepare contacts
$a_contacts_entities = array();
$a_list_contact = $pmContact_Item->find("`itemtype`='PluginMonitoringComponentscatalog'\n AND `users_id`>0");
foreach ($a_list_contact as $data) {
$contactentities = getSonsOf('glpi_entities', $data['entities_id']);
if (isset($a_contacts_entities[$data['items_id']][$data['users_id']])) {
$contactentities = array_merge($contactentities, $a_contacts_entities[$data['items_id']][$data['users_id']]);
}
$a_contacts_entities[$data['items_id']][$data['users_id']] = $contactentities;
}
$a_entities_allowed = $pmEntity->getEntitiesByTag($tag);
$query = "SELECT * FROM `glpi_plugin_monitoring_services`";
$result = $DB->query($query);
while ($data = $DB->fetch_array($result)) {
$notadd = 0;
$notadddescription = '';
$a_component = current($pmComponent->find("`id`='" . $data['plugin_monitoring_components_id'] . "'", "", 1));
$a_hostname = array();
$queryh = "SELECT * FROM `glpi_plugin_monitoring_componentscatalogs_hosts` \n WHERE `id` = '" . $data['plugin_monitoring_componentscatalogs_hosts_id'] . "'\n LIMIT 1";
$resulth = $DB->query($queryh);
$hostname = '';
$plugin_monitoring_componentscatalogs_id = 0;
while ($datah = $DB->fetch_array($resulth)) {
$itemtype = $datah['itemtype'];
$item = new $itemtype();
if ($item->getFromDB($datah['items_id'])) {
if (isset($a_entities_allowed['-1']) or isset($a_entities_allowed[$item->fields['entities_id']])) {
$a_hostname[] = $itemtype . "-" . $datah['items_id'] . "-" . preg_replace("/[^A-Za-z0-9]/", "", $item->fields['name']);
$hostname = $item->fields['name'];
$plugin_monitoring_componentscatalogs_id = $datah['plugin_monitoring_componentscalalog_id'];
}
}
}
if (count($a_hostname) > 0) {
if (isset($_SESSION['plugin_monitoring']['servicetemplates'][$a_component['id']])) {
$a_services[$i]['use'] = $_SESSION['plugin_monitoring']['servicetemplates'][$a_component['id']];
}
$a_services[$i]['host_name'] = implode(",", array_unique($a_hostname));
$hostnamebp = $a_services[$i]['host_name'];
// For business rules
$a_services[$i]['service_description'] = preg_replace("/[^A-Za-z0-9]/", "", $a_component['name']) . "-" . $data['id'];
$pMonitoringCommand->getFromDB($a_component['plugin_monitoring_commands_id']);
// Manage arguments
$array = array();
preg_match_all("/\\\$(ARG\\d+)\\\$/", $pMonitoringCommand->fields['command_line'], $array);
sort($array[0]);
$a_arguments = importArrayFromDB($a_component['arguments']);
$a_argumentscustom = importArrayFromDB($data['arguments']);
foreach ($a_argumentscustom as $key => $value) {
$a_arguments[$key] = $value;
}
$args = '';
foreach ($array[0] as $arg) {
if ($arg != '$PLUGINSDIR$' and $arg != '$HOSTADDRESS$' and $arg != '$MYSQLUSER$' and $arg != '$MYSQLPASSWORD$') {
$arg = str_replace('$', '', $arg);
if (!isset($a_arguments[$arg])) {
$args .= '!';
} else {
if (strstr($a_arguments[$arg], "[[HOSTNAME]]")) {
$a_arguments[$arg] = str_replace("[[HOSTNAME]]", $hostname, $a_arguments[$arg]);
} elseif (strstr($a_arguments[$arg], "[[NETWORKPORTDESCR]]")) {
if (class_exists("PluginFusinvsnmpNetworkPort")) {
$pfNetworkPort = new PluginFusinvsnmpNetworkPort();
$pfNetworkPort->loadNetworkport($data['networkports_id']);
$descr = '';
$descr = $pfNetworkPort->getValue("ifdescr");
$a_arguments[$arg] = str_replace("[[NETWORKPORTDESCR]]", $descr, $a_arguments[$arg]);
}
} elseif (strstr($a_arguments[$arg], "[[NETWORKPORTNUM]]")) {
$networkPort = new NetworkPort();
$networkPort->getFromDB($data['networkports_id']);
$logicalnum = $pfNetworkPort->fields['logical_number'];
$a_arguments[$arg] = str_replace("[[NETWORKPORTNUM]]", $logicalnum, $a_arguments[$arg]);
} elseif (strstr($a_arguments[$arg], "[[NETWORKPORTNAME]]")) {
$networkPort = new NetworkPort();
$networkPort->getFromDB($data['networkports_id']);
$portname = $pfNetworkPort->fields['name'];
$a_arguments[$arg] = str_replace("[[NETWORKPORTNAME]]", $portname, $a_arguments[$arg]);
} else {
if (strstr($a_arguments[$arg], "[")) {
$a_arguments[$arg] = PluginMonitoringService::convertArgument($data['id'], $a_arguments[$arg]);
}
}
if ($a_arguments == '') {
$notadd = 1;
if ($notadddescription != '') {
$notadddescription .= ", ";
}
$notadddescription .= "Argument " . $a_arguments[$arg] . " Not have value";
}
$args .= '!' . $a_arguments[$arg];
if ($a_arguments[$arg] == '' and $a_component['alias_command'] != '') {
$args .= $a_component['alias_command'];
}
}
}
}
// End manage arguments
if ($a_component['remotesystem'] == 'nrpe') {
if ($a_component['alias_command'] != '') {
$a_services[$i]['check_command'] = "check_nrpe!" . $a_component['alias_command'];
} else {
$a_services[$i]['check_command'] = "check_nrpe!" . $pMonitoringCommand->fields['command_name'];
}
} else {
$a_services[$i]['check_command'] = $pMonitoringCommand->fields['command_name'] . $args;
}
// * Contacts
$a_contacts = array();
$a_list_contact = $pmContact_Item->find("`itemtype`='PluginMonitoringComponentscatalog'\n AND `items_id`='" . $plugin_monitoring_componentscatalogs_id . "'");
foreach ($a_list_contact as $data_contact) {
if (isset($a_contacts_entities[$plugin_monitoring_componentscatalogs_id][$data_contact['users_id']])) {
if (in_array($data['entities_id'], $a_contacts_entities[$plugin_monitoring_componentscatalogs_id][$data_contact['users_id']])) {
// $pmContact->getFromDB($data_contact['plugin_monitoring_contacts_id']);
$user->getFromDB($data_contact['users_id']);
$a_contacts[] = $user->fields['name'];
}
}
}
$a_contacts_unique = array_unique($a_contacts);
$a_services[$i]['contacts'] = implode(',', $a_contacts_unique);
// ** If shinken not use templates or template not defined :
if (!isset($_SESSION['plugin_monitoring']['servicetemplates'][$a_component['id']])) {
$pMonitoringCheck->getFromDB($a_component['plugin_monitoring_checks_id']);
$a_services[$i]['check_interval'] = $pMonitoringCheck->fields['check_interval'];
$a_services[$i]['retry_interval'] = $pMonitoringCheck->fields['retry_interval'];
$a_services[$i]['max_check_attempts'] = $pMonitoringCheck->fields['max_check_attempts'];
if ($calendar->getFromDB($a_component['calendars_id'])) {
$a_services[$i]['check_period'] = $calendar->fields['name'];
}
$a_services[$i]['notification_interval'] = '30';
if ($calendar->getFromDB($a_component['calendars_id'])) {
$a_services[$i]['notification_period'] = $calendar->fields['name'];
} else {
$a_services[$i]['notification_period'] = "24x7";
}
$a_services[$i]['notification_options'] = 'w,c,r';
$a_services[$i]['active_checks_enabled'] = '1';
$a_services[$i]['process_perf_data'] = '1';
$a_services[$i]['active_checks_enabled'] = '1';
$a_services[$i]['passive_checks_enabled'] = '1';
$a_services[$i]['parallelize_check'] = '1';
$a_services[$i]['obsess_over_service'] = '1';
$a_services[$i]['check_freshness'] = '1';
$a_services[$i]['freshness_threshold'] = '1';
$a_services[$i]['notifications_enabled'] = '1';
$a_services[$i]['event_handler_enabled'] = '0';
//$a_services[$i]['event_handler'] = 'super_event_kill_everyone!DIE';
$a_services[$i]['flap_detection_enabled'] = '1';
$a_services[$i]['failure_prediction_enabled'] = '1';
$a_services[$i]['retain_status_information'] = '1';
$a_services[$i]['retain_nonstatus_information'] = '1';
$a_services[$i]['is_volatile'] = '0';
$a_services[$i]['_httpstink'] = 'NO';
}
$pmComponentscatalog->getFromDB($plugin_monitoring_componentscatalogs_id);
if ($pmComponentscatalog->fields['notification_interval'] != '30') {
$a_services[$i]['notification_interval'] = $pmComponentscatalog->fields['notification_interval'];
}
if ($notadd == '1') {
unset($a_services[$i]);
$input = array();
$input['id'] = $data['id'];
$input['event'] = $notadddescription;
$input['state'] = "CRITICAL";
$input['state_type'] = "HARD";
$pmService->update($input);
} else {
$i++;
}
}
}
// // Business rules....
$pmService = new PluginMonitoringService();
$pmServicescatalog = new PluginMonitoringServicescatalog();
$pMonitoringBusinessrulegroup = new PluginMonitoringBusinessrulegroup();
$pmBusinessrule = new PluginMonitoringBusinessrule();
$pmComponentscatalog_Host = new PluginMonitoringComponentscatalog_Host();
$a_listBA = $pmServicescatalog->find();
foreach ($a_listBA as $dataBA) {
if (isset($a_entities_allowed['-1']) or isset($a_entities_allowed[$dataBA['entities_id']])) {
$a_grouplist = $pMonitoringBusinessrulegroup->find("`plugin_monitoring_servicescatalogs_id`='" . $dataBA['id'] . "'");
$a_group = array();
foreach ($a_grouplist as $gdata) {
$a_listBR = $pmBusinessrule->find("`plugin_monitoring_businessrulegroups_id`='" . $gdata['id'] . "'");
foreach ($a_listBR as $dataBR) {
if ($pmService->getFromDB($dataBR['plugin_monitoring_services_id'])) {
$pmComponentscatalog_Host->getFromDB($pmService->fields['plugin_monitoring_componentscatalogs_hosts_id']);
$itemtype = $pmComponentscatalog_Host->fields['itemtype'];
$item = new $itemtype();
if ($item->getFromDB($pmComponentscatalog_Host->fields['items_id'])) {
$hostname = $itemtype . "-" . $pmComponentscatalog_Host->fields['items_id'] . "-" . preg_replace("/[^A-Za-z0-9]/", "", $item->fields['name']);
if ($gdata['operator'] == 'and' or $gdata['operator'] == 'or' or strstr($gdata['operator'], ' of:')) {
$operator = '|';
if ($gdata['operator'] == 'and') {
$operator = '&';
}
if (!isset($a_group[$gdata['id']])) {
$a_group[$gdata['id']] = '';
if (strstr($gdata['operator'], ' of:')) {
$a_group[$gdata['id']] = $gdata['operator'];
}
$a_group[$gdata['id']] .= $hostname . "," . preg_replace("/[^A-Za-z0-9]/", "", $pmService->fields['name']) . "-" . $pmService->fields['id'];
} else {
$a_group[$gdata['id']] .= $operator . $hostname . "," . preg_replace("/[^A-Za-z0-9]/", "", $pmService->fields['name']) . "-" . $pmService->fields['id'];
}
} else {
$a_group[$gdata['id']] = $gdata['operator'] . " " . $hostname . "," . preg_replace("/[^A-Za-z0-9]/", "", $item->getName()) . "-" . $item->fields['id'];
}
}
}
}
}
if (count($a_group) > 0) {
$pMonitoringCheck->getFromDB($dataBA['plugin_monitoring_checks_id']);
$a_services[$i]['check_interval'] = $pMonitoringCheck->fields['check_interval'];
$a_services[$i]['retry_interval'] = $pMonitoringCheck->fields['retry_interval'];
$a_services[$i]['max_check_attempts'] = $pMonitoringCheck->fields['max_check_attempts'];
if ($calendar->getFromDB($dataBA['calendars_id'])) {
$a_services[$i]['check_period'] = $calendar->fields['name'];
}
$a_services[$i]['host_name'] = $hostnamebp;
$a_services[$i]['service_description'] = preg_replace("/[^A-Za-z0-9]/", "", $dataBA['name']) . "-" . $dataBA['id'] . "-businessrules";
$command = "bp_rule!";
foreach ($a_group as $key => $value) {
if (!strstr($value, "&") and !strstr($value, "|")) {
$a_group[$key] = trim($value);
} else {
$a_group[$key] = "(" . trim($value) . ")";
}
}
$a_services[$i]['check_command'] = $command . implode("&", $a_group);
$a_services[$i]['notification_interval'] = '30';
if ($calendar->getFromDB($dataBA['calendars_id'])) {
$a_services[$i]['notification_period'] = $calendar->fields['name'];
} else {
$a_services[$i]['notification_period'] = "24x7";
}
$a_services[$i]['notification_options'] = 'w,c,r';
$a_services[$i]['active_checks_enabled'] = '1';
$a_services[$i]['process_perf_data'] = '1';
$a_services[$i]['active_checks_enabled'] = '1';
$a_services[$i]['passive_checks_enabled'] = '1';
$a_services[$i]['parallelize_check'] = '1';
$a_services[$i]['obsess_over_service'] = '1';
$a_services[$i]['check_freshness'] = '1';
$a_services[$i]['freshness_threshold'] = '1';
$a_services[$i]['notifications_enabled'] = '1';
$a_services[$i]['event_handler_enabled'] = '0';
//$a_services[$i]['event_handler'] = 'super_event_kill_everyone!DIE';
$a_services[$i]['flap_detection_enabled'] = '1';
$a_services[$i]['failure_prediction_enabled'] = '1';
$a_services[$i]['retain_status_information'] = '1';
$a_services[$i]['retain_nonstatus_information'] = '1';
$a_services[$i]['is_volatile'] = '0';
$a_services[$i]['_httpstink'] = 'NO';
$a_services[$i]['contacts'] = '';
$i++;
}
}
}
if ($file == "1") {
$config = "# Generated by plugin monitoring for GLPI\n# on " . date("Y-m-d H:i:s") . "\n\n";
foreach ($a_services as $data) {
$config .= $this->constructFile("service", $data);
}
return array('services.cfg', $config);
} else {
return $a_services;
}
}
/**
* Get modifications of resources (if have modifications);
*/
function configurationchangesMessage()
{
global $DB, $LANG;
$input = '';
$pmLog = new PluginMonitoringLog();
// Get id of last Shinken restart
$id_restart = 0;
$a_restarts = $pmLog->find("`action`='restart'", "`id` DESC", 1);
if (count($a_restarts) > 0) {
$a_restart = current($a_restarts);
$id_restart = $a_restart['id'];
}
// get number of modifications
$nb_delete = 0;
$nb_add = 0;
$nb_delete = countElementsInTable(getTableForItemType('PluginMonitoringLog'), "`id` > '" . $id_restart . "'\n AND `action`='delete'");
$nb_add = countElementsInTable(getTableForItemType('PluginMonitoringLog'), "`id` > '" . $id_restart . "'\n AND `action`='add'");
if ($nb_delete > 0 or $nb_add > 0) {
$input .= $LANG['plugin_monitoring']['log'][1] . "<br/>";
if ($nb_add > 0) {
$input .= "<a onClick='Ext.get(\"addelements\").toggle();'>" . $nb_add . "</a> " . $LANG['plugin_monitoring']['log'][2];
echo "<div style='position:absolute;z-index:10;left: 50%; \n margin-left: -350px;margin-top:40px;display:none'\n class='msgboxmonit msgboxmonit-grey' id='addelements'>";
$query = "SELECT * FROM `" . getTableForItemType('PluginMonitoringLog') . "`\n WHERE `id` > '" . $id_restart . "' AND `action`='add'\n ORDER BY `id` DESC";
$result = $DB->query($query);
while ($data = $DB->fetch_array($result)) {
echo "[" . convDateTime($data['date_mod']) . "] Add " . $data['value'] . "<br/>";
}
echo "</div>";
}
if ($nb_delete > 0) {
if ($nb_add > 0) {
$input .= " / ";
}
$input .= "<a onClick='Ext.get(\"deleteelements\").toggle();'>" . $nb_delete . "</a> " . $LANG['plugin_monitoring']['log'][3];
echo "<div style='position:absolute;z-index:10;left: 50%; \n margin-left: -350px;margin-top:40px;display:none'\n class='msgboxmonit msgboxmonit-grey' id='deleteelements'>";
$query = "SELECT * FROM `" . getTableForItemType('PluginMonitoringLog') . "`\n WHERE `id` > '" . $id_restart . "' AND `action`='delete'\n ORDER BY `id` DESC";
$result = $DB->query($query);
while ($data = $DB->fetch_array($result)) {
echo "[" . convDateTime($data['date_mod']) . "] Delete " . $data['value'] . "<br/>";
}
echo "</div>";
}
$input .= "<br/>";
$input .= $LANG['plugin_monitoring']['log'][4];
}
return $input;
}
