Management of Rackham IP Address Assignment
 
Rackham
Who we're doing this for

Interface
The HTML interface seen by Rackham employees

Kerberos
Plug-in needed to use the HTML forms

Overview
   Rackham wishes to use the reshall registration service to register it's 30 or so staff. Here are the tasks needed to provide Rackham with this service.
  • Add functionality to the SQL-daemon to allow Rackham staff to see only Rackham data, and Reshall staff to see only Reshall data. I believe this means creating oracle users that map to the reshall and rackham pts groups. Then when staff wish to access data, their membership in a pts group is checked, and then the sql-daemon performs data base operations with a view (i.e. select uniqname, ip_addr from oracleusername.machines). I believe that we want to create a table in oracle that holds the ptsgroup-> oracle username mapping, or just make them the same.
  • Create Rackham Registration forms by changing the reshall student and staff registration forms to hide the room#, dorm, hall fields because they won't be needed. Also place different title, pictures......
Status Report
   The Rackham interface is done. The tables have been patched for the time being, and a better solution is being worked out. As the new tables evolve, the Rackham interface will evolve with it.

[ Project Overview | Web Client | Java Client | Backend | Staff ]