DRMS DSA Installation Notes

Download

• -bash-2.05b$ wget http://www.astrogrid.org/maven/org.astrogrid/wars/astrogrid-dsa-catalog-2007.2pl.war
• -bash-2.05b$ cp astrogrid-dsa-catalog-2007.2pl.war esdo-drms-dsa.war
• -bash-2.05b$ cp esdo-drms-dsa.war /disk/d2/griduser/apache-tomcat-5.5.20/webapps/.
• http://msslxx.mssl.ucl.ac.uk:8080/esdo-drms-dsa/

Configuration

1. java / tomcat checks: java 1.5.0, tomcat 5.5.20
2. installation self-tests: success
3. RDBMS:
   • grant select on drms_series to esdo_drms_dsa
   • pg_ctl start -D $PGDATA -o "-i" - be sure to enable TCP / IP connections with -i
   • in pg_hba.conf, add line to allow esdo_drms_dsa access to jsoc with MD5 permission using specific IP address pair
   • driver org.postgresql.Driver in $TOMCAT_HOME/common/lib/postgresql-8.1-408.jdbc3.jar
   • direct connection (see default.properties step)
4. Customize your configuration (config default.properties) using postgres variables
   • Note: installation self-tests and SQL tests may fail (poss. with "failed to write query results to specified destination") until metadoc file has been generated in next step, specified in default.properties, and tomcat restarted.
5. Generate metadoc file
   • delete pg tables other than drms_series
6. Test your customized configuration
   • Rerun all self-tests. 2 SQL tasks may fail since "tapeunit" and "archive" columns may cause division by zero error. This is fine.

-- ElizabethAuden - 23 May 2007