$name, CONFIGWIZARD_TYPE => CONFIGWIZARD_TYPE_MONITORING, CONFIGWIZARD_DESCRIPTION => _("Clones existing hosts quickly and easily. Supports import from auto-discovery jobs and CSV input."), CONFIGWIZARD_DISPLAYTITLE => _("Bulk Host Cloning and Import"), CONFIGWIZARD_FUNCTION => "bulkhostimport_configwizard_func", CONFIGWIZARD_PREVIEWIMAGE => "bulkimport.png", CONFIGWIZARD_VERSION => "2.0.4", CONFIGWIZARD_DATE => "06/16/2017", CONFIGWIZARD_FILTER_GROUPS => array('nagios'), CONFIGWIZARD_REQUIRES_VERSION => 500 ); register_configwizard($name, $args); } /** * @return bool */ function bulkhostimport_configwizard_checkversion() { if (!function_exists('get_product_release')) { return false; } $ver = get_product_release(); if ($ver < 206) { return false; } return true; } /** * @param string $mode * @param null $inargs * @param $outargs * @param $result * * @return string */ function bulkhostimport_configwizard_func($mode = "", $inargs = null, &$outargs, &$result) { $wizard_name = "bulkhostimport"; $result = 0; $output = ""; // Initialize output args - pass back the same data we got $outargs[CONFIGWIZARD_PASSBACK_DATA] = $inargs; switch ($mode) { case CONFIGWIZARD_MODE_GETSTAGE1HTML: $host = grab_array_var($inargs, "host", ""); if (bulkhostimport_configwizard_checkversion() == false) { $output = '

' . _('Error') . ': ' . _('This wizard requires Nagios XI 2011R1.6 or later') . '.

'; } else { $output = '

' . _('This wizard allows you to clone existing hosts quicky and easily. It supports import of new hosts in bulk.') . '
' . _('New host information is specified in CSV format and each newly imported host is given the same services as an existing host that is being monitored. This is useful if you setup one host as a template and want to setup several other hosts using the same template') . '.

' . _('Template Host Information') . '
' . _('Select an existing host that should be cloned and used as the template for new hosts') . '.
'; } break; case CONFIGWIZARD_MODE_VALIDATESTAGE1DATA: // Get variables that were passed to us $host = grab_array_var($inargs, "host", ""); // Check for errors $errors = 0; $errmsg = array(); if (bulkhostimport_configwizard_checkversion() == false) { $errmsg[$errors++] = _("Error: This wizard requires Nagios XI 2011R1.6 or later"); } if (have_value($host) == false) { $errmsg[$errors++] = _("No template host specified."); } else if (host_exists($host) == false) { $errmsg[$errors++] = _("Template host could not be found."); } if ($errors > 0) { $outargs[CONFIGWIZARD_ERROR_MESSAGES] = $errmsg; $result = 1; } break; case CONFIGWIZARD_MODE_GETSTAGE2HTML: // Get variables that were passed to us $host = grab_array_var($inargs, "host"); $csvdata = grab_array_var($inargs, "csvdata"); $field1 = grab_array_var($inargs, "field1", "address"); $field2 = grab_array_var($inargs, "field2"); $field3 = grab_array_var($inargs, "field3"); $field4 = grab_array_var($inargs, "field4"); $field5 = grab_array_var($inargs, "field5"); $field6 = grab_array_var($inargs, "field6"); $field7 = grab_array_var($inargs, "field7"); $field8 = grab_array_var($inargs, "field8"); $field9 = grab_array_var($inargs, "field9"); $field10 = grab_array_var($inargs, "field10"); $overwrite = grab_array_var($inargs, "overwrite", 1); //Are these needed, or just duplicates... lets find out... // $field4 = grab_array_var($inargs, "field5"); // $field5 = grab_array_var($inargs, "field5"); $services = ""; $services_serial = grab_array_var($inargs, "services_serial", ""); if ($services_serial != "") { $services = unserialize(base64_decode($services_serial)); } if (!is_array($services)) { $services_default = array(); $services = grab_array_var($inargs, "services", $services_default); } $serviceargs = ""; $serviceargs_serial = grab_array_var($inargs, "serviceargs_serial", ""); if ($serviceargs_serial != "") { $serviceargs = unserialize(base64_decode($serviceargs_serial)); } if (!is_array($serviceargs)) { $serviceargs_default = array(); $serviceargs = grab_array_var($inargs, "serviceargs", $serviceargs_default); } $output = '
' . _('Host Template') . '
'; // Show host icon $img = get_object_icon_image($host); $imghtml = get_object_icon_html($img, ""); $output .= $imghtml; $output .= ' ' . encode_form_val($host) . '
' . _('Select Service Templates') . '

' . _('Specify the services from the template host that should cloned') . '.

' . _('Check All') . '  /  ' . _('Uncheck All') . '
'; $args = array( "host_name" => $host, "is_active" => 1, 'orderby' => 'service_description:a' ); $tservices = get_xml_service_objects($args); foreach ($tservices->service as $ts) { $sname = strval($ts->service_description); if (service_exists($host, $sname)) { // Checks if the service can be cloned or not... if it can be then display a checkbox or display disabled checkbox if it can't be if (service_is_cloneable($host, $sname)) { $output .= '
('._('Details').')
'; } else { $output .= ' ' . encode_form_val($sname) . ' (' . _("Inherited - Can not be cloned using the wizard") . ') '; } } } $output .= '
' . _('Import / Cloning Data') . '

' . _('Enter addresses of new hosts that should be created by cloning the template host and services specified above') . '.

' . _('Field') . ' 1' . _('Field') . ' 2' . _('Field') . ' 3' . _('Field') . ' 4' . _('Field') . ' 5' . _('Field') . ' 6' . _('Field') . ' 7' . _('Field') . ' 8' . _('Field') . ' 9' . _('Field') . ' 10
' . _('Specify the type of data that is present in the fields of the data below') . '.
' . _('The addresses of new hosts that should be created by cloning the template host and services specified above. Multiple fields should be separated by a comma. One entry per line.') . '
'; break; case CONFIGWIZARD_MODE_VALIDATESTAGE2DATA: // Get variables that were passed to us $host = grab_array_var($inargs, "host"); $csvdata = grab_array_var($inargs, "csvdata"); $overwrite = grab_array_var($inargs, "overwrite", 0); // Grab all 10 fields for ($i = 1; $i < 11; $i++) { $fields[$i] = grab_array_var($inargs, "field" . $i); } $host_template = nagiosql_read_host_config_from_file($host); $services = ""; $services_serial = grab_array_var($inargs, "services_serial", ""); if ($services_serial != "") { $services = unserialize(base64_decode($services_serial)); } if (!is_array($services)) { $services = grab_array_var($inargs, "services", array()); } // check for errors $errors = 0; $errmsg = array(); // Not sure why we were requiring services to be selected, so I removed them 6/21/2013 -SW //if(count($services)==0) // $errmsg[$errors++]=_("No template services selected."); // Check for required field values $has_address = false; $has_non_unique = false; foreach ($fields as $field) { // Check for address if ($field == "address") { $has_address = true; } // Check for non-unique within the fields $c = 0; foreach ($fields as $f2_check) { if ($field == $f2_check && $field != "ignore") { $c++; } if ($c > 1) { $has_non_unique = true; } } } // If no address, then complain if (!$has_address) { $errmsg[$errors++] = _("Address must be present in CSV fields."); } // If there are any non-unique values let's error if ($has_non_unique) { $errmsg[$errors++] = _("Import / cloning data fields must be unique."); } // check CSV data $csva1 = explode("\n", $csvdata); $csva2 = array_unique($csva1); $csva3 = array_filter($csva2); $csvarray = $csva3; if (count($csvarray) == 0) { $errmsg[$errors++] = _("No import / cloning data provided."); } if ($errors > 0) { $outargs[CONFIGWIZARD_ERROR_MESSAGES] = $errmsg; $result = 1; } break; case CONFIGWIZARD_MODE_GETSTAGE3OPTS: $output .= '
' . _('Monitoring options will be inherited from the template host and services you selected. Click Next to continue.') . '
'; $result = CONFIGWIZARD_HIDE_OPTIONS; break; case CONFIGWIZARD_MODE_GETSTAGE3HTML: // Get variables that were passed to us $host = grab_array_var($inargs, "host"); $csvdata = grab_array_var($inargs, "csvdata"); $overwrite = grab_array_var($inargs, "overwrite", 0); // Grab all 10 fields for ($i = 1; $i < 11; $i++) { $fields[$i] = grab_array_var($inargs, "field" . $i); } $services = ""; $services_serial = grab_array_var($inargs, "services_serial"); if ($services_serial != "") { $services = unserialize(base64_decode($services_serial)); } else { $services = grab_array_var($inargs, "services"); } $serviceargs = ""; $serviceargs_serial = grab_array_var($inargs, "serviceargs_serial"); if ($serviceargs_serial != "") { $serviceargs = unserialize(base64_decode($serviceargs_serial)); } else { $serviceargs = grab_array_var($inargs, "serviceargs"); } $output = ' '; break; case CONFIGWIZARD_MODE_VALIDATESTAGE3DATA: break; case CONFIGWIZARD_MODE_GETSTAGE4OPTS: $output .= '
' . _('Notification options will be inherited from the template host and services you selected. Click Next to continue.') . '
'; $result = CONFIGWIZARD_HIDE_OPTIONS; $outargs[CONFIGWIZARD_HIDDEN_OPTIONS] = array( CONFIGWIZARD_HIDE_NOTIFICATION_OPTIONS, CONFIGWIZARD_HIDE_NOTIFICATION_INTERVAL, CONFIGWIZARD_HIDE_NOTIFICATION_TARGETS, ); break; case CONFIGWIZARD_MODE_GETSTAGE5OPTS: $output .= '
' . _('Group membership will be inherited from the template host and services you selected unless you put hostgroup and/or parent host relationship data in. Click Next to continue.') . '
'; $result = CONFIGWIZARD_HIDE_OPTIONS; $outargs[CONFIGWIZARD_HIDDEN_OPTIONS] = array( CONFIGWIZARD_HIDE_HOSTGROUPS, CONFIGWIZARD_HIDE_SERVICEGROUPS, CONFIGWIZARD_HIDE_PARENT_HOSTS, ); break; case CONFIGWIZARD_MODE_GETFINALSTAGEHTML: break; case CONFIGWIZARD_MODE_GETOBJECTS: $host = grab_array_var($inargs, "host", ""); $csvdata = grab_array_var($inargs, "csvdata"); $overwrite = grab_array_var($inargs, "overwrite", 0); // Grab all 10 fields for ($i = 1; $i < 11; $i++) { $fields[$i] = grab_array_var($inargs, "field" . $i); } $services_serial = grab_array_var($inargs, "services_serial", ""); $serviceargs_serial = grab_array_var($inargs, "serviceargs_serial", ""); $services = unserialize(base64_decode($services_serial)); $serviceargs = unserialize(base64_decode($serviceargs_serial)); // This will be the NEW objects array $objs = array(); // Fetch template service settings from config file $service_templates = array(); foreach ($services as $svc => $svcstate) { // Execute query to get the config name of the service $config_name = ''; $sql = "SELECT tbl_service.config_name FROM tbl_service LEFT JOIN tbl_lnkServiceToHost ON tbl_service.id = tbl_lnkServiceToHost.idMaster LEFT JOIN tbl_host ON tbl_lnkServiceToHost.idSlave = tbl_host.id WHERE tbl_host.host_name = '".escape_sql_param($host, DB_NAGIOSQL)."' AND tbl_service.service_description = '".escape_sql_param($svc, DB_NAGIOSQL)."';"; $rs = exec_sql_query(DB_NAGIOSQL, $sql); if ($rs->RecordCount() == 1) { $config_name = $rs->fields['config_name']; } $service_templates[$svc] = nagiosql_read_service_config_from_file($host, $svc, $config_name); } // Fetch template host settings from config file $host_template = nagiosql_read_host_config_from_file($host); // Get the CSV data into an array $csva1 = explode("\n", $csvdata); $csva2 = array_unique($csva1); $csva3 = array_filter($csva2); $csvarray = $csva3; // For each CSV row let's process it as a host (possibly a NEW host) foreach ($csvarray as $c) { $cf = explode(",", $c); // Grab all the values in the CSV array for this row $fv = array(); for ($i = 0; $i < 11; $i++) { $val = grab_array_var($cf, $i, ""); $fv[$i + 1] = str_replace('"', '', $val); // Scott's fix for " in CSV data -JO } // Default all these... $address = ""; $hostname = ""; $hostalias = ""; $hostgroup = ""; $parenthost = ""; $displayname = ""; $notestext = ""; $notesurl = ""; $actionurl = ""; $amazonid = ""; // Add values to the correct variables for ($i = 1; $i < 11; $i++) { switch ($fields[$i]) { case "address": $address = trim($fv[$i]); break; case "hostname": $hostname = trim($fv[$i]); break; case "hostalias": $hostalias = trim($fv[$i]); break; case "hostgroup": $hostgroup = trim($fv[$i]); break; case "parenthost": $parenthost = trim($fv[$i]); break; case "displayname": $displayname = trim($fv[$i]); break; case "notestext": $notestext = trim($fv[$i]); break; case "notesurl": $notesurl = trim($fv[$i]); break; case "actionurl": $actionurl = trim($fv[$i]); break; case "amazonid": $amazonid = trim($fv[$i]); break; } } // Check for a valid address or bail if ($address == "") { continue; } // If there's no hostname we can set it to the address if ($hostname == "") { $hostname = $address; } // Replace hostgroup and parent host if they don't exist if (!host_exists($parenthost)) { $parenthost = ""; } if (!hostgroup_exists($hostgroup)) { $hostgroup = ""; } // Bail if the hostname isn't valid if (is_valid_host_name($hostname) == false) { continue; } // Add the host if (!host_exists($hostname)) { foreach ($host_template as $cv => $cvv) { // For parents and hostgroups let's append to what they may have given it in the CSV // ONLY DO THIS IF THE OVERWRITE SELECTOR IS SET TO 0 (NOT OVERWRITING TEMPLATE'S) if (($cv == "hostgroups" || $cv == "parents") && $overwrite == 0) { if (!empty($cvv) || $cvv != "null") { $temp = explode(",", $cvv); $add = true; foreach ($temp as $t) { if ($t == $parenthost) { $add = false; } } if ($add && !empty($parenthost)) { $temp[] = $parenthost; } if (count($temp) > 1) { $temp = array_diff($temp, array("null")); // Remove the "null" value } $newhost[$cv] = implode(",", $temp); continue; } } $newhost[$cv] = $cvv; } // The list of added things that the CSV is adding to a new host (hostname, address, etc) $newhost["type"] = OBJECTTYPE_HOST; $newhost["use"] = grab_array_var($host_template, "use", "generic-host"); $newhost["host_name"] = $hostname; $newhost["address"] = $address; $newhost["alias"] = $hostalias; $newhost["display_name"] = $displayname; $newhost["notes"] = $notestext; $newhost["notes_url"] = $notesurl; $newhost["action_url"] = $actionurl; $newhost["_amazonid"] = $amazonid; if ($overwrite == 1) { if ($hostgroup != "") $newhost["hostgroups"] = $hostgroup; if ($parenthost != "") $newhost["parents"] = $parenthost; } // Loop through and set all HOST TEMPLATE variables to the NEW HOST $objs[] = $newhost; } // Add services to the host foreach ($services as $svc => $svcstate) { $newsvc = array(); foreach ($service_templates[$svc] as $cv => $cvv) { $newsvc[$cv] = $cvv; } // Check host_name + option $plus = ""; $hn = grab_array_var($service_templates[$svc], "host_name", ""); if (strpos(trim($hn), "+") === 0) { $plus = "+"; } $newsvc["type"] = OBJECTTYPE_SERVICE; $newsvc["host_name"] = $plus.$hostname; $newsvc["service_description"] = $svc; $objs[] = $newsvc; } } // return the object definitions to the wizard $outargs[CONFIGWIZARD_SKIP_OBJECTS_RECONFIGURE] = true; $outargs[CONFIGWIZARD_NAGIOS_OBJECTS] = $objs; break; default: break; } return $output; } function bulkhostimport_configwizard_get_fval() { // Not sure what this does but not deleting it for reqs } /** * Checks the CCM database to make sure service is actually a part of the host. * * @param $host * @param $service * * @return bool */ function service_is_cloneable($host, $service) { global $db_tables; // Make sure this'll work for UTF8 exec_sql_query(DB_NAGIOSQL, "set names 'utf8'"); // Get all DIRECTLY LINKED services for the host $sql = "SELECT s.service_description FROM " . $db_tables[DB_NAGIOSQL]['service'] . " AS s INNER JOIN " . $db_tables[DB_NAGIOSQL]['lnkServiceToHost'] . " AS r ON r.idMaster = s.id INNER JOIN " . $db_tables[DB_NAGIOSQL]['host'] . " AS h ON h.id = r.idSlave WHERE h.host_name = '" . $host . "'"; $rs = exec_sql_query(DB_NAGIOSQL, $sql); while ($row = $rs->FetchRow()) { if ($row['service_description'] == $service) { return true; // This means we found a hard relationship and this service can be cloned } } return false; // This means the service is inherited somehow... can't be cloned via the wizard }