function get_xfer_metrics($system, $dates, $date_step) {
$metrics = array("tx_bytes", "rx_bytes", "vnc-tx_bytes", "vnc-rx_bytes");
$conn = cassandra_connect(KS_METRICS);
$agg = new ColumnFamily($conn, CF_AGG);
$keys = array();
$totals = array();
foreach($metrics as $metric) {
$keys[] = "$system-$metric-$date_step";
$totals[$metric] = array();
}
$result = $agg->multiget($keys, $dates);
foreach($metrics as $metric) {
$xfer = $result["$system-$metric-$date_step"];
foreach($dates as $date) {
$v = array_key_exists($date, $xfer) ? $xfer[$date] : "";
$totals[$metric][$date] = $v;
}
}
return $totals;
}
}
function get_current($period) {
return date(get_date_format($period));
}
$date_start = strtotime($_GET["date_start"]);
$date_stop = strtotime($_GET["date_stop"]);
$date_step = $_GET["date_step"];
$metric = $_GET["metric"];
$dates = get_date_span($date_start, $date_stop, $date_step);
$dates = array_reverse($dates);
$current = get_current($date_step);
try {
$sys = new ColumnFamily(cassandra_connect("fo"), "systems");
$agg = new ColumnFamily(cassandra_connect("metrics"), "agg");
$sys->read_consistency_level = cassandra_ConsistencyLevel::ONE;
$agg->read_consistency_level = cassandra_ConsistencyLevel::ONE;
if($_GET["load"] == "all") {
$systems = array();
$r = $sys->get_range("", "", $row_count=200, $columns=array("status"));
foreach($r as $system => $info) $systems[] = $system;
} else {
$systems = explode(",", $_GET["load"]);
}
$keys = array();
$totals = array();
foreach($systems as $system) {
$totals[$system] = array();
$keys["$system-$metric-$date_step"] = $system;
}
$system = $passwd = null;
if(isset($_SESSION[$k_system]) && isset($_SESSION[$k_passwd])) {
$system = $_SESSION[$k_system];
$passwd = $_SESSION[$k_passwd];
}
if(isset($_POST[$k_system]) && isset($_POST[$k_passwd])) {
$system = strtolower(trim($_POST[$k_system]));
$passwd = trim($_POST[$k_passwd]);
}
if($system != null && $passwd != null) {
require_once("/home/frozen/phpcassa.php");
$error = "Login failed. User does not exist or incorrect password.";
try {
$conn = cassandra_connect(KS_FO);
$sys = new ColumnFamily($conn, CF_SYSTEMS);
$system_info = $r = $sys->get($system);
if($r["status"] == "assigned" && $r["subscription"] != ""
&& hash("sha256", ".:$system.$passwd:.") == $r["slogin_www"]) {
$_SESSION[$k_system] = $system;
$_SESSION[$k_passwd] = $passwd;
unset($error);
$logged_in = true;
$sub = new ColumnFamily($conn, CF_SUBSCRIPTIONS);
$sub_info = $sub->get($system_info["subscription"]);
}
} catch (Exception $e) { }
}
if($logged_in) {