date: 11/01/98
written by: Sergio Strykowski, strykow@npac.syr.edu


ref.: Oracle support for management of Tango Project


1. Database content
   - all data is kept in the Oracle database on sunrise.npac.syr.edu under 'tango' account
   - 'tango' account is meant for keeping Tango Project data and for development purposes only;
     it should never be used to access data, specially from the Web
   - there are 3 roles defining 3 various access levels to 'tango' data:
       * TANGO_MANAGER
       * TANGO_DEVELOPER
       * TANGO_ASSOCIATE
   - to give access to Tango data one of these roles should be granted to the user;
     quite convenient way to do it is to use "Tango Developers" form
   - for servlets that put data into the database from the Web it has been created
     a special user named 'tango_web' that has almost no privileges
   - complete description of the Oracle database on sunrise can be obtained from Roman Markowski

2. Servlets
   - there are 2 servlets used to put Tango data into the database from the Web:
       * Download.java
       * Bug.java
   - machine having these servlets: sunrise.npac.syr.edu
   - unix account: webuser
   - http server: apache 1.2.5
         http://sunrise.npac.syr.edu/servlet/Download
         http://sunrise.npac.syr.edu/servlet/Bug
   - servlet directory: /export/home/webuser/servlets
     this directory contains both *.java and *.class servlets' files
   - error logs directory: /export/home/webuser/tango/logs
   - complete description of the apache http server on sunrise can be obtained from Roman Markowski

3. Developer/2000 2.1 Forms
  - deploying forms on the Web requires usage of Developer Server (aka Developer Application
    Server) and http server both running on the same machine;
    right now (November '98) NPAC possesses Developer Server only for Windows NT
  - machine: crpc1.npac.syr.edu
  - WindowsNT user: oracle
    because 'oracle' user has full administrator privileges be very careful while doing anything
    in order not to do any damages to the operating system
  - Developer Server is installed as windows service named "Developer/2000 Forms Server";
    it starts automatically with operating system
  - http server: O'Reilly WebServerPro from the year 1996
    also installed as windows service, starts automatically with operating system
  - directories:
      * o:\ORANT   ---> Developer/2000 home directory
      * o:\WWW\forms   ---> contains oracle forms executable files (*.fmx)
      * o:\WWW\forms\html   ---> contains html files necessary to run forms on the Web
      * o:\Tango   ---> contains source code of all forms
  - http server virtual directories mapping:
      /forms/      --->   o:\WWW\forms\html\
      /web_code/   --->   o:\orant\forms50\java\
      /web_jars/   --->   o:\orant\forms50\java\
  - starting the main form:
       http://crpc1.npac.syr.edu/forms/main.html
  - connecting to Oracle Database Server
      * because database server containing Tango data is on sunrise.npac.syr.edu, and Developer Server
        running Tango forms is on crpc1.npac.syr.edu therefore SQL*Net protocol must be used to establish
        connection between these two machines
      * required files:
          o:\orant\network\admin\tnsnames.ora
          o:\orant\network\admin\sqlnet.ora
  - more information about crpc1.npac.syr.edu can be obtained from Roman Markowski

4. Database content
   - machine: Oracle7 Database Server on sunrise.npac.syr.edu
   - oracle account keeping data: tango
   - list of tables:
       * BUGS   ---> contains descriptions of bugs submitted thru Web
       * DOWNLOADS   ---> contains detailed data about each download of Tango Products
       * MEMBERS   ---> contains personal data of people who downloaded Tango Products
                        the name comes from the idea of creating Tango Friends' Club
       * EMAILS   ---> contains emails sent to Members
       * MEMBERS_EMAILS   ---> additional table necessary to link emails with addressees (Members)
       * EMAIL_ADDRESSEES   ---> temporary table used while sending emails
       * TANGO_DEVS   ---> contains personal data of Tango Developer, Managers, and Associates
       * TANGO_PRODUCTS   ---> the list of Tango Products available to download
       * BUSINESS   ---> the list of businesses of people downloading Tango Products