GitLab

the node was temporarily given while it's configuring.

iface names

to the new_interfaces table.

which features and their weights can be placed, per node type.
ptopgen now includes these features in the ptop files it generates.

in the experiment_resources table as a BLOB. The advantages are no
more special directory and permission problems, and an archive of
pretty pictures of experiments (including per-modified experiments).

experiment_resources in revision 1.143.

when acting as a host for jails.

easier to chain back through the swapmod incarnations of an experiment,
without going through query hell, and is very useful in summary stats
page for calculating the usage across swapmods.

Note that the lastrsrc field of the experiments table can now go.

a null field is part of a primary key, there are no collisions. So
table_name "foo" and column_name NULL can have multiple rows, which is
bad.)

Also updated some state timeouts.

experiments are operated on by people other than the original creator.
The uid is currently a text field, but will need to change at some
point.

update V3 nodes to V4 CDs, and the new image. By inserting an entry
into this table, the node will update its image the next time it
reboots and checks in for instructions. The actual instructions are
hardwired in the web still, but this allows Dave to schedule updates
as needed. Eventually, the instructions will be part of the DB state
as well, but this works.

jail, to be added as an alias on the control network interface on the
phys node. There is no need for this to be in another table at this
point. Eventually, vnodes will be dynamic anyway, and a number of
things will change, including this.

will be the case for a trivial link with no underlying physical iface.

are packed 1) Add trivial_ok flag to virt_lans table. Global to the
lan or link, allow nodes in the lan or link to be colocated on the
same phys node. Perhaps make it per-node at some point. 2) Add
multiplex_factor to the experiments table to allow user to override
the multiplex_factor that is contained in the node_types table. Make
per type at some point.

   noswap_reason tinytext			- The reason they're unswappable
   idleswap tinyint(4) NOT NULL default '0'	- The idleswap bit (for auto. idleswap)
   idleswap_timeout int(4) NOT NULL default '0'	- The timeout for idleswap (in minutes)
   noidleswap_reason tinytext			- The reason they're non-idleswap
   autoswap tinyint(4) NOT NULL default '0'	- The autoswap bit
   autoswap_timeout int(4) NOT NULL default '0'	- The timeout for autoswap (in minutes)

The new form for expt create should fill these in, and swapin will update the idleswap
timeout if idleswap is set. Idlemail will read these and do the deed as needed.
They'll also get shown on the new expt display page.

As soon as we move to the new form, we can nuke priority.

Users can, via, moduserinfo, set a preferred shell.
One of {tcsh, bash, csh, sh}.
When users are created, they are given tcsh.
All users which already exist have been given tcsh.

to swap in/out/modify an experiment, so we can do proper accounting.

jailed nodes from veths for plain emulated links between phys nodes,
which we might generally allow at some point for supporting emulated
links (rather than using IP aliases). My plan is to use this im tmcd
to determine what ifconfig returns; no point in returning jailed veth
configuration when the node boots, but should wait until the jail is
setup (this is further complicated by rtabids, but thats another
story).

is not a string of bits, but really 0 when the type is unsigned.
Sheesh. Add link from testbed_stats to experiment_resources to get
better info in showstats.

per-experiment instantiation with aggregate data like the number of
swapins, the dates and the like. The other part is the per
swapin/modify stats. These are number of pnodes, links, lans,
etc. Long term, I think we want more precise swapin stats, and with
experiment modify in the mix, we need to have multiple stat records
per experiment, but do not need to duplicate all the stuff in the
other table just mentioned.

To reduce the amount the table size, we cross reference the tables by
index only instead of with pid,eid and the like. We use exptidx to
link experiments, experiment_stats, and the new experiment_resources
table. experiment_resources and stats are linked by another index in
the resources table, which indicates which is the current resource
row. On a modify, a new resource record is created, and the stats
record updated to point to the new (latest) resource record.

Web Changes: Improve showstats and showexpstats. Make them user
accessible so that mere users can see stats for themselves and for
their projects. No ability for mere users (PIs) to look at another
person's stats. Generally, these two pages need more work, but now
they are more useful. I added Show Stats to the user info and project
info pages to display per-usr/proj stats. Add more info in the
showstats display, but the showexpstats display is still not pretty
printed; just the raw tables.

Rename a few fields, add some indexes, and otherwise make some minor
changes that are sure to annoy everyone.

per-OS. Also, moved the functionality to check for this into libdb,
so we can call it from other places (like the batch daemon.)

we can create emulated links that use the veth device instead of an IP
alias. Without linux support, mere users would not get to choose this
option since it will only work between FreeBSD boxes with veth
support.

Unlike the interfaces table, veth interfaces come and go with
experiment swapin and swapout, with assignment to be done in
assign_wrapper. However, each veth maps to a real interface on a node,
as defined in the interfaces table, and the cross link is the "iface"
slot. There is a "mac" address since veth devices need a MAC, but I'm
not sure how that will be assigned yet. I am letting the DB do the
allocation of veth ids by making it an auto_increment field, and a
dual key of (node_id, veth_id). So, the DB will assign increasing
values per node_id, not globally to the table. Very slick.

but forgot to put in the real file.

swap_exitcode (last error), idle_swaps (a count), batch (a flag to
indicate a batch experiment).

Add a operational log. Okay, its not actually a log, but a table that
will grow forever until it consumes the earth. Its a small table
though, so it will take a few years. Its cross indexed with the
experiment_stats table, so by massaging this table along with the
stats table, we can get a good picture of what was running on the
testbed when, and how many resources it was using. Sorry, not a log
file, but we can easily generate a log file from tbe table if the Boss
really wants one. The table entry averages 28 bytes.

Move stats to their own main menu item (admin mode only). Remove from
the showexp_list page since that was bogus.

initstats.pl to fill in the tables as best as possible. Mostly a
hack job since we need Mac's scripts to go over the logs and really
fill in the info.

has the correct new_ tables in it.

as they primary key instead of the node_id, so that the latter can be
easily changed. Also added a timestamp the the new_nodes column.

been auto-discovered, but are waiting for the testbed admins to
'approve' them. They don't need nearly as much information as the
real nodes and interfaces tables.

who gets root on widearea nodes, inside and outside of jail. Kinda
brute force; might need to make this more flexible at some point,
perhaps with a node/user mapping table for widearearoot (root outside
the jail), and a widearea_trust slot to the group_membership table
(root inside a jail), but this will do for now since its handled
entirely inside of tmcd.

I was originally using local_root to determine root access inside the
jail, but we need to more finely control who gets root on widearea
nodes. Outside the jail, only tbadmin got jail, and thats definitely
too restrictive!

- Added 'Country' to users table
- Changed "Zip" to "ZIP/Postal Code"
- Reformatted Postal Address Forms

Changed sitevariables table to use 'varchar(255)' for
name column instead of 'text'.
Made name column primary key.