public function import()
{
$engine = $this->getEngine();
$job = $engine->getJob();
$job->addNotice("FruityHostImporter beginning to import Host Configuration.");
// Hosts
foreach ($this->dbConn->query("SELECT * FROM nagios_hosts", PDO::FETCH_ASSOC) as $hostData) {
$this->importHost($hostData);
}
// Host parents
// go through, check if the host actually exists in our system
// now, then add the parents, if it's found.
// First the host table,
foreach ($this->dbConn->query("SELECT * FROM nagios_hosts", PDO::FETCH_ASSOC) as $hostData) {
if (empty($hostData['parents'])) {
continue;
}
// Okay, there's actually an parent in here.
// Get the name.
$name = $this->getHostNameById($hostData['parents'], $this->dbConn);
if (!$name) {
$job->addNotice("Fruity Host Importer: Could not find host with id: " . $hostData['parents'] . " to add as parent.");
} else {
// Okay, $name is equal to the parent host name. Let's get the name
// of the host this parent belongs to
$childName = $this->getHostNameById($hostData['host_id'], $this->dbConn);
// Okay, fetch our host which should have this name.
$host = NagiosHostPeer::getByName($childName);
if (!$host) {
$job->addWarning("Fruity Host Importer: Could not find host in Lilac with name: " . $childName);
} else {
$host->addParentByName($name);
$host->save();
}
}
}
// then the nagios_host_parents table
foreach ($this->dbConn->query("SELECT * FROM nagios_host_parents", PDO::FETCH_ASSOC) as $hostData) {
// Get the name.
$name = $this->getHostNameById($hostData['parent_id'], $this->dbConn);
if (!$name) {
$job->addNotice("Fruity Host Importer: Could not find host with id: " . $hostData['parents'] . " to add as parent.");
} else {
// Okay, $name is equal to the parent host name. Let's get the name
// of the host this parent belongs to
$childName = $this->getHostNameById($hostData['child_id'], $this->dbConn);
// Okay, fetch our host which should have this name.
$host = NagiosHostPeer::getByName($childName);
if (!$host) {
$job->addWarning("Fruity Host Importer: Could not find host in Lilac with name: " . $childName);
} else {
$host->addParentByName($name);
$host->save();
}
}
}
// Host Check Command Parameters
foreach ($this->dbConn->query("SELECT * FROM nagios_hosts_check_command_parameters WHERE host_id IS NOT NULL", PDO::FETCH_ASSOC) as $commandParameterInfo) {
$hostName = $this->getHostNameById($commandParameterInfo['host_id']);
if (!$hostName) {
$job->addNotice("Fruity Host Check Command Parameter Importer: Could not find host with id " . $commandParameterInfo['host_id']);
continue;
}
// Get the host
$host = NagiosHostPeer::getByName($hostName);
if (!$host) {
$job->addNotice("Fruity Host Check Command Parameter Importer: Could not find host with name " . $hostTemplateName);
continue;
}
$newParameter = new NagiosHostCheckCommandParameter();
$newParameter->setHost($host->getId());
$newParameter->setParameter($commandParameterInfo['parameter']);
$newParameter->save();
}
// Host Contact Groups
foreach ($this->dbConn->query("SELECT * FROM nagios_host_contactgroups", PDO::FETCH_ASSOC) as $membershipInfo) {
$hostName = $this->getHostNameById($membershipInfo['host_id']);
if (!$hostName) {
$job->addNotice("Fruity Host Contact Group Importer: Could not find host with id " . $membershipInfo['host_id']);
continue;
}
// Get the template
$host = NagiosHostPeer::getByName($hostName);
if (!$host) {
$job->addNotice("Fruity Host Contact Group Importer: Could not find host with name " . $hostName);
continue;
}
// Now get Contact Group Name
$contactGroupName = $this->getContactGroupNameById($membershipInfo['contactgroup_id']);
if (!$contactGroupName) {
$job->addNotice("Fruity Host Contact Group Importer: Could not find contact group with id: " . $membershipInfo['contactgroup_id']);
continue;
}
$contactGroup = NagiosContactGroupPeer::getByName($contactGroupName);
if (!$contactGroup) {
$job->addNotice("Fruity Host Contact Group Importer: Could not find contact group with name: " . $contactGroupName);
continue;
}
$membership = new NagiosHostContactGroup();
$membership->setHost($host->getId());
$membership->setNagiosContactGroup($contactGroup);
$membership->save();
}
// Host Extended Information
foreach ($this->dbConn->query("SELECT * FROM nagios_hosts_extended_info", PDO::FETCH_ASSOC) as $extInfo) {
$hostName = $this->getHostNameById($extInfo['host_id']);
if (!$hostTemplateName) {
$job->addNotice("Fruity Host Extended Info Importer: Could not find host with id " . $extInfo['host_id']);
continue;
}
// Get the host
$host = NagiosHostPeer::getByName($hostName);
if (!$hostName) {
$job->addNotice("Fruity Host Extended Info Importer: Could not find host with name " . $hostTemplateName);
continue;
}
// Go through the extended info, and set it on the template.
$host->setNotes($extInfo['notes']);
$host->setNotesUrl($extInfo['notes_url']);
$host->setActionUrl($extInfo['action_url']);
$host->setIconImage($extInfo['icon_image']);
$host->setIconImageAlt($extInfo['icon_image_alt']);
$host->setVrmlImage($extInfo['vrml_image']);
$host->setStatusmapImage($extInfo['statusmap_image']);
$host->setTwoDCoords($extInfo['two_d_coords']);
$host->setThreeDCoords($extInfo['three_d_coords']);
$host->save();
}
// Host group memberships
foreach ($this->dbConn->query("SELECT * FROM nagios_hostgroup_membership", PDO::FETCH_ASSOC) as $membershipInfo) {
$hostName = $this->getHostNameById($membershipInfo['host_id']);
if (!$hostName) {
$job->addNotice("Fruity Host Host Group Importer: Could not find host with id " . $membershipInfo['host_id']);
continue;
}
// Get the template
$host = NagiosHostPeer::getByName($hostName);
if (!$host) {
$job->addNotice("Fruity Host Host Group Importer: Could not find host with name " . $hostName);
continue;
}
// Now get Host Group Name
$hostGroupName = $this->getHostGroupNameById($membershipInfo['hostgroup_id']);
if (!$hostGroupName) {
$job->addNotice("Fruity Host Host Group Importer: Could not find host group with id: " . $membershipInfo['hostgroup_id']);
continue;
}
$hostGroup = NagiosHostGroupPeer::getByName($hostGroupName);
if (!$contactGroup) {
$job->addNotice("Fruity Host Host Group Importer: Could not find host group with name: " . $hostGroupName);
continue;
}
$membership = new NagiosHostgroupMembership();
$membership->setHost($host->getId());
$membership->setNagiosHostGroup($hostGroup);
$membership->save();
}
$job->addNotice("FruityHostImported: Finished importing a total of " . $this->totalImported . " hosts.");
}
private function importService($serviceData)
{
$job = $this->getEngine()->getJob();
$newService = new NagiosService();
// Check to see if host or host template exists first
if (!empty($serviceData['host_id'])) {
$hostName = $this->getHostNameById($serviceData['host_id']);
if (!$hostName) {
$job->addNotice("Fruity Service Importer: Failed to find host with id: " . $serviceData['host_id']);
return true;
}
$host = NagiosHostPeer::getByName($hostName);
if (!$host) {
$job->addNotice("Fruity Service Importer: Failed to find host with name: " . $hostName);
return true;
}
$newService->setHost($host->getId());
} else {
if (!empty($serviceData['host_template_id'])) {
$hostTemplateName = $this->getHostTemplateNameById($serviceData['host_template_id']);
if (!$hostTemplateName) {
$job->addNotice("Fruity Service Importer: Failed to find host template with id: " . $serviceData['host_template_id']);
return true;
}
$hostTemplate = NagiosHostTemplatePeer::getByName($hostTemplateName);
if (!$hostTemplate) {
$job->addNotice("Fruity Service Importer: Failed to find host template with name: " . $hostTemplateName);
return true;
}
$newService->setHostTemplate($hostTemplate->getId());
} else {
if (!empty($serviceData['hostgroup_id'])) {
$hostgroupName = $this->getHostGroupNameById($serviceData['hostgroup_id']);
if (!$hostgroupName) {
$job->addNotice("Fruity Service Importer: Failed to find host group with id: " . $serviceData['host_template_id']);
return true;
}
$hostgroup = NagiosHostGroupPeer::getByName($hostgroupName);
if (!$hostgroup) {
$job->addNotice("Fruity Service Importer: Failed to find host group with name: " . $hostGroupName);
return true;
}
$newService->setHostgroup($hostgroup->getId());
}
}
}
// Check to see if we need the template
if (!empty($serviceData['use_template_id'])) {
$name = $this->getServiceTemplateNameById($serviceData['use_template_id'], $this->dbConn);
if (!$name) {
$job->addNotice("Fruity Service Importer: Could not find template with id: " . $serviceData['use_template_id'] . ". Aborting it's import.");
return false;
} else {
// Okay, we got the name, does this template exist?
$template = NagiosServiceTemplatePeer::getByName($name);
if (!$template) {
return false;
} else {
// Create a new inheritance relationship
$inheritance = new NagiosServiceTemplateInheritance();
$inheritance->setNagiosServiceTemplateRelatedByTargetTemplate($template);
$inheritance->setNagiosService($newService);
try {
$inheritance->save();
} catch (Exception $e) {
$job->addNotice("Fruity Service Template Importer: Cannot add inheritance from " . $template->getName() . " to " . $newService->getName());
}
}
}
}
// Okay, start 'er up!
foreach ($serviceData as $key => $val) {
unset($name);
if ($key == "service_template_id" || $key == "use_template_id" || $key == "template_name" || $key == "host_id" || $key == "hostgroup_id" || $key == "host_template_id" || $key == "service_id") {
continue;
}
if ($key == "service_description") {
$key = "description";
}
if ($key == "notification_options_warning") {
$key = "notification_on_warning";
}
if ($key == "notification_options_unknown") {
$key = "notification_on_unknown";
}
if ($key == "notification_options_critical") {
$key = "notification_on_critical";
}
if ($key == "notification_options_recovery") {
$key = "notification_on_recovery";
}
if ($key == "notification_options_flapping") {
$key = "notification_on_flapping";
}
if ($key == "stalking_options_warning") {
$key = "stalking_on_warning";
}
if ($key == "stalking_options_unknown") {
$key = "stalking_on_unknown";
}
if ($key == "stalking_options_critical") {
$key = "stalking_on_critical";
}
if ($key == "stalking_options_ok") {
$key = "stalking_on_ok";
}
if ($key == "max_check_attempts") {
$key = "maximum_check_attempts";
}
if ($key == "retry_check_interval") {
$key = "retry_interval";
}
if ($key == "check_command") {
$name = $this->getCommandNameById($val);
if ($name) {
$command = NagiosCommandPeer::getByName($name);
if ($command) {
$newService->setCheckCommand($command->getId());
}
}
continue;
}
if ($key == "check_period") {
$name = $this->getTimeperiodNameById($val);
if ($name) {
$timeperiod = NagiosTimeperiodPeer::getByName($name);
if ($timeperiod) {
$newService->setCheckPeriod($timeperiod->getId());
}
}
continue;
}
if ($key == "event_handler") {
$name = $this->getCommandNameById($val);
if ($name) {
$command = NagiosCommandPeer::getByName($name);
if ($command) {
$newService->setEventHandler($command->getId());
}
}
continue;
}
if ($key == "notification_period") {
$name = $this->getTimeperiodNameById($val);
if ($name) {
$timeperiod = NagiosTimeperiodPeer::getByName($name);
if ($timeperiod) {
$newService->setNotificationPeriod($timeperiod->getId());
}
}
continue;
}
try {
$name = NagiosServiceTemplatePeer::translateFieldName($key, BasePeer::TYPE_FIELDNAME, BasePeer::TYPE_PHPNAME);
} catch (Exception $e) {
$job->addNotice("Fruity Service Importer: Was unable to store unsupported value: " . $key);
}
if (!empty($name)) {
$method = "set" . $name;
$newService->{$method}($val);
}
}
$job->addNotice("Fruity Service Importer: Saved service: " . $newService->getDescription() . " on " . $newService->getOwnerDescription());
$newService->save();
$this->totalImported++;
return true;
}