1. 23 Jun, 2003 1 commit
  2. 18 Jun, 2003 2 commits
  3. 06 Jun, 2003 1 commit
  4. 05 Jun, 2003 1 commit
    • Leigh B. Stoller's avatar
      Add widearea_updates table. A very simple mechanism to let Dave auto · 39083d0e
      Leigh B. Stoller authored
      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.
      39083d0e
  5. 03 Jun, 2003 1 commit
  6. 30 May, 2003 1 commit
  7. 28 May, 2003 1 commit
  8. 27 May, 2003 2 commits
    • Leigh B. Stoller's avatar
      Add two crude controls to allow the user to change how virtual nodes · 76c37c50
      Leigh B. Stoller authored
      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.
      76c37c50
    • Mac Newbold's avatar
      Add the new fields related to our new swapping features: · de553419
      Mac Newbold authored
         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.
      de553419
  9. 20 May, 2003 2 commits
  10. 19 May, 2003 1 commit
  11. 15 May, 2003 4 commits
    • Leigh B. Stoller's avatar
    • Leigh B. Stoller's avatar
      Add vnode to veth_interfaces. This serves to distinguish veths for · 01432ea6
      Leigh B. Stoller authored
      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).
      01432ea6
    • Leigh B. Stoller's avatar
      A few more minor changes. Change exitcode to signed since in mysql, -1 · e6644faa
      Leigh B. Stoller authored
      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.
      e6644faa
    • Leigh B. Stoller's avatar
      Split the experiment stats table into two parts. The first is the · a382994d
      Leigh B. Stoller authored
      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.
      a382994d
  12. 14 May, 2003 1 commit
  13. 12 May, 2003 1 commit
  14. 09 May, 2003 1 commit
  15. 05 May, 2003 1 commit
    • Leigh B. Stoller's avatar
      Add veth_interfaces table for configuring new veth virtual interfaces. · 451dfa08
      Leigh B. Stoller authored
      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.
      451dfa08
  16. 01 May, 2003 1 commit
  17. 28 Apr, 2003 4 commits
  18. 23 Apr, 2003 1 commit
  19. 22 Apr, 2003 1 commit
  20. 18 Apr, 2003 1 commit
    • Leigh B. Stoller's avatar
      Add widearearoot and wideareajailroot to the users table, to control · 4154972a
      Leigh B. Stoller authored
      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!
      4154972a
  21. 17 Apr, 2003 2 commits
  22. 14 Apr, 2003 2 commits
  23. 10 Apr, 2003 4 commits
    • Chad Barb's avatar
      · 179b3635
      Chad Barb authored
      Changed sitevariables table to use 'varchar(255)' for
      name column instead of 'text'.
      Made name column primary key.
      179b3635
    • Chad Barb's avatar
      Added 'external_node_id' field to widearea_nodeinfo. · dc9ca2e4
      Chad Barb authored
      This is pretty much a comment field for now;
      NULL is a safe value, but if a node is a RON node
      "ron:" followed by the name of the node in the ron
      hosts table (in the external-to-emulab ron db) is
      the preferred value. (This may facilitate automatic
      db synchronization later.)
      dc9ca2e4
    • Chad Barb's avatar
      · 9e63ec4b
      Chad Barb authored
      Changed widearea_nodeinfo address columns to tinytext,
      to make them consistent with users table.
      9e63ec4b
    • Chad Barb's avatar
      · 892fef45
      Chad Barb authored
      Added 'sitevariables' table.
      
      This is the table prompted by Mac's email yesterday, which
      can contain site-specific configuration options.
      
      'default' _must_ be set for each row, and will be used if
      'value' is NULL.
      
      'description' _should_ be set for each row.
      
      The table doesn't have a primary key, but is indexed to
      32 characters on the "name" column, so it should be plenty efficient.
      
      libdb functions and web interface forthcoming...
      892fef45
  24. 04 Apr, 2003 2 commits
    • Leigh B. Stoller's avatar
      Add "Address Line 2", City, State, and Zip as independent entities, · 5e38412f
      Leigh B. Stoller authored
      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.
      5e38412f
    • Chad Barb's avatar
      · 6294daba
      Chad Barb authored
      Instructions for adding 'webnews' table.
      6294daba
  25. 26 Mar, 2003 1 commit
    • Leigh B. Stoller's avatar
      Add "gid" slot to the images table for changing permission scheme from · 4c56daf6
      Leigh B. Stoller authored
      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!
      4c56daf6