Server Build/Configuration Journal

This section contains information regarding configuration changes made to this server.

• Initial software installation/configuration, October 2008, EricKramer
  • Installed Cygwin to support Unix file formats/tools used by the CHTN Oracle database
  • Installed Oracle XE? and documented credentials in KeyPass? database
  • Installed Ruby? in order to automate Oracle database account setup (etc.). Used the Ruby One-click Installer
  • Installed Oracle SQLDeveloper graphical querying/admin/development tool
  • Installed Java 6, Update 10
  • Installed Collabnet's Subversion command-line client (for version control access)
  • Installed Tomcat Server version 5.5.27
    • Configured to use port 8090
    • Administrator account = admin
    • Configured service to auto-start with Windows
    • Verified functionality of start/manager webapp at http://127.0.0.1:8090/
  • Installed Tomcat Admin web app
    • Verified functionality of admin webapp at http://localhost:8090/admin
  • Installed Sun Netbeans IDE version 6.1
    • Enabled Tomcat support within Netbeans. Useful documents:
      • Installing and adding an External Tomcat server in Netbeans 6.0
      • Configuring an External Tomcat Server for Deployment * Oracle database configuration
  • Moved CHTN database exports (from John Williams) and export log files to e:\chtn\db\exports
  • Reviewed CCINV_export.log and created necessary schemas to import
  • Created e:/chtn/db/script/create_users.sql (generated from a Ruby script) to set up user accounts/schemas for objects to import.
  • Ran script via SQLPlus to create accounts
  • Created CHTN_READONLY role/group: create role chtn_readonly;
  • Created CC_DATA tablespace:
    

    create tablespace cc_data
      datafile 'E:\ORACLEXE\ORADATA\XE\CC_DATA.DBF' size 500m
      EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

  • Imported CCINV objects from TISSUEADM and INVESTIGATOR schemas:
    

    imp system/*** file=CCINV.dmp fromuser="(investigator, tissueadm)" log=../log/CCINV_import.log

  • Using SQLDeveloper, forced compilation of functions and views that were invalid within the INVESTIGATOR and TISSUEADM schemas
• Web Application Setup/Deployment
  • Tomcat Datasource Configuration
    • Useful document: Tomcat JNDI Datasource HOW-TO
    • Copied Oracle's latest JDBC driver from e:\oraclexe\app\oracle\product\10.2.0\server\jdbc\lib into the Tomcat server common classpath folder $CATALINA_HOME/common/lib
    • Using Administrator web app, configured a shared datasources for "masterpool" and "investpool":
      • JNDI Name: jdbc/masterpool and a duplicate entry for jdbc/investpool
      • Data Source URL: jdbc:oracle:thin:@127.0.0.1:1521:xe
      • JDBC Driver Class: oracle.jdbc.OracleDriver
      • User Name: tissueadm for "masterpool" and investigator for "investpool"
      • Validation Query: select 1 from dual
  • Generated self-signed keystore for use by Tomcat's SSL processor. See the SSL Config HOWTO for details.
  • Enabled SSL connector (and removed APR .dll that was causing strange/improper SSL handling)