vinterface to the underlying vlan so that tmcd knows how to find the
vlan tag.

directory is 755 and Mike wants it that way.

or the node_attributes table.

Note that I had to fix the query; the original select required that
the key be in the node_type_attributes table, else it would fail to
find it in the node_attributes table. In other words, I could not put
vgaonly on a specific node unless there was a definition in the
node_type_attributes table.

I've changed the query to use a "union" of two selects; this query is
intended to select certain attributes from node_type_attributes table,
but allow them to be overridden by entries in the node_attributes
table for the node making the request. The "union" of two selects,
allow results from the second select on node_attributes to overwrite
anything returned for the same key in the first select on
node_type_attributes.

This reverts commit a087c9e3.

Also add an option to do the control node ilo by hand.

devices with network interfaces. Emulab's spp and bbg nodes are
examples, but I did all that by hand inserting sql. An spp node is a
shared node with some interfaces. Users can allocate one or more of
those interfaces and establish vlans to the interfaces. The node is a
"fakenode" in "shared" mode, and everything else falls out. The mapper
assigns virtual nodes until all of the interfaces are allocated,
snmpit does its work on the interfaces, and the user then does the
rest.

Anyway, to added a special device:

  boss> wap addspecialdevice -s -t goober goober1

The -t argument is the name of the node type, created if it does not
exists. The last argument is the name of the fakenode to create in the
DB. The -s option says the special device is shared. Without -s, the
device is allocated exclusively.

Then to add interfaces to the device:

  boss> wap addspecialiface -b 1Gb -s cisco4,100,100 goober1 eth0

The -b option is the speed (either 100Mb or 1Gb). The -s option is the
switch side of the interface (switchname,card,port). The last two
arguments are the nodename and iface name for the interfaces table.

After the interface and wires table entry are added to the DB, snmpit
is called to put the switch port into tagged mode (if the node is
shared). To skip the snmpit step, add the -t option.

ilopswd.

Validate those SQL args!

NOTE: we also ensure that the reporting node is listed as a legit tip server
in the tipservers table. This means that capture may stop working on nodes
whose servers are not in the table! SQL update 291 will add any servers
listed in tiplines entries that are not in tipservers to prevent this breakage.

lengthy comment in the code (text from Ryan).

the parent osid, and can be used to select a different image to load,
sau FEDOR15-OPENVZ-STD. Does not work on shared nodes of course.

them to KEY.