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) {
