| $tmp[0] | null | null | $tmp[3]";
- }
- else {
- if ($tmp[1] == 'run') {
- echo "| $tmp[0] | loading | null | $tmp[3]";
- }
- else {
- if ($tmp[2] == NULL) {
- echo "| $tmp[0] | $tmp[1] | loading | $tmp[3]";
- }
- else {
- echo "| $tmp[0] | $tmp[1] | downloaded | $tmp[3]";
- }
- }
- }
- }
-
- echo " | | Last night $datem1 (UT)";
- $sql = "SELECT summitExp.exp_type,pzDownloadExp.state,rawExp.state,COUNT(*) FROM summitExp
- LEFT JOIN pzDownloadExp USING (summit_id) LEFT JOIN rawExp on summitExp.exp_name = rawExp.exp_name
- WHERE summitExp.dateobs like '$datem1%' group by summitExp.exp_type,pzDownloadExp.state,rawExp.state";
- $qry = $projectdb->query($sql);
- while ($qry->fetchInto($tmp)) {
- if ($tmp[1] == NULL) {
- echo " |
|---|
| $tmp[0] | null | null | $tmp[3]";
- }
- else {
- if ($tmp[1] == 'run') {
- echo "| $tmp[0] | loading | null | $tmp[3]";
- }
- else {
- if ($tmp[2] == NULL) {
- echo "| $tmp[0] | $tmp[1] | loading | $tmp[3]";
- }
- else {
- echo "| $tmp[0] | $tmp[1] | downloaded | $tmp[3]";
- }
- }
- }
- }
- // timer finished
- echo " | | ";
- $time = microtime();
- $time = explode(' ', $time);
- $time = $time[1] + $time[0];
- $finish = $time;
- $total_time = round(($finish - $start), 3);
- echo "loading in $total_time seconds.";
- $start= $finish;
- echo " |
|---|
";
- echo "
";
-}
-////////////////////////////////////////////////////////////////////////////////
-/// no needed functions ///
-////////////////////////////////////////////////////////////////////////////////
-//function createSummitDataTable($projectdb) {
-//
-// // timer start
-// $time = microtime();
-// $time = explode(' ', $time);
-// $time = $time[1] + $time[0];
-// $start = $time;
-//
-// // function begin
-// $date = date("Y-m-d");
-// $sql = "SELECT DISTINCT exp_type FROM summitExp WHERE dateobs > '$date'";
-//
-// $qry = $projectdb->query($sql);
-// if (dberror($qry)) {
-// echo "error reading newExp table
\n";
-// echo "
table query : $sql
\n";
-// menu_end();
-// }
-//
-// // set up the table
-// global $table;
-// echo $table;
-// echo "";
-// createTableTitle("Data status > $date", 4);
-// echo " ";
-// createTableColumnHeader("Exposure type");
-// createTableColumnHeader("At summit");
-// createTableColumnHeader("Registered at MHPCC");
-// createTableColumnHeader("Summit (Drop/Null)");
-//
-// $msg = "No science images taken since $date";
-//
-// // list the results
-// while ($qry->fetchInto($expType)) {
-//
-// $sql = "SELECT COUNT(*) FROM summitExp LEFT JOIN pzDownloadExp USING (summit_id)
-// WHERE dateobs > '$date' AND exp_type = '$expType[0]'";
-// // AND state != 'drop' AND state is not null AND fault != 1042";
-// $qry2 = $projectdb->query($sql);
-// $qry2->fetchInto($summit);
-//
-// $sql = "SELECT COUNT(*) FROM summitExp JOIN rawExp ON summitExp.exp_name = rawExp.exp_name
-// WHERE summitExp.dateobs > '$date' AND rawExp.dateobs > '$date' AND summitExp.exp_type = '$expType[0]'";
-// $qry2 = $projectdb->query($sql);
-// $qry2->fetchInto($mhpcc);
-//
-// $sql = "SELECT COUNT(*) FROM summitExp LEFT JOIN pzDownloadExp USING (summit_id)
-// WHERE dateobs > '$date' AND exp_type = '$expType[0]' AND (state = 'drop' OR state is null)";
-// $qry2 = $projectdb->query($sql);
-// $qry2->fetchInto($dropped);
-//
-//
-// #Query with 30 minutes delay to check during the night if any exposures are missing.
-// $datehour = gmdate("Y-m-d H:i:s");
-// $sql = "SELECT COUNT(*) FROM summitExp LEFT JOIN pzDownloadExp USING (summit_id)
-// WHERE dateobs > '$date' AND dateobs <= date_sub('$datehour', interval 30 minute)
-// AND exp_type = '$expType[0]' AND (state != 'drop' OR state is null) and fault != 1042";
-//
-// $qry2 = $projectdb->query($sql);
-// $qry2->fetchInto($summitdelay);
-//
-// $sql = "SELECT COUNT(*) FROM summitExp JOIN rawExp ON summitExp.exp_name = rawExp.exp_name
-// WHERE summitExp.dateobs > '$date' AND summitExp.dateobs <= date_sub('$datehour', interval 30 minute)
-// AND rawExp.dateobs > '$date' AND summitExp.exp_type = '$expType[0]'";
-// $qry2 = $projectdb->query($sql);
-// $qry2->fetchInto($mhpccdelay);
-//
-// echo " ";
-//
-// $DLdiff = $summit[0] - $mhpcc[0];
-// if ($DLdiff == 0) $error = 0;
-// else $error = 1;
-//
-// $delayDLdiff = $summitdelay[0] - $mhpccdelay[0];
-// if ($delayDLdiff == 0) $errordelay = 0;
-// else $errordelay = 1;
-//
-// echo "| $expType[0] | ";
-// echo "$summit[0] | ";
-// if ($delayDLdiff==0) {
-// createFormattedTableCell("", "", $mhpcc[0], $error, 0);
-// } else {
-// $DLStatus = "$mhpcc[0] ($delayDLdiff)";
-// echo "$DLStatus | ";
-// }
-//
-// echo "$dropped[0] | ";
-//
-// echo " ";
-// }
-//
-// // timer finished
-// echo "| ";
-// $time = microtime();
-// $time = explode(' ', $time);
-// $time = $time[1] + $time[0];
-// $finish = $time;
-// $total_time = round(($finish - $start), 3);
-// echo "loading in $total_time seconds.";
-// $start= $finish;
-// echo " |
|---|
";
-// echo "
";
-//}
-
-?>
-
Index: trunk/ippMonitor/raw/czartool_labels_old.php
===================================================================
--- trunk/ippMonitor/raw/czartool_labels_old.php (revision 42274)
+++ (revision )
@@ -1,983 +1,0 @@
- "failedChipProcessedImfile.php",
- "cam" => "failedCamProcessedExp.php",
- "fake" => "failedFakeProcessedImfile.php",
- "warp" => "failedWarpSkyfiles.php",
- "stack" => "failedStackSkyfile.php",
- "staticsky" => "failedStaticsky.php",
- "fullforce" => "failedFullForceSkyfiles.php",
- "diff" => "failedDiffSkyfile.php",
- "dist" => "NONE",
- "pub" => "publishDone.php",
-);
-
-$mainTable = array(
- "chip" => "chipRun",
- "cam" => "camRun",
- "fake" => "fakeRun",
- "warp" => "warpRun",
- "stack" => "stackRun",
- "staticsky" => "staticskyRun",
- "fullforce" => "fullForceRun",
- "diff" => "diffRun",
- "dist" => "distRun",
- "pub" => "publishRun",
-);
-
-$addSearchState = array(
- "chip" => 0,
- "cam" => 0,
- "fake" => 1,
- "warp" => 0,
- "stack" => 0,
- "staticsky" => 0,
- "fullforce" => 0,
- "diff" => 0,
- "dist" => 0,
- "pub" => 0,
-);
-
-$servers=array(
- #"addstar",
- #"addstarlap",
- "ippqub:stdscience_ws",
- "cleanup",
- #"detrend",
- "distribution",
- "pstamp",
- # "update",
- # "publishing",
- "registration",
- "replication",
- "stack",
- # "deepstack",
- "stdscience",
- "summitcopy");
-
-$pass = $ID['pass'];
-$proj = $ID['proj'];
-$menu = $ID['menu'];
-
-// The Update mode of czartool is obsolete since we don't use the update
-// pantasks.
-// $selectedMode = $_GET[mode];
-$selectedMode = "stdscience";
-
-$selectedStage = $_GET[stage];
-$selectedLabel = $_GET[label];
-$selectedServer = $_GET[server];
-$selectedRevertStage = $_GET[revertstage];
-$selectedRevertMode = $_GET[revertmode];
-$plotType = $_GET[plottype];
-$serverCmd = $_GET[servercmd];
-$allServerCmd = $_GET[allservercmd];
-
-$headerColor = "#0080c0";
-$columnHeaderColor = "lavender";
-
-if ($selectedMode == "") { $selectedMode = "stdscience"; }
-if ($selectedLabel == "") { $selectedLabel = "all"; }
-if ($selectedStage == "") { $selectedStage = "all_stages"; }
-if ($plotType == "") { $plotType = "linear"; }
-
-// deal with reverts: turn on or off if requested and pass current revert state for this stage onto labels table later
-if ($selectedRevertStage && $selectedRevertMode) turnRevertsOnOff($czardb, $selectedRevertStage, $selectedRevertMode);
-
-// tell selected server to stop or run
-if ($selectedServer && $serverCmd) serverStopRun($czardb, $selectedServer, $serverCmd);
-
-// tell all servers to stop or run
-if ($allServerCmd) {
-
- foreach ($servers as &$server) serverStopRun($czardb, $server, $allServerCmd);
-}
-
-
-$debug = 0;
-$table = "\n";
-
-$labels = getLabels($czardb, $selectedMode);
-$distLabels = getLabels($czardb, "distribution");
-// publishing is in stdscience now
-# $pubLabels = getLabels($czardb, "publishing");
-$pubLabels = $labels;
-
-if ($debug) {
- echo "prog returned $status, and output:
";
- for ($i = 0; $i < count($distLabels); $i++) {
- echo "$distLabels[$i]
";
- }
-}
-
-// The Update mode of czartool is obsolete. selectedMode is hardcoded to stdscience above.
-$isUpdate = ($selectedMode == "update");
-$isUpdate = 0;
-
-// hijack the text and link at the top to create a link to the czartool monitoring the other project database
-// I.E. Switch from gpc1 to gpc2 or gpc2 to gpc1
-
-$modeText = "Monitoring $proj";
-if ($proj == 'gpc1') {
- $newproj = 'gpc2';
-} else {
- $newproj = 'gpc1';
-}
-$link = "czartool_labels.php?pass=".$pass."&mode=".$selectedMode."&label=all&stage=" . $selectedStage . "&revertstage=" . $stage . "&plottype=$plotType";
-
-// set up the form
-echo "\n";
-
-echo "";
-
-echo "";
-echo "";
-echo "Czartool";
-echo "$modeText (change to $newproj)";
-echo " | ";
-echo " ";
-
-// PLOTS
-echo "";
-echo "";
- # time series plot
-echo "
![](\"czartool_getplot.php?mode=$selectedMode&type=t&label=$selectedLabel&proj=$proj&stage=$selectedStage&plottype=$plotType\")
";
- # rate time series plot
-echo "
![](\"czartool_getplot.php?mode=$selectedMode&type=rt&label=$selectedLabel&proj=$proj&stage=$selectedStage&plottype=linear\")
";
- # rate stacked histo plot
-# echo "![](\"czartool_getplot.php?mode=$selectedMode&type=rh&label=$selectedLabel&proj=$proj&stage=$selectedStage&plottype=linear\")
";
- # histogram plot
-# echo "![](\"czartool_getplot.php?mode=$selectedMode&type=h&label=$selectedLabel&proj=$proj&stage=$selectedStage&plottype=linear\")
";
- # storage plot
-echo "
![](\"czartool_getplot.php?type=s\" "\\"Click")
";
- # storage timeseries
-echo "
![](\"czartool_getplot.php?type=st\")
";
- # pantasks server status, if requested
-echo "
";
- if ($selectedServer && !$serverCmd) showServerStatus($selectedServer);
-echo " | ";
-
-
-echo "";
-echo " | ";
-
-#echo "
";
-
-// status table at top
-$nsStatus = getNightlyScienceStatus($czardb);
-$plotTypeLink = ($plotType == "linear") ? "log" : "linear";
-$link = "czartool_labels.php?pass=" . $pass . "&proj=" . $proj . "&label=" . $selectedLabel . "&stage=" . $selectedStage . "&revertstage=" . $stage . "&plottype=$plotTypeLink";
-echo "
";
-echo $table;
-
-createTableTitle("Status and links", 3);
-echo " | \n";
-echo " | Time of last update | $lastUpdateTime | ";
-echo "| ippMonitor SVN version | "; include 'version.php'; echo " | ";
-echo "| Current nightly science status | $nsStatus | ";
-echo "| Postage stamp server status | here | ";
-echo "| Documentation | here | ";
-echo "| Cluster load | here cpu_report mem_report | ";
-echo "| Who's using the cluster? | here | ";
-echo "| Files monitor | here | ";
-echo "| IPP metrics | here | ";
-echo "| Czar log pages | All ";
-echo "This week";
-echo " | ";
-echo "| Exposure summary | here | ";
-
-$plotTypeLink = ($plotType == "linear") ? "log" : "linear";
-$link = "czartool_labels.php?pass=" . $pass . "&proj=" . $proj . "&mode=" . $selectedMode . "&label=" . $selectedLabel . "&stage=" . $selectedStage . "&revertstage=" . $stage . "&plottype=$plotTypeLink";
-
-echo " \n";
-
-echo "
";
-
- createLabelsTable($pass,
- $proj,
- $czardb,
- $selectedMode,
- $labels,
- $distLabels,
- $pubLabels,
- $stages,
- "new",
- $selectedLabel,
- $selectedStage,
- $plotType);
-
-if ($selectedMode == "update") {echo "
"; createPStampDataTable();}
-echo "
";
-
- # XXX EAM : 2015.04.23 : debugging slowness
- createServersTable($pass, $proj,$selectedMode,$czardb, $servers, $selectedLabel, $selectedStage, $plotType); echo "
";
- createSummitDataTable($projectdb); echo "
";
- createDatesTable($czardb); echo "
";
-
- # This is awful
- echo $table;
- echo "";
- createTableTitle("Database replication status (update fix log here)", 2);
-
- echo " ";
- createTableColumnHeader("Database");
- createTableColumnHeader("Status (sec behind master)");
- showReplicationsStatus($REPL_HOST_GPC1, $REPL_USER_GPC1, $REPL_PASSWORD_GPC1, $REPL_DBNAME_GPC1);
- showReplicationsStatus($REPL_HOST_GPC1_SECONDARY, $REPL_USER_GPC1_SECONDARY, $REPL_PASSWORD_GPC1_SECONDARY, $REPL_DBNAME_GPC1_SECONDARY);
-
- showReplicationsStatus($REPL_HOST_NEBULOUS, $REPL_USER_NEBULOUS, $REPL_PASSWORD_NEBULOUS, $REPL_DBNAME_NEBULOUS);
- showReplicationsStatus($REPL_HOST_NEBULOUS_SECONDARY, $REPL_USER_NEBULOUS_SECONDARY, $REPL_PASSWORD_NEBULOUS_SECONDARY, $REPL_DBNAME_NEBULOUS_SECONDARY);
-
-# some mysql replication slaves to add when they are returned to service
-# showReplicationsStatus($REPL_HOST_PSTAMP, $REPL_USER_PSTAMP, $REPL_PASSWORD_PSTAMP, $REPL_DBNAME_PSTAMP);
-# showReplicationsStatus($REPL_HOST_IPPADMIN, $REPL_USER_IPPADMIN, $REPL_PASSWORD_IPPADMIN, $REPL_DBNAME_IPPADMIN); --- this one is in GPC1
-# showReplicationsStatus($REPL_HOST_ISP, $REPL_USER_ISP, $REPL_PASSWORD_ISP, $REPL_DBNAME_ISP);
- echo " ";
-echo "";
-menu_end();
-
-
-###########################################################################
-#
-# Creates a postage stamp status table
-#
-###########################################################################
-function createPStampDataTable() {
-
- $sql = "SELECT label, COUNT(job_id) AS 'Unfinished Jobs', IFNULL(priority,10000) AS priority FROM pstampRequest JOIN pstampJob USING(req_id) LEFT JOIN Label USING(label) WHERE pstampJob.state ='run' and pstampRequest.state ='run' GROUP by label";
-
- $pstampdb = DB::connect("mysql://ippuser:ippuser@ipp113/ippRequestServer");
- $qry = $pstampdb->query($sql);
- if (dberror($qry)) {
- echo "error reading pstamp table
\n";
- echo "
table query : $sql
\n";
- menu_end();
- }
-
- // set up the table
- global $table;
- echo $table;
-
- #echo "\n";
- echo "";
- createTableTitle("Postage stamp requests", 3);
- echo " ";
- createTableColumnHeader("Label");
- createTableColumnHeader("Unfinished jobs");
- createTableColumnHeader("Priority");
-
- // list the results
- while ($qry->fetchInto($row)) {
-
- echo " ";
-
- echo "| $row[0] | ";
- echo "$row[1] | ";
- echo "$row[2] | ";
-
- echo " ";
- }
-
- echo " \n";
-
-}
-
-###########################################################################
-#
-# Creates a table of summitExp against rawExp
-#
-###########################################################################
-function createSummitDataTable($projectdb) {
-
- $date = date("Y-m-d");
- $sql = "SELECT DISTINCT exp_type FROM summitExp WHERE dateobs > '$date'";
-
- $qry = $projectdb->query($sql);
- if (dberror($qry)) {
- echo "error reading newExp table
\n";
- echo "
table query : $sql
\n";
- menu_end();
- }
-
- // set up the table
- global $table;
- echo $table;
- echo "";
- createTableTitle("Status of last night's data", 4);
- echo " ";
- createTableColumnHeader("Exposure type");
- createTableColumnHeader("At summit (OK)");
- createTableColumnHeader("Registered at MHPCC");
- createTableColumnHeader("At summit (Dropped)");
-
- $msg = "No science images taken since $date";
-
- // list the results
- while ($qry->fetchInto($expType)) {
-
-# $sql = "SELECT COUNT(*) FROM summitExp WHERE dateobs > '$date' AND exp_type = '$expType[0]' and status != 'drop'";
- $sql = "SELECT COUNT(*) FROM summitExp WHERE dateobs > '$date' AND exp_type = '$expType[0]'";
- $qry2 = $projectdb->query($sql);
- $qry2->fetchInto($summit);
-
-# $sql = "SELECT COUNT(*) FROM summitExp JOIN rawExp ON summitExp.exp_name = rawExp.exp_name WHERE summitExp.dateobs > '$date' AND summitExp.exp_type = '$expType[0]' AND summitExp.status != 'drop'";
- $sql = "SELECT COUNT(*) FROM summitExp JOIN rawExp ON summitExp.exp_name = rawExp.exp_name WHERE summitExp.dateobs > '$date' AND summitExp.exp_type = '$expType[0]'";
- $qry2 = $projectdb->query($sql);
- $qry2->fetchInto($mhpcc);
-
- $sql = "SELECT COUNT(*) FROM summitExp WHERE dateobs > '$date' AND exp_type = '$expType[0]'";
- $qry2 = $projectdb->query($sql);
- $qry2->fetchInto($dropped);
-
- echo " ";
-
- if ($summit[0] == $mhpcc[0]) $error = 0;
- else $error = 1;
-
- echo "| $expType[0] | ";
- echo "$summit[0] | ";
- createFormattedTableCell("", "", $mhpcc[0], $error, 0);
- echo "$dropped[0] | ";
-
- echo " ";
- }
-
- echo "\n";
-
-}
-
-###########################################################################
-#
-# Gets labels for this server
-#
-###########################################################################
-function getLabels($db, $server) {
-
- # order by descending priority as set in project database
- $sql = "SELECT label FROM current_labels WHERE server LIKE '$server' ORDER BY priority DESC, label";
- if ($debug) {echo "$sql
";}
-
- $qry = $db->query($sql);
- if (dberror($qry)) {echo "error with $sql
\n";}
- while ($qry->fetchInto($row)) {
-
- $labels[] = $row[0];
- }
-
- return $labels;
-}
-
-###########################################################################
-#
-# Creates table for all labels showing all stages for given 'state'
-#
-###########################################################################
-function createLabelsTable(
- $pass,
- $proj,
- $db,
- $selectedMode,
- $labels,
- $distLabels,
- $pubLabels,
- $stages,
- $selectedState,
- $selectedLabel, $selectedStage, $plotType) {
-
- $isUpdate = ($selectedMode == "update");
- global $headerColor;
- global $columnHeaderColor;
- global $getFailures;
- global $mainTable;
- global $addSearchStage;
-
- // setup table
- global $table;
- echo $table;
- createTableTitle("Label status", 13);
-
- echo "\n";
- $link = "czartool_labels.php?pass=".$pass
- ."&proj=".$proj
- ."&mode=".$selectedMode
- ."&label=".$selectedLabel
- ."&stage=all_stages"
- ."&plottype=".$plotType;
- createFormattedTableCell(($selectedStage != "all_stages"), $link, "All stages", 0, "$columnHeaderColor");
-
- #echo "| Label (in order of priority) | ";
- foreach ($stages as &$stage) {
-
- if ($stage == $selectedStage) $showLink = 0;
- else $showLink = 1;
- $link =
- "czartool_labels.php?pass=".$pass
- ."&proj=".$proj
- ."&mode=" .$selectedMode
- ."&label=".$selectedLabel
- ."&stage=".$stage
- ."&plottype=".$plotType;
-
- createFormattedTableCell($showLink, $link, $stage, 0, "$columnHeaderColor");
-# createTableColumnHeader("Dates");
- }
-
- // setup default link
- $defaultlink =
- "czartool_labels.php?pass=".$pass
- ."&proj=".$proj
- ."&mode=" .$selectedMode
- ."&label=".$selectedLabel
- ."&stage=".$selectedStage
- ."&plottype=".$plotType;
-
- $searchState = "new";
- if ($selectedMode == "update") $searchState = "update";
-
- // write rows
- foreach ($labels as &$thisLabel) {
- $distributing = false;
- $publishing = false;
- foreach ($distLabels as &$distLabel) {
- if ($thisLabel == $distLabel) { $distributing = true; break;}
- }
- foreach ($pubLabels as &$pubLabel) {
-
- if ($thisLabel == $pubLabel) { $publishing = true; break;}
- }
-
- // show distribution/publishing status
- echo " \n";
-
- // create link to label summary page for each label
- if ($thisLabel == $selectedLabel) $showLink = 0;
- else $showLink = 1;
- $link =
- "czartool_labels.php?pass=".$pass
- ."&proj=".$proj
- ."&mode=" .$selectedMode
- ."&label=".$thisLabel
- ."&stage=".$selectedStage
- ."&plottype=".$plotType;
- createFormattedTableCell($showLink, $link, $thisLabel, 0, null);
-
- $str = "";
- $anyFaults = false;
-
- foreach ($stages as &$stage) {
- // Note: Do not include the state for chip, cam, and warp so that both new and update faults are listed
- $myTable = $mainTable[$stage];
- $myFailures = $getFailures[$stage];
- # echo "myTable: $myTable";
-
- if ("$myFailures" == "NONE") {
- $link = $defaultlink;
- } else {
- $link = $myFailures . "?pass=" . $pass . "&proj=" . $proj . "&" . $myTable . ".label=" . $thisLabel;
- if ($addSearchState[$stage]) {
- // Note: Do not include the state for chip, cam, and warp so that both new and update faults are listed
- $link .= "&" . $myTable . ".state=" . $searchState;
- }
- }
- getStateAndFaults($db, $thisLabel, $proj, $selectedState, $stage, $str, $anyFaults);
-
- $cellcolor = 0;
- if ("$stage" == "dist") {
- $cellcolor = (!$isUpdate && !$distributing) ? "gray" : 0;
- }
- if ("$stage" == "pub") {
- $cellcolor = (!$isUpdate && !$publishing) ? "gray" : 0;
- }
- createFormattedTableCell($anyFaults, $link, $str, $anyFaults, $cellcolor);
- }
- echo " \n";
- }
-
- echo "\n";
- $link = "czartool_labels.php?pass=" . $pass . "&proj=" . $proj . "&mode=" . $selectedMode . "&label=all&stage=".$selectedStage."&plottype=".$plotType;
- createFormattedTableCell(($selectedLabel != "all"), $link, "All labels", 0, null);
-
- foreach ($stages as &$stage) {
-
- $reverting = getRevertStatus($db, $stage);
- if(!$reverting) {$label = "";}
- if($reverting) {$label = "reverting";}
- unset($reverting);
- createFormattedTableCell(0, null, $label, 0, "$columnHeaderColor");
- }
-
- echo " \n";
- if ($selectedLabel == "all") $showLink = 0;
- else $showLink = 1;
- $link = "czartool_labels.php?pass=".$pass."&proj=".$proj."&mode=".$selectedMode."&label=all&stage=".$selectedStage."&plottype=".$plotType;
-
- echo " | \n";
- echo "\n";
-}
-
-
-###########################################################################
-#
-# Creates a table title
-#
-###########################################################################
-function createTableTitle($str, $colSpan) {
-
- global $headerColor;
- echo " | $str | ";
-}
-
-###########################################################################
-#
-# Creates a table header cell
-#
-###########################################################################
-function createTableColumnHeader($str) {
-
- global $columnHeaderColor;
- echo "$str | ";
-}
-
-###########################################################################
-#
-# Creates table cell with a red background if an error
-#
-###########################################################################
-function createFormattedTableCell($showLink, $link, $str, $error, $color) {
-
- $fontColor = $error ? "black" : "blue";
-
- if ($error) echo "";
- else if ($color) echo " | ";
- else echo " | ";
- if ($showLink) echo "$str | ";
- else if ($str) echo "$str";
- else echo " ";
-}
-
-###########################################################################
-#
-# Sets reverts status
-#
-###########################################################################
-function setRevertStatus($db, $stage, $reverting) {
-
- $sql = "UPDATE reverts SET reverting = $reverting WHERE stage LIKE '$stage'";
- if ($debug) {echo "$sql
";}
-
- $qry = $db->query($sql);
- if (dberror($qry)) {echo "error with $sql
\n";}
-}
-
-###########################################################################
-#
-# Returns current nightly science status
-#
-###########################################################################
-function getNightlyScienceStatus($db) {
-
- $sql = "SELECT status FROM nightlyscience";
- if ($debug) {echo "$sql
";}
-
- $qry = $db->query($sql);
- if (dberror($qry)) {echo "error with $sql
\n";}
- $qry->fetchInto($row);
-
- return $row[0];
-}
-
-###########################################################################
-#
-# Turns reverts on or off for a given task
-#
-###########################################################################
-function turnRevertsOnOff($db, $stage, $mode) {
-
- exec("czartool_revert.pl -t $stage -o $mode", $response, $status);
- $currentRevertMode;
- if ($response[0] == "off") $currentRevertMode = 0;
- else if ($response[0] == "on") $currentRevertMode = 1;
-
- setRevertStatus($db, $stage, $currentRevertMode);
-}
-
-###########################################################################
-#
-# Returns whether this stage is reverting or not
-#
-###########################################################################
-function getRevertStatus($db, $stage) {
-
- $anyFaults = false;
-
- $sql = "SELECT reverting FROM reverts WHERE stage LIKE '$stage'";
- if ($debug) {echo "$sql
";}
-
- $qry = $db->query($sql);
- if (dberror($qry)) {echo "error with $sql
\n";}
- $qry->fetchInto($row);
-
- return $row[0];
-}
-
-###########################################################################
-#
-# Returns state and fault-count (if new) as a string
-#
-###########################################################################
-function getStateAndFaults($db, $label, $proj, $state, $stage, &$str, &$anyFaults) {
-
- $anyFaults = false;
- $sql = "SELECT pending, faults FROM $stage WHERE label LIKE '$label' AND dbname LIKE '$proj' 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);
-
- $pending = $row[0];
- $faults = $row[1];
-
- if ($pending == 0)
- $str = "";
- else
- $str = "$pending";
-
- if ($state == "new") {
-
- if ($faults > 0) {
-
- $str = $str."(".$faults.")";
- $anyFaults = true;
- }
- }
-}
-
-###########################################################################
-#
-# Populates a tables with the current dates listed in the server_dates table
-#
-###########################################################################
-function createDatesTable($db) {
-
- global $table;
- echo $table;
- echo "
|---|
\n";
- createTableTitle("Current dates for selected pantasks servers", 3);
- echo " \n";
- createTableColumnHeader("Server");
- createTableColumnHeader("Dates");
- echo " \n";
-
- createServerDateRow($db, "stdscience");
- createServerDateRow($db, "registration");
-
- echo "\n";
-}
-
-
-###########################################################################
-#
-# Checks the status of all the pantasks servers
-#
-###########################################################################
-function createServerDateRow($db, $server) {
-
- $sql = "SELECT date FROM server_dates WHERE server LIKE '$server' ORDER BY date";
- if ($debug) {echo "$sql
";}
-
- $qry = $db->query($sql);
- if (dberror($qry)) {echo "error with $sql
\n";}
- $dates = "";
- $firstIn = true;
- while ($qry->fetchInto($row)) {
-
- if ($firstIn) {
-
- $dates = $row[0];
- $firstIn = false;
- }
- else $dates = $dates . ", " . $row[0];
- }
-
- echo "";
- echo "| $server | ";
- echo "$dates | ";
- echo " ";
-
-}
-
-###########################################################################
-#
-# Checks the status of all the pantasks servers
-#
-###########################################################################
-function createServersTable($pass, $proj, $selectedMode, $db, $servers, $selectedLabel, $selectedStage, $plotType) {
-
- // set up table columns
- global $table;
- echo $table;
- echo "";
- createTableTitle("Pantasks server status", 3);
- echo " ";
- createTableColumnHeader("Server");
- createTableColumnHeader("Alive?");
- createTableColumnHeader("Running?");
-
- //write_header_cell($class, "Server");
- //write_header_cell($class, "Alive?");
- //$link = "czartool_labels.php?pass=".$pass
- // ."&proj=".$proj
- // ."&label=".$selectedLabel
- // ."&stage=".$selectedStage
- // ."&plottype=".$plotType
- // ."&allservercmd=stop";
-
- //$link = ""; # TODO removed links temporarily
- // write_table_cell($class, '%s', $link, "Stop all");
- //$link = "czartool_labels.php?pass=".$pass
- // ."&proj=".$proj
- // ."&label=".$selectedLabel
- // ."&stage=".$selectedStage
- // ."&plottype=".$plotType
- // ."&allservercmd=run";
-
- //$link = ""; # TODO removed links temporarily
- // write_table_cell($class, '%s', $link, "Run all");
- echo " \n";
-
- foreach ($servers as &$server) {
-
- getServerStatus($db, $server, $alive, $running);
-
- echo "\n";
- $link = "czartool_labels.php?pass=".$pass
- ."&proj=".$proj
- ."&mode=".$selectedMode
- ."&server=".$server
- ."&label=".$selectedLabel
- ."&stage=".$selectedStage
- ."&plottype=".$plotType;
-
- #$link = ""; # TODO removed links temporarily
- //write_table_cell($class, '%s', $link, $server);
- //write_table_cell($class, '%s', "", $alive ? "yes" : "NO");
- //echo "| $server | ";
- createFormattedTableCell(1, $link, $server, 0, 0);
- createFormattedTableCell(0, "", $alive ? "yes" : "NO", !$alive, 0);
- createFormattedTableCell(0, "", $running ? "yes" : "NO", !$running, 0);
-
- //if ($alive) {
-
- // $link = "czartool_labels.php?pass=".$pass
- // ."&proj=".$proj
- // ."&label=".$selectedLabel
- // ."&stage=".$selectedStage
- // ."&plottype=".$plotType
- // ."&server=".$server
- // ."&servercmd=";
-
- //if ($running) {
-
- // $link = $link . "stop";
- // $link = ""; # TODO removed links temporarily
- // write_table_cell($class, '%s', $link, "stop");
- // write_table_cell($class, '%s', "", "");
- // }
- // else {
-
- // $link = $link . "run";
- // write_table_cell($class, '%s', "", "");
- // $link = ""; # TODO removed links temporarily
- // write_table_cell($class, '%s', $link, "run");
- // }
- // }
- // else {
-
- // write_table_cell($class, '%s', "", "");
- // write_table_cell($class, '%s', "", "");
- // }
- echo " \n";
- }
-
- echo "\n";
-}
-
-###########################################################################
-#
-# Commands a server to stop or run
-#
-###########################################################################
-function serverStopRun($db, $server, $cmd) {
-
- exec("czartool_serverstoprun.pl -s $server -c $cmd", $response, $status);
- $alive = 0;
- $running = 0;
- if ($response[0] == "running") {$alive = 1; $running = 1;}
- else if ($response[0] == "stopped") {$alive = 1; $running = 0;}
- else if ($response[0] == "dead") {$alive = 0; $running = 0;}
- setServerStatus($db, $server, $alive, $running);
-}
-
-###########################################################################
-#
-# Sets server status
-#
-###########################################################################
-function setServerStatus($db, $server, $alive, $running) {
-
- $sql = "INSERT INTO servers (server, alive, running) VALUES ('$server', $alive, $running)";
-
- if ($debug) {echo "$sql
";}
-
- $qry = $db->query($sql);
- if (dberror($qry)) {echo "error with $sql
\n";}
-}
-
-
-###########################################################################
-#
-# Returns state and fault-count (if new) as a string
-#
-###########################################################################
-function getServerStatus($db, $server, &$alive, &$running) {
-
- $sql = "SELECT alive, running FROM servers WHERE server LIKE '$server' 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);
-
- $alive = $row[0];
- $running = $row[1];
-}
-
-###########################################################################
-#
-# Returns time of last czarDb update
-#
-###########################################################################
-function getLastUpdateTime($db) {
-
- $anyFaults = false;
- $sql = "SELECT timestamp FROM chip 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);
-
- return $row[0];
-}
-
-###########################################################################
-#
-# Shows the status of the provided pantasks server
-#
-###########################################################################
-function showServerStatus($server) {
-
- echo " Status for $server server ";
-
- $results=array();
- exec("czartool_getServerStatus.pl -s $server", $results, $status);
-
- foreach ($results as &$line) {
- echo "\n";
- echo "$line\n";
- echo " \n";
-
- }
-}
-
-###########################################################################
-#
-# Shows the status of the various replication mysql servers
-#
-###########################################################################
-function showReplicationsStatus($replHost, $replUser, $replPassword, $replDatabaseName) {
- #print "
$replHost, $replUser, $replPassword, $replDatabaseName
";
- $dbRepl = DB::connect("mysql://$replUser:$replPassword@$replHost");
- if (PEAR::isError($dbRepl)) {
- echo "| $replDatabaseName | MySQL DB connection error - check configuration | ";
- //die("MySQL DB connection error: Check the configuration for $replDatabaseName");
- //die("");
- return -1;
-
- }
-
- # note: mysql user must have either SUPER or REPLICATION CLIENT privileges on the database
- $res = $dbRepl->query('SHOW SLAVE STATUS');
- if (dberror($res)) {
- echo "| $replDatabaseName | MySQL query error - invalid user? check configuration | ";
- //die("MySQL DB connection error: Check the configuration for $replDatabaseName");
- //die("");
- return -1;
- }
-
- while ($res->fetchInto($row)) {
- # Have a look for Last_Errno in http://dev.mysql.com/doc/refman/5.0/en/show-slave-status.html
- $errorStatusInMySql = $row[18];
- $sec_behind = $row[32];
- if ($sec_behind===NULL) {
- $sec_behind = 99999999;
- $errorStatusInMySql = 999999999;
- }
- $replStatus = ($errorStatusInMySql==0?"OK ($sec_behind)":"PROBLEM");
- echo "| $replDatabaseName | $replStatus | ";
- if ($errorStatusInMySql!=0) {
- echo "Connect to $replDatabaseName replication host, execute 'SHOW SLAVE STATUS', and fix the problem.
";
- echo "Information here | ";
- }
- }
- $dbRepl->disconnect();
-}
-
-?>
-
| | | |