Difference: PhaseADemoPAL (r3 vs. r2)

Phase A: Demostration Astrogrid PAL

Pre-requisites for PAL

1. Java

  • a. Java SDK 1.4.1_01 already installed
  • b. Set env. var JAVA_HOME="/usr/java/j2sdk1.4.1_01" in .bash_profile

2. Tomcat

  • a. Downloaded and installed jakarta-tomcat-5.0.28.tar
  • b. Set env var CATALINA_HOME="$HOME/jakarta-tomcat-5.0.28"


3. Axis

  • a. Downloaded axis-1_2RC2-bin.tar
  • b. Untar and copy axis-1_2RC2/webapps/axis directory to $TOMCAT_HOME/webapps
  • c. Install Xerces XML Parser
    • Downloaded / untarred Xerces-J-bin.2.5.0.tar to axis-1_2RC2/webapps/axis/WEB-INF/lib/
    • Copied xml-apis.jar, xercesImpl.jar, xmlParserAPIs.jar to axis-1_2RC2/webapps/axis/WEB-INF/lib/
    • chmod +x for xml-apis.jar, xercesImpl.jar, xmlParserAPIs.jar (may be unnecessary)
  • d. Install activation.jar
    • Downloaded jaf-1_0_2.upd.zip to $TOMCAT_HOME/common/lib
    • Untarred and copied jaf-1.0.2/activation.jar to TOMCAT_HOME/common/lib
  • e. Stop / restart Tomcat
  • f. Check installation at http://msslxx.mssl.ucl.ac.uk:8080/axis and http://msslxx.mssl.ucl.ac.uk:8080/axis/happyaxis.jsp

MYSQL installation on msslxx

1. Check for installation:

  • a. % rpm -q mysql mysql-server mysqlclient9


2. Configure database:

  • a. mySQL configured to run as a daemon on machine startup by Paul Lamb
  • b. mySQL users “mysql” and “root” created by Paul Lamb
  • c. mySQL user “root” should be used to create databases and tables, import data, and perform other table manipulation
  • d. mySQL grant tables listed user “root” at “localhost”; ElizabethAuden added a duplicate entry for “root” at “localhost.localdemain” and performed a “flush privileges.” (This is to allow connections by the mySQL jdbc driver, which recognizes “localhost.localdemain” in place of “localhost”.)

3. Install mySQL jdbc driver:

  • a. Download from
  • b. Configure

4. . Create database and table. Import data. Test database.

  • a. Create database as root:
  • b. Create table as root
  • c. Create columns in “trace” as root:

Note: the “date” column was first set to type “datetime”. However, the version of VOTable used by the Astrogrid PAL cannot parse the datetime used by mySQL. Therefore, the “date” column was reset to VARCHAR(20) using the alter command:

  • d. Import table of TRACE filenames, paths, and file creation dates from a tab-separated text file:
  • e. Test database from commandline and through jdbc connection:
    • From commandline
    • With jdbc connection, using java class (see attached file)

PAL Installation and Configuration

1. Installation

  • a. Download pal-SNAPSHOT.war (on 18-01-05) from


2. Configuration

  • a. Edit file /home/griduser/jakarta-tomcat-5.0.28/webapps/pal/WEB-INF/classes/default.properties, making sure the following pair values are set:
    • datacenter.querier.plugin=org.astrogrid.datacenter.queriers.test.SampleStarsPlugin
    • conesearch.table=SampleStars
    • conesearch.ra.column=RA
    • conesearch.dec.column=DEC
    • conesearch.columns.units=deg
    • db.trigfuncs.in.radians=true
    • datacenter.implements.circle=true
    • datacenter.implements.xmatch=false
    • datacenter.url=http://localhost:8080/pal
    • datacenter.resource.plugin.1=org.astrogrid.datacenter.metadata.CeaResourceServer
    • datacenter.resource.plugin.2=org.astrogrid.datacenter.queriers.test.SampleStarsMetaServer
    • org.astrogrid.registry.admin.endpoint=http://hydra.star.le.ac.uk:8080/astrogrid-registry/services/RegistryUpdate
    • org.astrogrid.registry.query.endpoint=http://hydra.star.le.ac.uk:8080/astrogrid-registry/services/RegistryQuery
    • org.astrogrid.localhost/frog=astrogrid:store:myspace:http://twmbarlwm.star.le.ac.uk:8080/astrogrid-mySpace-SNAPSHOT/services/Manager
  • b. Copy default.properties to $TOMCAT_HOME/common/classes/astrogrid.properties (for safe-keeping)
  • c. Add :$TOMCAT_HOME/common/classes/astrogrid.properties to CLASSPATH in .bash_profile

3. Connecting to a database

  • a. Install JDBC driver
    • Download mysql-connector-java-3.0.16-ga.tar and untra untar
    • Copy mysql-connector-java-3.0.16-ga-bin.jar to $TOMCAT_HOME/common/lib
  • b. Modify $TOMCAT_HOME/common/classes/astrogrid.properties as follows:
    • datacenter.querier.plugin=org.astrogrid.datacenter.queriers.sql.JdbcPlugin
    • datacenter.plugin.jdbc.drivers=com.mysql.jdbc.Driver
    • datacenter.plugin.jdbc.url=mysql://:3306/
    • datacenter.plugin.jdbc.user=
    • datacenter.plugin.jdbc.password=

In the case of the demo PAL installation on the server 'msslxx', the following are set:

    • = "msslxx.mssl.ucl.ac.uk"
    • = "esdo"
    • = "root"
    • = ""


Setting datacenter.querier.plugin as above (and thereby disabling the default setting) results in the following PAL installation Self Test checks failing:

  • testBigAdqlSearch
  • testConeSearch
  • testSoapDelegate
  • testSkyNode (also fails with default plugin setting)
  • testMetaData

-- ElizabethAuden - 24 Jan 2005

View topic | View difference side by side | History: r4 < r3 < r2 < r1 | More topic actions
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 2008-2020 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback