Project Profile

\n"; $proj_created = $row[created]; #$proj_expires = $row[expires]; $proj_name = stripslashes($row[name]); $proj_URL = $row[URL]; $proj_public = $row[public]; $proj_funders = stripslashes($row[funders]);; $proj_head_uid = $row[head_uid]; $proj_members = $row[num_members]; $proj_pcs = $row[num_pcs]; $proj_ronpcs = $row[num_ron]; $proj_plabpcs = $row[num_pcplab]; $proj_why = nl2br($row[why]); $control_node = $row[control_node]; $approved = $row[approved]; $expt_count = $row[expt_count]; $expt_last = $row[expt_last]; if ($proj_public) { $proj_public = "Yes"; } else { $proj_public = "No"; } if (!$expt_last) { $expt_last = " "; } # # Generate the table. # echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; #echo " # # # \n"; echo "\n"; echo "\n"; echo "\n"; if ($approved) { echo "\n"; } else { echo "\n"; } echo "\n"; echo "\n"; echo "\n"; echo "
Name: $pid
Long Name: $proj_name
Project Head: $proj_head_uid
URL: $proj_URL
Publicly Visible: $proj_public
Funders: $proj_funders
#Project Members: $proj_members
#PCs: $proj_pcs
#Planetlab PCs: $proj_plabpcs
#RON PCs: $proj_ronpcs
Created: $proj_created
Expires: $proj_expires
Experiments Created: $expt_count
Date of last experiment: $expt_last
Approved?: \"Y\"\"N\"
Why?:
$proj_why
\n"; } # # A Group # function SHOWGROUP($pid, $gid) { global $OURDOMAIN; $query_result = DBQueryFatal("SELECT * FROM groups WHERE pid='$pid' and gid='$gid'"); $row = mysql_fetch_array($query_result); echo "

Group Profile

\n"; $leader = $row[leader]; $created = $row[created]; $description= stripslashes($row[description]); $expt_count = $row[expt_count]; $expt_last = $row[expt_last]; $unix_gid = $row[unix_gid]; $unix_name = $row[unix_name]; if (strcmp($pid,$gid)) $mail = "$pid-$gid" . "-users@" . $OURDOMAIN; else $mail = "$pid" . "-users@" . $OURDOMAIN; if (!$expt_last) { $expt_last = " "; } # # Generate the table. # echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "
GID: $gid
PID: $pid
Description: $description
Unix GID: $unix_gid
Unix Group Name: $unix_name
Group Leader: $leader
Email List: $mail
Created: $created
Experiments Created: $expt_count
Date of last experiment: $expt_last
\n"; } # # A list of Group members. # function SHOWGROUPMEMBERS($pid, $gid, $prived = 0) { $query_result = DBQueryFatal("SELECT m.*,u.* FROM group_membership as m ". "left join users as u on u.uid=m.uid ". "WHERE pid='$pid' and gid='$gid'"); if (! mysql_num_rows($query_result)) { return; } $showdel = (($prived && !strcmp($pid, $gid)) ? 1 : 0); echo "
\n"; if (strcmp($pid, $gid)) { echo "

Group Members

\n"; } else { echo "

Project Members

\n"; } echo "
\n"; echo "\n"; if (strcmp($pid, $gid)) { echo "\n"; } echo " \n"; if ($showdel) { echo "\n"; } echo "\n"; while ($row = mysql_fetch_array($query_result)) { $target_uid = $row[uid]; $usr_name = $row[usr_name]; $usr_email = $row[usr_email]; $trust = $row[trust]; echo "\n"; if (strcmp($pid, $gid)) { echo "\n"; } echo " \n"; if (TBTrustConvert($trust) != $TBDB_TRUST_NONE) { echo "\n"; } else { echo "\n"; } if ($showdel) { echo "\n"; } echo "\n"; } echo "
NameEmailUID PrivsRemove
$usr_name$usr_email $target_uid $trust$trust N
\n"; } # # A list of groups for a user. # function SHOWGROUPMEMBERSHIP($uid) { $none = TBDB_TRUSTSTRING_NONE; $query_result = DBQueryFatal("SELECT * FROM group_membership ". "WHERE uid='$uid' and trust!='$none' ". "order by pid"); if (! mysql_num_rows($query_result)) { return; } echo "

Group Membership

\n"; echo "\n"; while ($row = mysql_fetch_array($query_result)) { $pid = $row[pid]; $gid = $row[gid]; $trust = $row[trust]; if (TBTrustConvert($trust) != $TBDB_TRUST_NONE) { echo "\n"; echo "\n"; } } echo "
PID GID Privs
$pid $gid $trust
\n"; } # # A User # function SHOWUSER($uid) { global $TBDBNAME; $userinfo_result = DBQueryFatal("SELECT * from users where uid='$uid'"); $row = mysql_fetch_array($userinfo_result); #$usr_expires = $row[usr_expires]; $usr_email = $row[usr_email]; $usr_URL = $row[usr_URL]; $usr_addr = stripslashes($row[usr_addr]); $usr_addr2 = stripslashes($row[usr_addr2]); $usr_city = stripslashes($row[usr_city]); $usr_state = stripslashes($row[usr_state]); $usr_zip = stripslashes($row[usr_zip]); $usr_country = stripslashes($row[usr_country]); $usr_name = stripslashes($row[usr_name]); $usr_phone = $row[usr_phone]; $usr_shell = stripslashes($row[usr_shell]); $usr_title = stripslashes($row[usr_title]); $usr_affil = stripslashes($row[usr_affil]); $status = $row[status]; $admin = $row[admin]; $adminoff = $row[adminoff]; if (!strcmp($usr_addr2, "")) $usr_addr2 = " "; if (!strcmp($usr_city, "")) $usr_city = " "; if (!strcmp($usr_state, "")) $usr_state = " "; if (!strcmp($usr_zip, "")) $usr_zip = " "; if (!strcmp($usr_country, "")) $usr_country = " "; # # Last Login info. # if (($lastweblogin = LASTWEBLOGIN($uid)) == 0) $lastweblogin = " "; if (($lastuserslogininfo = TBUsersLastLogin($uid)) == 0) $lastuserslogin = "N/A"; else { $lastuserslogin = $lastuserslogininfo["date"] . " " . $lastuserslogininfo["time"]; } if (($lastnodelogininfo = TBUidNodeLastLogin($uid)) == 0) $lastnodelogin = "N/A"; else { $lastnodelogin = $lastnodelogininfo["date"] . " " . $lastnodelogininfo["time"] . " " . "(" . $lastnodelogininfo["node_id"] . ")"; } echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; #echo " # # # \n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; if ($admin) { $onoff = ($adminoff ? "Off" : "On"); $flip = ($adminoff ? 0 : 1); echo "\n"; } echo "\n"; echo "\n"; echo "\n"; echo "
Username: $uid
Full Name: $usr_name
Email Address: $usr_email
Home Page URL: $usr_URL
Expiration date:$usr_expires
Address 1: $usr_addr
Address 2: $usr_addr2
City: $usr_city
State: $usr_state
ZIP: $usr_zip
Country: $usr_country
Phone #: $usr_phone
Shell: $usr_shell
Title/Position: $usr_title
Institutional Affiliation: $usr_affil
Status: $status
Admin (on/off): Yes ($onoff)
Last Web Login: $lastweblogin
Last Users Login: $lastuserslogin
Last Node Login: $lastnodelogin
\n"; } # # Show an experiment. # function SHOWEXP($pid, $eid, $edit=0) { global $TBDBNAME, $TBDOCBASE; $nodecounts = array(); # Node counts, by class. $query_result = DBQueryFatal("select nt.class,count(*) from reserved as r ". "left join nodes as n on n.node_id=r.node_id ". "left join node_types as nt on n.type=nt.type ". "where pid='$pid' and eid='$eid' group by nt.class"); while ($row = mysql_fetch_array($query_result)) { $class = $row[0]; $count = $row[1]; $nodecounts[$class] = $count; } $query_result = DBQueryFatal("select e.*, round(minimum_nodes+.1,0) as min_nodes ". " from experiments as e ". "where e.pid='$pid' and e.eid='$eid'"); if (($exprow = mysql_fetch_array($query_result)) == 0) { TBERROR("Experiment $eid in project $pid is gone!\n", 1); } $exp_gid = $exprow[gid]; #$exp_expires = $exprow[expt_expires]; $exp_name_safe= htmlspecialchars(stripslashes($exprow[expt_name])); $exp_name = stripslashes($exprow[expt_name]); $exp_created = $exprow[expt_created]; $exp_swapped = $exprow[expt_swapped]; $exp_swapuid = $exprow[expt_swap_uid]; $exp_end = $exprow[expt_end]; $exp_created = $exprow[expt_created]; $exp_head = $exprow[expt_head_uid]; $exp_status = $exprow[state]; $exp_shared = $exprow[shared]; $exp_path = $exprow[path]; $batchmode = $exprow[batchmode]; $attempts = $exprow[attempts]; $batchstate = $exprow[batchstate]; $priority = $exprow[priority]; $swappable = $exprow[swappable]; $noswap_reason_safe = htmlspecialchars(stripslashes($exprow[noswap_reason])); $noswap_reason = stripslashes($exprow[noswap_reason]); $idleswap = $exprow[idleswap]; $idleswap_timeout = $exprow[idleswap_timeout]; $noidleswap_reason_safe = htmlspecialchars(stripslashes($exprow[noidleswap_reason])); $noidleswap_reason = stripslashes($exprow[noidleswap_reason]); $autoswap = $exprow[autoswap]; $autoswap_timeout = $exprow[autoswap_timeout]; $idle_ignore = $exprow[idle_ignore]; $swapreqs = $exprow[swap_requests]; $lastswapreq = $exprow[last_swap_req]; $minnodes = $exprow["min_nodes"]; $autoswap_hrs= ($autoswap_timeout/60.0); $idleswap_hrs= ($idleswap_timeout/60.0); if ($edit) { # make this a form too echo "
\n"; $noswap_form = "Why: "; $noidleswap_form = "Why: "; $autoswap_form= " hour".($autoswap_hrs==1 ? "" : "s"); $toggle = "Toggle"; $expttag = "pid=$pid&eid=$eid&edit=1"; if ($swappable) $swappable = "Yes $toggle $noswap_form"; else $swappable = "No $toggle $noswap_form"; $idleswap_form= " hour".($idleswap_hrs==1 ? "" : "s"); if ($idleswap) $idleswap = "Yes $toggle (after $idleswap_form)
$noidleswap_form"; else $idleswap = "No $toggle (after $idleswap_form)
$noidleswap_form"; if ($autoswap) $autoswap = "Yes $toggle (after $autoswap_form)"; else $autoswap = "No $toggle (after $autoswap_form)"; if ($idle_ignore) $idle_ignore = "Yes $toggle"; else $idle_ignore = "No $toggle"; } else { $noswap = "($noswap_reason)"; $noidleswap = "($noidleswap_reason)"; $autoswap_str= $autoswap_hrs." hour".($autoswap_hrs==1 ? "" : "s"); $idleswap_str= $idleswap_hrs." hour".($idleswap_hrs==1 ? "":"s"); if ($swappable) $swappable = "Yes"; else $swappable = "No $noswap"; if ($idleswap) $idleswap = "Yes (after $idleswap_str)"; else $idleswap = "No $noidleswap"; if ($autoswap) $autoswap = "Yes (after $autoswap_str)"; else $autoswap = "No"; if ($idle_ignore) $idle_ignore = "Yes"; else $idle_ignore = "No"; } # # Generate the table. # echo "\n"; echo "\n"; if ($edit) { $exp_name_str = ""; } else { $exp_name_str = $exp_name; } echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; if ($exp_swapped) { echo "\n"; } if (ISADMIN()) { echo "\n"; } echo "\n"; echo "\n"; if (ISADMIN()) { echo "\n"; } echo "\n"; echo "\n"; echo "\n"; if (count($nodecounts)) { echo "\n"; } else { if ($minnodes!="") { echo "\n"; } else { echo "\n"; } } $lastact = TBGetExptLastAct($pid,$eid); $idletime = TBGetExptIdleTime($pid,$eid); $stale = TBGetExptIdleStale($pid,$eid); if ($lastact != -1) { echo "\n"; if ($stale) { $str = "(stale)"; } else { $str = ""; } echo "\n"; } if (! ($swapreqs=="" || $swapreqs==0)) { echo "\n"; echo "\n"; } if ($batchmode) { echo "\n"; echo "\n"; echo "\n"; } if ($edit) { echo "\n"; } echo "
Name: $eid
Long Name: $exp_name_str
Project: $pid
Group: $exp_gid
Experiment Head: $exp_head
Created: $exp_created
Last Swap/Modify: $exp_swapped ($exp_swapuid)
Swappable: $swappable
Idle-Swap: $idleswap
Max. Duration: $autoswap
Idle Ignore: $idle_ignore
Shared: "; if ($exp_shared) { echo "Yes"; } else { echo "No"; } echo "
Path: $exp_path
Status: $exp_status
Reserved Nodes: \n"; while (list ($class, $count) = each($nodecounts)) { echo "$count ($class)   "; } echo "
Minumum Nodes: $minnodes (estimate)
Minumum Nodes: Unknown
Last Activity: $lastact
Idle Time: $idletime hours $str
Swap Requests: $swapreqs
Last Swap Req.: $lastswapreq
Batch Mode: Yes
Batch Status: $batchstate
Start Attempts: $attempts
\n"; if ($edit) { echo "
\n"; } } # # Show a listing of experiments by user/pid/gid # function SHOWEXPLIST($type,$id) { if ($type == "USER") { $where = "expt_head_uid='$id'"; $title = "Current"; } elseif ($type == "PROJ") { $where = "e.pid='$id'"; $title = "Project"; $nopid = 1; } elseif ($type == "GROUP") { $where = "e.gid='$id'"; $title = "Group"; $nopid = 1; } else { $where = "e.eid='$id'"; $title = "Bad id '$id'!"; } $query_result = DBQueryFatal("select e.*,count(r.node_id) as nodes, ". "round(minimum_nodes+.1,0) as min_nodes ". "from experiments as e ". "left join reserved as r on e.pid=r.pid and e.eid=r.eid ". "where $where ". "group by e.pid,e.eid order by e.state,e.eid"); if (mysql_num_rows($query_result)) { echo "

$title Experiments

\n"; if ($nopid) { $pidrow=""; } else { $pidrow="\n"; } echo "$pidrow \n"; $idlemark = "*"; $stalemark = "?"; while ($row = mysql_fetch_array($query_result)) { $pid = $row[pid]; $eid = $row[eid]; $state= $row[state]; $nodes= $row["nodes"]; $minnodes = $row["min_nodes"]; $idlehours = TBGetExptIdleTime($pid,$eid); $stale = TBGetExptIdleStale($pid,$eid); $ignore = $row["idle_ignore"]; $name = stripslashes($row[expt_name]); if ($nodes==0) { $nodes = "$minnodes"; } elseif ($row[swap_requests] > 0) { $nodes .= $idlemark; } if ($nopid) { $pidrow=""; } else { $pidrow="\n"; } $idlestr = $idlehours; if ($idlehours > 0) { if ($stale) { $idlestr .= $stalemark; } if ($ignore) { $idlestr = "($idlestr)"; $parens=1; } } elseif ($idlehours == -1) { $idlestr = " "; } echo "$pidrow \n"; } echo "
PID
EID State Nodes [1] Hours Idle [2] Description
". "$pid
$eid $state $nodes $idlestr $name
\n"; echo "\n". "
    \n". "
  1. Node counts in green\n". "show a rough estimate of the minimum number of \n". "nodes
    required to swap in.\n". "They account for delay nodes, but not for node types, etc.\n". "
  2. A $stalemark indicates that the data is stale, and ". "at least one node in the experiment has not
    reported ". "on its proper schedule.\n"; if ($parens) { # don't show this unless we did it... most users shouldn't ever # need to know that some expts have their idleness ignored echo "Values are in parenthesis for idle-ignore experiments.\n"; } echo "
\n"; } } # # Show Node information for an experiment. # function SHOWNODES($pid, $eid) { global $TBDBNAME; global $TBOPSPID; global $altnodesort; global $SCRIPT_NAME; $reserved_result = DBQueryFatal("SELECT * FROM reserved WHERE ". "eid='$eid' and pid='$pid'"); # If this is an expt in emulab-ops, we don't care about vname, # since it won't be defined. But we do want to know when the node # entered the experiment, since it won't match the experiment's # swapin date. $nodename="". "Node Name"; $vnamefield="vname"; if (!strcmp($pid, $TBOPSPID)) { $nodename="". "Reserve Time"; $vnamefield="rsrvtime"; if (!isset($altnodesort)) { $altnodesort = 2; } } if (mysql_num_rows($reserved_result)) { if (!isset($altnodesort)) { $altnodesort = 1; } echo "

Reserved Nodes

\n"; $sort = "type,priority"; if ($altnodesort==1) { $sort = "vname"; } elseif ($altnodesort==2) { $sort = "rsrvtime"; } # Can add other alt sorts here too $query_result = DBQueryFatal("SELECT nodes.*,reserved.*,ns.status as nodestatus, ". "date_format(rsrv_time,\"%Y-%m-%d %T\") as rsrvtime ". "FROM nodes LEFT JOIN node_activity ". "on nodes.node_id=node_activity.node_id ". "LEFT JOIN reserved ON nodes.node_id=reserved.node_id ". "LEFT JOIN node_status as ns ON ns.node_id=nodes.node_id ". "WHERE reserved.eid=\"$eid\" and reserved.pid=\"$pid\" ". "ORDER BY $sort"); $stalemark = "?"; while ($row = mysql_fetch_array($query_result)) { $node_id = $row[node_id]; $vname = $row[$vnamefield]; $type = $row[type]; $def_boot_osid = $row[def_boot_osid]; $startstatus = $row[startstatus]; $readystatus = $row[ready]; $status = $row[nodestatus]; $bootstate = $row[eventstate]; $idlehours = TBGetNodeIdleTime($node_id); $stale = TBGetNodeIdleStale($node_id); $idlestr = $idlehours; if ($idlehours > 0) { if ($stale) { $idlestr .= $stalemark; } if ($ignore) { $idlestr = "($idlestr)"; $parens=1; } } elseif ($idlehours == -1) { $idlestr = " "; } if (!$vname) $vname = "--"; if ($readystatus) $readylabel = "Yes"; else $readylabel = "No"; echo "\n"; if ($def_boot_osid) { echo ""; } else echo "\n"; if ($bootstate != "ISUP") { echo " \n"; } else { echo " \n"; } echo " \n"; } echo "
". "Node ID $nodename Type Default OSID Node
Status		 Hours
Idle[1]		 Startup
Status[2]		 Ready
Status[3]
$node_id $vname $type"; SPITOSINFOLINK($def_boot_osid); echo " $status ($bootstate)$status$idlestr $startstatus $readylabel
\n"; echo "

  1. A $stalemark indicates that the data is stale, and the node has not reported on its proper schedule.
  2. Exit value of the node startup command. A value of 666 indicates a testbed internal error.
  3. User application ready status, reported via TMCC.

\n"; } } # # Show OS INFO record. # function SHOWOSINFO($osid) { global $TBDBNAME; $query_result = DBQueryFatal("SELECT * FROM os_info WHERE osid='$osid'"); $osrow = mysql_fetch_array($query_result); $os_description = stripslashes($osrow[description]); $os_OS = $osrow[OS]; $os_version = $osrow[version]; $os_path = $osrow[path]; $os_magic = $osrow[magic]; $os_osfeatures = $osrow[osfeatures]; $os_op_mode = $osrow[op_mode]; $os_pid = $osrow[pid]; $os_shared = $osrow[shared]; $os_osname = $osrow[osname]; $creator = $osrow[creator]; $created = $osrow[created]; $mustclean = $osrow[mustclean]; $nextosid = $osrow[nextosid]; if (!$os_description) $os_description = " "; if (!$os_version) $os_version = " "; if (!$os_path) $os_path = " "; if (!$os_magic) $os_magic = " "; if (!$os_osfeatures) $os_osfeatures = " "; if (!$os_op_mode) $os_op_mode = " "; if (!$created) $created = "N/A"; # # Generate the table. # echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; if ($nextosid) { echo "\n"; } echo "\n"; echo "
Name: $os_osname
Project: $os_pid
Creator: $creator
Created: $created
Description: $os_description
Operating System: $os_OS
Version: $os_version
Path: $os_path
Magic (uname -r -s): $os_magic
Features: $os_osfeatures
Operational Mode: $os_op_mode
Shared?: \n"; if ($os_shared) echo "Yes"; else echo "No"; echo "
Must Clean?: \n"; if ($mustclean) echo "Yes"; else echo "No"; echo "
Next Osid: $nextosid
Internal ID: $osid
\n"; } # # Show ImageID record. # function SHOWIMAGEID($imageid, $edit, $isadmin = 0) { global $TBDBNAME; $query_result = DBQueryFatal("select * from images where imageid='$imageid'"); $row = mysql_fetch_array($query_result); $imagename = $row[imagename]; $pid = $row[pid]; $gid = $row[gid]; $description = stripslashes($row[description]); $loadpart = $row[loadpart]; $loadlength = $row[loadlength]; $part1_osid = $row[part1_osid]; $part2_osid = $row[part2_osid]; $part3_osid = $row[part3_osid]; $part4_osid = $row[part4_osid]; $default_osid= $row[default_osid]; $path = $row[path]; $loadaddr = $row[load_address]; $shared = $row[shared]; $globalid = $row["global"]; $creator = $row[creator]; $created = $row[created]; if ($edit) { if (!$description) $description = ""; if (!$path) $path = ""; if (!$loadaddr) $loadaddr = ""; } else { if (!$description) $description = " "; if (!$path) $path = " "; if (!$loadaddr) $loadaddr = " "; if (!$created) $created = "N/A"; } # # Generate the table. # echo "\n"; if ($edit) { $imageid_encoded = rawurlencode($imageid); echo "\n"; } echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; if ($part1_osid) { echo "\n"; } if ($part2_osid) { echo "\n"; } if ($part3_osid) { echo "\n"; } if ($part4_osid) { echo "\n"; } if ($default_osid) { echo "\n"; } echo "\n"; if (! $edit) { echo "\n"; } echo "\n"; echo "\n"; echo "\n"; echo "\n"; if ($edit) { echo "\n"; } echo "
Image Name: $imagename
Project: $pid
Group: $gid
Creator: $creator
Created: $created
Description: \n"; if ($edit) { echo ""; } else { echo "$description"; } echo "
Load Partition: $loadpart
Load Length: $loadlength
Partition 1 OS: "; SPITOSINFOLINK($part1_osid); echo "
Partition 2 OS: "; SPITOSINFOLINK($part2_osid); echo "
Partition 3 OS: "; SPITOSINFOLINK($part3_osid); echo "
Partition 4 OS: "; SPITOSINFOLINK($part4_osid); echo "
Boot OS: "; SPITOSINFOLINK($default_osid); echo "
Filename: \n"; if ($edit) { echo ""; } else { echo "$path"; } echo "
Types: \n"; $types_result = DBQueryFatal("select distinct type from osidtoimageid ". "where imageid='$imageid'"); if (mysql_num_rows($types_result)) { while ($row = mysql_fetch_array($types_result)) { $type = $row[type]; echo "$type   "; } } else { echo " "; } echo "
Shared?: \n"; if ($shared) echo "Yes"; else echo "No"; echo "
Global?: \n"; if ($globalid) echo "Yes"; else echo "No"; echo "
Internal ID: $imageid
Load Address: \n"; if ($edit && $isadmin) { echo ""; } else { echo "$loadaddr"; } echo "
\n"; } # # Show node record. # function SHOWNODE($node_id) { $query_result = DBQueryFatal("select n.*,na.*,r.vname,r.pid,r.eid,i.IP, ". "greatest(last_tty_act,last_net_act,last_cpu_act,". "last_ext_act) as last_act, ". " t.isvirtnode,t.isremotenode,r.erole as rsrvrole ". " from nodes as n ". "left join reserved as r on n.node_id=r.node_id ". "left join node_activity as na on n.node_id=na.node_id ". "left join node_types as t on t.type=n.type ". "left join interfaces as i on i.card=t.control_net ". " and i.node_id=n.node_id ". "where n.node_id='$node_id'"); if (mysql_num_rows($query_result) == 0) { TBERROR("The node $node_id is not a valid nodeid!", 1); } $row = mysql_fetch_array($query_result); $phys_nodeid = $row[phys_nodeid]; $type = $row[type]; $vname = $row[vname]; $pid = $row[pid]; $eid = $row[eid]; $bios = $row[bios_version]; $def_boot_osid = $row[def_boot_osid]; $def_boot_path = $row[def_boot_path]; $def_boot_cmd_line = $row[def_boot_cmd_line]; $next_boot_osid = $row[next_boot_osid]; $next_boot_path = $row[next_boot_path]; $next_boot_cmd_line = $row[next_boot_cmd_line]; $rpms = $row[rpms]; $tarballs = $row[tarballs]; $startupcmd = $row[startupcmd]; $routertype = $row[routertype]; $eventstate = $row[eventstate]; $state_timestamp = $row[state_timestamp]; $allocstate = $row[allocstate]; $allocstate_timestamp= $row[allocstate_timestamp]; $op_mode = $row[op_mode]; $op_mode_timestamp = $row[op_mode_timestamp]; $IP = $row[IP]; $isvirtnode = $row[isvirtnode]; $isremotenode = $row[isremotenode]; $ipport_low = $row[ipport_low]; $ipport_next = $row[ipport_next]; $ipport_high = $row[ipport_high]; $last_act = $row[last_act]; $last_tty_act = $row[last_tty_act]; $last_net_act = $row[last_net_act]; $last_cpu_act = $row[last_cpu_act]; $last_ext_act = $row[last_ext_act]; $last_report = $row[last_report]; $rsrvrole = $row[rsrvrole]; if (!$def_boot_cmd_line) $def_boot_cmd_line = " "; if (!$def_boot_path) $def_boot_path = " "; if (!$next_boot_path) $next_boot_path = " "; if (!$next_boot_cmd_line) $next_boot_cmd_line = " "; if (!$rpms) $rpms = " "; if (!$tarballs) $tarballs = " "; if (!$startupcmd) $startupcmd = " "; if (!$bios) $bios = " "; echo "\n"; echo "\n"; if ($isvirtnode) { if (strcmp($node_id, $phys_nodeid)) { echo "\n"; } } if ($vname) { echo "\n"; } if ($pid) { echo "\n"; echo "\n"; } echo "\n"; echo "\n"; if ($eventstate) { $when = strftime("20%y-%m-%d %H:%M:%S", $state_timestamp); echo "\n"; } if ($op_mode) { $when = strftime("20%y-%m-%d %H:%M:%S", $op_mode_timestamp); echo "\n"; } if ($allocstate) { $when = strftime("20%y-%m-%d %H:%M:%S", $allocstate_timestamp); echo "\n"; } # # We want the last login for this node, but only if its *after* the # experiment was created (or swapped in). # if ($lastnodeuidlogin = TBNodeUidLastLogin($node_id)) { $foo = $lastnodeuidlogin["date"] . " " . $lastnodeuidlogin["time"] . " " . "(" . $lastnodeuidlogin["uid"] . ")"; echo "\n"; } if ($last_act) { echo "\n"; $idletime = TBGetNodeIdleTime($node_id); echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; } if (!$isvirtnode && !$isremotenode) { echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; } elseif ($isvirtnode) { echo "\n"; echo "\n"; echo "\n"; } echo "\n"; echo "\n"; if (!$isvirtnode && !$isremotenode) { echo "\n"; } if (!$isvirtnode && !$isremotenode) { echo "\n"; } echo "\n"; if ($rsrvrole) { echo "\n"; } echo "\n"; if ($isremotenode) { if ($isvirtnode) { SHOWWIDEAREANODE($phys_nodeid, 1); } else { SHOWWIDEAREANODE($node_id, 1); } } echo "
Node ID: $node_id
Phys ID: $phys_nodeid
Virtual Name: $vname
Project: $pid
Experiment: $eid
Node Type: $type
Def Boot OS: "; SPITOSINFOLINK($def_boot_osid); echo "
EventState: $eventstate ($when)
Operating Mode: $op_mode ($when)
AllocState: $allocstate ($when)
Last Login: $foo
Last Activity: $last_act
Idle Time: $idletime hours
Last Act. Report: $last_report
Last TTY Act.: $last_tty_act
Last Net. Act.: $last_net_act
Last CPU Act.: $last_cpu_act
Last Ext. Act.: $last_ext_act
Def Boot Path: $def_boot_path
Def Boot Command Line: $def_boot_cmd_line
Next Boot OS: "; if ($next_boot_osid) SPITOSINFOLINK($next_boot_osid); else echo " "; echo "
Next Boot Path: $next_boot_path
Next Boot Command Line: $next_boot_cmd_line
IP Port Low: $ipport_low (sshd port)
IP Port Next: $ipport_next
IP Port High: $ipport_high
Startup Command: $startupcmd
Tarballs: $tarballs
RPMs: $rpms
Router Type: $routertype
Control Net IP: $IP
Role: $rsrvrole
Bios Version: $bios
\n"; } # # Show log. # function SHOWNODELOG($node_id) { $query_result = DBQueryFatal("select * from nodelog where node_id='$node_id'". "order by reported"); if (! mysql_num_rows($query_result)) { echo "
There are no entries in the log for node $node_id.
\n"; return; } echo "
Log for node $node_id.

\n"; echo "\n"; echo "\n"; while ($row = mysql_fetch_array($query_result)) { $type = $row[type]; $log_id = $row[log_id]; $reporter = $row[reporting_uid]; $date = $row[reported]; $entry = stripslashes($row[entry]); echo "\n"; } echo "
Delete? Date ID Type Reporter Entry
o $date $log_id $type $reporter $entry
\n"; } # # Show one log entry. # function SHOWNODELOGENTRY($node_id, $log_id) { $query_result = DBQueryFatal("select * from nodelog where ". "node_id='$node_id' and log_id=$log_id"); if (! mysql_num_rows($query_result)) { return; } echo "\n"; $row = mysql_fetch_array($query_result); $type = $row[type]; $log_id = $row[log_id]; $reporter = $row[reporting_uid]; $date = $row[reported]; $entry = stripslashes($row[entry]); echo "\n"; echo "
$date $log_id $type $reporter $entry
\n"; } # # Spit out an OSID link in user format. # function SPITOSINFOLINK($osid) { if (! TBOSInfo($osid, $osname, $pid)) return; echo "$osname\n"; } # # A list of widearea accounts. # function SHOWWIDEAREAACCOUNTS($uid) { $none = TBDB_TRUSTSTRING_NONE; $query_result = DBQueryFatal("SELECT * FROM widearea_accounts ". "WHERE uid='$uid' and trust!='$none' ". "order by node_id"); if (! mysql_num_rows($query_result)) { return; } echo "

Widearea Accounts

\n"; echo "\n"; while ($row = mysql_fetch_array($query_result)) { $node_id = $row[node_id]; $approved = $row[date_approved]; $trust = $row[trust]; if (TBTrustConvert($trust) != $TBDB_TRUST_NONE) { echo "\n"; echo "\n"; } } echo "
Node ID Approved Privs
$node_id $approved $trust
\n"; } # # Show widearea node record. Just the widearea stuff, not the other. # function SHOWWIDEAREANODE($node_id, $embedded = 0) { $query_result = DBQueryFatal("select * from widearea_nodeinfo ". "where node_id='$node_id'"); $row = mysql_fetch_array($query_result); if (! mysql_num_rows($query_result)) { return; } $contact_uid = $row[contact_uid]; $machine_type = $row[machine_type]; $connect_type = $row[connect_type]; $city = $row[city]; $state = $row[state]; $zip = $row[zip]; $country = $row[country]; if (! $embedded) { echo "\n"; } else { echo "\n"; } echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; if (! $embedded) { echo "
Widearea Info
Contact UID: $contact_uid
Machine Type: $machine_type
connect Type: $connect_type
City: $city
State: $state
ZIP: $zip
Country: $country
\n"; } } # # Stats # function SHOWUSERSTATS($uid) { $query_result = DBQueryFatal("SELECT * from user_stats where uid='$uid'"); if (! mysql_num_rows($query_result)) { return; } $row = mysql_fetch_assoc($query_result); # # Not pretty printed yet. # echo "\n"; foreach($row as $key => $value) { echo "\n"; } echo "
$key: $value
\n"; } function SHOWPROJSTATS($pid) { $query_result = DBQueryFatal("SELECT * from project_stats where pid='$pid'"); if (! mysql_num_rows($query_result)) { return; } $row = mysql_fetch_assoc($query_result); # # Not pretty printed yet. # echo "\n"; foreach($row as $key => $value) { echo "\n"; } echo "
$key: $value
\n"; } function SHOWGROUPSTATS($pid, $gid) { $query_result = DBQueryFatal("SELECT * from group_stats ". "where pid='$pid' and gid='$gid'"); if (! mysql_num_rows($query_result)) { return; } $row = mysql_fetch_assoc($query_result); # # Not pretty printed yet. # echo "\n"; foreach($row as $key => $value) { echo "\n"; } echo "
$key: $value
\n"; } function SHOWEXPTSTATS($pid, $eid) { $query_result = DBQueryFatal("select s.*,r.* from experiments as e ". "left join experiment_stats as s on s.exptidx=e.idx ". "left join experiment_resources as r on ". " r.idx=s.rsrcidx ". "where e.pid='$pid' and e.eid='$eid'"); if (! mysql_num_rows($query_result)) { return; } $row = mysql_fetch_assoc($query_result); # # Not pretty printed yet. # echo "\n"; foreach($row as $key => $value) { if ($key == "thumbnail") continue; echo "\n"; } echo "
$key: $value
\n"; } # # This is an included file. # ?>