Equipment & Inventory Database

See InventoryUserDocs

The following information is obsoleted by the revised Inventory web interface and is preserved for historical purposes. OldEquipmentInventoryStillCurrent contains a revised version of the below information.

The E&I database is available on the web at https://webobjects.math.uwaterloo.ca/cgi-bin/WebObjects/equipment.

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 webobjects.math as user webobjects. Important locations:

• /Volumes/kai_webobjects/DURF/equipment - The application files and build/install script are here. These are a copy of the ones on the development machine, except that the EOModel file refers to the production server database.cs rather than localhost.
• /Library/WebObjects/Applications/equipment.woa - The actual running copy of the application. Updated automatically by the build script.
• /var/log/webobjects/equipment - Logging information generated by the application, useful for debugging.
• /Volumes/kai_webobjects/DURF/nightlyErrorChecks - Contains the Java Jar file with the code for doing the nightly error check. This is invoked by ssh from cscf.cs.

The authoritative source code is on IsaacMorland's office computer in ~ijmorlan/WebObjects/Equipment, along with a pushToProduction script that updates webobjects.math and runs the build/install script. It also patches the EOModel file to refer to database.cs (production) rather than localhost (development).

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.

-- IsaacMorland - 19 Jun 2006

Redesign Work

InventoryRedesignRequirements work has been started by DanielAllen in May 2008.