1. 07 Jan, 2009 1 commit
    • Leigh B. Stoller's avatar
      Various changes to support storing control network vlans in · f55e466c
      Leigh B. Stoller authored
      the DB, and eventually elabinelab firewalls.
      
             # Allow arbitrary the names for the ids. Forgot who wanted this.
             alter table elabinelab_vlans change `inner_id`
                      `inner_id` varchar(32) NOT NULL default '';
             alter table elabinelab_vlans change `outer_id`
                      `outer_id` varchar(32) NOT NULL default '';
      
             # Tag elabinelab created vlans with the stack module.
             alter table elabinelab_vlans add `stack`
                 enum('Control','Experimental') NOT NULL default 'Experimental';
      
             # Tag vlans softstate table with the stack module.
             alter table vlans add `stack`
                 enum('Control','Experimental') NOT NULL default 'Experimental';
      
             # A new table, to store softstate on interfaces. snmpit will
             # modify this table whenever a port is enabled/trunked(tagged)
             # on the command line. Eventually speed/duplex should go here.
             CREATE TABLE `interface_state` (
      	  `node_id` varchar(32) NOT NULL default '',
      	  `card` tinyint(3) unsigned NOT NULL default '0',
      	  `port` tinyint(3) unsigned NOT NULL default '0',
      	  `iface` varchar(32) NOT NULL,
      	  `enabled` tinyint(1) default '1',
      	  `tagged` tinyint(1) default '0',
      	  PRIMARY KEY  (`node_id`,`card`,`port`),
      	  KEY `nodeiface` (`node_id`,`iface`)
      	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
      
      	# Initialize the above table.
      	insert into interface_state (node_id,card,port,iface)
      	   select node_id,card,port,iface from interfaces;
      
      	# Cleanup the vlans table which was filling with cruft
      	# cause of a bug in the swapout code. Finally figured
      	# out how to combine delete and join!
      	delete v FROM vlans v LEFT JOIN lans l on l.lanid=v.id
      	       WHERE l.lanid IS NULL;
      
              # Fix an unrelated bug; slot overflow.
              alter table nodelog change `log_id`
                      `log_id` int(10) unsigned NOT NULL auto_increment;
      f55e466c
  2. 11 Dec, 2008 1 commit
  3. 08 Dec, 2008 1 commit
  4. 04 Dec, 2008 1 commit
  5. 17 Nov, 2008 1 commit
    • Leigh B. Stoller's avatar
      Minor changes to user certs to support certificate revocation lists · 4809cd65
      Leigh B. Stoller authored
      in the protogeni code. We no longer save the unencrypted certs after
      they are revoked, since protogeni will ignore them. I redid the the
      DB table as well, adding a revoked stamp, and the DN so that we can
      generate the CRL list from the DB directly, without having to run them
      all through openssl.
      
      This commit requires all certs to be regenerated, and the ssl xmlrpc
      server to be restarted.
      4809cd65
  6. 07 Nov, 2008 1 commit
  7. 20 Oct, 2008 1 commit
  8. 17 Oct, 2008 1 commit
  9. 05 Sep, 2008 1 commit
  10. 28 Aug, 2008 1 commit
  11. 20 Aug, 2008 1 commit
  12. 19 Aug, 2008 1 commit
  13. 28 Jul, 2008 2 commits
  14. 21 Jul, 2008 1 commit
  15. 17 Jul, 2008 1 commit
  16. 16 Jul, 2008 1 commit
  17. 11 Jul, 2008 2 commits
  18. 10 Jul, 2008 2 commits
  19. 08 Jul, 2008 1 commit
  20. 05 Jul, 2008 1 commit
  21. 11 Jun, 2008 3 commits
    • Kevin Atkinson's avatar
      · e7436fd8
      Kevin Atkinson authored
      Update database-create.sql from last commit.
      e7436fd8
    • Kevin Atkinson's avatar
      · 425c4b89
      Kevin Atkinson authored
      Set the charset for all emulab pages to utf-8 which is needed to
      display foreign names correctly.  Also added three rows to table_regex:
      tinytext_utf8, text_utf8, fulltext_utf8
      
      Enhanced form_defs.php:
      
        - Add Support for Textarea
      
        - Add Support for a vertical list, for example see Category in
          submitpub.php
      
        - Add support for dumping the form values in plain text, used in the
          email I send to testbed-ops.
      
        - Change Error Reporting text for subfields such as in a list so
          they also include the text from the outer field, for example in
          newosid "ping" will become "OS Features, ping".  I needed this
          since some of my subfields didn't have labels and it seamed like
          the right thing to do.
      
        - Set #return_value to 1 in FormRenderCheckBox if it not already
          specified
      
        - In FormRenderSelect, if the #value is not in the list add it to
          the end.
      
        - Add support for "display" type, to just display some text in the
          table
      
        - Possibly some other little things I forgot about.
      
      New site variable PUBSUPPORT.
      
      Implement FS#201: Provide users a way to add a paper that used Emulab
      see (https://users.emulab.net/flyspray/?do=details&id=201), summary of
      changes:
      
        - Controlled via the new site variable PUBSUPPORT.
      
        - The emulab_papers spread sheet is now frozen all new changes
          should be made using the new system.
      
        - New pages submitpub.php for users to submit a new publication
          with different views for admins and non-admins.
      
        - New page expubs.php to replace doc/expubs.html, lists publications
          in database.  Also allows admins to edit publications.
      
        - Project members can edit papers associated with the project as
          long as they have local_root or higher privileges. Papers for a
          project are listed under a new tab in the showproject page. I keep
          track of the last person to edit the paper submission in addition
          to who initially submitted it.
      
        - Users can modify papers they submitted which is needed if the
          project was N/A. Papers users submitted now appear in a new tab in
          the showuser page.
      
        - Script to import spreadsheet to the database is in
          utah/bibliography/emulab_pubs-import.pl.
      
        - Changes web pages that point to doc/expubs.html to instead point
          to expubs.php
      425c4b89
    • Leigh B. Stoller's avatar
      Add uuids to the interfaces table. · 357df448
      Leigh B. Stoller authored
      357df448
  22. 03 Jun, 2008 1 commit
  23. 30 May, 2008 1 commit
  24. 20 May, 2008 1 commit
  25. 19 May, 2008 1 commit
  26. 13 May, 2008 2 commits
  27. 12 May, 2008 1 commit
  28. 09 May, 2008 1 commit
    • Kevin Atkinson's avatar
      Make project approval mail truly anonymous. Also make membership · 503bb661
      Kevin Atkinson authored
      acceptance email truly anonymous.  A few other emails related to
      project membership are still not anonymous though.  New function
      AnonSENDMAIL in libtestbed which will try to make sure there is no
      trace of the current user in the mail sent.
      
      For now, stop sending membership approval related email to the project
      admin list since this will also go to testbed-approval.  There is also
      some code to remove testbed-approval from the proj-admin list after
      the acceptance email but this is disabled for now since some times people
      reply to the approval email.
      503bb661
  29. 01 May, 2008 1 commit
    • Kevin Atkinson's avatar
      Implemt FS#187 -- Show admin history of projects: · 8054f5f8
      Kevin Atkinson authored
        When a project is initially created a new mailing list is created,
        PROJ-admin@emulab.net.
      
        testbed-approval is subscribed to the list
      
        Several emails that originally went to testbed-approval now go to the
        mailing list instead.  The From, To, fields are basically the same
        with testbed-approval becoming PROJ-admin.  This means some mail
        is sent with a From PROJ-admin and Bcc the mailing list.  Note that
        some mail still goes to testbed-approval directly, in particular
        ones where there is no clear project involved, and when a project is
        denied.
      
        In addition notifications of approval status of new members is also
        sent to the list.  These emails use to only go to testbed-audit@.
      
        Currently All mail sent to PROJ-admin is also sent to testbed-audit
        (via a Bcc).  This means that some mail that didn't use to go to
        testbed-audit now does.
      
        The mailing list is deleted when a project is deleted with out first
        being approved.  Becuase of this notified that a project is denied
        is sent to testbed-approval instead of PROJ-admin.
      
        Admins can access the mailing list from the Project Profile page.
      
        The mailing list is open in order to allow users to reply to the
        mailing list, in addition the check that PROJ-admin is in the To or
        CC field is disabled.  There is currently no spam control on the
        mailing lists.  However, since the mailing list address is not posted
        anywhere it should't pick up to much spam.  If it does we can deal
        with it then.
      
        Finally, a new script is created to create the per-project admin
        mailing list.  See doc/UPDATING.
      
      Also add DBQuerySingleFatal to libdb, which is like DBQueryFatal but
      also fails if the query didn't return any results.  Basically
      identical to he version in libtblog.  Eventually libtblog should be
      modified to use this version.
      8054f5f8
  30. 17 Apr, 2008 3 commits
  31. 24 Mar, 2008 2 commits