Page History

...

id - id of module
name - name of module
prettyname - more descriptive name of module
description - description of module
perlpackage - string to use when including this module in perl scripts

...

nathost

This table contains information about OSes VCL knows abouttracks which management nodes and computers are configured to function as NAT hosts.

id - id of entry
name - name of entry
prettyname - more descriptive name of OS
type resourceid - reference to OStype.name - windows, linux, unix, etc
installtype - reference to OSinstalltype.name - none, partimage, kickstart, etc
sourcepath - ??
moduleid - reference to module.id - module that handles this OS

OSinstalltype table

This table is a list of the ways an image can be installed.

id - id of entry
name - name of entry

OStype table

This table contains a list of OS types VCL knows about - linux, unix, windows, etc.

id - id of entry
name - name of entry

platform table

This table contains a list of platforms VCL knows about - i386, i386_lab (special case for lab machines), and ultrasparc.

id - id of entry
name - name of entry

privnode table

This table contains all of the nodes that make up the Privilege Tree on the Privileges page.

id - id of entry
parent - reference to privnode.id - parent of this node
name - name of entry

provisioning table

This table contains all of the provisioning modules that are part of vcld.

id - id of entry
name - name of entry
prettyname - more descriptive name of provisioning method
moduleid - reference to module.id - id of module that handles this provisioning method

provisioningOSinstalltype table

This table is a mapping of which provisioning methods can handle which OS install types.

provisioningid - reference to provisioning.id
OSinstalltypeid - reference to OSinstalltype.id

querylog table

This table contains an entry for every query performed by the frontend that modifies the database (i.e. everything but SELECT statements).

userid - reference to user.id
timestamp - date/time of query
mode - mode of site when query performed
query - string of query

request table

resource.id matching management node or computer
publicIPaddress - public IP address of the NAT host; this is the node's IP address on the public Internet
internalIPaddress - internal IP address of NAT host; this is the node's IP address on the internal network over which the NAT host can communicate with the compute nodes

nathostcomputermap

This table tracks which compute nodes are assigned to which NAT hosts.

nathostid - reference to nathost.id
computerid - reference to computer.id

natlog

This table logs information about the NAT configuration used by each reservation.

sublogid - reference to sublog.id
nathostresourceid - reference to resource.id corresponding to resource.id of management node or computer that was acting as the NAT host for the reservation
publicIPaddress - public IP address of the NAT host during the time of the reservation
publicport - port on public IP address that was forwarded to the compute node during the reservation
internalIPaddress - internal IP address of compute node during the reservation
internalport - port on compute node to which traffic was forwarded during the reservation
protocol - protocol (TCP or UDP) of the port that was being forwarded
timestamp - time at which the port fowarding was set up

natport

This table tracks which public ports are currently being fowarded by the NAT hosts to the compute nodes.

reservationid - reference to reservation.id
nathostid - reference to nathost.id
publicport - public port being forwarded
connectmethodportid - reference to connectmethodport.id

openstackcomputermap

This table tracks which OpenStack instance ids correspond to which computer ids.

instanceid - OpenStack instance id
computerid - reference to computer.id

openstackimagerevision

This table records additional information about image revisions related to OpenStack.

imagerevisionid - reference to imagerevision.id
imagedetails - additional OpenStack image details
flavordetails - additional OpenStack flavor details

OS table

This table contains information about OSes VCL knows aboutThis table contains information about every current or future reservation. Only a single entry exists in this table for cluster reservations.

id - id of entry
stateid - reference to state.id - current state of reservation
userid name - name of entry
prettyname - more descriptive name of OS
type - reference to user.id
laststateid OStype.name - windows, linux, unix, etc
installtype - reference to state.id - last state of reservation
logid - reference to log.id - log entry for reservation
forimaging - 0 for normal reservation, 1 for imaging
test - ??
preload - ??
start - date/time for start of reservation
end - date/time for end of reservation
daterequested - date/time reservation submitted
datemodified - date/time reservation modified
checkuser - flag to tell if reservation should be timed out if user is disconnect for > 15 minutes - 0 not to do timeout, 1 to do timeout

reservation table

OSinstalltype.name - none, partimage, kickstart, etc
minram - minimum RAM required by the OS; nodes provisioned with images based on this OS will at least have this amount of RAM
sourcepath - ??
moduleid - reference to module.id - module that handles this OS

OSinstalltype table

This table is a list of the ways an image can be installed.

id - id of entry
name - name of entry

OStype table

This table contains a list of OS types VCL knows about - linux, unix, windows, etc.

id - id of entry
name - name of entry

platform table

This table contains a list of platforms VCL knows about - i386, i386_lab (special case for lab machines), and ultrasparc.

id - id of entry
name - name of entry

privnode table

This table contains all of the nodes that make up the Privilege Tree on the Privileges pageThis table contains information about every current or future reservation. There will be one entry in this table corresponding to each entry in the request table for normal reservations, and multiple entries (one for each node) in this one for each entry in the request table for cluster reservations.

id - id of entry
requestid parent - reference to requestprivnode.id - corresponding entry in request table
computerid - reference to computer.id - computer assigned to this reservation
imageid - reference to image.id - image deployed on computer
imagerevisionid - reference to imagerevision.id - image revision to be deployed on computer
managementnodeid - reference to managementnode.id - management node handling this reservation
remoteIP - IP address of user's machine
lastcheck - date/time reservation last checked by vcld
pw - user's password for reservation - leave empty to signify user should use enterprise authentication password
connectIP - (unused)
connectport - (unused)

reservationaccounts table

This table contains userids and passwords for additional accounts for server reservations. There is not an entry for the owner of the reservation. These correspond to the admin and login user groups.

reservationid - reference to reservation.id
userid - reference to user.id
password - user's password for this reservation

resource table

This table contains an entry for every resource VCL knows about. Every resource has a unique id from this table, and a sub id from a resource specific table (computer, image, management node, etc).

id - id of entry
resourcetypeid - reference to resourcetype.id - type of this resource
subid - reference to id from specific resource table (computer.id, image.id, managementnode.id, etc)

resourcegroup table

This table contains all of the resource groups.

id - id of entry
name - name of entry
ownerusergroupid - reference to usergroup.id - user group that owns this resource group
resourcetypeid - reference to resourcetype.id - type of this resource group

resourcegroupmembers table

This table contains a list of which resources are in which resource groups.

resourceid - reference to resource.id
resourcegroupid - reference to resourcegroup.id

resourcemap table

This table contains which resource groups map to other resource groups.

resourcegroupid1 - reference to resourcegroup.id
resourcetypeid1 - reference to resourcetype.id
resourcegroupid2 - reference to resourcegroup.id
resourcetypeid2 - reference to resourcetype.id

resourcepriv table

This table contains the attributes that can be granted to resource groups.

id - id of entry
resourcegroupid - reference to resourcegroup.id - resource group being assigned attribute
privnodeid - reference to privnode.id - node where attribute being assigned
type - block, cascade, available, administer, manageGroup, or manageMapping - attribute being assigned at node

resourcetype table

This table contains a list of all the resource types.

id - id of entry
name - name of entry

schedule table

- parent of this node
name - name of entry

provisioning table

This table contains all of the provisioning modules that are part of vcld.

id - id of entry
name - name of entry
prettyname - more descriptive name of provisioning method
moduleid - reference to module.id - id of module that handles this provisioning method

provisioningOSinstalltype table

This table is a mapping of which provisioning methods can handle which OS install types.

provisioningid - reference to provisioning.id
OSinstalltypeid - reference to OSinstalltype.id

querylog table

This table contains an entry for every query performed by the frontend that modifies the database (i.e. everything but SELECT statements).

userid - reference to user.id
timestamp - date/time of query
mode - mode of site when query performed
query - string of query

request table

This table contains information about every current or future reservation. Only a single entry exists in this table for cluster reservations.

id - id of entry
stateid - reference to state.id - current state of reservation
userid - reference to user.id
laststateid - reference to state.id - last state of reservation
logid - reference to log.id - log entry for reservation
forimaging - 0 for normal reservation, 1 for imaging
test - ??
preload - ??
start - date/time for start of reservation
end - date/time for end of reservation
daterequested - date/time reservation submitted
datemodified - date/time reservation modified
checkuser - flag to tell if reservation should be timed out if user is disconnect for > 15 minutes - 0 not to do timeout, 1 to do timeout

reservation table

This table contains information about every current or future reservation. There will be one entry in this table corresponding to each entry in the request table for normal reservations, and multiple entries (one for each node) in this one for each entry in the request table for cluster reservations.

id - id of entry
requestid - reference to request.id - corresponding entry in request table
computerid - reference to computer.id - computer assigned to this reservation
imageid - reference to image.id - image deployed on computer
imagerevisionid - reference to imagerevision.id - image revision to be deployed on computer
managementnodeid - reference to managementnode.id - management node handling this reservation
remoteIP - IP address of user's machine
lastcheck - date/time reservation last checked by vcld
pw - user's password for reservation - leave empty to signify user should use enterprise authentication password
connectIP - (unused)
connectport - (unused)

reservationaccounts table

This table contains userids and passwords for additional accounts for server reservations. There is not an entry for the owner of the reservation. These correspond to the admin and login user groups.

reservationid - reference to reservation.id
userid - reference to user.id
password - user's password for this reservation

resource table

This table contains an entry for every resource VCL knows about. Every resource has a unique id from this table, and a sub id from a resource specific table (computer, image, management node, etc)This table contains all of the schedules available.

id - id of entry
name - name of entry
ownerid - resourcetypeid - reference to userresourcetype.id - owner of schedule

...

type of this resource
subid - reference to id from specific resource table (computer.id, image.id, managementnode.id, etc)

resourcegroup table

This table contains all of the starts/ends of the time slots for each schedule. Schedules are what times during a week that computers are available. They run from midnight Sunday morning (0) to midnight Sunday morning one week later (10080).

scheduleid - reference to schedule.id
start - start of time slot in minutes since midnight Sunday morning
end - end of time slot in minutes since midnight Sunday morning

...

resource groups.

id - id of entry
name - name of entry
ownerusergroupid - reference to usergroup.id - user group that owns this resource group
resourcetypeid - reference to resourcetype.id - type of this resource group

resourcegroupmembers table

This table contains all of the server profiles.

id - id of entry
name - name of entry
description - info about profile
imageid - reference to image.id
ownerid - reference to user.id - owner of this profile
ending - specified or indefinite - how reservations for this profile will typically end
fixedIP - IP address reservations for this profile will typically use
fixedMAC - MAC address reservations for this profile will typically use
admingroupid - reference to usergroup.id
logingroupid - reference to usergroup.id
monitored -

serverrequest table

a list of which resources are in which resource groups.

resourceid - reference to resource.id
resourcegroupid - reference to resourcegroup.id

resourcemap table

This table contains which resource groups map to other resource groups.

resourcegroupid1 - reference to resourcegroup.id
resourcetypeid1 - reference to resourcetype.id
resourcegroupid2 - reference to resourcegroup.id
resourcetypeid2 - reference to resourcetype.id

resourcepriv table

This table contains the attributes that can be granted to resource groupsThis table contains an entry for each server reservation.

id - id of entry
serverprofileid resourcegroupid - reference to serverprofileresourcegroup.id - 0 if no profile used or too many items changed from profile
requestid resource group being assigned attribute
privnodeid - reference to requestprivnode.id - main request entry associated with this server reservation
fixedIP - IP address to use on deployed machine
fixedMAC - MAC address to use on deployed machine
admingroupid - reference to usergroup.id - user group containing users that should be able to control this reservation and have admin access to the machine
logingroupid - reference to usergroup.id - user group containing users that should be only be able to log in to this machine (will see reservation, but only the Connect button)
monitored - 1 to have this reservation monitored, 0 otherwise

shibauth table

node where attribute being assigned
type - block, cascade, available, administer, manageGroup, or manageMapping - attribute being assigned at node

resourcetype table

This table contains a list of all the resource types.

id - id of entry
name - name of entry

schedule table

This table contains all of the schedules availableThis table contains authentication information related to shibboleth logins.

id - id of entry
userid name - name of entry
ownerid - reference to user.id - user entry associated with
ts - date/time entry was inserted
sessid - shib session id
data - various shibboleth related data passed in from httpd

...

owner of schedule

scheduletimes table

This table contains an entry for any active or upcoming scheduled site maintenance windows.

id - id of entry
start - date/time for start of maintenance window
end - date/time for end of maintenance window
ownerid - reference to user.id - owner of this entry
created - date/time entry created
reason - info about why maintenance is scheduled
usermessage - message that will be displayed to users about the maintenance
informhoursahead - hours before the start time that a warning should be displayed on the VCL site about upcoming maintenance
allowreservations - 1 to allow reservations to be scheduled ahead of time that overlap with the window, 0 to keep overlapping future reservations from being scheduled

state table

This table contains all of the states used in VCL. Not all states are used any place where states are used. For example, there are states used in the request table that are not used in the computer table.

id - id of entry
name - name of entry

statgraphcache table

This table contains cached values for the stat graphs. Some of the data points take enough computation time that it is prohibitive to calculate them for really long periods of time. This table allows historical points to computed once and then saved forever.

graphtype - totalres, concurres, concurblade, or concurvm - type of graph for this entry
statdate - date for this entry
affiliationid - affiliation for this entry
value - data point value for this entry

subimages table

This table contains a list of sub images associated with any clusters.

imagemetaid - reference to imagemeta.id
imageid - reference to image.id - subimage associated with imagemetaid

...

all of the starts/ends of the time slots for each schedule. Schedules are what times during a week that computers are available. They run from midnight Sunday morning (0) to midnight Sunday morning one week later (10080).

scheduleid - reference to schedule.id
start - start of time slot in minutes since midnight Sunday morning
end - end of time slot in minutes since midnight Sunday morning

semaphore

This table is used by the web frontend to create semaphore locks on computers being considered to assign to reservations. Entries in this table typically are removed within less than a second of being added. This table was introduced in 2.4.2 to allow multiple web servers to be used in an active/active configuration.

computerid - reference to computer.id
imageid - reference to image.id
imagerevisionid - reference to imagerevision.id
managementnodeid - reference to management.id
expires - time at which this semaphore will expire
procid - unique identifier for each web server process

serverprofile table

This table contains all of the server profiles.

id - id of entry
name - name of entry
description - info about profile
imageid - reference to image.id
ownerid - reference to user.id - owner of this profile
ending - specified or indefinite - how reservations for this profile will typically end
fixedIP - IP address reservations for this profile will typically use
fixedMAC - MAC address reservations for this profile will typically use
admingroupid - reference to usergroup.id
logingroupid - reference to usergroup.id
monitored - (unused) the intention of this field was to flag if reservations for this profile should be integrated in to a monitoring system

serverrequest table

This table contains an entry for each computer that was part of a log table entry. For normal reservations, this is a single entry; for cluster reservations, it is one entry for each subimage.

logid - reference to log.id - corresponding entry in log table
imageid - reference to image.id - image deployed for this reservation
imagerevisionid - reference to imagerevision.id - image revision deployed for this reservation
computerid - reference to computer.id - computer deployed for this reservation
IPaddress - IP address of computer during this deploy
managementnodeid - reference to managementnode.id - management node that handled this deploy
predictivemoduleid - reference to module.id - prediction module used to load image when this reservation finished ??
hostcomputerid - reference to computer.id - for VMs, this was the host the VM was deployed to

user table

server reservation.

id - id of entry
name - name of the server reservation
serverprofileid - reference to serverprofile.id - 0 if no profile used or too many items changed from profile
requestid - reference to request.id - main request entry associated with this server reservation
fixedIP - IP address to use on deployed machine
fixedMAC - MAC address to use on deployed machine
admingroupid - reference to usergroup.id - user group containing users that should be able to control this reservation and have admin access to the machine
logingroupid - reference to usergroup.id - user group containing users that should be only be able to log in to this machine (will see reservation, but only the Connect button)
monitored - (unused) 1 to have this reservation monitored, 0 otherwise

shibauth table

This table contains authentication information related to shibboleth loginsThis table contains an entry for every user that has every logged in to VCL.

id - id of entry
userid - reference to user.id - user entry associated with
ts - date/time entry was inserted
sessid - shib session id
data - various shibboleth related data passed in from httpd

sitemaintenance table

This table contains an entry for any active or upcoming scheduled site maintenance windows.

id - id of entry
start - date/time for start of maintenance window
end - date/time for end of maintenance window
ownerid - reference to user.id - owner of this entry
created - date/time entry created
reason - info about why maintenance is scheduled
usermessage - message that will be displayed to users about the maintenance
informhoursahead - hours before the start time that a warning should be displayed on the VCL site about upcoming maintenance
allowreservations - 1 to allow reservations to be scheduled ahead of time that overlap with the window, 0 to keep overlapping future reservations from being scheduled

state table

This table contains all of the states used in VCL. Not all states are used any place where states are used. For example, there are states used in the request table that are not used in the computer table.

id - id of entry
name - name of entry

statgraphcache table

This table contains cached values for the stat graphs. Some of the data points take enough computation time that it is prohibitive to calculate them for really long periods of time. This table allows historical points to computed once and then saved forever.

graphtype - totalres, concurres, concurblade, or concurvm - type of graph for this entry
statdate - date for this entry
affiliationid - affiliation for this entry
value - data point value for this entry
provisioningid - reference to provisioning.id

subimages table

This table contains a list of sub images associated with any clusters.

imagemetaid - reference to imagemeta.id
imageid - reference to image.id - subimage associated with imagemetaid

sublog table

This table contains an entry for each computer that was part of a log table entry. For normal reservations, this is a single entry; for cluster reservations, it is one entry for each subimage.

id - id of entry
logid - reference to log.id - corresponding entry in log table
imageid - reference to image.id - image deployed for this reservation
imagerevisionid - reference to imagerevision.id - image revision deployed for this reservation
computerid - reference to computer.id - computer deployed for this reservation
IPaddress - IP address of computer during this deploy
managementnodeid - reference to managementnode.id - management node that handled this deploy
predictivemoduleid - reference to module.id - prediction module used to load image when this reservation finished
hostcomputerid - reference to computer.id - for VMs, this was the host the VM was deployed to
blockRequestid - reference to blockRequest.id - NULL if this was not part of a block request
blockStart - start time of the blockTimes entry for the block request
blockEnd - end time of the blockTimes entry for the block request

user table

This table contains an entry for every user that has every logged in to VCL.

id - id of entry
uid - numeric id of user for accounts on deployed reservations
unityid - normal user id for user
affiliationid - reference to affiliation.id - affiliation of user
firstname - first name of user
lastname - last name of user
preferredname - preferred name of user
email - email address of user
emailnotices - 1 to get email notices, 0 otherwise
IMtypeid - reference to IMtype.id - type of IM address in IMid
IMid - IM account for user
adminlevelid - reference to adminlevel.id - deprecated
width - screen width for RDP files
height - screen height for RDP files
bpp - color depth for RDP files
audiomode - audio mode for RDP files
mapdrives - drive mapping status for RDP files
mapprinters - printer mapping status for RDP files
mapserial - serial mapping status for RDP files
rdpport - user's preferred RDP port
showallgroups - 1 to show user groups from all affiliations where user groups can be selected, 0 to only show user groups matching user's affiliation
lastupdated - date/time user's info was last updated
validated - 1 if the user is part of the Local affiliation or if the user has been validated by a login or by being looked up via LDAP; 0 if the user is part of a Shibboleth only authenticated affiliation and the user has never logged in
usepublickeys - flag to tell if ssh public key authentication should be used for logging in to Linux reservations
sshpublickeys - list of ssh public keys to set up for user within the user's reservations uid - numeric id of user for accounts on deployed reservations
unityid - normal user id for user
affiliationid - reference to affiliation.id - affiliation of user
firstname - first name of user
lastname - last name of user
preferredname - preferred name of user
email - email address of user
emailnotices - 1 to get email notices, 0 otherwise
IMtypeid - reference to IMtype.id - type of IM address in IMid
IMid - IM account for user
adminlevelid - reference to adminlevel.id - deprecated
width - screen width for RDP files
height - screen height for RDP files
bpp - color depth for RDP files
audiomode - audio mode for RDP files
mapdrives - drive mapping status for RDP files
mapprinters - printer mapping status for RDP files
mapserial - serial mapping status for RDP files
showallgroups - 1 to show user groups from all affiliations where user groups can be selected, 0 to only show user groups matching user's affiliation
lastupdated - date/time user's info was last updated

usergroup table

This table contains all of the user groups.

...

id - id of entry
computerid - reference to computer.id - physical machine entry refers to
vmlimit - max number of VMs that can be on this host
vmprofileid - reference to vmprofile.id - profile being used on this host
vmkernalnic - ??
vmwaredisk - localdisk or networkdisk - ??

vmprofile table

This table contains an entry for each virtual host profile.

id - id of entry
profilename - name of the profile
vmtypeid - reference to vmtype.id - hypervisor type of this profile
imageid - reference to image.id - image deployed on host
resourcepath -
folderpath -
repositorypath - ??
repositoryimagetypeid -
datastorepath - ??
virtualdiskpath datastoreimagetypeid - ??
vmpath - ??
virtualswitch0 - name of virtual switch0
virtualswitch1 - name of virtual switch1
virtualswitch2 - name of virtual switch2
virtualswitch3 - name of virtual switch3
vmdisk - localdist localdisk or networkdisk - ??
username - username to use when accessing hosts with this profile
password - password to use when accessing hosts with this profile
vmware_mac_eth0_generated eth0generated - 1 to generate eth0 MAC for VMs on hosts with this profile, 0 to use MAC from computer table
vmware_mac_eth1_generated eth1generated - 1 to generate eth1 MAC for VMs on hosts with this profile, 0 to use MAC from computer table
rsapub -
rsakey -
encryptedpasswd -

vmtype table

This table contains all of the virtual machine types.

...

affiliationid - reference to affiliation.id
productname - ??
productkey - ??

xmlrpcLog table

This table logs each XML RPC API call.

...