function show()
{
global $DB;
$networkPort = new NetworkPort();
$computer = new Computer();
$pmHostconfig = new PluginMonitoringHostconfig();
// Shinken server
$source_id = $pmHostconfig->getValueAncestor('computers_id', '0');
$switches_id = 0;
$this->a_devices['Computer-' . $source_id] = "SHINKEN";
$a_networkports = $networkPort->find("`itemtype`='Computer'\n AND `items_id`='" . $source_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') {
$this->a_devices['NetworkEquipment-' . $networkPort->fields['items_id']] = $this->getState('NetworkEquipment', $networkPort->fields['items_id']);
$this->a_devices_link['NetworkEquipment-' . $networkPort->fields['items_id']]['Computer-' . $source_id] = 1;
$this->getNetworkEquipments($networkPort->fields['items_id']);
$switches_id = $networkPort->fields['items_id'];
}
}
}
$this->addPoint('NetworkEquipment-' . $switches_id);
$computer->getFromDB($source_id);
$this->drawCanvas($computer, array(), array());
}
static function displayTabContentForItem(CommonGLPI $item, $tabnum = 1, $withtemplate = 0)
{
if ($item->getID() > -1) {
$pmEntity = new PluginMonitoringEntity();
$pmHostconfig = new PluginMonitoringHostconfig();
$pmHostconfig->showForm($item->getID(), "Entity");
$pmEntity->showForm($item->fields['id']);
}
return true;
}
function pluginMonitoringInstall($version)
{
global $DB, $LANG, $CFG_GLPI;
// ** Insert in DB
$DB_file = GLPI_ROOT . "/plugins/monitoring/install/mysql/plugin_monitoring-" . $version . "-empty.sql";
$DBf_handle = fopen($DB_file, "rt");
$sql_query = fread($DBf_handle, filesize($DB_file));
fclose($DBf_handle);
foreach (explode(";\n", "{$sql_query}") as $sql_line) {
if (get_magic_quotes_runtime()) {
$sql_line = stripslashes_deep($sql_line);
}
if (!empty($sql_line)) {
$DB->query($sql_line);
}
}
include GLPI_ROOT . "/plugins/monitoring/inc/profile.class.php";
$pmProfile = new PluginMonitoringProfile();
$pmProfile->initProfile();
include GLPI_ROOT . "/plugins/monitoring/inc/command.class.php";
$pmCommand = new PluginMonitoringCommand();
$pmCommand->initCommands();
include GLPI_ROOT . "/plugins/monitoring/inc/notificationcommand.class.php";
$pmNotificationcommand = new PluginMonitoringNotificationcommand();
$pmNotificationcommand->initCommands();
include GLPI_ROOT . "/plugins/monitoring/inc/check.class.php";
$pmCheck = new PluginMonitoringCheck();
$pmCheck->initChecks();
include GLPI_ROOT . "/plugins/monitoring/inc/hostconfig.class.php";
$pmHostconfig = new PluginMonitoringHostconfig();
$pmHostconfig->initConfig();
include GLPI_ROOT . "/plugins/monitoring/inc/config.class.php";
$pmConfig = new PluginMonitoringConfig();
$pmConfig->initConfig();
$query = "UPDATE `glpi_plugin_monitoring_configs`\n SET `version`='" . PLUGIN_MONITORING_VERSION . "'\n WHERE `id`='1'";
$DB->query($query);
if (!is_dir(GLPI_PLUGIN_DOC_DIR . '/monitoring')) {
mkdir(GLPI_PLUGIN_DOC_DIR . "/monitoring");
}
if (!is_dir(GLPI_PLUGIN_DOC_DIR . '/monitoring/templates')) {
mkdir(GLPI_PLUGIN_DOC_DIR . "/monitoring/templates");
}
if (!is_dir(GLPI_PLUGIN_DOC_DIR . '/monitoring/weathermapbg')) {
mkdir(GLPI_PLUGIN_DOC_DIR . "/monitoring/weathermapbg");
}
CronTask::Register('PluginMonitoringServiceevent', 'updaterrd', '300', array('mode' => 2, 'allowmode' => 3, 'logs_lifetime' => 30));
CronTask::Register('PluginMonitoringLog', 'cleanlogs', '96400', array('mode' => 2, 'allowmode' => 3, 'logs_lifetime' => 30));
CronTask::Register('PluginMonitoringUnavaibility', 'unavaibility', '300', array('mode' => 2, 'allowmode' => 3, 'logs_lifetime' => 30));
}
static function displayTabContentForItem(CommonGLPI $item, $tabnum = 1, $withtemplate = 0)
{
if ($item->getID() > 0) {
if ($tabnum == 0) {
PluginMonitoringServicegraph::loadLib();
$pmService = new PluginMonitoringService();
$pmService->manageServices(get_class($item), $item->fields['id']);
$pmHostconfig = new PluginMonitoringHostconfig();
$pmHostconfig->showForm($item->getID(), get_class($item));
} else {
if ($tabnum == 1) {
$pmService = new PluginMonitoringService();
$pmService->showGraphsByHost(get_class($item), $item->fields['id']);
}
}
}
return true;
}
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 plugin_headings_monitoring_entitytag($item)
{
$pmEntity = new PluginMonitoringEntity();
$pmHostconfig = new PluginMonitoringHostconfig();
$pmHostconfig->showForm($item->getID(), "Entity");
$pmEntity->showForm($item->fields['id']);
}
static function displayTabContentForItem(CommonGLPI $item, $tabnum=1, $withtemplate=0) {
switch ($item->getType()) {
case 'Central' :
$pmDisplay = new PluginMonitoringDisplay();
// $pmDisplay->showHostsCounters("Hosts", 1, 1);
$pmDisplay->showHostsBoard();
return true;
}
if ($item->getID() > 0) {
if ($tabnum == 0) {
PluginMonitoringToolbox::loadLib();
$pmService = new PluginMonitoringService();
$pmService->manageServices(get_class($item), $item->fields['id']);
$pmHostconfig = new PluginMonitoringHostconfig();
$pmHostconfig->showForm($item->getID(), get_class($item));
} else if ($tabnum == 1) {
$pmService = new PluginMonitoringService();
$pmService->showGraphsByHost(get_class($item), $item->fields['id']);
}
}
return true;
}
@package Plugin Monitoring for GLPI
@author David Durieux
@co-author
@comment
@copyright Copyright (c) 2011-2014 Plugin Monitoring for GLPI team
@license AGPL License 3.0 or (at your option) any later version
http://www.gnu.org/licenses/agpl-3.0-standalone.html
@link https://forge.indepnet.net/projects/monitoring/
@since 2011
------------------------------------------------------------------------
*/
include "../../../inc/includes.php";
Session::checkCentralAccess();
Html::header(__('Monitoring', 'monitoring'), $_SERVER["PHP_SELF"], "plugins", "monitoring", "hostconfig");
$pmHostconfig = new PluginMonitoringHostconfig();
if (isset($_POST["update"])) {
if ($_POST['plugin_monitoring_components_id'] != '-1' or $_POST['plugin_monitoring_realms_id'] != '-1' or $_POST['jetlag'] != '100') {
if (isset($_POST['id'])) {
$pmHostconfig->update($_POST);
} else {
$pmHostconfig->add($_POST);
}
} else {
if (isset($_POST['id'])) {
$pmHostconfig->delete($_POST);
}
}
Html::back();
}
Html::footer();
function pluginMonitoringInstall($version)
{
global $DB, $CFG_GLPI;
// ** Insert in DB
$DB_file = GLPI_ROOT . "/plugins/monitoring/install/mysql/plugin_monitoring-" . $version . "-empty.sql";
$DBf_handle = fopen($DB_file, "rt");
$sql_query = fread($DBf_handle, filesize($DB_file));
fclose($DBf_handle);
foreach (explode(";\n", "{$sql_query}") as $sql_line) {
if (get_magic_quotes_runtime()) {
$sql_line = Toolbox::stripslashes_deep($sql_line);
}
if (!empty($sql_line)) {
$DB->query($sql_line);
}
}
include GLPI_ROOT . "/plugins/monitoring/inc/profile.class.php";
$pmProfile = new PluginMonitoringProfile();
$pmProfile->initProfile();
include GLPI_ROOT . "/plugins/monitoring/inc/command.class.php";
$pmCommand = new PluginMonitoringCommand();
$pmCommand->initCommands();
include GLPI_ROOT . "/plugins/monitoring/inc/notificationcommand.class.php";
$pmNotificationcommand = new PluginMonitoringNotificationcommand();
$pmNotificationcommand->initCommands();
include GLPI_ROOT . "/plugins/monitoring/inc/check.class.php";
$pmCheck = new PluginMonitoringCheck();
$pmCheck->initChecks();
include GLPI_ROOT . "/plugins/monitoring/inc/hostconfig.class.php";
$pmHostconfig = new PluginMonitoringHostconfig();
$pmHostconfig->initConfig();
include GLPI_ROOT . "/plugins/monitoring/inc/config.class.php";
$pmConfig = new PluginMonitoringConfig();
$pmConfig->initConfig();
$query = "UPDATE `glpi_plugin_monitoring_configs`\n SET `version`='" . PLUGIN_MONITORING_VERSION . "'\n WHERE `id`='1'";
$DB->query($query);
$query = "SELECT * FROM `glpi_calendars`\n WHERE `name`='24x7'\n LIMIT 1";
$result = $DB->query($query);
if ($DB->numrows($result) == 0) {
$calendar = new Calendar();
$input = array();
$input['name'] = '24x7';
$input['is_recursive'] = 1;
$calendars_id = $calendar->add($input);
$calendarSegment = new CalendarSegment();
$input = array();
$input['calendars_id'] = $calendars_id;
$input['is_recursive'] = 1;
$input['begin'] = '00:00:00';
$input['end'] = '24:00:00';
$input['day'] = '0';
$calendarSegment->add($input);
$input['day'] = '1';
$calendarSegment->add($input);
$input['day'] = '2';
$calendarSegment->add($input);
$input['day'] = '3';
$calendarSegment->add($input);
$input['day'] = '4';
$calendarSegment->add($input);
$input['day'] = '5';
$calendarSegment->add($input);
$input['day'] = '6';
$calendarSegment->add($input);
}
if (!is_dir(GLPI_PLUGIN_DOC_DIR . '/monitoring')) {
mkdir(GLPI_PLUGIN_DOC_DIR . "/monitoring");
}
if (!is_dir(GLPI_PLUGIN_DOC_DIR . '/monitoring/templates')) {
mkdir(GLPI_PLUGIN_DOC_DIR . "/monitoring/templates");
}
if (!is_dir(GLPI_PLUGIN_DOC_DIR . '/monitoring/weathermapbg')) {
mkdir(GLPI_PLUGIN_DOC_DIR . "/monitoring/weathermapbg");
}
CronTask::Register('PluginMonitoringServiceevent', 'updaterrd', '300', array('mode' => 2, 'allowmode' => 3, 'logs_lifetime' => 30));
CronTask::Register('PluginMonitoringLog', 'cleanlogs', '96400', array('mode' => 2, 'allowmode' => 3, 'logs_lifetime' => 30));
CronTask::Register('PluginMonitoringUnavaibility', 'unavaibility', '300', array('mode' => 2, 'allowmode' => 3, 'logs_lifetime' => 30));
CronTask::Register('PluginMonitoringDisplayview_rule', 'replayallviewrules', '1200', array('mode' => 2, 'allowmode' => 3, 'logs_lifetime' => 30));
}
function generateHostsCfg($file = 0, $tag = '')
{
global $DB;
$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();
$user = new User();
$a_hosts = array();
$i = 0;
$a_parents_found = array();
$a_hosts_found = array();
$a_entities_allowed = $pmEntity->getEntitiesByTag($tag);
// * 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;
}
$query = "SELECT * FROM `glpi_plugin_monitoring_componentscatalogs_hosts`\n GROUP BY `itemtype`, `items_id`";
$result = $DB->query($query);
while ($data = $DB->fetch_array($result)) {
$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']])) {
$a_hosts[$i]['host_name'] = $classname . "-" . $data['items_id'] . "-" . preg_replace("/[^A-Za-z0-9]/", "", $class->fields['name']);
$a_hosts_found[$a_hosts[$i]['host_name']] = 1;
$a_hosts[$i]['alias'] = preg_replace("/[^A-Za-z0-9]/", "", $class->fields['name']) . " / " . $classname . "-" . $data['items_id'];
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']) . ")";
}
}
}
}
$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'] . "'\n 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 = 'NetworkEquipment-' . $networkPort->fields['items_id'] . '-' . 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']);
}
}
}
}
$a_hosts[$i]['parents'] = $parent;
$a_fields = array();
$pmCommand->getFromDB($pmHostconfig->getValueAncestor('plugin_monitoring_commands_id', $class->fields['entities_id'], $classname, $class->getID()));
$a_component = current($pmComponent->find("`plugin_monitoring_commands_id`='" . $pmCommand->fields['id'] . "'", "", 1));
$a_fields = $a_component;
$a_hosts[$i]['check_command'] = $pmCommand->fields['command_name'];
$pmCheck->getFromDB($pmHostconfig->getValueAncestor('plugin_monitoring_checks_id', $class->fields['entities_id'], $classname, $class->getID()));
$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($pmHostconfig->getValueAncestor('calendars_id', $class->fields['entities_id'], $classname, $class->getID()))) {
$a_hosts[$i]['check_period'] = $calendar->fields['name'];
} else {
$a_hosts[$i]['check_period'] = "24x7";
}
$pmRealm->getFromDB($pmHostconfig->getValueAncestor('plugin_monitoring_realms_id', $class->fields['entities_id'], $classname, $class->getID()));
$a_hosts[$i]['realm'] = $pmRealm->fields['name'];
$a_hosts[$i]['process_perf_data'] = '1';
$a_hosts[$i]['notification_interval'] = '30';
// For contact check if a service with this component
$a_hosts[$i]['contacts'] = '';
$querycont = "SELECT * FROM `glpi_plugin_monitoring_componentscatalogs_hosts`\n LEFT JOIN `glpi_plugin_monitoring_services`\n ON `plugin_monitoring_componentscatalogs_hosts_id`\n = `glpi_plugin_monitoring_componentscatalogs_hosts`.`id`\n WHERE `plugin_monitoring_components_id`='" . $a_component['id'] . "'\n AND `items_id`='" . $data['items_id'] . "'\n AND `itemtype`='" . $data['itemtype'] . "'\n 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'\n 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);
}
}
if ($calendar->getFromDB($a_fields['calendars_id'])) {
$a_hosts[$i]['notification_period'] = $calendar->fields['name'];
} else {
$a_hosts[$i]['notification_period'] = "24x7";
}
$a_hosts[$i]['notification_options'] = 'd,u,r';
$i++;
}
}
}
// 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'] = '';
}
}
}
}
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->constructFile("host", $data);
}
return array('hosts.cfg', $config);
} else {
return $a_hosts;
}
}
function pluginMonitoringUpdate($current_version, $migrationname = 'Migration')
{
global $DB;
$migration = new $migrationname($current_version);
if (!is_dir(GLPI_PLUGIN_DOC_DIR . '/monitoring')) {
mkdir(GLPI_PLUGIN_DOC_DIR . "/monitoring");
}
if (!is_dir(GLPI_PLUGIN_DOC_DIR . '/monitoring/templates')) {
mkdir(GLPI_PLUGIN_DOC_DIR . "/monitoring/templates");
}
if (!is_dir(GLPI_PLUGIN_DOC_DIR . '/monitoring/weathermapbg')) {
mkdir(GLPI_PLUGIN_DOC_DIR . "/monitoring/weathermapbg");
}
$unavaibility_recalculate = 0;
if (!TableExists("glpi_plugin_monitoring_unavaibilities") || !FieldExists("glpi_plugin_monitoring_unavaibilities", "duration")) {
$unavaibility_recalculate = 1;
}
/*
* Table glpi_plugin_monitoring_servicescatalogs
*/
$newTable = "glpi_plugin_monitoring_servicescatalogs";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'name', 'name', "varchar(255) DEFAULT NULL");
$migration->changeField($newTable, 'entities_id', 'entities_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'is_recursive', 'is_recursive', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'comment', 'comment', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->changeField($newTable, 'last_check', 'last_check', "datetime DEFAULT NULL");
$migration->changeField($newTable, 'state', 'state', "varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'state_type', 'state_type', "varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'plugin_monitoring_checks_id', 'plugin_monitoring_checks_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'calendars_id', 'calendars_id', "int(11) NOT NULL DEFAULT '0'");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'name', "varchar(255) DEFAULT NULL");
$migration->addField($newTable, 'entities_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'is_recursive', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'last_check', "datetime DEFAULT NULL");
$migration->addField($newTable, 'state', "varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'state_type', "varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'plugin_monitoring_checks_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'calendars_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'is_acknowledged', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'is_acknowledgeconfirmed', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'acknowledge_comment', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->addField($newTable, 'acknowledge_users_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addKey($newTable, "name");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_componentscatalogs
*/
$newTable = "glpi_plugin_monitoring_componentscatalogs";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'name', 'name', "varchar(255) DEFAULT NULL");
$migration->changeField($newTable, 'entities_id', 'entities_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'is_recursive', 'is_recursive', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'comment', 'comment', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->changeField($newTable, 'notification_interval', 'notification_interval', "int(4) NOT NULL DEFAULT '30'");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'name', "varchar(255) DEFAULT NULL");
$migration->addField($newTable, 'entities_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'is_recursive', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'comment', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->addField($newTable, 'notification_interval', "int(4) NOT NULL DEFAULT '30'");
$migration->addKey($newTable, "name");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_components
*/
$newTable = "glpi_plugin_monitoring_components";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'name', 'name', "varchar(255) DEFAULT NULL");
$migration->changeField($newTable, 'plugin_monitoring_commands_id', 'plugin_monitoring_commands_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'arguments', 'arguments', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->changeField($newTable, 'plugin_monitoring_checks_id', 'plugin_monitoring_checks_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'active_checks_enabled', 'active_checks_enabled', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->changeField($newTable, 'passive_checks_enabled', 'passive_checks_enabled', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->changeField($newTable, 'calendars_id', 'calendars_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'remotesystem', 'remotesystem', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'is_arguments', 'is_arguments', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'alias_command', 'alias_command', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->changeField($newTable, 'graph_template', 'graph_template', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'link', 'link', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'is_weathermap', 'is_weathermap', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'weathermap_regex', 'weathermap_regex_in', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->changeField($newTable, 'perfname', 'perfname', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->changeField($newTable, 'perfnameinvert', 'perfnameinvert', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->changeField($newTable, 'perfnamecolor', 'perfnamecolor', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->addField($newTable, 'name', "varchar(255) DEFAULT NULL");
$migration->addField($newTable, 'plugin_monitoring_commands_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'arguments', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->addField($newTable, 'plugin_monitoring_checks_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'active_checks_enabled', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->addField($newTable, 'passive_checks_enabled', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->addField($newTable, 'calendars_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'remotesystem', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'is_arguments', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'alias_command', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->addField($newTable, 'graph_template', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'link', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'is_weathermap', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'weathermap_regex_in', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->addField($newTable, 'weathermap_regex_out', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->addField($newTable, 'perfname', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->addField($newTable, 'perfnameinvert', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->addField($newTable, 'perfnamecolor', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->addField($newTable, 'plugin_monitoring_eventhandlers_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addKey($newTable, "plugin_monitoring_commands_id");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_componentscatalogs_components
*/
$newTable = "glpi_plugin_monitoring_componentscatalogs_components";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'plugin_monitoring_componentscalalog_id', 'plugin_monitoring_componentscalalog_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'plugin_monitoring_components_id', 'plugin_monitoring_components_id', "int(11) NOT NULL DEFAULT '0'");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'plugin_monitoring_componentscalalog_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'plugin_monitoring_components_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addKey($newTable, array('plugin_monitoring_componentscalalog_id', 'plugin_monitoring_components_id'), "unicity", "UNIQUE");
$migration->addKey($newTable, "plugin_monitoring_componentscalalog_id");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_componentscatalogs_hosts
*/
$newTable = "glpi_plugin_monitoring_componentscatalogs_hosts";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'plugin_monitoring_componentscalalog_id', 'plugin_monitoring_componentscalalog_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'is_static', 'is_static', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->changeField($newTable, 'items_id', 'items_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'itemtype', 'itemtype', "varchar(100) DEFAULT NULL");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'plugin_monitoring_componentscalalog_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'is_static', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->addField($newTable, 'items_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'itemtype', "varchar(100) DEFAULT NULL");
$migration->addKey($newTable, array('itemtype', 'items_id'), 'itemtype');
$migration->addKey($newTable, 'plugin_monitoring_componentscalalog_id');
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_componentscatalogs_rules
*/
$newTable = "glpi_plugin_monitoring_componentscatalogs_rules";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'plugin_monitoring_componentscalalog_id', 'plugin_monitoring_componentscalalog_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'name', 'name', "varchar(255) DEFAULT NULL");
$migration->changeField($newTable, 'itemtype', 'itemtype', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'condition', 'condition', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->dropField($newTable, 'entities_id');
$migration->dropField($newTable, 'is_recursive');
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'plugin_monitoring_componentscalalog_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'name', "varchar(255) DEFAULT NULL");
$migration->addField($newTable, 'itemtype', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'condition', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->addKey($newTable, 'plugin_monitoring_componentscalalog_id');
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_services
*/
$newTable = "glpi_plugin_monitoring_services";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'entities_id', 'entities_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'name', 'name', "varchar(255) DEFAULT NULL");
$migration->changeField($newTable, 'plugin_monitoring_components_id', 'plugin_monitoring_components_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'plugin_monitoring_componentscatalogs_hosts_id', 'plugin_monitoring_componentscatalogs_hosts_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'event', 'event', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'state', 'state', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'state_type', 'state_type', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'last_check', 'last_check', "datetime DEFAULT NULL");
$migration->changeField($newTable, 'arguments', 'arguments', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->changeField($newTable, 'networkports_id', 'networkports_id', "int(11) NOT NULL DEFAULT '0'");
$migration->dropField($newTable, 'alias_command');
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'entities_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'name', "varchar(255) DEFAULT NULL");
$migration->addField($newTable, 'plugin_monitoring_components_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'plugin_monitoring_componentscatalogs_hosts_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'event', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'state', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'state_type', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'last_check', "datetime DEFAULT NULL");
$migration->addField($newTable, 'arguments', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->addField($newTable, 'networkports_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'is_acknowledged', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'is_acknowledgeconfirmed', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'acknowledge_comment', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->addField($newTable, 'acknowledge_users_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addKey($newTable, array('state', 'state_type'), 'state');
$migration->addKey($newTable, 'plugin_monitoring_componentscatalogs_hosts_id');
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_servicegraphs
*/
$newTable = "glpi_plugin_monitoring_servicegraphs";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` bigint(30) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "bigint(30) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'plugin_monitoring_services_id', 'plugin_monitoring_services_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'date', 'date', "datetime DEFAULT NULL");
$migration->changeField($newTable, 'data', 'data', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->changeField($newTable, 'type', 'type', "varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'plugin_monitoring_services_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'date', "datetime DEFAULT NULL");
$migration->addField($newTable, 'data', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->addField($newTable, 'type', "varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addKey($newTable, array('plugin_monitoring_services_id', 'type'), 'plugin_monitoring_services_id');
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_contacttemplates
*/
$newTable = "glpi_plugin_monitoring_contacttemplates";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'name', 'name', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'is_default', 'is_default', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'host_notifications_enabled', 'host_notifications_enabled', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->changeField($newTable, 'service_notifications_enabled', 'service_notifications_enabled', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->changeField($newTable, 'service_notification_period', 'service_notification_period', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'host_notification_period', 'host_notification_period', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'service_notification_options_w', 'service_notification_options_w', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->changeField($newTable, 'service_notification_options_u', 'service_notification_options_u', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->changeField($newTable, 'service_notification_options_c', 'service_notification_options_c', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->changeField($newTable, 'service_notification_options_r', 'service_notification_options_r', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->changeField($newTable, 'service_notification_options_f', 'service_notification_options_f', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'service_notification_options_n', 'service_notification_options_n', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'host_notification_options_d', 'host_notification_options_d', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->changeField($newTable, 'host_notification_options_u', 'host_notification_options_u', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->changeField($newTable, 'host_notification_options_r', 'host_notification_options_r', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->changeField($newTable, 'host_notification_options_f', 'host_notification_options_f', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'host_notification_options_s', 'host_notification_options_s', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'host_notification_options_n', 'host_notification_options_n', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'service_notification_commands', 'service_notification_commands', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'host_notification_commands', 'host_notification_commands', "int(11) NOT NULL DEFAULT '0'");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'name', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'is_default', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'host_notifications_enabled', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->addField($newTable, 'service_notifications_enabled', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->addField($newTable, 'service_notification_period', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'host_notification_period', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'service_notification_options_w', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->addField($newTable, 'service_notification_options_u', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->addField($newTable, 'service_notification_options_c', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->addField($newTable, 'service_notification_options_r', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->addField($newTable, 'service_notification_options_f', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'service_notification_options_n', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'host_notification_options_d', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->addField($newTable, 'host_notification_options_u', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->addField($newTable, 'host_notification_options_r', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->addField($newTable, 'host_notification_options_f', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'host_notification_options_s', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'host_notification_options_n', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'service_notification_commands', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'host_notification_commands', "int(11) NOT NULL DEFAULT '0'");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_contacts
*/
$newTable = "glpi_plugin_monitoring_contacts";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'users_id', 'users_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'plugin_monitoring_contacttemplates_id', 'plugin_monitoring_contacttemplates_id', "int(11) NOT NULL DEFAULT '0'");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'users_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'plugin_monitoring_contacttemplates_id', "int(11) NOT NULL DEFAULT '0'");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_contacts_items
*/
$newTable = "glpi_plugin_monitoring_contacts_items";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'users_id', 'users_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'groups_id', 'groups_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'items_id', 'items_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'itemtype', 'itemtype', "varchar(100) DEFAULT NULL");
$migration->changeField($newTable, 'entities_id', 'entities_id', "int(11) NOT NULL DEFAULT '0'");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'users_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'groups_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'items_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'itemtype', "varchar(100) DEFAULT NULL");
$migration->addField($newTable, 'entities_id', "int(11) NOT NULL DEFAULT '0'");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_commandtemplates
*/
$newTable = "glpi_plugin_monitoring_commandtemplates";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'plugin_monitoring_commands_id', 'plugin_monitoring_commands_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'name', 'name', "varchar(255) DEFAULT NULL");
$migration->changeField($newTable, 'key', 'key', "varchar(255) DEFAULT NULL");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'plugin_monitoring_commands_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'name', "varchar(255) DEFAULT NULL");
$migration->addField($newTable, 'key', "varchar(255) DEFAULT NULL");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_rrdtooltemplates
*/
$newTable = "glpi_plugin_monitoring_rrdtooltemplates";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'plugin_monitoring_commands_id', 'plugin_monitoring_commands_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'name', 'name', "varchar(255) DEFAULT NULL");
$migration->changeField($newTable, 'key', 'key', "varchar(255) DEFAULT NULL");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'plugin_monitoring_commands_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'name', "varchar(255) DEFAULT NULL");
$migration->addField($newTable, 'key', "varchar(255) DEFAULT NULL");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_configs
*/
$newTable = "glpi_plugin_monitoring_configs";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'timezones', 'timezones', "varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '[\"0\"]'");
$migration->changeField($newTable, 'version', 'version', "varchar(255) DEFAULT NULL");
$migration->changeField($newTable, 'logretention', 'logretention', "int(5) NOT NULL DEFAULT '30'");
$migration->dropField($newTable, 'phppath');
$migration->dropField($newTable, 'rrdtoolpath');
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'timezones', "varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '[\"0\"]'");
$migration->addField($newTable, 'version', "varchar(255) DEFAULT NULL");
$migration->addField($newTable, 'logretention', "int(5) NOT NULL DEFAULT '30'");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_displayviews
*/
$newTable = "glpi_plugin_monitoring_displayviews";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'name', 'name', "varchar(255) DEFAULT NULL");
$migration->changeField($newTable, 'entities_id', 'entities_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'is_recursive', 'is_recursive', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'is_active', 'is_active', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'users_id', 'users_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'counter', 'counter', "varchar(255) DEFAULT NULL");
$migration->changeField($newTable, 'in_central', 'in_central', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'width', 'width', "int(5) NOT NULL DEFAULT '950'");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'name', "varchar(255) DEFAULT NULL");
$migration->addField($newTable, 'entities_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'is_recursive', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'is_active', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'users_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'counter', "varchar(255) DEFAULT NULL");
$migration->addField($newTable, 'in_central', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'width', "int(5) NOT NULL DEFAULT '950'");
$migration->addField($newTable, 'is_frontview', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'comment', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_displayviews_groups
*/
$newTable = "glpi_plugin_monitoring_displayviews_groups";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->addField($newTable, 'pluginmonitoringdisplayviews_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'groups_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'entities_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'is_recursive', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->addKey($newTable, "pluginmonitoringdisplayviews_id");
$migration->addKey($newTable, "groups_id");
$migration->addKey($newTable, "entities_id");
$migration->addKey($newTable, "is_recursive");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_displayviews_users
*/
$newTable = "glpi_plugin_monitoring_displayviews_users";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->addField($newTable, 'pluginmonitoringdisplayviews_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'users_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addKey($newTable, "pluginmonitoringdisplayviews_id");
$migration->addKey($newTable, "users_id");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_displayviews_items
*/
$newTable = "glpi_plugin_monitoring_displayviews_items";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'plugin_monitoring_displayviews_id', 'plugin_monitoring_displayviews_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'x', 'x', "int(5) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'y', 'y', "int(5) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'items_id', 'items_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'itemtype', 'itemtype', "varchar(100) DEFAULT NULL");
$migration->changeField($newTable, 'extra_infos', 'extra_infos', "varchar(255) DEFAULT NULL");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'plugin_monitoring_displayviews_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'x', "int(5) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'y', "int(5) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'items_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'itemtype', "varchar(100) DEFAULT NULL");
$migration->addField($newTable, 'extra_infos', "varchar(255) DEFAULT NULL");
$migration->addKey($newTable, "plugin_monitoring_displayviews_id");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_displayviews_rules
*/
$newTable = "glpi_plugin_monitoring_displayviews_rules";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'plugin_monitoring_displayviews_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'name', "varchar(255) DEFAULT NULL");
$migration->addField($newTable, 'itemtype', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'type', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'condition', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->addKey($newTable, 'plugin_monitoring_displayviews_id');
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_entities
*/
$newTable = "glpi_plugin_monitoring_entities";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'entities_id', 'entities_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'tag', 'tag', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'entities_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'tag', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addKey($newTable, "entities_id");
$migration->addKey($newTable, "tag");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_hostaddresses
*/
$newTable = "glpi_plugin_monitoring_hostaddresses";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'items_id', 'items_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'itemtype', 'itemtype', "varchar(100) DEFAULT NULL");
$migration->changeField($newTable, 'networkports_id', 'networkports_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'ipaddresses_id', 'ipaddresses_id', "int(11) NOT NULL DEFAULT '0'");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'items_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'itemtype', "varchar(100) DEFAULT NULL");
$migration->addField($newTable, 'networkports_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'ipaddresses_id', "int(11) NOT NULL DEFAULT '0'");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_hostconfigs
*/
$newTable = "glpi_plugin_monitoring_hostconfigs";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'items_id', 'items_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'itemtype', 'itemtype', "varchar(100) DEFAULT NULL");
$migration->changeField($newTable, 'plugin_monitoring_commands_id', 'plugin_monitoring_commands_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'plugin_monitoring_checks_id', 'plugin_monitoring_checks_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'calendars_id', 'calendars_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'plugin_monitoring_realms_id', 'plugin_monitoring_realms_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'computers_id', 'computers_id', "int(11) NOT NULL DEFAULT '0'");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'items_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'itemtype', "varchar(100) DEFAULT NULL");
$migration->addField($newTable, 'plugin_monitoring_commands_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'plugin_monitoring_checks_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'calendars_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'plugin_monitoring_realms_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'computers_id', "int(11) NOT NULL DEFAULT '0'");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_hosts
*/
$newTable = "glpi_plugin_monitoring_hosts";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'items_id', 'items_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'itemtype', 'itemtype', "varchar(100) DEFAULT NULL");
$migration->changeField($newTable, 'event', 'event', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'state', 'state', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'state_type', 'state_type', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'last_check', 'last_check', "datetime DEFAULT NULL");
$migration->changeField($newTable, 'dependencies', 'dependencies', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'items_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'itemtype', "varchar(100) DEFAULT NULL");
$migration->addField($newTable, 'event', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'state', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'state_type', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'last_check', "datetime DEFAULT NULL");
$migration->addField($newTable, 'dependencies', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_logs
*/
$newTable = "glpi_plugin_monitoring_logs";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` bigint(30) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "bigint(30) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'date_mod', 'date_mod', "datetime DEFAULT NULL");
$migration->changeField($newTable, 'user_name', 'user_name', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'itemtype', 'itemtype', "varchar(100) DEFAULT NULL");
$migration->changeField($newTable, 'items_id', 'items_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'action', 'action', "varchar(100) DEFAULT NULL");
$migration->changeField($newTable, 'value', 'value', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'date_mod', "datetime DEFAULT NULL");
$migration->addField($newTable, 'user_name', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'itemtype', "varchar(100) DEFAULT NULL");
$migration->addField($newTable, 'items_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'action', "varchar(100) DEFAULT NULL");
$migration->addField($newTable, 'value', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_networkports
*/
$newTable = "glpi_plugin_monitoring_networkports";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'items_id', 'items_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'itemtype', 'itemtype', "varchar(100) DEFAULT NULL");
$migration->changeField($newTable, 'networkports_id', 'networkports_id', "int(11) NOT NULL DEFAULT '0'");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'items_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'itemtype', "varchar(100) DEFAULT NULL");
$migration->addField($newTable, 'networkports_id', "int(11) NOT NULL DEFAULT '0'");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_realms
*/
$newTable = "glpi_plugin_monitoring_realms";
$insertrealm = 0;
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
$insertrealm = 1;
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'name', 'name', "varchar(255) DEFAULT NULL");
$migration->changeField($newTable, 'comment', 'comment', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->changeField($newTable, 'date_mod', 'date_mod', "datetime DEFAULT NULL");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'name', "varchar(255) DEFAULT NULL");
$migration->addField($newTable, 'comment', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->addField($newTable, 'date_mod', "datetime DEFAULT NULL");
$migration->migrationOneTable($newTable);
if ($insertrealm == '1') {
$query = "INSERT INTO `glpi_plugin_monitoring_realms` \n (`id` ,`name` ,`comment` ,`date_mod`) VALUES (NULL , 'All', NULL , NULL)";
$DB->query($query);
}
/*
* Table glpi_plugin_monitoring_serviceevents
*/
$newTable = "glpi_plugin_monitoring_serviceevents";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` bigint(30) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "bigint(30) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'plugin_monitoring_services_id', 'plugin_monitoring_services_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'date', 'date', "datetime DEFAULT NULL");
$migration->changeField($newTable, 'event', 'event', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'perf_data', 'perf_data', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->changeField($newTable, 'output', 'output', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'state', 'state', "varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'state_type', 'state_type', "varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'latency', 'latency', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'execution_time', 'execution_time', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'unavailability', 'unavailability', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'plugin_monitoring_services_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'date', "datetime DEFAULT NULL");
$migration->addField($newTable, 'event', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'perf_data', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->addField($newTable, 'output', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'state', "varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'state_type', "varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'latency', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'execution_time', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'unavailability', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->addKey($newTable, "plugin_monitoring_services_id");
$migration->addKey($newTable, array('plugin_monitoring_services_id', 'date'), "plugin_monitoring_services_id_2");
$migration->addKey($newTable, array('unavailability', 'state_type', 'plugin_monitoring_services_id'), "unavailability");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_commands
*/
$newTable = "glpi_plugin_monitoring_commands";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'is_active', 'is_active', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->changeField($newTable, 'name', 'name', "varchar(255) DEFAULT NULL");
$migration->changeField($newTable, 'command_name', 'command_name', "varchar(255) DEFAULT NULL");
$migration->changeField($newTable, 'command_line', 'command_line', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->changeField($newTable, 'poller_tag', 'poller_tag', "varchar(255) DEFAULT NULL");
$migration->changeField($newTable, 'module_type', 'module_type', "varchar(255) DEFAULT NULL");
$migration->changeField($newTable, 'arguments', 'arguments', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->dropField($newTable, 'regex');
$migration->dropField($newTable, 'legend');
$migration->dropField($newTable, 'unit');
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'is_active', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->addField($newTable, 'name', "varchar(255) DEFAULT NULL");
$migration->addField($newTable, 'command_name', "varchar(255) DEFAULT NULL");
$migration->addField($newTable, 'command_line', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->addField($newTable, 'poller_tag', "varchar(255) DEFAULT NULL");
$migration->addField($newTable, 'module_type', "varchar(255) DEFAULT NULL");
$migration->addField($newTable, 'arguments', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->addKey($newTable, "name");
$migration->addKey($newTable, "command_name");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_checks
*/
$newTable = "glpi_plugin_monitoring_checks";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'name', 'name', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'max_check_attempts', 'max_check_attempts', "int(2) NOT NULL DEFAULT '1'");
$migration->changeField($newTable, 'check_interval', 'check_interval', "int(5) NOT NULL DEFAULT '1'");
$migration->changeField($newTable, 'retry_interval', 'retry_interval', "int(5) NOT NULL DEFAULT '1'");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'name', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'max_check_attempts', "int(2) NOT NULL DEFAULT '1'");
$migration->addField($newTable, 'check_interval', "int(5) NOT NULL DEFAULT '1'");
$migration->addField($newTable, 'retry_interval', "int(5) NOT NULL DEFAULT '1'");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_businessrules
*/
$newTable = "glpi_plugin_monitoring_businessrules";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'plugin_monitoring_businessrulegroups_id', 'plugin_monitoring_businessrulegroups_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'plugin_monitoring_services_id', 'plugin_monitoring_services_id', "int(11) NOT NULL DEFAULT '0'");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'plugin_monitoring_businessrulegroups_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'plugin_monitoring_services_id', "int(11) NOT NULL DEFAULT '0'");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_businessrulegroups
*/
$newTable = "glpi_plugin_monitoring_businessrulegroups";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'name', 'name', "varchar(255) DEFAULT NULL");
$migration->changeField($newTable, 'plugin_monitoring_servicescatalogs_id', 'plugin_monitoring_servicescatalogs_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'operator', 'operator', "varchar(255) DEFAULT NULL");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'name', "varchar(255) DEFAULT NULL");
$migration->addField($newTable, 'plugin_monitoring_servicescatalogs_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'operator', "varchar(255) DEFAULT NULL");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_eventhandlers
*/
$newTable = "glpi_plugin_monitoring_eventhandlers";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'is_active', 'is_active', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->changeField($newTable, 'name', 'name', "varchar(255) DEFAULT NULL");
$migration->changeField($newTable, 'command_name', 'command_name', "varchar(255) DEFAULT NULL");
$migration->changeField($newTable, 'command_line', 'command_line', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'is_active', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->addField($newTable, 'name', "varchar(255) DEFAULT NULL");
$migration->addField($newTable, 'command_name', "varchar(255) DEFAULT NULL");
$migration->addField($newTable, 'command_line', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->addKey($newTable, "name");
$migration->addKey($newTable, "command_name");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_notificationcommands
*/
$newTable = "glpi_plugin_monitoring_notificationcommands";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'is_active', 'is_active', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->changeField($newTable, 'name', 'name', "varchar(255) DEFAULT NULL");
$migration->changeField($newTable, 'command_name', 'command_name', "varchar(255) DEFAULT NULL");
$migration->changeField($newTable, 'command_line', 'command_line', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'is_active', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->addField($newTable, 'name', "varchar(255) DEFAULT NULL");
$migration->addField($newTable, 'command_name', "varchar(255) DEFAULT NULL");
$migration->addField($newTable, 'command_line', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->addKey($newTable, "name");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_contactgroups
*/
$newTable = "glpi_plugin_monitoring_contactgroups";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'name', 'name', "varchar(255) DEFAULT NULL");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'name', "varchar(255) DEFAULT NULL");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_contacts_contactgroups
*/
$newTable = "glpi_plugin_monitoring_contacts_contactgroups";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'plugin_monitoring_contacts_id', 'plugin_monitoring_contacts_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'plugin_monitoring_contactgroups_id', 'plugin_monitoring_contactgroups_id', "int(11) NOT NULL DEFAULT '0'");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'plugin_monitoring_contacts_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'plugin_monitoring_contactgroups_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addKey($newTable, array('plugin_monitoring_contacts_id', 'plugin_monitoring_contactgroups_id'), "unicity", "UNIQUE");
$migration->addKey($newTable, "plugin_monitoring_contactgroups_id");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_contactgroups_contactgroups
*/
$newTable = "glpi_plugin_monitoring_contactgroups_contactgroups";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'plugin_monitoring_contactgroups_id_1', 'plugin_monitoring_contactgroups_id_1', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'plugin_monitoring_contactgroups_id_2', 'plugin_monitoring_contactgroups_id_2', "int(11) NOT NULL DEFAULT '0'");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'plugin_monitoring_contactgroups_id_1', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'plugin_monitoring_contactgroups_id_2', "int(11) NOT NULL DEFAULT '0'");
$migration->addKey($newTable, array('plugin_monitoring_contactgroups_id_1', 'plugin_monitoring_contactgroups_id_2'), "unicity", "UNIQUE");
$migration->addKey($newTable, "plugin_monitoring_contactgroups_id_2");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_profiles
*/
$newTable = "glpi_plugin_monitoring_profiles";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `profiles_id` int(11) NOT NULL DEFAULT '0'\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'profiles_id', 'profiles_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'dashboard', 'dashboard', "char(1) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'servicescatalog', 'servicescatalog', "char(1) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'view', 'view', "char(1) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'componentscatalog', 'componentscatalog', "char(1) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'viewshomepage', 'viewshomepage', "char(1) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'weathermap', 'weathermap', "char(1) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'component', 'component', "char(1) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'command', 'command', "char(1) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'config', 'config', "char(1) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'check', 'check', "char(1) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'profiles_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'dashboard', "char(1) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'servicescatalog', "char(1) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'view', "char(1) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'componentscatalog', "char(1) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'viewshomepage', "char(1) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'weathermap', "char(1) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'component', "char(1) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'command', "char(1) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'config', "char(1) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'check', "char(1) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'allressources', "char(1) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'restartshinken', "char(1) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_servicedefs
*/
$newTable = "glpi_plugin_monitoring_servicedefs";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'name', 'name', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'plugin_monitoring_commands_id', 'plugin_monitoring_commands_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'arguments', 'arguments', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->changeField($newTable, 'plugin_monitoring_checks_id', 'plugin_monitoring_checks_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'active_checks_enabled', 'active_checks_enabled', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->changeField($newTable, 'passive_checks_enabled', 'passive_checks_enabled', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->changeField($newTable, 'calendars_id', 'calendars_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'remotesystem', 'remotesystem', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'is_arguments', 'is_arguments', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'alias_command', 'alias_command', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->changeField($newTable, 'aliasperfdata_commands_id', 'aliasperfdata_commands_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'link', 'link', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'name', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'plugin_monitoring_commands_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'arguments', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->addField($newTable, 'plugin_monitoring_checks_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'active_checks_enabled', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->addField($newTable, 'passive_checks_enabled', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->addField($newTable, 'calendars_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'remotesystem', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'is_arguments', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'alias_command', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->addField($newTable, 'aliasperfdata_commands_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'link', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_unavaibilities
*/
$newTable = "glpi_plugin_monitoring_unavaibilities";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
if (!FieldExists($newTable, "plugin_monitoring_services_id")) {
$migration->changeField($newTable, 'items_id', 'plugin_monitoring_services_id', "int(11) NOT NULL DEFAULT '0'");
}
$migration->migrationOneTable($newTable);
$migration->changeField($newTable, 'plugin_monitoring_services_id', 'plugin_monitoring_services_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'begin_date', 'begin_date', "datetime DEFAULT NULL");
$migration->changeField($newTable, 'end_date', 'end_date', "datetime DEFAULT NULL");
$migration->dropField($newTable, 'itemtype');
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'plugin_monitoring_services_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'begin_date', "datetime DEFAULT NULL");
$migration->addField($newTable, 'end_date', "datetime DEFAULT NULL");
$migration->addField($newTable, 'duration', "int(15) NOT NULL DEFAULT '0'");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_weathermaps
*/
$newTable = "glpi_plugin_monitoring_weathermaps";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'name', 'name', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'width', 'width', "smallint(6) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'height', 'height', "smallint(6) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'background', 'background', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'name', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'width', "smallint(6) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'height', "smallint(6) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'background', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_weathermapnodes
*/
$newTable = "glpi_plugin_monitoring_weathermapnodes";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'name', 'name', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'plugin_monitoring_weathermaps_id', 'plugin_monitoring_weathermaps_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'items_id', 'items_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'itemtype', 'itemtype', "varchar(100) DEFAULT NULL");
$migration->changeField($newTable, 'x', 'x', "smallint(6) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'y', 'y', "smallint(6) NOT NULL DEFAULT '0'");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'name', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'plugin_monitoring_weathermaps_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'items_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'itemtype', "varchar(100) DEFAULT NULL");
$migration->addField($newTable, 'x', "smallint(6) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'y', "smallint(6) NOT NULL DEFAULT '0'");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_weathermaplinks
*/
$newTable = "glpi_plugin_monitoring_weathermaplinks";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'plugin_monitoring_weathermapnodes_id_1', 'plugin_monitoring_weathermapnodes_id_1', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'plugin_monitoring_weathermapnodes_id_2', 'plugin_monitoring_weathermapnodes_id_2', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'plugin_monitoring_services_id', 'plugin_monitoring_services_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'bandwidth_in', 'bandwidth_in', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'bandwidth_out', 'bandwidth_out', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'plugin_monitoring_weathermapnodes_id_1', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'plugin_monitoring_weathermapnodes_id_2', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'plugin_monitoring_services_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'bandwidth_in', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'bandwidth_out', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_shinkenwebservices
*/
$newTable = "glpi_plugin_monitoring_shinkenwebservices";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->addField($newTable, 'url', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'action', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'cnt', "tinyint(2) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'fields_string', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_tags
*/
$newTable = "glpi_plugin_monitoring_tags";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->addField($newTable, 'tag', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'ip', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'username', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'password', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->migrationOneTable($newTable);
/*
* Table Delete old table not used
*/
if (TableExists("glpi_plugin_monitoring_servicesuggests")) {
$DB->query("DROP TABLE `glpi_plugin_monitoring_servicesuggests`");
}
if (!is_dir(GLPI_PLUGIN_DOC_DIR . '/monitoring')) {
mkdir(GLPI_PLUGIN_DOC_DIR . "/monitoring");
}
if (!is_dir(GLPI_PLUGIN_DOC_DIR . '/monitoring/templates')) {
mkdir(GLPI_PLUGIN_DOC_DIR . "/monitoring/templates");
}
$query = "SELECT * FROM `glpi_calendars`\n WHERE `name`='24x7'\n LIMIT 1";
$result = $DB->query($query);
if ($DB->numrows($result) == 0) {
$calendar = new Calendar();
$input = array();
$input['name'] = '24x7';
$input['is_recursive'] = 1;
$calendars_id = $calendar->add($input);
$calendarSegment = new CalendarSegment();
$input = array();
$input['calendars_id'] = $calendars_id;
$input['is_recursive'] = 1;
$input['begin'] = '00:00:00';
$input['end'] = '24:00:00';
$input['day'] = '0';
$calendarSegment->add($input);
$input['day'] = '1';
$calendarSegment->add($input);
$input['day'] = '2';
$calendarSegment->add($input);
$input['day'] = '3';
$calendarSegment->add($input);
$input['day'] = '4';
$calendarSegment->add($input);
$input['day'] = '5';
$calendarSegment->add($input);
$input['day'] = '6';
$calendarSegment->add($input);
}
$crontask = new CronTask();
if (!$crontask->getFromDBbyName('PluginMonitoringServiceevent', 'updaterrd')) {
CronTask::Register('PluginMonitoringServiceevent', 'updaterrd', '300', array('mode' => 2, 'allowmode' => 3, 'logs_lifetime' => 30));
}
if (!$crontask->getFromDBbyName('PluginMonitoringLog', 'cleanlogs')) {
CronTask::Register('PluginMonitoringLog', 'cleanlogs', '96400', array('mode' => 2, 'allowmode' => 3, 'logs_lifetime' => 30));
}
if (!$crontask->getFromDBbyName('PluginMonitoringUnavaibility', 'unavaibility')) {
CronTask::Register('PluginMonitoringUnavaibility', 'unavaibility', '300', array('mode' => 2, 'allowmode' => 3, 'logs_lifetime' => 30));
}
if (!$crontask->getFromDBbyName('PluginMonitoringDisplayview_rule', 'replayallviewrules')) {
CronTask::Register('PluginMonitoringDisplayview_rule', 'replayallviewrules', '1200', array('mode' => 2, 'allowmode' => 3, 'logs_lifetime' => 30));
}
/*
* Clean services not have host
*/
$query = "SELECT `glpi_plugin_monitoring_services`.* FROM `glpi_plugin_monitoring_services`\n LEFT JOIN `glpi_plugin_monitoring_componentscatalogs_hosts`\n ON `glpi_plugin_monitoring_componentscatalogs_hosts`.`id` = `plugin_monitoring_componentscatalogs_hosts_id`\n WHERE `is_static` IS NULL";
$result = $DB->query($query);
while ($data = $DB->fetch_array($result)) {
$queryd = "DELETE FROM `glpi_plugin_monitoring_services`\n WHERE `id`='" . $data['id'] . "'";
$DB->query($queryd);
}
include GLPI_ROOT . "/plugins/monitoring/inc/hostconfig.class.php";
$pmHostconfig = new PluginMonitoringHostconfig();
$pmHostconfig->initConfig();
include GLPI_ROOT . "/plugins/monitoring/inc/host.class.php";
$pmHost = new PluginMonitoringHost();
$pmHost->verifyHosts();
if ($insertrealm == '1') {
// Insert into hostconfigs
$query = "UPDATE `glpi_plugin_monitoring_hostconfigs` \n SET `plugin_monitoring_realms_id` = '1'\n WHERE `items_id` = '0'\n AND `itemtype` = 'Entity'";
$DB->query($query);
}
include GLPI_ROOT . "/plugins/monitoring/inc/config.class.php";
$pmConfig = new PluginMonitoringConfig();
$pmConfig->initConfig();
// * Recalculate unavaibility
if ($unavaibility_recalculate == 1) {
$query = "SELECT * FROM `glpi_plugin_monitoring_unavaibilities`\n WHERE `end_date` IS NOT NULL";
$result = $DB->query($query);
while ($data = $DB->fetch_array($result)) {
$time = strtotime($data['end_date']) - strtotime($data['begin_date']);
$queryd = "UPDATE `glpi_plugin_monitoring_unavaibilities`\n SET `duration`='" . $time . "'\n WHERE `id`='" . $data['id'] . "'";
$DB->query($queryd);
}
}
$query = "UPDATE `glpi_plugin_monitoring_configs`\n SET `version`='" . PLUGIN_MONITORING_VERSION . "'\n WHERE `id`='1'";
$DB->query($query);
}
function generateTimeperiodsCfg($file = 0, $tag = '')
{
global $DB;
PluginMonitoringToolbox::logIfExtradebug('pm-shinken', "Starting generateTimeperiodsCfg ...\n");
$calendar = new Calendar();
$calendarSegment = new CalendarSegment();
$calendar_Holiday = new Calendar_Holiday();
$holiday = new Holiday();
$hostconfig = new PluginMonitoringHostconfig();
$pmEntity = new PluginMonitoringEntity();
// Get list of entities
$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);
}
foreach ($a_entities_list as $entities_id) {
$jetlag = $hostconfig->getValueAncestor('jetlag', $entities_id);
$a_entities_list[$entities_id] = $jetlag;
}
// Get all calendars of components
$cals_entities = array();
$query = "SELECT `entities_id`, `calendars_id`\n FROM `glpi_plugin_monitoring_services`\n LEFT JOIN `glpi_plugin_monitoring_components`\n ON `plugin_monitoring_components_id` = `glpi_plugin_monitoring_components`.`id` ";
if ($where == '') {
$query .= "WHERE `glpi_plugin_monitoring_components`.`id` IS NOT NULL";
} else {
$query .= $where . " AND `glpi_plugin_monitoring_components`.`id` IS NOT NULL";
}
$result = $DB->query($query);
while ($data = $DB->fetch_array($result)) {
if (!isset($cals_entities[$data['entities_id']])) {
$cals_entities[$data['entities_id']] = array();
}
$cals_entities[$data['entities_id']][$data['calendars_id']] = $data['calendars_id'];
}
// get all calendars of servciescatalog
$query = "SELECT `entities_id`, `calendars_id`\n FROM `glpi_plugin_monitoring_servicescatalogs` " . $where;
$result = $DB->query($query);
while ($data = $DB->fetch_array($result)) {
if (!isset($cals_entities[$data['entities_id']])) {
$cals_entities[$data['entities_id']] = array();
}
$cals_entities[$data['entities_id']][$data['calendars_id']] = $data['calendars_id'];
}
// Get all calendars of contacts TODO
$calendars_added = array();
$a_timeperiods = array();
$i = 0;
foreach ($cals_entities as $entities_id => $calendars) {
foreach ($calendars as $calendars_id) {
$jetlag = $a_entities_list[$entities_id];
if (!isset($calendars_added[$calendars_id . "-" . $jetlag])) {
$calendars_added[$calendars_id . "-" . $jetlag] = 1;
$calendar->getFromDB($calendars_id);
$tmp = array();
$tmp['timeperiod_name'] = $calendar->fields['name'];
$tmp['alias'] = $calendar->fields['name'];
$a_listsegment = $calendarSegment->find("`calendars_id`='" . $calendar->fields['id'] . "'");
$a_cal = array();
foreach ($a_listsegment as $datasegment) {
$begin = preg_replace("/:00\$/", "", $datasegment['begin']);
$end = preg_replace("/:00\$/", "", $datasegment['end']);
$day = "";
switch ($datasegment['day']) {
case "0":
$day = "sunday";
break;
case "1":
$day = "monday";
break;
case "2":
$day = "tuesday";
break;
case "3":
$day = "wednesday";
break;
case "4":
$day = "thursday";
break;
case "5":
$day = "friday";
break;
case "6":
$day = "saturday";
break;
}
$a_cal[$day][] = $begin . "-" . $end;
}
foreach ($a_cal as $day => $a_times) {
$tmp[$day] = implode(',', $a_times);
}
$a_cholidays = $calendar_Holiday->find("`calendars_id`='" . $calendar->fields['id'] . "'");
foreach ($a_cholidays as $a_choliday) {
$holiday->getFromDB($a_choliday['holidays_id']);
if ($holiday->fields['is_perpetual'] == 1 && $holiday->fields['begin_date'] == $holiday->fields['end_date']) {
$datetime = strtotime($holiday->fields['begin_date']);
$tmp[strtolower(date('F', $datetime)) . ' ' . date('j', $datetime)] = '00:00-00:00';
}
}
if ($jetlag == 0) {
$tmp['timeperiod_name'] = $tmp['timeperiod_name'];
$tmp['alias'] = $tmp['alias'];
} else {
$tmp['timeperiod_name'] = $tmp['timeperiod_name'] . "-" . $jetlag;
$tmp['alias'] = $tmp['alias'] . "-" . $jetlag;
}
$days = array('sunday', 'monday', 'tuesday', 'wednesday', 'thursday', 'friday', 'saturday');
$saturday = '';
$reportHours = 0;
$beforeday = 'saturday';
foreach ($days as $numday => $day) {
if (isset($tmp[$day])) {
$splitDay = explode(',', $tmp[$day]);
$toAdd = '';
if ($reportHours > 0) {
$toAdd = '00:00-' . sprintf("%02s", $reportHours) . ':00';
$reportHours = 0;
}
foreach ($splitDay as $num => $hourMinute) {
$previous_begin = 0;
$beginEnd = explode('-', $hourMinute);
// ** Begin **
$split = explode(':', $beginEnd[0]);
$split[0] += $jetlag;
if ($split[0] > 24) {
//$reportHours = $split[0] - 24;
unset($splitDay[$num]);
} else {
if ($split[0] < 0) {
$reportHours = $split[0];
$previous_begin = 24 + $split[0];
$split[0] = '00';
}
$beginEnd[0] = sprintf("%02s", $split[0]) . ':' . $split[1];
// ** End **
$split = explode(':', $beginEnd[1]);
$split[0] += $jetlag;
if ($split[0] < 0) {
if ($numday - 1 == -1) {
$saturday .= "," . sprintf("%02s", $previous_begin) . ":00-" . sprintf("%02s", 24 + $split[0]) . ":00";
} else {
$tmp[$days[$numday - 1]] .= "," . sprintf("%02s", $previous_begin) . ":00-" . sprintf("%02s", 24 + $split[0]) . ":00";
}
unset($splitDay[$num]);
} else {
if ($split[0] > 24) {
$reportHours = $split[0] - 24;
$split[0] = 24;
}
$beginEnd[1] = sprintf("%02s", $split[0]) . ':' . $split[1];
$hourMinute = implode('-', $beginEnd);
$splitDay[$num] = $hourMinute;
}
}
}
if ($reportHours < 0) {
// if (!isset($tmp[$beforeday])) {
// $tmp[$beforeday] = array();
// }
// $splitBeforeDay = explode(',', $tmp[$beforeday]);
// $splitBeforeDay[] = sprintf("%02s", (24 + $reportHours)).':00-24:00';
// $tmp[$beforeday] = implode(',', $splitBeforeDay);
$reportHours = 0;
}
if (!empty($toAdd)) {
array_unshift($splitDay, $toAdd);
}
$tmp[$day] = implode(',', $splitDay);
} else {
if ($reportHours > 0) {
//$tmp[$day] = '00:00-'.$reportHours.':00';
$reportHours = 0;
}
}
$beforeday = $day;
}
// Manage for report hours from saturday to sunday
if ($reportHours > 0) {
$splitDay = explode(',', $tmp['sunday']);
array_unshift($splitDay, '00:00-' . sprintf("%02s", $reportHours) . ':00');
$tmp['sunday'] = implode(',', $splitDay);
}
if ($saturday != '') {
if (isset($tmp['saturday'])) {
$tmp['saturday'] .= $saturday;
} else {
$tmp['saturday'] = $saturday;
}
}
// concatain if need
foreach ($days as $day) {
if (isset($tmp[$day])) {
$splitDay = explode(',', $tmp[$day]);
$beforeHour = '';
$beforeNum = 0;
foreach ($splitDay as $num => $data) {
if (substr($data, 0, 2) == $beforeHour) {
$splitDay[$beforeNum] = substr($splitDay[$beforeNum], 0, 6) . substr($data, 6, 5);
$beforeHour = substr($data, 6, 2);
unset($splitDay[$num]);
} else {
$beforeHour = substr($data, 6, 2);
$beforeNum = $num;
}
}
$tmp[$day] = implode(',', $splitDay);
}
}
$a_timeperiods[$i] = $tmp;
$i++;
}
}
}
PluginMonitoringToolbox::logIfExtradebug('pm-shinken', "End generateTimeperiodsCfg\n");
if ($file == "1") {
$config = "# Generated by plugin monitoring for GLPI\n# on " . date("Y-m-d H:i:s") . "\n\n";
foreach ($a_timeperiods as $data) {
$config .= $this->writeFile("timeperiod", $data);
}
return array('timeperiods.cfg', $config);
} else {
return $a_timeperiods;
}
}
function pluginMonitoringUpdate($current_version, $migrationname = 'Migration')
{
global $DB;
$migration = new $migrationname($current_version);
if (!is_dir(GLPI_PLUGIN_DOC_DIR . '/monitoring')) {
mkdir(GLPI_PLUGIN_DOC_DIR . "/monitoring");
}
if (!is_dir(GLPI_PLUGIN_DOC_DIR . '/monitoring/templates')) {
mkdir(GLPI_PLUGIN_DOC_DIR . "/monitoring/templates");
}
if (!is_dir(GLPI_PLUGIN_DOC_DIR . '/monitoring/weathermapbg')) {
mkdir(GLPI_PLUGIN_DOC_DIR . "/monitoring/weathermapbg");
}
$unavailability_recalculate = 0;
if (!TableExists("glpi_plugin_monitoring_unavailabilities") || !FieldExists("glpi_plugin_monitoring_unavailabilities", "duration")) {
$unavailability_recalculate = 1;
}
$unavailability_reset = 0;
if (!TableExists("glpi_plugin_monitoring_unavailabilities")) {
$unavailability_reset = 1;
}
/*
* Table glpi_plugin_monitoring_servicescatalogs
*/
$newTable = "glpi_plugin_monitoring_servicescatalogs";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'name', 'name', "varchar(255) DEFAULT NULL");
$migration->changeField($newTable, 'entities_id', 'entities_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'is_recursive', 'is_recursive', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'comment', 'comment', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->changeField($newTable, 'last_check', 'last_check', "datetime DEFAULT NULL");
$migration->changeField($newTable, 'state', 'state', "varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'state_type', 'state_type', "varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'plugin_monitoring_checks_id', 'plugin_monitoring_checks_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'calendars_id', 'calendars_id', "int(11) NOT NULL DEFAULT '0'");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'name', "varchar(255) DEFAULT NULL");
$migration->addField($newTable, 'entities_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'is_recursive', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'last_check', "datetime DEFAULT NULL");
$migration->addField($newTable, 'event', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'state', "varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'state_type', "varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'plugin_monitoring_checks_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'calendars_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'is_acknowledged', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'is_acknowledgeconfirmed', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'acknowledge_comment', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->addField($newTable, 'acknowledge_users_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'notification_interval', "int(4) NOT NULL DEFAULT '30'");
$migration->addField($newTable, 'business_priority', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->addField($newTable, 'is_generic', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'plugin_monitoring_servicescatalogs_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addKey($newTable, "name");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_componentscatalogs
*/
$newTable = "glpi_plugin_monitoring_componentscatalogs";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'name', 'name', "varchar(255) DEFAULT NULL");
$migration->changeField($newTable, 'entities_id', 'entities_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'is_recursive', 'is_recursive', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'comment', 'comment', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->changeField($newTable, 'notification_interval', 'notification_interval', "int(4) NOT NULL DEFAULT '30'");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'name', "varchar(255) DEFAULT NULL");
$migration->addField($newTable, 'entities_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'is_recursive', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'comment', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->addField($newTable, 'notification_interval', "int(4) NOT NULL DEFAULT '30'");
$migration->addKey($newTable, "name");
$migration->migrationOneTable($newTable);
/*
* glpi_plugin_monitoring_perfdatas
*/
$a_table = array();
$a_table['name'] = 'glpi_plugin_monitoring_perfdatas';
$a_table['oldname'] = array();
$a_table['fields'] = array('id' => array('type' => 'autoincrement', 'value' => ''), 'name' => array('type' => 'string', 'value' => NULL), 'perfdata' => array('type' => 'text', 'value' => NULL));
$a_table['oldfields'] = array();
$a_table['renamefields'] = array();
$a_table['keys'] = array();
$a_table['oldkeys'] = array();
migrateTablesMonitoring($migration, $a_table);
/*
* glpi_plugin_monitoring_customitems_counters
*/
$a_table = array();
$a_table['name'] = 'glpi_plugin_monitoring_customitems_counters';
$a_table['oldname'] = array();
$a_table['fields'] = array('id' => array('type' => 'autoincrement', 'value' => ''), 'name' => array('type' => 'string', 'value' => NULL), 'entities_id' => array('type' => 'integer', 'value' => NULL), 'is_recursive' => array('type' => 'bool', 'value' => NULL), 'type' => array('type' => 'string', 'value' => NULL), 'aggregate_items' => array('type' => 'text', 'value' => NULL), 'time' => array('type' => 'string', 'value' => NULL), 'time_specific' => array('type' => 'string', 'value' => NULL));
$a_table['oldfields'] = array();
$a_table['renamefields'] = array();
$a_table['keys'] = array();
$a_table['oldkeys'] = array();
migrateTablesMonitoring($migration, $a_table);
/*
* glpi_plugin_monitoring_customitems_gauges
*/
$a_table = array();
$a_table['name'] = 'glpi_plugin_monitoring_customitems_gauges';
$a_table['oldname'] = array();
$a_table['fields'] = array('id' => array('type' => 'autoincrement', 'value' => ''), 'name' => array('type' => 'string', 'value' => NULL), 'entities_id' => array('type' => 'integer', 'value' => NULL), 'is_recursive' => array('type' => 'bool', 'value' => NULL), 'type' => array('type' => 'string', 'value' => NULL), 'aggregate_items' => array('type' => 'text', 'value' => NULL), 'aggregate_warn' => array('type' => 'text', 'value' => NULL), 'aggregate_crit' => array('type' => 'text', 'value' => NULL), 'aggregate_limit' => array('type' => 'text', 'value' => NULL), 'time' => array('type' => 'string', 'value' => NULL), 'time_specific' => array('type' => 'string', 'value' => NULL));
$a_table['oldfields'] = array();
$a_table['renamefields'] = array();
$a_table['keys'] = array();
$a_table['oldkeys'] = array();
migrateTablesMonitoring($migration, $a_table);
/*
* glpi_plugin_monitoring_perfdatadetails
*/
$a_table = array();
$a_table['name'] = 'glpi_plugin_monitoring_perfdatadetails';
$a_table['oldname'] = array();
$a_table['fields'] = array('id' => array('type' => 'autoincrement', 'value' => ''), 'name' => array('type' => 'string', 'value' => NULL), 'dynamic_name' => array('type' => 'bool', 'value' => NULL), 'plugin_monitoring_perfdatas_id' => array('type' => 'integer', 'value' => NULL), 'position' => array('type' => "int(2) NOT NULL DEFAULT '0'", 'value' => NULL), 'dsname_num' => array('type' => 'tinyint(1) NOT NULL DEFAULT "1"', 'value' => NULL), 'dsname1' => array('type' => 'string', 'value' => NULL), 'dsname2' => array('type' => 'string', 'value' => NULL), 'dsname3' => array('type' => 'string', 'value' => NULL), 'dsname4' => array('type' => 'string', 'value' => NULL), 'dsname5' => array('type' => 'string', 'value' => NULL), 'dsname6' => array('type' => 'string', 'value' => NULL), 'dsname7' => array('type' => 'string', 'value' => NULL), 'dsname8' => array('type' => 'string', 'value' => NULL), 'dsname9' => array('type' => 'string', 'value' => NULL), 'dsname10' => array('type' => 'string', 'value' => NULL), 'dsname11' => array('type' => 'string', 'value' => NULL), 'dsname12' => array('type' => 'string', 'value' => NULL), 'dsname13' => array('type' => 'string', 'value' => NULL), 'dsname14' => array('type' => 'string', 'value' => NULL), 'dsname15' => array('type' => 'string', 'value' => NULL), 'dsnameincr1' => array('type' => 'bool', 'value' => 0), 'dsnameincr2' => array('type' => 'bool', 'value' => 0), 'dsnameincr3' => array('type' => 'bool', 'value' => 0), 'dsnameincr4' => array('type' => 'bool', 'value' => 0), 'dsnameincr5' => array('type' => 'bool', 'value' => 0), 'dsnameincr6' => array('type' => 'bool', 'value' => 0), 'dsnameincr7' => array('type' => 'bool', 'value' => 0), 'dsnameincr8' => array('type' => 'bool', 'value' => 0), 'dsnameincr9' => array('type' => 'bool', 'value' => 0), 'dsnameincr10' => array('type' => 'bool', 'value' => 0), 'dsnameincr11' => array('type' => 'bool', 'value' => 0), 'dsnameincr12' => array('type' => 'bool', 'value' => 0), 'dsnameincr13' => array('type' => 'bool', 'value' => 0), 'dsnameincr14' => array('type' => 'bool', 'value' => 0), 'dsnameincr15' => array('type' => 'bool', 'value' => 0));
$a_table['oldfields'] = array();
$a_table['renamefields'] = array();
$a_table['keys'] = array(array('field' => 'plugin_monitoring_perfdatas_id', 'name' => '', 'type' => 'INDEX'));
$a_table['oldkeys'] = array();
migrateTablesMonitoring($migration, $a_table);
if (countElementsInTable('glpi_plugin_monitoring_perfdatas') == 0) {
include GLPI_ROOT . "/plugins/monitoring/inc/perfdata.class.php";
include GLPI_ROOT . "/plugins/monitoring/inc/perfdatadetail.class.php";
PluginMonitoringPerfdata::initDB();
}
/*
* Table glpi_plugin_monitoring_components
*/
if (TableExists('glpi_plugin_monitoring_components')) {
$a_data = getAllDatasFromTable('glpi_plugin_monitoring_components');
foreach ($a_data as $data) {
if (!is_numeric($data['graph_template'])) {
$a_perfs = getAllDatasFromTable('glpi_plugin_monitoring_perfdatas', '`name`="' . $data['graph_template'] . '"');
if (count($a_perfs) == 0) {
$DB->query("UPDATE `glpi_plugin_monitoring_components`\n SET `graph_template`='0'\n WHERE `id`='" . $data['id'] . "'");
} else {
$a_perf = current($a_perfs);
$DB->query("UPDATE `glpi_plugin_monitoring_components`\n SET `graph_template`='" . $a_perf['id'] . "'\n WHERE `id`='" . $data['id'] . "'");
}
}
}
}
$newTable = "glpi_plugin_monitoring_components";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'name', 'name', "varchar(255) DEFAULT NULL");
// 0.84+1.3
$migration->changeField($newTable, 'description', 'description', "varchar(255) DEFAULT NULL");
$migration->changeField($newTable, 'plugin_monitoring_commands_id', 'plugin_monitoring_commands_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'arguments', 'arguments', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->changeField($newTable, 'plugin_monitoring_checks_id', 'plugin_monitoring_checks_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'active_checks_enabled', 'active_checks_enabled', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->changeField($newTable, 'passive_checks_enabled', 'passive_checks_enabled', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->changeField($newTable, 'calendars_id', 'calendars_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'remotesystem', 'remotesystem', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'is_arguments', 'is_arguments', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'alias_command', 'alias_command', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->changeField($newTable, 'graph_template', 'graph_template', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'link', 'link', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'is_weathermap', 'is_weathermap', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'weathermap_regex', 'weathermap_regex_in', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->changeField($newTable, 'perfname', 'perfname', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->changeField($newTable, 'perfnameinvert', 'perfnameinvert', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->changeField($newTable, 'perfnamecolor', 'perfnamecolor', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->addField($newTable, 'name', "varchar(255) DEFAULT NULL");
// 0.84+1.3
$migration->addField($newTable, 'description', "varchar(255) DEFAULT NULL");
$migration->addField($newTable, 'plugin_monitoring_commands_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'arguments', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->addField($newTable, 'plugin_monitoring_checks_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'active_checks_enabled', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->addField($newTable, 'passive_checks_enabled', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->addField($newTable, 'calendars_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'remotesystem', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'is_arguments', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'alias_command', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->addField($newTable, 'graph_template', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'link', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'is_weathermap', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'weathermap_regex_in', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->addField($newTable, 'weathermap_regex_out', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->addField($newTable, 'perfname', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->addField($newTable, 'perfnameinvert', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->addField($newTable, 'perfnamecolor', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->addField($newTable, 'plugin_monitoring_eventhandlers_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'freshness_count', "int(6) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'freshness_type', "varchar(255) DEFAULT 'seconds'");
$migration->addKey($newTable, "plugin_monitoring_commands_id");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_componentscatalogs_components
*/
$newTable = "glpi_plugin_monitoring_componentscatalogs_components";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'plugin_monitoring_componentscalalog_id', 'plugin_monitoring_componentscalalog_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'plugin_monitoring_components_id', 'plugin_monitoring_components_id', "int(11) NOT NULL DEFAULT '0'");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'plugin_monitoring_componentscalalog_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'plugin_monitoring_components_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addKey($newTable, array('plugin_monitoring_componentscalalog_id', 'plugin_monitoring_components_id'), "unicity", "UNIQUE");
$migration->addKey($newTable, "plugin_monitoring_componentscalalog_id");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_componentscatalogs_hosts
*/
$newTable = "glpi_plugin_monitoring_componentscatalogs_hosts";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'plugin_monitoring_componentscalalog_id', 'plugin_monitoring_componentscalalog_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'is_static', 'is_static', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->changeField($newTable, 'items_id', 'items_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'itemtype', 'itemtype', "varchar(100) DEFAULT NULL");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'plugin_monitoring_componentscalalog_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'is_static', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->addField($newTable, 'items_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'itemtype', "varchar(100) DEFAULT NULL");
$migration->addKey($newTable, array('itemtype', 'items_id'), 'itemtype');
$migration->addKey($newTable, 'plugin_monitoring_componentscalalog_id');
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_componentscatalogs_rules
*/
$newTable = "glpi_plugin_monitoring_componentscatalogs_rules";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'plugin_monitoring_componentscalalog_id', 'plugin_monitoring_componentscalalog_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'name', 'name', "varchar(255) DEFAULT NULL");
$migration->changeField($newTable, 'itemtype', 'itemtype', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'condition', 'condition', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->dropField($newTable, 'entities_id');
$migration->dropField($newTable, 'is_recursive');
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'plugin_monitoring_componentscalalog_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'name', "varchar(255) DEFAULT NULL");
$migration->addField($newTable, 'itemtype', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'condition', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->addKey($newTable, 'plugin_monitoring_componentscalalog_id');
$migration->migrationOneTable($newTable);
$DB->query("UPDATE `glpi_plugin_monitoring_componentscatalogs_rules`\n SET `itemtype`='Computer' WHERE `itemtype`='PluginMonitoringComputer'");
/*
* Table glpi_plugin_monitoring_services
*/
$newTable = "glpi_plugin_monitoring_services";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'entities_id', 'entities_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'name', 'name', "varchar(255) DEFAULT NULL");
$migration->changeField($newTable, 'plugin_monitoring_components_id', 'plugin_monitoring_components_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'plugin_monitoring_componentscatalogs_hosts_id', 'plugin_monitoring_componentscatalogs_hosts_id', "int(11) NOT NULL DEFAULT '0'");
// Event should contain up to 4096 bytes (Nagios plugin specification)
$migration->changeField($newTable, 'event', 'event', "varchar(4096) COLLATE utf8_unicode_ci DEFAULT NULL");
// $migration->changeField($newTable,
// 'event',
// 'event',
// "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'state', 'state', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'state_type', 'state_type', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'last_check', 'last_check', "datetime DEFAULT NULL");
$migration->changeField($newTable, 'arguments', 'arguments', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->changeField($newTable, 'networkports_id', 'networkports_id', "int(11) NOT NULL DEFAULT '0'");
$migration->dropField($newTable, 'alias_command');
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'entities_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'name', "varchar(255) DEFAULT NULL");
$migration->addField($newTable, 'plugin_monitoring_components_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'plugin_monitoring_componentscatalogs_hosts_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'event', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'state', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'state_type', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'last_check', "datetime DEFAULT NULL");
$migration->addField($newTable, 'arguments', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->addField($newTable, 'networkports_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'is_acknowledged', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'is_acknowledgeconfirmed', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'acknowledge_comment', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->addField($newTable, 'acknowledge_users_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addKey($newTable, array('state', 'state_type'), 'state');
$migration->addKey($newTable, 'plugin_monitoring_componentscatalogs_hosts_id');
$migration->addKey($newTable, 'last_check');
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_contacttemplates
*/
$newTable = "glpi_plugin_monitoring_contacttemplates";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'name', 'name', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'is_default', 'is_default', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'shinken_administrator', 'shinken_administrator', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'shinken_can_submit_commands', 'shinken_can_submit_commands', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'host_notifications_enabled', 'host_notifications_enabled', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->changeField($newTable, 'service_notifications_enabled', 'service_notifications_enabled', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->changeField($newTable, 'service_notification_period', 'service_notification_period', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'host_notification_period', 'host_notification_period', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'service_notification_options_w', 'service_notification_options_w', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->changeField($newTable, 'service_notification_options_u', 'service_notification_options_u', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->changeField($newTable, 'service_notification_options_c', 'service_notification_options_c', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->changeField($newTable, 'service_notification_options_r', 'service_notification_options_r', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->changeField($newTable, 'service_notification_options_f', 'service_notification_options_f', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'service_notification_options_n', 'service_notification_options_n', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'host_notification_options_d', 'host_notification_options_d', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->changeField($newTable, 'host_notification_options_u', 'host_notification_options_u', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->changeField($newTable, 'host_notification_options_r', 'host_notification_options_r', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->changeField($newTable, 'host_notification_options_f', 'host_notification_options_f', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'host_notification_options_s', 'host_notification_options_s', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'host_notification_options_n', 'host_notification_options_n', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'service_notification_commands', 'service_notification_commands', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'host_notification_commands', 'host_notification_commands', "int(11) NOT NULL DEFAULT '0'");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'name', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'is_default', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'shinken_administrator', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'shinken_can_submit_commands', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'host_notifications_enabled', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->addField($newTable, 'service_notifications_enabled', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->addField($newTable, 'service_notification_period', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'host_notification_period', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'service_notification_options_w', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->addField($newTable, 'service_notification_options_u', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->addField($newTable, 'service_notification_options_c', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->addField($newTable, 'service_notification_options_r', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->addField($newTable, 'service_notification_options_f', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'service_notification_options_n', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'host_notification_options_d', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->addField($newTable, 'host_notification_options_u', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->addField($newTable, 'host_notification_options_r', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->addField($newTable, 'host_notification_options_f', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'host_notification_options_s', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'host_notification_options_n', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'service_notification_commands', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'host_notification_commands', "int(11) NOT NULL DEFAULT '0'");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_contacts
*/
$newTable = "glpi_plugin_monitoring_contacts";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'users_id', 'users_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'plugin_monitoring_contacttemplates_id', 'plugin_monitoring_contacttemplates_id', "int(11) NOT NULL DEFAULT '0'");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'users_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'plugin_monitoring_contacttemplates_id', "int(11) NOT NULL DEFAULT '0'");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_contacts_items
*/
$newTable = "glpi_plugin_monitoring_contacts_items";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'users_id', 'users_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'groups_id', 'groups_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'items_id', 'items_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'itemtype', 'itemtype', "varchar(100) DEFAULT NULL");
$migration->changeField($newTable, 'entities_id', 'entities_id', "int(11) NOT NULL DEFAULT '0'");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'users_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'groups_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'items_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'itemtype', "varchar(100) DEFAULT NULL");
$migration->addField($newTable, 'entities_id', "int(11) NOT NULL DEFAULT '0'");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_commandtemplates
*/
$newTable = "glpi_plugin_monitoring_commandtemplates";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'plugin_monitoring_commands_id', 'plugin_monitoring_commands_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'name', 'name', "varchar(255) DEFAULT NULL");
$migration->changeField($newTable, 'key', 'key', "varchar(255) DEFAULT NULL");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'plugin_monitoring_commands_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'name', "varchar(255) DEFAULT NULL");
$migration->addField($newTable, 'key', "varchar(255) DEFAULT NULL");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_rrdtooltemplates
*/
$newTable = "glpi_plugin_monitoring_rrdtooltemplates";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'plugin_monitoring_commands_id', 'plugin_monitoring_commands_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'name', 'name', "varchar(255) DEFAULT NULL");
$migration->changeField($newTable, 'key', 'key', "varchar(255) DEFAULT NULL");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'plugin_monitoring_commands_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'name', "varchar(255) DEFAULT NULL");
$migration->addField($newTable, 'key', "varchar(255) DEFAULT NULL");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_configs
*/
$newTable = "glpi_plugin_monitoring_configs";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'timezones', 'timezones', "varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '[\"0\"]'");
$migration->changeField($newTable, 'version', 'version', "varchar(255) DEFAULT NULL");
$migration->changeField($newTable, 'logretention', 'logretention', "int(5) NOT NULL DEFAULT '30'");
$migration->changeField($newTable, 'nrpe_prefix_contener', 'nrpe_prefix_contener', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'append_id_hostname', 'append_id_hostname', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->dropField($newTable, 'phppath');
$migration->dropField($newTable, 'rrdtoolpath');
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'timezones', "varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '[\"0\"]'");
$migration->addField($newTable, 'version', "varchar(255) DEFAULT NULL");
$migration->addField($newTable, 'logretention', "int(5) NOT NULL DEFAULT '30'");
$migration->addField($newTable, 'extradebug', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'nrpe_prefix_contener', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'append_id_hostname', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_displayviews
*/
$newTable = "glpi_plugin_monitoring_displayviews";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'name', 'name', "varchar(255) DEFAULT NULL");
$migration->changeField($newTable, 'entities_id', 'entities_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'is_recursive', 'is_recursive', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'is_active', 'is_active', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'users_id', 'users_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'counter', 'counter', "varchar(255) DEFAULT NULL");
$migration->changeField($newTable, 'in_central', 'in_central', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'width', 'width', "int(5) NOT NULL DEFAULT '950'");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'name', "varchar(255) DEFAULT NULL");
$migration->addField($newTable, 'entities_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'is_recursive', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'is_active', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'users_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'counter', "varchar(255) DEFAULT NULL");
$migration->addField($newTable, 'in_central', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'width', "int(5) NOT NULL DEFAULT '950'");
$migration->addField($newTable, 'is_frontview', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'comment', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_displayviews_groups
*/
$newTable = "glpi_plugin_monitoring_displayviews_groups";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->addField($newTable, 'pluginmonitoringdisplayviews_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'groups_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'entities_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'is_recursive', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->addKey($newTable, "pluginmonitoringdisplayviews_id");
$migration->addKey($newTable, "groups_id");
$migration->addKey($newTable, "entities_id");
$migration->addKey($newTable, "is_recursive");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_displayviews_users
*/
$newTable = "glpi_plugin_monitoring_displayviews_users";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->addField($newTable, 'pluginmonitoringdisplayviews_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'users_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addKey($newTable, "pluginmonitoringdisplayviews_id");
$migration->addKey($newTable, "users_id");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_displayviews_items
*/
$newTable = "glpi_plugin_monitoring_displayviews_items";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'plugin_monitoring_displayviews_id', 'plugin_monitoring_displayviews_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'x', 'x', "int(5) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'y', 'y', "int(5) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'items_id', 'items_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'itemtype', 'itemtype', "varchar(100) DEFAULT NULL");
$migration->changeField($newTable, 'extra_infos', 'extra_infos', "varchar(255) DEFAULT NULL");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'plugin_monitoring_displayviews_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'x', "int(5) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'y', "int(5) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'items_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'itemtype', "varchar(100) DEFAULT NULL");
$migration->addField($newTable, 'extra_infos', "varchar(255) DEFAULT NULL");
$migration->addField($newTable, 'is_minemap', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->addKey($newTable, "plugin_monitoring_displayviews_id");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_displayviews_rules
*/
$newTable = "glpi_plugin_monitoring_displayviews_rules";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'plugin_monitoring_displayviews_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'name', "varchar(255) DEFAULT NULL");
$migration->addField($newTable, 'itemtype', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'type', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'condition', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->addKey($newTable, 'plugin_monitoring_displayviews_id');
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_entities
*/
$newTable = "glpi_plugin_monitoring_entities";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'entities_id', 'entities_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'tag', 'tag', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'entities_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'tag', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addKey($newTable, "entities_id");
$migration->addKey($newTable, "tag");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_hostaddresses
*/
$newTable = "glpi_plugin_monitoring_hostaddresses";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'items_id', 'items_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'itemtype', 'itemtype', "varchar(100) DEFAULT NULL");
$migration->changeField($newTable, 'networkports_id', 'networkports_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'ipaddresses_id', 'ipaddresses_id', "int(11) NOT NULL DEFAULT '0'");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'items_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'itemtype', "varchar(100) DEFAULT NULL");
$migration->addField($newTable, 'networkports_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'ipaddresses_id', "int(11) NOT NULL DEFAULT '0'");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_hostconfigs
*/
$a_hostsconfig = array();
if (TableExists('glpi_plugin_monitoring_hostconfigs') && FieldExists('glpi_plugin_monitoring_hostconfigs', 'plugin_monitoring_commands_id')) {
$a_hostsconfig = getAllDatasFromTable('glpi_plugin_monitoring_hostconfigs');
}
$a_table = array();
$a_table['name'] = 'glpi_plugin_monitoring_hostconfigs';
$a_table['oldname'] = array();
$a_table['fields'] = array('id' => array('type' => 'autoincrement', 'value' => ''), 'items_id' => array('type' => 'integer', 'value' => NULL), 'itemtype' => array('type' => 'varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL', 'value' => NULL), 'plugin_monitoring_components_id' => array('type' => 'integer', 'value' => NULL), 'plugin_monitoring_realms_id' => array('type' => 'integer', 'value' => NULL), 'computers_id' => array('type' => 'integer', 'value' => NULL), 'jetlag' => array('type' => 'varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL', 'value' => '0'));
$a_table['oldfields'] = array('plugin_monitoring_commands_id', 'plugin_monitoring_checks_id', 'calendars_id');
$a_table['renamefields'] = array();
$a_table['keys'] = array();
$a_table['oldkeys'] = array();
migrateTablesMonitoring($migration, $a_table);
if (count($a_hostsconfig) > 0) {
// Convert commands by components
foreach ($a_hostsconfig as $data) {
$a_components = getAllDatasFromTable('glpi_plugin_monitoring_components', "`plugin_monitoring_commands_id`='" . $data['plugin_monitoring_commands_id'] . "'");
if (count($a_components) > 0) {
$a_component = current($a_components);
$DB->query("UPDATE `" . $a_table['name'] . "`\n SET `plugin_monitoring_components_id`='" . $a_component['id'] . "'\n WHERE `id`='" . $data['id'] . "'");
}
}
}
/*
* Table glpi_plugin_monitoring_hosts
*/
$newTable = "glpi_plugin_monitoring_hosts";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
if (TableExists($newTable)) {
$a_hosts = getAllDatasFromTable($newTable, "`itemtype`='Computer'");
}
// Duplicate field with event
$migration->dropField($newTable, 'ouput');
$migration->migrationOneTable($newTable);
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'entities_id', 'entities_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'items_id', 'items_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'itemtype', 'itemtype', "varchar(100) DEFAULT NULL");
// Event should contain up to 4096 bytes (Nagios plugin specification)
$migration->changeField($newTable, 'event', 'event', "varchar(4096) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'state', 'state', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'state_type', 'state_type', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'last_check', 'last_check', "datetime DEFAULT NULL");
$migration->changeField($newTable, 'dependencies', 'dependencies', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'perf_data', 'perf_data', "text DEFAULT NULL COLLATE utf8_unicode_ci");
// Duplicate field with event
// $migration->changeField($newTable,
// 'output',
// 'output',
// "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'latency', 'latency', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'execution_time', 'execution_time', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'entities_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'is_acknowledged', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'is_acknowledgeconfirmed', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'acknowledge_comment', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->addField($newTable, 'acknowledge_users_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'items_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'itemtype', "varchar(100) DEFAULT NULL");
$migration->addField($newTable, 'event', "varchar(512) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'state', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'state_type', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'last_check', "datetime DEFAULT NULL");
$migration->addField($newTable, 'dependencies', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'perf_data', "text COLLATE utf8_unicode_ci DEFAULT NULL");
// Duplicate field with event
// $migration->addField($newTable,
// 'output',
// "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'latency', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'execution_time', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addKey($newTable, array('itemtype', 'items_id'), 'itemtype');
$migration->migrationOneTable($newTable);
if (count($a_hosts) > 0) {
// Convert commands by components
foreach ($a_hosts as $data) {
$a_computers = getAllDatasFromTable('glpi_computers', "`id`='" . $data['items_id'] . "'");
if (count($a_computers) > 0) {
$a_computer = current($a_computers);
$DB->query("UPDATE `" . $newTable . "`\n SET `entities_id`='" . $a_computer['entities_id'] . "'\n WHERE `id`='" . $data['id'] . "'");
}
}
}
/*
* Table glpi_plugin_monitoring_logs
*/
$newTable = "glpi_plugin_monitoring_logs";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` bigint(30) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "bigint(30) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'date_mod', 'date_mod', "datetime DEFAULT NULL");
$migration->changeField($newTable, 'user_name', 'user_name', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'itemtype', 'itemtype', "varchar(100) DEFAULT NULL");
$migration->changeField($newTable, 'items_id', 'items_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'action', 'action', "varchar(100) DEFAULT NULL");
$migration->changeField($newTable, 'value', 'value', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'date_mod', "datetime DEFAULT NULL");
$migration->addField($newTable, 'user_name', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'itemtype', "varchar(100) DEFAULT NULL");
$migration->addField($newTable, 'items_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'action', "varchar(100) DEFAULT NULL");
$migration->addField($newTable, 'value', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_networkports
*/
$newTable = "glpi_plugin_monitoring_networkports";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'items_id', 'items_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'itemtype', 'itemtype', "varchar(100) DEFAULT NULL");
$migration->changeField($newTable, 'networkports_id', 'networkports_id', "int(11) NOT NULL DEFAULT '0'");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'items_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'itemtype', "varchar(100) DEFAULT NULL");
$migration->addField($newTable, 'networkports_id', "int(11) NOT NULL DEFAULT '0'");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_realms
*/
$newTable = "glpi_plugin_monitoring_realms";
$insertrealm = 0;
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
$insertrealm = 1;
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'name', 'name', "varchar(255) DEFAULT NULL");
$migration->changeField($newTable, 'comment', 'comment', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->changeField($newTable, 'date_mod', 'date_mod', "datetime DEFAULT NULL");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'name', "varchar(255) DEFAULT NULL");
$migration->addField($newTable, 'comment', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->addField($newTable, 'date_mod', "datetime DEFAULT NULL");
$migration->migrationOneTable($newTable);
if ($insertrealm == '1') {
$query = "INSERT INTO `glpi_plugin_monitoring_realms`\n (`id` ,`name` ,`comment` ,`date_mod`) VALUES (NULL , 'All', NULL , NULL)";
$DB->query($query);
}
/*
* Table glpi_plugin_monitoring_serviceevents
*/
$newTable = "glpi_plugin_monitoring_serviceevents";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` bigint(30) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
// Duplicate field with event
$migration->dropField($newTable, 'ouput');
$migration->migrationOneTable($newTable);
$migration->changeField($newTable, 'id', 'id', "bigint(30) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'plugin_monitoring_services_id', 'plugin_monitoring_services_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'date', 'date', "datetime DEFAULT NULL");
// Event should contain up to 4096 bytes (Nagios plugin specification)
$migration->changeField($newTable, 'event', 'event', "varchar(4096) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'perf_data', 'perf_data', "text DEFAULT NULL COLLATE utf8_unicode_ci");
// Duplicate field with event
// $migration->changeField($newTable,
// 'output',
// 'output',
// "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'state', 'state', "varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'state_type', 'state_type', "varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'latency', 'latency', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'execution_time', 'execution_time', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'unavailability', 'unavailability', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'plugin_monitoring_services_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'date', "datetime DEFAULT NULL");
$migration->addField($newTable, 'event', "varchar(512) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'perf_data', "text DEFAULT NULL COLLATE utf8_unicode_ci");
// Duplicate field with event
// $migration->addField($newTable,
// 'output',
// "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'state', "varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'state_type', "varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'latency', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'execution_time', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'unavailability', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->addKey($newTable, "plugin_monitoring_services_id");
$migration->addKey($newTable, array('plugin_monitoring_services_id', 'date'), "plugin_monitoring_services_id_2");
$migration->addKey($newTable, array('unavailability', 'state_type', 'plugin_monitoring_services_id'), "unavailability");
$migration->addKey($newTable, array('plugin_monitoring_services_id', 'id'), "plugin_monitoring_services_id_3");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_commands
*/
$newTable = "glpi_plugin_monitoring_commands";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'is_active', 'is_active', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->changeField($newTable, 'name', 'name', "varchar(255) DEFAULT NULL");
$migration->changeField($newTable, 'command_name', 'command_name', "varchar(255) DEFAULT NULL");
$migration->changeField($newTable, 'command_line', 'command_line', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->changeField($newTable, 'poller_tag', 'poller_tag', "varchar(255) DEFAULT NULL");
$migration->changeField($newTable, 'module_type', 'module_type', "varchar(255) DEFAULT NULL");
$migration->changeField($newTable, 'arguments', 'arguments', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->dropField($newTable, 'regex');
$migration->dropField($newTable, 'legend');
$migration->dropField($newTable, 'unit');
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'is_active', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->addField($newTable, 'name', "varchar(255) DEFAULT NULL");
$migration->addField($newTable, 'command_name', "varchar(255) DEFAULT NULL");
$migration->addField($newTable, 'command_line', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->addField($newTable, 'poller_tag', "varchar(255) DEFAULT NULL");
$migration->addField($newTable, 'module_type', "varchar(255) DEFAULT NULL");
$migration->addField($newTable, 'arguments', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->addKey($newTable, "name");
$migration->addKey($newTable, "command_name");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_checks
*/
$newTable = "glpi_plugin_monitoring_checks";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'name', 'name', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'max_check_attempts', 'max_check_attempts', "int(2) NOT NULL DEFAULT '1'");
$migration->changeField($newTable, 'check_interval', 'check_interval', "int(5) NOT NULL DEFAULT '1'");
$migration->changeField($newTable, 'retry_interval', 'retry_interval', "int(5) NOT NULL DEFAULT '1'");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'name', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'max_check_attempts', "int(2) NOT NULL DEFAULT '1'");
$migration->addField($newTable, 'check_interval', "int(5) NOT NULL DEFAULT '1'");
$migration->addField($newTable, 'retry_interval', "int(5) NOT NULL DEFAULT '1'");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_businessrules
*/
$a_table = array();
$a_table['name'] = 'glpi_plugin_monitoring_businessrules';
$a_table['oldname'] = array();
$a_table['fields'] = array('id' => array('type' => 'autoincrement', 'value' => ''), 'plugin_monitoring_businessrulegroups_id' => array('type' => 'integer', 'value' => 0), 'plugin_monitoring_services_id' => array('type' => 'integer', 'value' => 0), 'is_dynamic' => array('type' => 'bool', 'value' => 0), 'is_generic' => array('type' => 'bool', 'value' => 0));
$a_table['oldfields'] = array();
$a_table['renamefields'] = array();
$a_table['keys'] = array();
$a_table['oldkeys'] = array();
migrateTablesMonitoring($migration, $a_table);
/*
* glpi_plugin_monitoring_businessrules_components
*/
$a_table = array();
$a_table['name'] = 'glpi_plugin_monitoring_businessrules_components';
$a_table['oldname'] = array();
$a_table['fields'] = array('id' => array('type' => 'autoincrement', 'value' => ''), 'plugin_monitoring_businessrulegroups_id' => array('type' => 'integer', 'value' => 0), 'plugin_monitoring_componentscatalogs_components_id' => array('type' => 'integer', 'value' => 0));
$a_table['oldfields'] = array();
$a_table['renamefields'] = array();
$a_table['keys'] = array();
$a_table['oldkeys'] = array();
migrateTablesMonitoring($migration, $a_table);
/*
* Table glpi_plugin_monitoring_businessrulegroups
*/
$newTable = "glpi_plugin_monitoring_businessrulegroups";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'name', 'name', "varchar(255) DEFAULT NULL");
$migration->changeField($newTable, 'plugin_monitoring_servicescatalogs_id', 'plugin_monitoring_servicescatalogs_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'operator', 'operator', "varchar(255) DEFAULT NULL");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'name', "varchar(255) DEFAULT NULL");
$migration->addField($newTable, 'plugin_monitoring_servicescatalogs_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'operator', "varchar(255) DEFAULT NULL");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_eventhandlers
*/
$newTable = "glpi_plugin_monitoring_eventhandlers";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'is_active', 'is_active', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->changeField($newTable, 'name', 'name', "varchar(255) DEFAULT NULL");
$migration->changeField($newTable, 'command_name', 'command_name', "varchar(255) DEFAULT NULL");
$migration->changeField($newTable, 'command_line', 'command_line', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'is_active', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->addField($newTable, 'name', "varchar(255) DEFAULT NULL");
$migration->addField($newTable, 'command_name', "varchar(255) DEFAULT NULL");
$migration->addField($newTable, 'command_line', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->addKey($newTable, "name");
$migration->addKey($newTable, "command_name");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_notificationcommands
*/
$newTable = "glpi_plugin_monitoring_notificationcommands";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'is_active', 'is_active', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->changeField($newTable, 'name', 'name', "varchar(255) DEFAULT NULL");
$migration->changeField($newTable, 'command_name', 'command_name', "varchar(255) DEFAULT NULL");
$migration->changeField($newTable, 'command_line', 'command_line', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->changeField($newTable, 'reactionner_tag', 'reactionner_tag', "varchar(255) DEFAULT NULL");
$migration->changeField($newTable, 'module_type', 'module_type', "varchar(255) DEFAULT NULL");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'is_active', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->addField($newTable, 'name', "varchar(255) DEFAULT NULL");
$migration->addField($newTable, 'command_name', "varchar(255) DEFAULT NULL");
$migration->addField($newTable, 'command_line', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->addField($newTable, 'reactionner_tag', "varchar(255) DEFAULT NULL");
$migration->addField($newTable, 'module_type', "varchar(255) DEFAULT NULL");
$migration->addKey($newTable, "name");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_contactgroups
*/
$newTable = "glpi_plugin_monitoring_contactgroups";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'name', 'name', "varchar(255) DEFAULT NULL");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'name', "varchar(255) DEFAULT NULL");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_contacts_contactgroups
*/
$newTable = "glpi_plugin_monitoring_contacts_contactgroups";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'plugin_monitoring_contacts_id', 'plugin_monitoring_contacts_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'plugin_monitoring_contactgroups_id', 'plugin_monitoring_contactgroups_id', "int(11) NOT NULL DEFAULT '0'");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'plugin_monitoring_contacts_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'plugin_monitoring_contactgroups_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addKey($newTable, array('plugin_monitoring_contacts_id', 'plugin_monitoring_contactgroups_id'), "unicity", "UNIQUE");
$migration->addKey($newTable, "plugin_monitoring_contactgroups_id");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_contactgroups_contactgroups
*/
$newTable = "glpi_plugin_monitoring_contactgroups_contactgroups";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'plugin_monitoring_contactgroups_id_1', 'plugin_monitoring_contactgroups_id_1', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'plugin_monitoring_contactgroups_id_2', 'plugin_monitoring_contactgroups_id_2', "int(11) NOT NULL DEFAULT '0'");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'plugin_monitoring_contactgroups_id_1', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'plugin_monitoring_contactgroups_id_2', "int(11) NOT NULL DEFAULT '0'");
$migration->addKey($newTable, array('plugin_monitoring_contactgroups_id_1', 'plugin_monitoring_contactgroups_id_2'), "unicity", "UNIQUE");
$migration->addKey($newTable, "plugin_monitoring_contactgroups_id_2");
$migration->migrationOneTable($newTable);
/*
* glpi_plugin_monitoring_profiles
*/
$a_table = array();
$a_table['name'] = 'glpi_plugin_monitoring_profiles';
$a_table['oldname'] = array();
$a_table['fields'] = array('profiles_id' => array('type' => 'integer', 'value' => NULL), 'config' => array('type' => 'char', 'value' => NULL), 'config_views' => array('type' => 'char', 'value' => NULL), 'config_sliders' => array('type' => 'char', 'value' => NULL), 'config_services_catalogs' => array('type' => 'char', 'value' => NULL), 'config_components_catalogs' => array('type' => 'char', 'value' => NULL), 'config_weathermap' => array('type' => 'char', 'value' => NULL), 'dashboard' => array('type' => 'char', 'value' => NULL), 'dashboard_system_status' => array('type' => 'char', 'value' => NULL), 'dashboard_hosts_status' => array('type' => 'char', 'value' => NULL), 'dashboard_all_ressources' => array('type' => 'char', 'value' => NULL), 'dashboard_views' => array('type' => 'char', 'value' => NULL), 'dashboard_sliders' => array('type' => 'char', 'value' => NULL), 'dashboard_services_catalogs' => array('type' => 'char', 'value' => NULL), 'dashboard_components_catalogs' => array('type' => 'char', 'value' => NULL), 'dashboard_perfdatas' => array('type' => 'char', 'value' => NULL), 'homepage' => array('type' => 'char', 'value' => NULL), 'homepage_views' => array('type' => 'char', 'value' => NULL), 'homepage_services_catalogs' => array('type' => 'char', 'value' => NULL), 'homepage_components_catalogs' => array('type' => 'char', 'value' => NULL), 'homepage_system_status' => array('type' => 'char', 'value' => NULL), 'homepage_hosts_status' => array('type' => 'char', 'value' => NULL), 'homepage_perfdatas' => array('type' => 'char', 'value' => NULL), 'homepage_all_ressources' => array('type' => 'char', 'value' => NULL), 'acknowledge' => array('type' => 'char', 'value' => NULL), 'downtime' => array('type' => 'char', 'value' => NULL), 'counters' => array('type' => 'char', 'value' => NULL), 'restartshinken' => array('type' => 'char', 'value' => NULL), 'host_command' => array('type' => 'char', 'value' => NULL));
$a_table['oldfields'] = array('servicescatalog', 'view', 'componentscatalog', 'viewshomepage', 'weathermap', 'component', 'command', 'check', 'allressources');
$a_table['renamefields'] = array();
$a_table['keys'] = array();
$a_table['oldkeys'] = array();
migrateTablesMonitoring($migration, $a_table);
/*
* Table glpi_plugin_monitoring_servicedefs
*/
$newTable = "glpi_plugin_monitoring_servicedefs";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'name', 'name', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'plugin_monitoring_commands_id', 'plugin_monitoring_commands_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'arguments', 'arguments', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->changeField($newTable, 'plugin_monitoring_checks_id', 'plugin_monitoring_checks_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'active_checks_enabled', 'active_checks_enabled', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->changeField($newTable, 'passive_checks_enabled', 'passive_checks_enabled', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->changeField($newTable, 'calendars_id', 'calendars_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'remotesystem', 'remotesystem', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'is_arguments', 'is_arguments', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'alias_command', 'alias_command', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->changeField($newTable, 'aliasperfdata_commands_id', 'aliasperfdata_commands_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'link', 'link', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'name', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'plugin_monitoring_commands_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'arguments', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->addField($newTable, 'plugin_monitoring_checks_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'active_checks_enabled', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->addField($newTable, 'passive_checks_enabled', "tinyint(1) NOT NULL DEFAULT '1'");
$migration->addField($newTable, 'calendars_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'remotesystem', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'is_arguments', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'alias_command', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->addField($newTable, 'aliasperfdata_commands_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'link', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_sliders
*/
$a_table = array();
$a_table['name'] = 'glpi_plugin_monitoring_sliders';
$a_table['oldname'] = array();
$a_table['fields'] = array('id' => array('type' => 'autoincrement', 'value' => ''), 'name' => array('type' => 'string', 'value' => NULL), 'entities_id' => array('type' => 'integer', 'value' => NULL), 'is_recursive' => array('type' => 'bool', 'value' => NULL), 'is_active' => array('type' => 'bool', 'value' => NULL), 'users_id' => array('type' => 'integer', 'value' => NULL), 'in_central' => array('type' => 'bool', 'value' => NULL), 'is_frontview' => array('type' => 'bool', 'value' => NULL), 'comment' => array('type' => 'text', 'value' => NULL), 'duration' => array('type' => 'integer', 'value' => '2'));
$a_table['oldfields'] = array();
$a_table['renamefields'] = array();
$a_table['keys'] = array();
$a_table['oldkeys'] = array();
migrateTablesMonitoring($migration, $a_table);
/*
* Table glpi_plugin_monitoring_sliders_groups
*/
$a_table = array();
$a_table['name'] = 'glpi_plugin_monitoring_sliders_groups';
$a_table['oldname'] = array();
$a_table['fields'] = array('id' => array('type' => 'autoincrement', 'value' => ''), 'pluginmonitoringsliders_id' => array('type' => 'integer', 'value' => NULL), 'groups_id' => array('type' => 'integer', 'value' => NULL), 'entities_id' => array('type' => 'integer', 'value' => '-1'), 'is_recursive' => array('type' => 'bool', 'value' => NULL));
$a_table['oldfields'] = array();
$a_table['renamefields'] = array();
$a_table['keys'] = array(array('field' => 'pluginmonitoringsliders_id', 'name' => '', 'type' => 'INDEX'), array('field' => 'groups_id', 'name' => '', 'type' => 'INDEX'), array('field' => 'entities_id', 'name' => '', 'type' => 'INDEX'), array('field' => 'is_recursive', 'name' => '', 'type' => 'INDEX'));
$a_table['oldkeys'] = array();
migrateTablesMonitoring($migration, $a_table);
/*
* Table glpi_plugin_monitoring_sliders_users
*/
$a_table = array();
$a_table['name'] = 'glpi_plugin_monitoring_sliders_users';
$a_table['oldname'] = array();
$a_table['fields'] = array('id' => array('type' => 'autoincrement', 'value' => ''), 'pluginmonitoringsliders_id' => array('type' => 'integer', 'value' => NULL), 'users_id' => array('type' => 'integer', 'value' => NULL));
$a_table['oldfields'] = array();
$a_table['renamefields'] = array();
$a_table['keys'] = array(array('field' => 'pluginmonitoringsliders_id', 'name' => '', 'type' => 'INDEX'), array('field' => 'users_id', 'name' => '', 'type' => 'INDEX'));
$a_table['oldkeys'] = array();
migrateTablesMonitoring($migration, $a_table);
/*
* Table glpi_plugin_monitoring_sliders_items
*/
$a_table = array();
$a_table['name'] = 'glpi_plugin_monitoring_sliders_items';
$a_table['oldname'] = array();
$a_table['fields'] = array('id' => array('type' => 'autoincrement', 'value' => ''), 'plugin_monitoring_sliders_id' => array('type' => 'integer', 'value' => NULL), 'items_id' => array('type' => 'integer', 'value' => NULL), 'itemtype' => array('type' => 'varchar(100) DEFAULT NULL', 'value' => NULL), 'extra_infos' => array('type' => 'string', 'value' => NULL), 'is_minemap' => array('type' => 'bool', 'value' => NULL));
$a_table['oldfields'] = array();
$a_table['renamefields'] = array();
$a_table['keys'] = array(array('field' => 'plugin_monitoring_sliders_id', 'name' => '', 'type' => 'INDEX'));
$a_table['oldkeys'] = array();
migrateTablesMonitoring($migration, $a_table);
/*
* Table glpi_plugin_monitoring_unavaibilities
*/
$newTable = "glpi_plugin_monitoring_unavailabilities";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
$migration->addField($newTable, 'plugin_monitoring_services_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'begin_date', "datetime DEFAULT NULL");
$migration->addField($newTable, 'end_date', "datetime DEFAULT NULL");
$migration->addField($newTable, 'duration', "int(15) NOT NULL DEFAULT '0'");
// Scheduled unavailability
$migration->addField($newTable, 'scheduled', "tinyint(1) NOT NULL DEFAULT '0'");
// Unavailability details
$migration->addField($newTable, 'details', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->addKey($newTable, "plugin_monitoring_services_id");
$migration->migrationOneTable($newTable);
}
/*
$migration->changeField($newTable,
'id',
'id',
"int(11) NOT NULL AUTO_INCREMENT");
if (!FieldExists($newTable, "plugin_monitoring_services_id")) {
$migration->changeField($newTable,
'items_id',
'plugin_monitoring_services_id',
"int(11) NOT NULL DEFAULT '0'");
}
$migration->migrationOneTable($newTable);
$migration->changeField($newTable,
'plugin_monitoring_services_id',
'plugin_monitoring_services_id',
"int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable,
'begin_date',
'begin_date',
"datetime DEFAULT NULL");
$migration->changeField($newTable,
'end_date',
'end_date',
"datetime DEFAULT NULL");
$migration->dropField($newTable,
'itemtype');
$migration->migrationOneTable($newTable);
*/
/*
* glpi_plugin_monitoring_unavailabilitystates
*/
$a_table = array();
$a_table['name'] = 'glpi_plugin_monitoring_unavailabilitystates';
$a_table['oldname'] = array();
$a_table['fields'] = array('id' => array('type' => 'autoincrement', 'value' => ''), 'plugin_monitoring_services_id' => array('type' => 'integer', 'value' => 0), 'plugin_monitoring_serviceevents_id' => array('type' => 'integer', 'value' => 0));
$a_table['oldfields'] = array();
$a_table['renamefields'] = array();
$a_table['keys'] = array();
$a_table['oldkeys'] = array();
migrateTablesMonitoring($migration, $a_table);
/*
* Table glpi_plugin_monitoring_weathermaps
*/
$newTable = "glpi_plugin_monitoring_weathermaps";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'name', 'name', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'width', 'width', "smallint(6) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'height', 'height', "smallint(6) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'background', 'background', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'name', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'width', "smallint(6) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'height', "smallint(6) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'background', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_weathermapnodes
*/
$newTable = "glpi_plugin_monitoring_weathermapnodes";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'name', 'name', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'plugin_monitoring_weathermaps_id', 'plugin_monitoring_weathermaps_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'items_id', 'items_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'itemtype', 'itemtype', "varchar(100) DEFAULT NULL");
$migration->changeField($newTable, 'x', 'x', "smallint(6) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'y', 'y', "smallint(6) NOT NULL DEFAULT '0'");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'name', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'plugin_monitoring_weathermaps_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'items_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'itemtype', "varchar(100) DEFAULT NULL");
$migration->addField($newTable, 'x', "smallint(6) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'y', "smallint(6) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'position', "varchar(255) COLLATE utf8_unicode_ci DEFAULT 'middle'");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_weathermaplinks
*/
$newTable = "glpi_plugin_monitoring_weathermaplinks";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->changeField($newTable, 'id', 'id', "int(11) NOT NULL AUTO_INCREMENT");
$migration->changeField($newTable, 'plugin_monitoring_weathermapnodes_id_1', 'plugin_monitoring_weathermapnodes_id_1', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'plugin_monitoring_weathermapnodes_id_2', 'plugin_monitoring_weathermapnodes_id_2', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'plugin_monitoring_services_id', 'plugin_monitoring_services_id', "int(11) NOT NULL DEFAULT '0'");
$migration->changeField($newTable, 'bandwidth_in', 'bandwidth_in', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->changeField($newTable, 'bandwidth_out', 'bandwidth_out', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->migrationOneTable($newTable);
$migration->addField($newTable, 'plugin_monitoring_weathermapnodes_id_1', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'plugin_monitoring_weathermapnodes_id_2', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'plugin_monitoring_services_id', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'bandwidth_in', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'bandwidth_out', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_shinkenwebservices
*/
$newTable = "glpi_plugin_monitoring_shinkenwebservices";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->addField($newTable, 'url', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'action', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'cnt', "tinyint(2) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'fields_string', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_tags
*/
$newTable = "glpi_plugin_monitoring_tags";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `" . $newTable . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";
$DB->query($query);
}
$migration->addField($newTable, 'tag', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'ip', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'iplock', "bool");
$migration->addField($newTable, 'username', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'password', "varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL");
$migration->addField($newTable, 'port', "varchar(255) COLLATE utf8_unicode_ci DEFAULT '7760'");
$migration->addField($newTable, 'comment', "text DEFAULT NULL COLLATE utf8_unicode_ci");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_downtimes
*/
$newTable = "glpi_plugin_monitoring_downtimes";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `{$newTable}` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `plugin_monitoring_hosts_id` int(11) NOT NULL DEFAULT '0',\n PRIMARY KEY (`id`),\n KEY `plugin_monitoring_hosts_id` (`plugin_monitoring_hosts_id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;";
$DB->query($query);
}
$migration->addField($newTable, 'start_time', "datetime NOT NULL DEFAULT '2014-01-01 00:00:00'");
$migration->addField($newTable, 'end_time', "datetime NOT NULL DEFAULT '2014-01-01 00:00:00'");
$migration->addField($newTable, 'flexible', "tinyint(1) DEFAULT '1'");
$migration->addField($newTable, 'duration', "int(1) DEFAULT '24'");
$migration->addField($newTable, 'duration_type', "varchar(64) DEFAULT 'days'");
$migration->addField($newTable, 'comment', "varchar(1024) DEFAULT NULL");
$migration->addField($newTable, 'users_id', "int(11) DEFAULT '-1'");
$migration->addField($newTable, 'tickets_id', "int(11) DEFAULT '0'");
$migration->addField($newTable, 'services', "tinyint(1) DEFAULT '0'");
$migration->addField($newTable, 'notified', "tinyint(1) DEFAULT '0'");
$migration->addField($newTable, 'expired', "tinyint(1) DEFAULT '0'");
$migration->migrationOneTable($newTable);
$migration->changeField($newTable, 'flexible', 'flexible', "tinyint(1) DEFAULT '0'");
$migration->changeField($newTable, 'notified', 'notified', "tinyint(1) DEFAULT '0'");
$migration->changeField($newTable, 'expired', 'expired', "tinyint(1) DEFAULT '0'");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_acknowledges
*/
$newTable = "glpi_plugin_monitoring_acknowledges";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `{$newTable}` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `itemtype` varchar(100) DEFAULT 'Host',\n `items_id` int(11) NOT NULL DEFAULT '0',\n PRIMARY KEY (`id`),\n KEY `itemtype` (`itemtype`,`items_id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;";
$DB->query($query);
}
$migration->addField($newTable, 'start_time', "datetime NOT NULL DEFAULT '2014-01-01 00:00:00'");
$migration->addField($newTable, 'end_time', "datetime NOT NULL DEFAULT '2014-01-01 00:00:00'");
$migration->addField($newTable, 'sticky', "tinyint(1) DEFAULT '1'");
$migration->addField($newTable, 'persistent', "tinyint(1) DEFAULT '1'");
$migration->addField($newTable, 'notify', "tinyint(1) DEFAULT '1'");
$migration->addField($newTable, 'comment', "varchar(1024) DEFAULT NULL");
$migration->addField($newTable, 'users_id', "int(11) DEFAULT '-1'");
$migration->addField($newTable, 'notified', "tinyint(1) DEFAULT '0'");
$migration->addField($newTable, 'expired', "tinyint(1) DEFAULT '0'");
$migration->migrationOneTable($newTable);
$migration->changeField($newTable, 'expired', 'expired', "tinyint(1) DEFAULT '0'");
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_hostcounters
*/
$newTable = "glpi_plugin_monitoring_hostcounters";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `{$newTable}` (\n `id` INT(11) NOT NULL AUTO_INCREMENT,\n `hostname` VARCHAR(255) DEFAULT NULL,\n PRIMARY KEY (`id`),\n KEY `hostname` (`hostname`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;";
$DB->query($query);
}
$migration->addField($newTable, 'date', "datetime DEFAULT NULL");
$migration->addField($newTable, 'counter', "varchar(255) DEFAULT NULL");
$migration->addField($newTable, 'value', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'updated', "tinyint(1) NOT NULL DEFAULT '0'");
$migration->addKey($newTable, array('hostname', 'date', 'updated'), 'updated');
$migration->migrationOneTable($newTable);
/*
* Table glpi_plugin_monitoring_hostdailycounters
*/
$newTable = "glpi_plugin_monitoring_hostdailycounters";
if (!TableExists($newTable)) {
$query = "CREATE TABLE `{$newTable}` (\n `id` INT(11) NOT NULL AUTO_INCREMENT,\n `hostname` VARCHAR(255) NOT NULL DEFAULT '',\n `day` DATE NOT NULL DEFAULT '2013-01-01',\n `dayname` varchar(16) NOT NULL DEFAULT '',\n PRIMARY KEY (`id`),\n KEY (`hostname`,`day`),\n KEY (`hostname`,`dayname`)\n ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;";
$DB->query($query);
}
/*
$migration->addField($newTable,
'plugin_monitoring_services_id',
"int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable,
'plugin_monitoring_services_id2',
"int(11) NOT NULL DEFAULT '0'");
*/
$migration->addField($newTable, 'counters', "varchar(4096) NOT NULL DEFAULT ''");
$migration->dropField($newTable, 'plugin_monitoring_services_id');
$migration->dropField($newTable, 'plugin_monitoring_services_id2');
$migration->addField($newTable, 'dayname', "varchar(16) NOT NULL DEFAULT ''");
$migration->addField($newTable, 'cPaperChanged', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'cPrinterChanged', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'cBinEmptied', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'cPagesInitial', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'cPagesTotal', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'cPagesToday', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'cPagesRemaining', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'cRetractedInitial', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'cRetractedTotal', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'cRetractedToday', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'cRetractedRemaining', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'cPaperLoad', "int(11) NOT NULL DEFAULT '0'");
$migration->dropField($newTable, 'cCardsInsertedOk');
$migration->dropField($newTable, 'cCardsInsertedKo');
$migration->dropField($newTable, 'cCardsRemoved');
$migration->addField($newTable, 'cCardsInsertedOkToday', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'cCardsInsertedOkTotal', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'cCardsInsertedKoToday', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'cCardsInsertedKoTotal', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'cCardsRemovedToday', "int(11) NOT NULL DEFAULT '0'");
$migration->addField($newTable, 'cCardsRemovedTotal', "int(11) NOT NULL DEFAULT '0'");
$migration->migrationOneTable($newTable);
/*
* Table Delete old table not used
*/
if (TableExists("glpi_plugin_monitoring_servicesuggests")) {
$DB->query("DROP TABLE `glpi_plugin_monitoring_servicesuggests`");
}
if (TableExists("glpi_plugin_monitoring_servicegraphs")) {
$DB->query("DROP TABLE `glpi_plugin_monitoring_servicegraphs`");
}
if (TableExists("glpi_plugin_monitoring_securities")) {
$DB->query("DROP TABLE `glpi_plugin_monitoring_securities`");
}
if (!is_dir(GLPI_PLUGIN_DOC_DIR . '/monitoring')) {
mkdir(GLPI_PLUGIN_DOC_DIR . "/monitoring");
}
if (!is_dir(GLPI_PLUGIN_DOC_DIR . '/monitoring/templates')) {
mkdir(GLPI_PLUGIN_DOC_DIR . "/monitoring/templates");
}
// Update calendars
$query = "SELECT * FROM `glpi_calendars`\n WHERE `name`='24x7'\n LIMIT 1";
$result = $DB->query($query);
if ($DB->numrows($result) == 0) {
$calendar = new Calendar();
$input = array();
$input['name'] = '24x7';
$input['is_recursive'] = 1;
$calendars_id = $calendar->add($input);
$calendarSegment = new CalendarSegment();
$input = array();
$input['calendars_id'] = $calendars_id;
$input['is_recursive'] = 1;
$input['begin'] = '00:00:00';
$input['end'] = '24:00:00';
$input['day'] = '0';
$calendarSegment->add($input);
$input['day'] = '1';
$calendarSegment->add($input);
$input['day'] = '2';
$calendarSegment->add($input);
$input['day'] = '3';
$calendarSegment->add($input);
$input['day'] = '4';
$calendarSegment->add($input);
$input['day'] = '5';
$calendarSegment->add($input);
$input['day'] = '6';
$calendarSegment->add($input);
}
// Update crontasks
$crontask = new CronTask();
if (!$crontask->getFromDBbyName('PluginMonitoringDowntime', 'DowntimesExpired')) {
CronTask::Register('PluginMonitoringDowntime', 'DowntimesExpired', '3600', array('mode' => 2, 'allowmode' => 3, 'logs_lifetime' => 30));
}
if (!$crontask->getFromDBbyName('PluginMonitoringLog', 'cleanlogs')) {
CronTask::Register('PluginMonitoringLog', 'cleanlogs', '96400', array('mode' => 2, 'allowmode' => 3, 'logs_lifetime' => 30));
}
if (!$crontask->getFromDBbyName('PluginMonitoringUnavailability', 'unavailability')) {
CronTask::Register('PluginMonitoringUnavailability', 'Unavailability', '300', array('mode' => 2, 'allowmode' => 3, 'logs_lifetime' => 30));
}
if (!$crontask->getFromDBbyName('PluginMonitoringDisplayview_rule', 'replayallviewrules')) {
CronTask::Register('PluginMonitoringDisplayview_rule', 'replayallviewrules', '1200', array('mode' => 2, 'allowmode' => 3, 'logs_lifetime' => 30));
}
if ($crontask->getFromDBbyName('PluginMonitoringUnavaibility', 'unavaibility')) {
$crontask->getFromDBbyName('PluginMonitoringUnavaibility', 'unavaibility');
$crontask->delete($crontask->fields);
}
if ($crontask->getFromDBbyName('PluginMonitoringServiceevent', 'updaterrd')) {
$crontask->getFromDBbyName('PluginMonitoringServiceevent', 'updaterrd');
$crontask->delete($crontask->fields);
}
if ($crontask->getFromDBbyName('PluginMonitoringHostdailycounter', 'DailyCounters')) {
$crontask->getFromDBbyName('PluginMonitoringHostdailycounter', 'DailyCounters');
$crontask->delete($crontask->fields);
}
include GLPI_ROOT . "/plugins/monitoring/inc/command.class.php";
$pmCommand = new PluginMonitoringCommand();
$a_list = $pmCommand->find();
$check_dummy_found = false;
$restart_shinken_found = false;
$host_action_found = false;
foreach ($a_list as $data) {
if ($data['command_name'] == "check_dummy") {
$check_dummy_found = true;
}
if ($data['command_name'] == "restart_shinken") {
$restart_shinken_found = true;
}
if ($data['command_name'] == "host_action") {
$host_action_found = true;
}
}
if (!$host_action_found) {
// Host action command
$pmCommand = new PluginMonitoringCommand();
$input = array();
$input['name'] = "Host action";
$input['command_name'] = "host_action";
$input['command_line'] = $DB->escape("host_action");
$pmCommand->add($input);
}
if (!$restart_shinken_found) {
// Restart shinken command
$pmCommand = new PluginMonitoringCommand();
$input = array();
$input['name'] = "Restart Shinken";
$input['command_name'] = "restart_shinken";
$input['command_line'] = $DB->escape("nohup sh -c '/usr/local/shinken/bin/stop_arbiter.sh && sleep 3 && /usr/local/shinken/bin/launch_arbiter.sh' > /dev/null 2>&1 &");
$pmCommand->add($input);
}
if (!$check_dummy_found) {
// Check dummy command
$pmCommand = new PluginMonitoringCommand();
$input = array();
$input['name'] = "Dummy check";
$input['command_name'] = "check_dummy";
$input['command_line'] = $DB->escape("\$PLUGINSDIR\$/check_dummy \$ARG1\$ \"\$ARG2\$\"");
$arg = array();
$arg['ARG1'] = 'INTEGER: dummy status code';
$arg['ARG2'] = 'TEXT: dummy status output text';
$input['arguments'] = exportArrayToDB($arg);
$pmCommand->add($input);
}
/*
* Clean services not having hosts
*/
$query = "SELECT `glpi_plugin_monitoring_services`.* FROM `glpi_plugin_monitoring_services`\n LEFT JOIN `glpi_plugin_monitoring_componentscatalogs_hosts`\n ON `glpi_plugin_monitoring_componentscatalogs_hosts`.`id` = `plugin_monitoring_componentscatalogs_hosts_id`\n WHERE `is_static` IS NULL";
$result = $DB->query($query);
while ($data = $DB->fetch_array($result)) {
$queryd = "DELETE FROM `glpi_plugin_monitoring_services`\n WHERE `id`='" . $data['id'] . "'";
$DB->query($queryd);
}
/*
* Clean components catalog not having hosts
*/
$query = "SELECT `glpi_plugin_monitoring_componentscatalogs_hosts`.`id`\n FROM `glpi_plugin_monitoring_componentscatalogs_hosts`\n LEFT JOIN `glpi_computers`\n ON (`glpi_plugin_monitoring_componentscatalogs_hosts`.`items_id` = `glpi_computers`.`id`)\n WHERE (`glpi_computers`.`name` IS NULL);";
$result = $DB->query($query);
while ($data = $DB->fetch_array($result)) {
$queryd = "DELETE FROM `glpi_plugin_monitoring_componentscatalogs_hosts`\n WHERE `id`='" . $data['id'] . "'";
$DB->query($queryd);
}
/*
* Clean services not having valide component
*/
$query = "SELECT `glpi_plugin_monitoring_services`.`id`\n FROM `glpi_plugin_monitoring_services`\n LEFT JOIN `glpi_plugin_monitoring_components`\n ON (`plugin_monitoring_components_id` = `glpi_plugin_monitoring_components`.`id`)\n WHERE (`glpi_plugin_monitoring_components`.`id` IS NULL);";
$result = $DB->query($query);
include GLPI_ROOT . "/plugins/monitoring/inc/service.class.php";
$pmService = new PluginMonitoringService();
while ($data = $DB->fetch_array($result)) {
$pmService->delete($data);
}
// Update hosts config
include GLPI_ROOT . "/plugins/monitoring/inc/hostconfig.class.php";
$pmHostconfig = new PluginMonitoringHostconfig();
$pmHostconfig->initConfig();
// Verify hosts
include GLPI_ROOT . "/plugins/monitoring/inc/host.class.php";
$pmHost = new PluginMonitoringHost();
$pmHost->verifyHosts();
if ($insertrealm == '1') {
// Insert into hostconfigs
$query = "UPDATE `glpi_plugin_monitoring_hostconfigs`\n SET `plugin_monitoring_realms_id` = '1'\n WHERE `items_id` = '0'\n AND `itemtype` = 'Entity'";
$DB->query($query);
}
include GLPI_ROOT . "/plugins/monitoring/inc/config.class.php";
$pmConfig = new PluginMonitoringConfig();
$pmConfig->initConfig();
// Add user monitoring if not defined
if (!countElementsInTable('glpi_users', "`name`='monitoring'")) {
// Create
$input = array('name' => 'monitoring');
$user = new User();
$user->add($input);
}
// Update items of views to be compatible with step of 10px instead 1 px
$query = "SELECT *\n FROM `glpi_plugin_monitoring_displayviews_items`";
$result = $DB->query($query);
while ($data = $DB->fetch_array($result)) {
$x = 10 * round($data['x'] / 10);
$y = 10 * round($data['y'] / 10);
$DB->query("UPDATE `glpi_plugin_monitoring_displayviews_items` " . "SET `x`='" . $x . "', `y`='" . $y . "' " . "WHERE `id`='" . $data['id'] . "'");
}
// Udpate componentcatalog_rules with new search engine (0.85)
$query = "SELECT *\n FROM `glpi_plugin_monitoring_componentscatalogs_rules`";
$result = $DB->query($query);
while ($data = $DB->fetch_array($result)) {
$data_array = importArrayFromDB($data['condition']);
if (!isset($data_array['searchtype'])) {
continue;
}
$criteria = array();
foreach ($data_array['field'] as $num => $value) {
$criteria[$num]['field'] = $value;
}
unset($data_array['field']);
foreach ($data_array['searchtype'] as $num => $value) {
$criteria[$num]['searchtype'] = $value;
}
unset($data_array['searchtype']);
foreach ($data_array['contains'] as $num => $value) {
$criteria[$num]['value'] = $value;
}
unset($data_array['contains']);
if (isset($data_array['link'])) {
foreach ($data_array['link'] as $num => $value) {
$criteria[$num]['link'] = $value;
}
unset($data_array['link']);
}
$data_array['criteria'] = $criteria;
unset($data_array['_glpi_csrf_token']);
$DB->query("UPDATE `glpi_plugin_monitoring_componentscatalogs_rules` " . "SET `condition`='" . exportArrayToDB($data_array) . "' " . "WHERE `id`='" . $data['id'] . "'");
}
// * Update unavailability (with table glpi_plugin_monitoring_unavailabilitystates)
// include (GLPI_ROOT . "/plugins/monitoring/inc/unavailabilitystate.class.php");
// $pmUnavailabilityState = new PluginMonitoringUnavailabilityState();
// $query = "SELECT * FROM `glpi_plugin_monitoring_services`";
// $result = $DB->query($query);
// while ($data=$DB->fetch_array($result)) {
// if ($pmUnavailabilityState->getLastID($data['id']) == 0) {
// $query2 = "SELECT id FROM `glpi_plugin_monitoring_serviceevents`
// WHERE `plugin_monitoring_services_id`='".$data['id']."'
// AND `unavailability`='1'
// ORDER BY id DESC
// LIMIT 1";
// $result2 = $DB->query($query2);
// while ($data2=$DB->fetch_array($result2)) {
// $pmUnavailabilityState->setLastID($data['id'], $data2['id']);
// }
// }
// }
$query = "UPDATE `glpi_plugin_monitoring_configs`\n SET `version`='" . PLUGIN_MONITORING_VERSION . "'\n WHERE `id`='1'";
$DB->query($query);
}
