Tags:
create new tag
view all tags

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"
JAVA_HOME="/usr/java/j2sdk1.4.1_01"

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

mysql-3.23.56-1.72
mysql-server-3.23.56-1.72
mysqlclient9-3.23.22-8

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
http://www.astrogrid.org/

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 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"
    • = ""

Note:

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

Note:

Since 14th March '05 PAL has adopted a new naming convention to bring it in line with other AstroGrid components. It now has the designation:

astrogrid-pal-skycatserver-n.n-bnnnpl.war

Latest PAL installed on the msslxx server is version astrogrid-pal-skycatserver-0.9-b010pl.war

The following configuration changes have been made on msslxx to reflect architectural differences in the latest PAL:

  • Addition of a <metadoc.xml> file to $CATALINA_HOME/webapps//WEB-INF/classes, where = "pal_esdo" and <metadoc.xml> = "esdo_metadoc.xml" in the case of msslxx.

The metadoc.xml file is configured with MySQL esdo database metadata (e.g. table names, column names etc).

  • "astrogrid.properties" file in the $CATALINA_HOME/common/classes path modified as follows:

    • datacenter.metadoc.file=esdo_metadoc.xml
    • datacenter.querier.plugin.sql.translator=org.astrogrid.tableserver.jdbc.StdSqlMaker

    • datacenter.querier.plugin=org.astrogrid.tableserver.jdbc.JdbcPlugin (was org.astrogrid.datacenter.queriers.sql.JdbcPlugin)

-- MikeSmith - 05 Apr 2005

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