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

name, your idleswap time, and your unswappable/noidleswap reasons if
applicable. Also, make toggle send mail if people try to go unswappable or
turn off their idleswap bit.

them.

Make user profile toggle for admin mode use toggle.php too.)

Fix Eric's nit about showing no estimate before we have one to offer.

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.

system now to do scheduling. Instead just show last swap/modify time,
along with the uid of the person who did it.

Report on per-class node counts instead of the total number, since
with virtual nodes it is better to split that number up.

before was idle view of the expt list. Now it shows in all (non-thumb)
views.

I also added it to the right hand table in the expt page.

It also shows in the little expt lists in the user, group, and proj pages.
(I'm already really glad those got consolidated into a single function.)

Also cleaned up idle view a bit. Now that we show staleness and idle
ignore anyway, we don't need text tags for them, and we no longer need the
red dot that links to swap requests because of idlemail. So there's no
longer the weird double-column thing in idle view.

I'm still looking for a good way to non-intrusively mark expts in the expt
list as being unswappable, so if you think of anything, let me know.
(Maybe boldface, or a little lock icon or something?)

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.

show{user,group,proj,exp}.php3 pages.

While I'm at it, move the triplicated code into a single function inside
showstuff.php.

The first three are aggregate tables, while the experiment stats table
gets a record for each new experiment, and is updated when an
experiment is swapped in/out/modify or terminated. Look at the table
to see what is tracked. Once the experiment_stats record is updated,
the aggregate tables are updated as necessary. There are a bunch of
ugly changes to assign_wrapper to get the stats. Note that pnodes is
not incremented until an experiment sucessfully swaps in. This is in
leu of getting status codes; I'm not tracking failed operations yet,
nor creating the log file that Jay wants. I'll do that in the next
round of changes when we see how useful these numbers are.

Most of the changes are to create/delete table entries where
appropriate, and to display the records. Display is only under admin
mode, and the display is raw; just a dump of the assoc tables in php.
The last 100 experiment stats records are available via the Experiment
List page, using the "Stats" show option at the top. Bad place, but
will do for now.

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

soon be used by admins only to grant swappability. For now, it is open to
anyone who has expt modify access as well.

The change is visible everywhere SHOWEXP is called, like showexp.php3 for
instance.

Also introduced toggle.php, a generic toggle script, similar to
adminmode.php, but useful for just about anything. To add something, just
add it to the list, specify the valid values it can have, and add its
permission check and action. Now you don't need a different php page for
each toggle switch. This page is already set up to take over from
adminmode.php, but I didn't change things over just yet.

(Should this go in the changelog?)

Sort by vname is now the default sort, and you can sort by node_id (the
old sort), and by vname, by clicking on the column title, as usual.

It means nothing and just takes up space and may cause confusion, and is
easy to reenable as soon as we want to.

finally! These have been in the DB for a long time, but never used.
As Eric pointed out, its easier to get realistic address info from
people if we provide the right forms. The downside is that all current
users will have to adjust their info the next time they edit their
info. Thats okay. I thought about forcing all users to do it the next
time they log in, but I figured people would scream.

and when the last one was sent.

only pid, to pid/gid like most other things in the testbed. Also add a
"global" slot to denote images that are globally available to all
projects (system images). The older "shared" attribute is now used to
denote images that are shared within a project (available to all
subgroups in the project). The migration path for existing DBs is
given in the migrate file. Be sure to run those commands on an
existing testbed or things will break!

www/newimageid, www/newimageid_ez: A bunch of changes for
shared/global attributes. Added a group menu to the form so users can
create images in subgroups. Beefed up the Java code that constructs
the path name to use the gid, shared, and global attributes of the
form to give the user the best possible path that we can. Improved the
pathname checking code so that we do not allow just any old path in
case the user elects to disregard the path we carefully constructed
for them. Also check the proj/group membership, and setup defaults for
users that have permission in just one pid/gid to create images.

libdb.in: Changed permission check in TBImageIDAccessCheck() to
reflect shared/global attribute changes.

os_load: Get rid of test that checked path of the image. The path
checking is done in the web interface anyway, so why duplicate in 4
places. Other minor changes reflecting shared->global name change.
Also note that images can come from the group directory now.

create_image: Get rid of test that checked path of the image. The path
checking is done in the web interface anyway, so why duplicate in 4
places. Also note that images can come from the group directory now.

www/dbdefs: Changed permission check in TBImageIDAccessCheck() to
reflect shared/global attribute changes.

www/showimageid_list, www/showstuff: Minor global/shared attribute
changes.

www/menu: Change osids/imageids pointer to point to the image list,
not the osid list. This is more reasonable for mere users who have
access to the EZ form, and thus never really need to concern
themselves with osids.

www/editimageid: Add proper pathname checking. There were no checks at
all before!

 - Added a bunch of functions to get time of last activity, hours idle,
   and staleness for nodes and experiments.
 - Fixed the showexp_list page to use the new idle measures, including
   idle view. Idle view now runs in about 1.3 seconds instead of 13.
 - Changed all the "show" functions for nodes and expts to show idleness.

More changes will be coming, but I wanted to commit this before I install
it for real.

to a specific one, for the purposes of mapping things like FBSD-STD to
FBSD47-STD (the current OSID to use). This is technically more correct
than what os_setup used to do, which was map FBSD-STD to whatever
FreeBSD OSID was currently on the disk. Now it maps to a specific one,
and if that is not loaded, it sets up a reload.

Fixed missing '?' in GID link when showing group.

a call to existing routine in showstuff. Also changed the interface
to SHOWGROUPMEMBERS() so that priv people get a "remove from project"
option when showing the default group membership. Yes, project leaders
can now delete users from their project.

in his profile output.

Too noisy.