GitLab

them as an interface_type in the interfaces table, we should have
them.

in Utah.

Also add initialization of user_sslcerts to avoid serial number
conflict with initial certificates.

rather then a specific interface that no testbed is going to have in
their DB.

This should never have been there in the first place, and I don't want to
carry that hack forward into the post-frisbeelauncher world.

Basically, we cannot create an image descriptor without any types
defined, and we cannot create any types without a default image
descriptor. I broke the circle by adding a stub pc type into the
database fill file so that all Emulabs start with a predefined type.
Then you can load the descriptor file, create your actual types, and
then go back and edit the image descriptors to set the types those
images run on (you always had to do this).

pairs. Used only by the pool daemon, to control concurrency between
the pool daemon and mapper.

(also knows an integers).

* install/dump-descriptors <filename> will write out a set of insert
  statements for the images and os_info table, slightly munged. In
  fact, what I do is create temporary tables called temp_images and
  temp_os_info, clean them a bit, and then write out the insert
  statements to load them into new tables of the same name.

  There are some arrays at the top of this script that says what images and
  osids to write out.

* install/load-descriptors <filename> takes the output of
  dump-descriptors, creates the two temporary tables and loads the
  data into them. Then it (optionally) updates those tables with the
  local indicies of elabman and the emulab-ops project and group.

  Then it computes an osidtoimageid table for all class='pc' types. On a
  new testbed this is a reasonable approach, in my opinion.

  Next it takes the contents of the two temp tables and moves them across
  to the actual tables.

* install/descriptors.sql is the current data set which has everything
  contained in sql/database-fill-supplemental.sql and install/images/*

indexed by exptidx. I also got the last of the pid and pid,gid tables.

most of the rest of the tables in the system (still a few exceptions).
Bound to be some bugs ...

Prep for Mike Kasick report code.  Updated database schema and
installed hooks for his code.

Cleaned up how errors were handled in tblog(...).

Allow SENDMAIL to be called before the path is untained in '-T' scripts.

Other small changes.

node_types pxe_boot_path is going to be needed after all, so it has
made a triumphant return.

Finish off changes to consult the os_boot_cmd table when setting
def_boot_cmd_line.

	* db/libdb.pm.in: Add TBGetOSBootCmd function that returns the
	boot command line for an osid/role.

	* sql/database-fill-supplemental.sql: Add some queries that
	initialize the os_boot_cmd table.

	* tbsetup/assign_wrapper.in: For nodes that need linkdelays or
	inner elab boss nodes, set their command line using
	TBGetOSBootCmd.  Since the TBGetOSBootCmd function needs a "real"
	OSID to work, we resolve the nextosid for any meta OSIDs.

	* tbsetup/elabinelab.in: Add os_boot_cmd to the list of full
	tables to be dumped.

	* tbsetup/ns2ir/elabinelab-withfsnode.ns,
	tbsetup/ns2ir/elabinelab.ns: Remove boot command lines,
	assign_wrapper does it instead.

this file. If the entries already exist, the errors are silently
ignored.

       and default_firewall_rules.

Add OPSNODEBSD stated machine for aforementioned OSID.
Add a new trigger for aforementioned OSID that causes sbin/opsreboot
to be invoked whenever ops reboots.

filename to boot, and all local nodes will boot the same pxeboot kernel,
which has been extended to allow for jumping directly into a specific MFS
(in addition to the usual testbed boot into a partition or multiboot
kernel).

Bootinfo and the bootwhat protocol extended to tell the client node what
MFS to jump into directly, without a reboot. pxe_boot_path and
next_pxe_boot_path are now deprecated, with bootinfo used to control which
MFS to boot. Nodes now boot a single pxeboot kernel, and bootinfo tells
them what to do next.

Bootinfo greatly simplifed. temp_boot_osid has been added to allow for
temporary booting of different kernels (such as with ndoe_admin or
create_image). Unlike next_boot_osid which is a one-shot boot,
temp_boot_osid causes the node to boot that OS until told not too.

next_boot_path and def_boot_path in the nodes table are now ignored.
Bootinfo gets path info strictly from the os_info table entry for the osid
given in one of def_boot_osid, temp_boot_osid, or next_boot_osid.  This
makes the selection of what to do in bootinfo a lot simpler (and for
TBBootWhat in libdb). The os_info table also modified to include an MFS
flag so that bootinfo knows to tell the client that the path refers to an
MFS and not a multiboot kernel.

Change to boot sequence; free nodes no longer boot into the default OSID.
Instead, they are told to wait in pxeboot until told what to do, which
will typically be when the node is allocated and a specific OSID
picked. If the node needs to be reloaded, then the node is told to jump
directly into the Frisbee MFS, which saves one complete reboot cycle
whether the node has the requested OS installed, or not.  New program
added called "bootinfosend" that is used by node_reboot to "wake up" up
nodes sitting in pxewait mode, so that they query bootinfo again and boot.

node_reboot changed to look at the event state of a node, and use
bootinfosend to wake up nodes, rather then power cycle, since pxeboot does
not repsond to pings. Retry (if the UDP packet is lost) is handled by
stated.

Event support added to bootinfo, to replace the event generation that was
in proxydhcp. I have not included the caching that Mac had in proxydhcp
since it does not appear that bootinfo packets are lost very
often. Cleaned up all of the event and DB queury code to use lib/libtb for
DB access, and moved all of the event code into a separate file.  The
event sequence when a node boots now looks like this:

	'SHUTDOWN'    --> 'PXEBOOTING'  (BootInfo)
	'PXEBOOTING', --> 'PXEBOOTING'  (BootInfo Retry)
	'PXEBOOTING', --> 'BOOTING'     (Node Not Free)
	'PXEBOOTING', --> 'PXEWAIT'     (Node is Free)
	'PXEWAIT',    --> 'PXEWAKEUP'   (Node Allocated)
	'PXEWAKEUP',  --> 'PXEWAKEUP'   (Bootinfo Retry)
	'PXEWAKEUP',  --> 'PXEBOOTING'  (Node Woke Up)

Change stated to support resending PXEWAKEUP events when node times out.
After 3 tries, node is power cycled. Other minor cleanup in stated.

Clean up and simplify os_select, while adding support for temp_next_boot
and removing all trace of def_boot_path and next_boot_path processing.
Remove all pxe_boot_path and next_pxe_boot_path processing.  Changed
command line interface to support "clearing" fields. For example,
node_admin changed to call os_select like this to have the node
temporarily boot the FreeBSD MFS:

	os_select -t FREEBSD-MFS pcXXX

which sets temp_boot_osid. To turn admin mode off:

	os_select -c -t pcXXX

which says to clear temp_boot_osid.

sql/database-fill-supplemental.sql modifed to add os_info table
entries for the FreeBSD, Frisbee, and newnode MFS's.

Be sure to change dhcpd config, restart dhcp, kill proxydhcp, restart
bootinfo,

Various things that need to go into new sites' databases, but don't really fit
into database-fill.sql, which is auto-generated. Also, unlike the contents of
database-fill.sql, inserting these is not idempotent, since a site may have
changed them for some reason.