Import du réseau sous nagios
Résolu
bijente
Messages postés
5
Statut
Membre
-
romuald -
romuald -
Bonjour,
je souhaite mettre a jour nagios, c'est pourquoi j'exporte la base de donnée de oreon afin de conserver mes 'host' pour ne pas avoir a recommencer mais lorsrque je l'importe sous centron
j'obtien une erreur sur la ligne 153 du fichier importé (à la fonction numRows() ) en PHP voici le fichier :
function microtime_float() {
list($usec, $sec) = explode(" ", microtime());
return ((float)$usec + (float)$sec);
}
set_time_limit(60);
$time_start = microtime_float();
$advanced_search = 0;
# Define
define('SMARTY_DIR', '../GPL_LIB/Smarty/libs/');
# Include
require_once ("./oreon.conf.php");
require_once ("./DBconnect.php");
require_once ("./DBOdsConnect.php");
require_once ("$classdir/Session.class.php");
require_once ("$classdir/Oreon.class.php");
require_once (SMARTY_DIR."Smarty.class.php");
ini_set("session.gc_maxlifetime", "31536000");
Session::start();
if (version_compare(phpversion(), '5.0') < 0) {
eval('
function clone($object) {
return $object;
}
');
}
if (isset($_POST["export_sub_list"])) {
$mime_type = 'text/x-text';
if (!strcmp($_GET['p'], "2"))
$mime_type .= 'image/jpeg';
$filename = "oreon_" . date("Y-m-d") . ".sql";
// Send headers
header('Content-Type: '.$mime_type);
// IE need specific headers
if (stristr($_SERVER['HTTP_USER_AGENT'], "MSIE")) {
header("Content-Disposition: inline; filename=\"".$filename."\"");
header('Expires: 0');
header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
header('Pragma: public');
} else {
header('Content-Disposition: attachment; filename="'.$filename.'"');
header('Expires: 0');
header('Pragma: no-cache');
}
if (isset($_POST["s"]) && ($_POST["s"] == 1 || $_POST["s"] == 2 || $_POST["s"] == 4)) {
include("./include/options/db/extractDB/extract_sub.php");exit();}
} else {
# Delete Session Expired
$DBRESULT =& $pearDB->query("SELECT session_expire FROM general_opt LIMIT 1");
if (PEAR::isError($DBRESULT)) print "DB Error : ".$DBRESULT->getDebugInfo()."<br>";
$DBRESULT->fetchInto($session_expire);
$time_limit = time() - ($session_expire["session_expire"] * 60);
$DBRESULT =& $pearDB->query("DELETE FROM session WHERE last_reload < '".$time_limit."'");
if (PEAR::isError($DBRESULT)) print "DB error Where deleting Sessions : ".$DBRESULT->getDebugInfo()."<br>";
# Get session and Check if session is not expired
$DBRESULT =& $pearDB->query("SELECT user_id FROM session WHERE `session_id` = '".session_id()."'");
if (PEAR::isError($DBRESULT)) print "DB Error : ".$DBRESULT->getDebugInfo()."<br>";
if (!$DBRESULT->numRows())
header("Location: index.php?disconnect=2");
if (!isset($_SESSION["oreon"]))
header("Location: index.php?disconnect=1");
# Define Oreon var alias
$oreon =& $_SESSION["oreon"];
if (!is_object($oreon))
exit();
# Init differents elements we need in a lot of pages
unset($oreon->user->lcaTopo);
unset($oreon->user->lcaTStr);
$oreon->user->createLCA($pearDB);
unset($oreon->Nagioscfg);
$oreon->initNagiosCFG($pearDB);
unset($oreon->optGen);
$oreon->initOptGen($pearDB);
if (!$p){
$root_menu = get_my_first_allowed_root_menu($oreon->user->lcaTStr);
if (isset($root_menu["topology_page"])) $p = $root_menu["topology_page"] ; else $p = NULL;
if (isset($root_menu["topology_url_opt"])){
$tab = split("\=", $root_menu["topology_url_opt"]);
if (isset($tab[1]))
$o = $tab[1];
}
}
# Cut Page ID
$level1 = NULL;
$level2 = NULL;
$level3 = NULL;
$level4 = NULL;
switch (strlen($p)) {
case 1 : $level1= $p; break;
case 3 : $level1 = substr($p, 0, 1); $level2 = substr($p, 1, 2); $level3 = substr($p, 3, 2); break;
case 5 : $level1 = substr($p, 0, 1); $level2 = substr($p, 1, 2); $level3 = substr($p, 3, 2); break;
case 6 : $level1 = substr($p, 0, 2); $level2 = substr($p, 2, 2); $level3 = substr($p, 3, 2); break;
case 7 : $level1 = substr($p, 0, 1); $level2 = substr($p, 1, 2); $level3 = substr($p, 3, 2); $level4 = substr($p, 5, 2); break;
default : $level1= $p; break;
}
# Skin path
$DBRESULT =& $pearDB->query("SELECT template FROM general_opt LIMIT 1");
if (PEAR::isError($DBRESULT))
print "DB error : ".$DBRESULT->getDebugInfo()."<br>";
$DBRESULT->fetchInto($data);
$skin = "./Themes/".$data["template"]."/";
$tab_file_css = array();
$i = 0;
if ($handle = @opendir($skin."Color")) {
while ($file = @readdir($handle)){
if (is_file($skin."Color"."/$file")) {
$tab_file_css[$i++] = $file;
}
}
@closedir($handle);
}
$colorfile = "Color/". $tab_file_css[0];
$DBRESULT =& $pearDB->query("SELECT css_name FROM css_color_menu WHERE menu_nb = '".$level1."'");
if (PEAR::isError($DBRESULT))
print ($DBRESULT->getMessage());
l'erreur est ici ----> if($DBRESULT->numRows() && $DBRESULT->fetchInto($elem))
$colorfile = "Color/".$elem["css_name"];
# Update Session Table For last_reload and current_page row
$DBRESULT =& $pearDB->query("UPDATE `session` SET `current_page` = '".$level1.$level2.$level3.$level4."',`last_reload` = '".time()."', `ip_address` = '".$_SERVER["REMOTE_ADDR"]."' WHERE CONVERT( `session_id` USING utf8 ) = '".session_id()."' AND `user_id` = '".$oreon->user->user_id."' LIMIT 1");
if (PEAR::isError($DBRESULT))
print "DB Error WHERE Updating Session : ".$DBRESULT->getDebugInfo()."<br>";
# Load traduction in the selected language.
is_file ("./lang/".$oreon->user->get_lang().".php") ? include_once ("./lang/".$oreon->user->get_lang().".php") : include_once ("./lang/en.php");
is_file ("./include/configuration/lang/".$oreon->user->get_lang().".php") ? include_once ("./include/configuration/lang/".$oreon->user->get_lang().".php") : include_once ("./include/configuration/lang/en.php");
is_file ("./include/monitoring/lang/".$oreon->user->get_lang().".php") ? include_once ("./include/monitoring/lang/".$oreon->user->get_lang().".php") : include_once ("./include/monitoring/lang/en.php");
is_file ("./include/options/lang/".$oreon->user->get_lang().".php") ? include_once ("./include/options/lang/".$oreon->user->get_lang().".php") : include_once ("./include/options/lang/en.php");
is_file ("./include/reporting/lang/".$oreon->user->get_lang().".php") ? include_once ("./include/reporting/lang/".$oreon->user->get_lang().".php") : include_once ("./include/reporting/lang/en.php");
is_file ("./include/inventory/lang/".$oreon->user->get_lang().".php") ? include_once ("./include/inventory/lang/".$oreon->user->get_lang().".php") : include_once ("./include/inventory/lang/en.php");
is_file ("./include/views/lang/".$oreon->user->get_lang().".php") ? include_once ("./include/views/lang/".$oreon->user->get_lang().".php") : include_once ("./include/views/lang/en.php");
is_file ("./include/tools/lang/".$oreon->user->get_lang().".php") ? include_once ("./include/tools/lang/".$oreon->user->get_lang().".php") : include_once ("./include/tools/lang/en.php");
# Take this part again and get infos in module table
foreach ($oreon->modules as $module)
$module["lang"] ? (is_file ("./modules/".$module["name"]."/lang/".$oreon->user->get_lang().".php") ? include_once ("./modules/".$module["name"]."/lang/".$oreon->user->get_lang().".php") : include_once ("./modules/".$module["name"]."/lang/en.php")) : NULL;
$mlang = $oreon->user->get_lang();
}
?>
ect-ce quelqu'un aurait une idée??
merci de votre aide
je souhaite mettre a jour nagios, c'est pourquoi j'exporte la base de donnée de oreon afin de conserver mes 'host' pour ne pas avoir a recommencer mais lorsrque je l'importe sous centron
j'obtien une erreur sur la ligne 153 du fichier importé (à la fonction numRows() ) en PHP voici le fichier :
function microtime_float() {
list($usec, $sec) = explode(" ", microtime());
return ((float)$usec + (float)$sec);
}
set_time_limit(60);
$time_start = microtime_float();
$advanced_search = 0;
# Define
define('SMARTY_DIR', '../GPL_LIB/Smarty/libs/');
# Include
require_once ("./oreon.conf.php");
require_once ("./DBconnect.php");
require_once ("./DBOdsConnect.php");
require_once ("$classdir/Session.class.php");
require_once ("$classdir/Oreon.class.php");
require_once (SMARTY_DIR."Smarty.class.php");
ini_set("session.gc_maxlifetime", "31536000");
Session::start();
if (version_compare(phpversion(), '5.0') < 0) {
eval('
function clone($object) {
return $object;
}
');
}
if (isset($_POST["export_sub_list"])) {
$mime_type = 'text/x-text';
if (!strcmp($_GET['p'], "2"))
$mime_type .= 'image/jpeg';
$filename = "oreon_" . date("Y-m-d") . ".sql";
// Send headers
header('Content-Type: '.$mime_type);
// IE need specific headers
if (stristr($_SERVER['HTTP_USER_AGENT'], "MSIE")) {
header("Content-Disposition: inline; filename=\"".$filename."\"");
header('Expires: 0');
header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
header('Pragma: public');
} else {
header('Content-Disposition: attachment; filename="'.$filename.'"');
header('Expires: 0');
header('Pragma: no-cache');
}
if (isset($_POST["s"]) && ($_POST["s"] == 1 || $_POST["s"] == 2 || $_POST["s"] == 4)) {
include("./include/options/db/extractDB/extract_sub.php");exit();}
} else {
# Delete Session Expired
$DBRESULT =& $pearDB->query("SELECT session_expire FROM general_opt LIMIT 1");
if (PEAR::isError($DBRESULT)) print "DB Error : ".$DBRESULT->getDebugInfo()."<br>";
$DBRESULT->fetchInto($session_expire);
$time_limit = time() - ($session_expire["session_expire"] * 60);
$DBRESULT =& $pearDB->query("DELETE FROM session WHERE last_reload < '".$time_limit."'");
if (PEAR::isError($DBRESULT)) print "DB error Where deleting Sessions : ".$DBRESULT->getDebugInfo()."<br>";
# Get session and Check if session is not expired
$DBRESULT =& $pearDB->query("SELECT user_id FROM session WHERE `session_id` = '".session_id()."'");
if (PEAR::isError($DBRESULT)) print "DB Error : ".$DBRESULT->getDebugInfo()."<br>";
if (!$DBRESULT->numRows())
header("Location: index.php?disconnect=2");
if (!isset($_SESSION["oreon"]))
header("Location: index.php?disconnect=1");
# Define Oreon var alias
$oreon =& $_SESSION["oreon"];
if (!is_object($oreon))
exit();
# Init differents elements we need in a lot of pages
unset($oreon->user->lcaTopo);
unset($oreon->user->lcaTStr);
$oreon->user->createLCA($pearDB);
unset($oreon->Nagioscfg);
$oreon->initNagiosCFG($pearDB);
unset($oreon->optGen);
$oreon->initOptGen($pearDB);
if (!$p){
$root_menu = get_my_first_allowed_root_menu($oreon->user->lcaTStr);
if (isset($root_menu["topology_page"])) $p = $root_menu["topology_page"] ; else $p = NULL;
if (isset($root_menu["topology_url_opt"])){
$tab = split("\=", $root_menu["topology_url_opt"]);
if (isset($tab[1]))
$o = $tab[1];
}
}
# Cut Page ID
$level1 = NULL;
$level2 = NULL;
$level3 = NULL;
$level4 = NULL;
switch (strlen($p)) {
case 1 : $level1= $p; break;
case 3 : $level1 = substr($p, 0, 1); $level2 = substr($p, 1, 2); $level3 = substr($p, 3, 2); break;
case 5 : $level1 = substr($p, 0, 1); $level2 = substr($p, 1, 2); $level3 = substr($p, 3, 2); break;
case 6 : $level1 = substr($p, 0, 2); $level2 = substr($p, 2, 2); $level3 = substr($p, 3, 2); break;
case 7 : $level1 = substr($p, 0, 1); $level2 = substr($p, 1, 2); $level3 = substr($p, 3, 2); $level4 = substr($p, 5, 2); break;
default : $level1= $p; break;
}
# Skin path
$DBRESULT =& $pearDB->query("SELECT template FROM general_opt LIMIT 1");
if (PEAR::isError($DBRESULT))
print "DB error : ".$DBRESULT->getDebugInfo()."<br>";
$DBRESULT->fetchInto($data);
$skin = "./Themes/".$data["template"]."/";
$tab_file_css = array();
$i = 0;
if ($handle = @opendir($skin."Color")) {
while ($file = @readdir($handle)){
if (is_file($skin."Color"."/$file")) {
$tab_file_css[$i++] = $file;
}
}
@closedir($handle);
}
$colorfile = "Color/". $tab_file_css[0];
$DBRESULT =& $pearDB->query("SELECT css_name FROM css_color_menu WHERE menu_nb = '".$level1."'");
if (PEAR::isError($DBRESULT))
print ($DBRESULT->getMessage());
l'erreur est ici ----> if($DBRESULT->numRows() && $DBRESULT->fetchInto($elem))
$colorfile = "Color/".$elem["css_name"];
# Update Session Table For last_reload and current_page row
$DBRESULT =& $pearDB->query("UPDATE `session` SET `current_page` = '".$level1.$level2.$level3.$level4."',`last_reload` = '".time()."', `ip_address` = '".$_SERVER["REMOTE_ADDR"]."' WHERE CONVERT( `session_id` USING utf8 ) = '".session_id()."' AND `user_id` = '".$oreon->user->user_id."' LIMIT 1");
if (PEAR::isError($DBRESULT))
print "DB Error WHERE Updating Session : ".$DBRESULT->getDebugInfo()."<br>";
# Load traduction in the selected language.
is_file ("./lang/".$oreon->user->get_lang().".php") ? include_once ("./lang/".$oreon->user->get_lang().".php") : include_once ("./lang/en.php");
is_file ("./include/configuration/lang/".$oreon->user->get_lang().".php") ? include_once ("./include/configuration/lang/".$oreon->user->get_lang().".php") : include_once ("./include/configuration/lang/en.php");
is_file ("./include/monitoring/lang/".$oreon->user->get_lang().".php") ? include_once ("./include/monitoring/lang/".$oreon->user->get_lang().".php") : include_once ("./include/monitoring/lang/en.php");
is_file ("./include/options/lang/".$oreon->user->get_lang().".php") ? include_once ("./include/options/lang/".$oreon->user->get_lang().".php") : include_once ("./include/options/lang/en.php");
is_file ("./include/reporting/lang/".$oreon->user->get_lang().".php") ? include_once ("./include/reporting/lang/".$oreon->user->get_lang().".php") : include_once ("./include/reporting/lang/en.php");
is_file ("./include/inventory/lang/".$oreon->user->get_lang().".php") ? include_once ("./include/inventory/lang/".$oreon->user->get_lang().".php") : include_once ("./include/inventory/lang/en.php");
is_file ("./include/views/lang/".$oreon->user->get_lang().".php") ? include_once ("./include/views/lang/".$oreon->user->get_lang().".php") : include_once ("./include/views/lang/en.php");
is_file ("./include/tools/lang/".$oreon->user->get_lang().".php") ? include_once ("./include/tools/lang/".$oreon->user->get_lang().".php") : include_once ("./include/tools/lang/en.php");
# Take this part again and get infos in module table
foreach ($oreon->modules as $module)
$module["lang"] ? (is_file ("./modules/".$module["name"]."/lang/".$oreon->user->get_lang().".php") ? include_once ("./modules/".$module["name"]."/lang/".$oreon->user->get_lang().".php") : include_once ("./modules/".$module["name"]."/lang/en.php")) : NULL;
$mlang = $oreon->user->get_lang();
}
?>
ect-ce quelqu'un aurait une idée??
merci de votre aide
A voir également:
- Import du réseau sous nagios
- Le message n'a pas été envoyé car le service n'est pas activé sur le réseau - Forum Xiaomi
- Entrer les informations d'identification reseau - Guide
- Partage reseau - Guide
- Câble réseau du player freebox ✓ - Forum Freebox
- Opérateur de réseau mobile - Guide