Import du réseau sous nagios

Résolu/Fermé
bijente Messages postés 5 Date d'inscription mardi 27 novembre 2007 Statut Membre Dernière intervention 18 juin 2008 - 9 avril 2008 à 09:23
 romuald - 28 juin 2012 à 11:01
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

2 réponses

bijente Messages postés 5 Date d'inscription mardi 27 novembre 2007 Statut Membre Dernière intervention 18 juin 2008 1
9 avril 2008 à 09:42
Petite erreur il sagit du fichier header.php que centreon essaye de charger à la connexion.
1
comment as tu fait
0