create new tag
view all tags

DRMS DSA Installation Notes



  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

Edit | Attach | Watch | Print version | History: r4 < r3 < r2 < r1 | Backlinks | Raw View | More topic actions
Topic revision: r4 - 2007-05-25 - ElizabethAuden
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 2008-2019 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback