include 'include_nav.php'; ?> <!-- START page content --> <div class="container"> <?php include 'include_alerts.php'; ?> <?php if (isset($strNode)) { echo '<div class="row">' . "\n"; echo ' <div class="col-sm-12">' . "\n"; echo ' <h1>' . $strNode . '<small>' . $arrDBConns[$strNode]['DBIP'] . '</small></h1>' . "\n"; echo ' <p class="lead">The following settings are displayed via the <strong>SHOW ALL;</strong> command.</p>' . "\n"; echo ' </div>' . "\n"; echo '</div>' . "\n"; $objResults = getDBSystemParam($strNode); $intRows = pg_numrows($objResults); echo '<div class="row">' . "\n"; echo ' <div class="list-group">' . "\n"; for ($ri = 0; $ri < $intRows; $ri++) { $row = pg_fetch_array($objResults, $ri); $strParamValue = $row[$strParam]; // echo '<div class="row">' . "\n"; // echo ' <div class="col-sm-6"><strong>' . $row['name'] . '</strong></div>' . "\n"; // echo ' <div class="col-sm-6">' . $row['setting'] . '</div>' . "\n"; // echo '</div>' . "\n"; // echo '<div class="row">' . "\n"; // echo ' <div class="col-sm-12">' . $row['description'] . '</div>' . "\n"; // echo '</div>' . "\n"; echo ' <div class="list-group-item">' . "\n"; echo ' <h4 class="list-group-item-heading">' . $row['name'] . ' <small><i>:' . $row['description'] . '</i></small></h4>' . "\n";
</div> </div> </div> </div> <div class="row"> <div class="col-lg-12 text-center"> <div class="panel panel-default"> <div class="panel-heading"><strong>Datanodes</strong></div> <div class="panel-body"> <?php foreach ($arrDBConns as $key => $value) { if (strtolower($value['DBXLNode']) == 'datanode') { $strPanelColor = 'success'; // check the number of connections $intConnections = getConnections($key); $intMaxConnections = getDBSystemParam($key, 'max_connections'); if ($intMaxConnections >= $intConnections && $intMaxConnections > 0) { $perConnections = round($intConnections / $intMaxConnections * 100, 0); } else { $intConnections = '?'; $intMaxConnections = '?'; $perConnections = '???'; $strPanelColor = 'warning'; } // display number of deadlocks $intDeadlocks = getDeadlocks($key); if ($intDeadlocks != '0') { $strPanelColor = 'warning'; } // try to ping the server if (testPing($value['DBIP'])) {
<div class="row"> <div class="col-sm-12"> <?php echo $strNodeTable; ?> </div> </div> <div class="row"> <div class="col-sm-12"> <?php $arrDBSettings = array(); $arrDBNodes = array(); foreach ($arrDBConns as $key => $value) { if (strtolower($value['DBXLNode']) == 'datanode' || strtolower($value['DBXLNode']) == 'coordinator') { if (testPort($value['DBIP'], $value['DBPort'], 0.05)) { $objResults = getDBSystemParam($key); $intRows = pg_numrows($objResults); $arrDBNodes[] = $key; for ($ri = 0; $ri < $intRows; $ri++) { $row = pg_fetch_array($objResults, $ri); $arrDBSetting = array($key => $row['setting']); $arrDBSettings[$row['name']][$key] = $row['setting']; } } } } echo '<div class="table-responsive">' . "\n"; echo '<table class="table table-bordered table-striped table-hover table-condensed">' . "\n"; echo '<tr>' . "\n"; echo '<th>System<br>Setting</th>' . "\n"; foreach ($arrDBNodes as $strENode) {