Equipment & Inventory Database

This is based on OldEquipmentInventory, with stale information removed.

Some information is available from http://www.cs.uwaterloo.ca/cscf/internal/applications/Equipment+Inventory/ This is probably mostly still correct as far as the basic architecture and design is concerned, but out-of-date with respect to specific configuration details such as the actual hosts used. The information on this TWiki should be more up-to-date in this respect.

Hosts

The data for the E&I database are in the database equipment on the database.cs MySQL installation.

The application itself runs on www.cs .

Cron Jobs

The aux_sponsors, aux_groups, and aux_subscription_code tables of the database are automatically updated by a cron job running in the equipment-1 package on cscf.cs. In addition, the file dnsDigest.txt is generated by the cron job and copied over to webobjects.math. Full documentation for the equipment-1 package is being created in PackageDocumentationEquipment1.

-- DanielAllen - 02 Mar 2011