Index: trunk/ippMonitor/raw/storage.php =================================================================== --- trunk/ippMonitor/raw/storage.php (revision 42923) +++ trunk/ippMonitor/raw/storage.php (revision 42972) @@ -12,8 +12,9 @@ $projectdb = dbconnect($ID['proj']); + if ($ID['menu']) {$myMenu = $ID['menu'];} else {$myMenu = "ipp.czar.dat";} -menu($myMenu, 'Czartool on '.$lastUpdateTime, 'ipp.css', $ID['link'], $ID['proj']); +menu($myMenu, 'Czartool on ', 'ipp.css', $ID['link'], $ID['proj']); $pass = $ID['pass']; @@ -25,4 +26,7 @@ echo " "; echo "

Storage status

"; + +require_once 'functions.php'; + # storage timeseries echo getSpaces($czardb); @@ -35,277 +39,4 @@ menu_end(); - -///////////////////////////////////////////////////////////////////////////// -// // -// Functions // -// // -///////////////////////////////////////////////////////////////////////////// - -########################################################################### -# -# Gets disk status -# -########################################################################### -function getHosts($db) { - $start = microtime(true); - - - // Set environment variables - putenv("PATH=/usr/local/bin:/usr/bin:/bin:/data/ippc65.0/ipp/src/psconfig//ipp-20210708-gentoo.lin64/bin"); - putenv("PERL5LIB=/data/ippc65.0/ipp/src/psconfig//ipp-20210708-gentoo.lin64/lib"); - - $hostnoteall = array(); - exec("neb-host |cut -b 17-30,86-", $hostnoteall); - - $sql = "SELECT host, format(total, 2), format(available, 2), format(used, 2), writable, readable, format(used/total*100,3) as ratio FROM hosts where xattr <> 3 ORDER BY CASE WHEN ROUND(used/total*100,3) = 100 THEN 0 ELSE 1 END, xattr, host;"; - $qry = $db->query($sql); - - if ($qry === false) { - echo "Error with SQL query
"; - return; - } - - $sqlMax = "SELECT MAX(total) AS max_total FROM hosts WHERE xattr <> 3"; - $qryMax = $db->query($sqlMax); - $maxUsed = 0; - - if ($qryMax && $qryMax->fetchInto($rowMax)) { - $maxUsed = $rowMax[0]; // max_total value - } - - $dataRows = array(); - while ($qry->fetchInto($row)) { - // Access by index - $host = $row[0]; // ipp071.0 - $total = $row[1]; // 80.0352 TB - $available = $row[2]; // 10.8096 TB - $used = $row[3]; // 69.2256 TB - $writable = $row[4]; // 0 - $readable = $row[5]; // 1 - $ratio = $row[6]; // 86.4939 % - - // Match notes - $hostnotes = preg_grep("/$host/", $hostnoteall); - $hostnote = reset($hostnotes); - - // Defaults - $styles = "stroke-width: .5; stroke-color: black;"; - $status = "down"; - $usedColor = "lightgrey"; - $freeColor = "lightgrey"; - - // Status logic - if ($writable == 1 && $readable == 1) { - $status = "up"; - $usedColor = ($ratio >= 97) ? "pink" : "yellow"; // red if ≥97% - $freeColor = "#a6ec99"; // green free - } elseif ($writable == 0 && $readable == 1) { - $status = "repair"; - $usedColor = ($ratio >= 97) ? "pink" : "yellow"; - $freeColor = "lightgrey"; // grey free - } elseif ($available < 1) { - $used = $maxUsed; - $available = 0; - $status = "offline"; - $usedColor = "white"; - $freeColor = "white"; - } - - if ($status == "down") { - $tooltipUsed = $host . ": " . round($ratio, 1) . "% of " . $total . " TB used ". - "
" . $hostnote . ""; - $tooltipFree = "" . - $host . ": " . $available . " TB free" . - ""; - } elseif ($status == "offline") { - $tooltipUsed = $host . ": " . round($ratio, 1) . "% of " . $total . " TB used ". - "
" . $hostnote . ""; - $tooltipFree = "" . - $host . ": " . $total . " TB free" . - ""; - } else { - $tooltipUsed = $host . ": " . round($ratio, 1) . "% of " . $total . " TB used
" . $hostnote ; - $tooltipFree = $host . ": " . $available . " TB free"; - } - - - // Build data row (manual string concatenation for old PHP) - $dataRows[] = - "[ \"" . $host . ":" . $status . "\", " . - $used . ", \"" . $styles . " color: " . $usedColor . ";\", \"" . $tooltipUsed . "\", " . - $available . ", \"" . $styles . " color: " . $freeColor . ";\", \"" . $tooltipFree . "\" ]"; - - } - echo ""; - -echo " -
-
- -
- -
- -
Free
-
Used
-
97% Usage
-
Down/Repair
-
Offline
-
- ATRC ganglia -
- -
- -
"; - - $total_time = round(microtime(true) - $start, 3); - echo "
loading in $total_time seconds
"; -} - - -########################################################################### -# -# Gets disk spaces status -# -########################################################################### -function getSpaces($db) { - // timer start - $time = microtime(); - $time = explode(' ', $time); - $time = $time[1] + $time[0]; - $start = $time; - - $db->query("SELECT FORMAT(IFNULL(SUM(available), 0), 1) FROM hosts where host like 'ippb%' and xattr <> 3")->fetchInto($row); - $ippbusable = $row[0]; - $db->query("SELECT FORMAT(IFNULL(SUM(available), 0), 1) FROM hosts where host like 'ippb%' and writable = 1 and xattr <> 3")->fetchInto($row); - $ippbfree = $row[0]; - - $db->query("SELECT FORMAT(IFNULL(SUM(available), 0), 1) FROM hosts where host not like 'ippb%' and xattr <> 3")->fetchInto($row); - $ippusable = $row[0]; - $db->query("SELECT FORMAT(IFNULL(SUM(available), 0), 1) FROM hosts where host not like 'ippb%' and writable = 1 and xattr <> 3")->fetchInto($row); - $ippfree = $row[0]; - - $db->query("SELECT FORMAT(IFNULL(SUM(available), 0), 1) FROM hosts where host like 'ipp%_bck.0' and xattr <> 3")->fetchInto($row); - $bckusable = $row[0]; - $db->query("SELECT FORMAT(IFNULL(SUM(available), 0), 1) FROM hosts where host like 'ipp%_bck.0' and writable = 1 and xattr <> 3")->fetchInto($row); - $bckfree = $row[0]; - - - $sql = "select format(used/total*100,1), usable from cluster_space order by timestamp desc limit 1;"; - - if ($debug) {echo "$sql
";} - $qry = $db->query($sql); - if (dberror($qry)) {echo "error with $sql
\n";} - $qry->fetchInto($row); - $allocated = $row[0]; - $usable = $row[1]; - - #echo ""; - echo ""; - echo "
"; - echo "
"; - echo "
"; - echo "
ipp*_bck: $bckusable TB (usable)
"; - echo "
ipp*_bck: $bckfree TB (free)
"; - echo "
"; - echo "
"; - - echo ""; - $time = microtime(); - $time = explode(' ', $time); - $time = $time[1] + $time[0]; - $finish = $time; - $total_time = round(($finish - $start), 3); - $start= $finish; - echo "
loading in $total_time seconds
"; -} - - ?>