Deploying OGSA-DAI(AXIS) 3.0 & DQP 3.2 on to Windows

来源:百度文库 编辑:神马文学网 时间:2024/05/08 07:59:17

The following article was provided by one of our users and gives astep-by-step overview for installing OGSA-DAI on to a Vista platform.

1 Prerequisite Software

1.1 Java

1.1.1 Download

http://java.sun.com/products/archive/

jdk-1_5_0_07-windows-i586-p.exe

1.1.2 Installation

Install in to the directory: D:\Program Files\Java

1.1.3 Set Environment Variables

Add: JAVA_HOME=D:\Program Files\Java\jdk1.5.0_07

Change: PATH=% JAVA_HOME %\bin; % JAVA_HOME %\lib; %path%

Add: CLASSPATH= .;%JAVA_HOME%\lib;%JAVA_HOME%\lib\dt.jar;%JAVA_HOME%\lib\tools.jar

1.2 Jakarta Tomcat

1.2.1 Download

http://archive.apache.org/dist/tomcat/tomcat-5/v5.0.28/bin/jakarta-tomcat-5.0.28.exe

1.2.2 Installation

D:\Program Files\Apache Software Foundation\Tomcat 5.0

During the installation, set port: 8080, the password of admin: admin

1.2.3 Setting

Setting: control panel → management tools → Services: Apache tomcat—not auto

>cd D:\Program Files\Apache Software Foundation\Tomcat 5.0\bin

D:\Program Files\Apache Software Foundation\Tomcat 5.0\bin>startup

1.3 Apache Ant

1.3.1 Download

http://ant.apache.org/bindownload.cgi

apache-ant-1.7.1-bin.zip

1.3.2 Installation

Unzip to D:\Program Files\Apache Software Foundation\

D:\Program Files\Apache Software Foundation\apache-ant-1.7.1

1.3.3 Setting Environment Variable

Add: ANT_HOME= D:\Program Files\Apache Software Foundation\apache-ant-1.7.1

Change: PATH=% ANT_HOME %\bin;% ANT_HOME %\lib;%path%

1.4 MySQL

1.4.1 Download

http://dev.mysql.com/downloads/mysql/5.0.html

mysql-essential-5.0.67-win32.msi

1.4.2 Installation

D:\Program Files\MySQL\MySQL Server 5.0

During the installation, set the password of root: admin

1.4.3 Setting

>cd D:\Program Files\MySQL\MySQL Server 5.0\bin

D:\Program Files\MySQL\MySQL Server 5.0\bin>mysql –u root –p

input password: admin

mysql>create database ogsadai;

mysql>INSERT INTO user (Host,User,Password) VALUES(’localhost’,ogsadai,’ogsadai’);

2 Deploy OGSA-DAI Axis

2.1 Download

http://www.ogsadai.org.uk/downloads/ogsadai3.0/

binary distribution: ogsadai-3.0-axis-1.4-bin.zip

2.2 Deployment

Unzip to D:\Program Files\ogsadai\

D:\Program Files\ogsadai\ogsadai-3.0-axis-1.4-bin

Download DB Driver : mysql-connector-java-5.0.4-bin.jar

copy to D:\Program Files\ogsadai\ogsadai-3.0-axis-1.4-bin\thirdparty\lib\ mysql-connector-java-5.0.8-bin.jar

>cd D:\Program Files\ogsadai\ogsadai-3.0-axis-1.4-bin

D:\Program Files\ogsadai\ogsadai-3.0-axis-1.4-bin>ant -Dtomcat.dir=”D:\Program Files\Apache Software Foundation\Tomcat5.0″ -Ddai.host=localhost -Ddai.port=8080 buildDeployWARAndServices

D:\Program Files\ogsadai\ogsadai-3.0-axis-1.4-bin> ant -Dtomcat.dir=”D:\Program Files\Apache Software Foundation\Tomcat 5.0″ -Ddai.host=localhost -Ddai.port=8080 deployServices

2.3 Configuring the server

2.3.1 Config and deploy a relational resource file

D:\Program Files\ogsadai\ogsadai-3.0-axis-1.4-bin>setenv

D:\ProgramFiles\ogsadai\ogsadai-3.0-axis-1.4-bin>ant -Ddai.db.product=MySQL-Ddai.db.vendor=MySQL -Ddai.db.version=5-Ddai.db.uri=jdbc:mysql://localhost:3306/ogsadai-Ddai.db.driver=org.gjt.mm.mysql.Driver-Ddai.resource.id=MySQLDataResource createRelationalConfig

D:\ProgramFiles\ogsadai\ogsadai-3.0-axis-1.4-bin>ant -Dtomcat.dir=”D:\ProgramFiles\Apache Software Foundation\Tomcat 5.0″-Ddai.resource.file=”D:\ProgramFiles\ogsadai\ogsadai-3.0-axis-1.4-bin\MySQLDataResource” deployResource

D:\ProgramFiles\ogsadai\ogsadai-3.0-axis-1.4-bin>ant -Dtomcat.dir=”D:\ProgramFiles\Apache Software Foundation\Tomcat 5.0″-Ddai.resource.id=MySQLDataResource -Ddai.user=root -Ddai.password=adminpermit

2.3.2 Config and deploy a file system resource file

D:\ProgramFiles\ogsadai\ogsadai-3.0-axis-1.4-bin>ant-Ddai.db.file.path=D:\works -Ddai.resource.id=FileSystemDataResourcecreateFileSystemConfig

D:\ProgramFiles\ogsadai\ogsadai-3.0-axis-1.4-bin>ant -Dtomcat.dir=”D:\ProgramFiles\Apache Software Foundation\Tomcat 5.0″-Ddai.resource.file=”D:\ProgramFiles\ogsadai\ogsadai-3.0-axis-1.4-bin\FileSystemDataResource”deployResource

*D:\ProgramFiles\ogsadai\ogsadai-3.0-axis-1.4-bin>ant -Dtomcat.dir=”D:\ProgramFiles\Apache Software Foundation\Tomcat 5.0″ -Ddai.resource.id=FileSystemDataResource -Ddai.user=root -Ddai.password=admin permit

2.4 Test OGSA-DAI server deployment

2.4.1 Web access

http://localhost:8080/dai/services

http://localhost:8080/dai/dai-manager.jsp

2.4.2 Create test databases

D:\Program Files\ogsadai\ogsadai-3.0-axis-1.4-bin>setenv

D:\ProgramFiles\ogsadai\ogsadai-3.0-axis-1.4-bin>javauk.org.ogsadai.dbcreate.CreateTestMySQLDB -driverclassorg.gjt.mm.mysql.Driver -host localhost -database ogsadai -usernameogsadai -password ogsadai -tablename littleblackbook -rows 10000-rootusername root -rootpassword admin

2.4.3 server client

D:\Program Files\ogsadai\ogsadai-3.0-axis-1.4-bin>setenv

>java uk.org.ogsadai.client.toolkit.example.ServerClient -u “http://localhost:8080/dai/services” -c getVersion

>java uk.org.ogsadai.client.toolkit.example.ServerClient -u “http://localhost:8080/dai/services” -c listResources

>javauk.org.ogsadai.client.toolkit.example.ServerClient -u“http://localhost:8080/dai/services” -r MySQLDataResource -tuk.org.ogsadai.DATA_RESOURCE -c getLifetime

2.4.4 SQL client

>javauk.org.ogsadai.client.toolkit.example.SQLClient -eDataRequestExecutionResource -d MySQLDataResource -u“http://localhost:8080/dai/services” -q “select * from littleblackbookwhere id<10;”

2.4.5 File client

>javauk.org.ogsadai.client.toolkit.example.FileClient -uhttp://localhost:8080/dai/services/ -d FileSystemDataResource -c list

>javauk.org.ogsadai.client.toolkit.example.FileClient -uhttp://localhost:8080/dai/services/ -d FileSystemDataResource -c list-dir vig/

(d:/works/vig/)

>javauk.org.ogsadai.client.toolkit.example.FileClient -uhttp://localhost:8080/dai/services/ -d FileSystemDataResource -c read-f someFile.txt

3 Deployment OGSA-DQP

3.1 Another Tomcat container

Install another Tomcat container

D:\Program Files\Apache Software Foundation\Tomcat 5.0 2 nd

D:\Program Files\Apache Software Foundation\Tomcat 5.0 2nd\conf\ server.xml

D:\Program Files\Apache Software Foundation\Tomcat 5.0 2nd \bin>startup

3.2 Deployment of OGSA-DAI on Tomcat 2nd container

cd D:\Program Files\ogsadai\ogsadai-3.0-axis-1.4-bin

D:\Program Files\ogsadai\ogsadai-3.0-axis-1.4-bin>ant -Dtomcat.dir=”D:\Program Files\Apache Software Foundation\Tomcat5.0 2nd” -Ddai.host=localhost -Ddai.port=8081 buildDeployWARAndServices

D:\Program Files\ogsadai\ogsadai-3.0-axis-1.4-bin>ant -Dtomcat.dir=”D:\Program Files\Apache Software Foundation\Tomcat5.0 2nd” -Ddai.host=localhost -Ddai.port=8081 deployServices

3.3 Deployment of OGSA-DQP

3.3.1 Download

ogsadai-3.0-extension-dqp-bin.zip

ogsadqp-3.2.1-od30port.zip

unzip to D:\Program Files\ogsadai\

D:\Program Files\ogsadai\ogsadai-3.0-extension-dqp-bin

D:\Program Files\ogsadai\ogsadqp-3.2.1-od30port

3.3.2 OGSA-DQP QES Installation

D:\Program Files\ogsadai\ogsadqp-3.2.1-od30port\evaluator> antdeploy.axis121 -Dogsadai.dir=”D:\ProgramFiles\ogsadai\ogsadai-3.0-axis-1.4-bin” -Dtomcat.dir=”D:\ProgramFiles\Apache Software Foundation\Tomcat 5.0″

D:\Program Files\ogsadai\ogsadqp-3.2.1-od30port\evaluator> antdeploy.axis121 -Dogsadai.dir=”D:\ProgramFiles\ogsadai\ogsadai-3.0-axis-1.4-bin” -Dtomcat.dir=”D:\ProgramFiles\Apache Software Foundation\Tomcat 5.0 2nd”

3.3.3 DQP Extension Pack

D:\ProgramFiles\ogsadai\ogsadai-3.0-extension-dqp-bin>ant-Dogsadai.dir=”D:\Program Files\ogsadai\ogsadai-3.0-axis-1.4-bin”deployToDistribution

D:\ProgramFiles\ogsadai\ogsadai-3.0-extension-dqp-bin>ant-Dogsadai.dir=”D:\Program Files\ogsadai\ogsadai-3.0-axis-1.4-bin”-Dtomcat.dir=”D:\Program Files\Apache Software Foundation\Tomcat 5.0″deployToDRER

D:\ProgramFiles\ogsadai\ogsadai-3.0-extension-dqp-bin>ant-Dogsadai.dir=”D:\Program Files\ogsadai\ogsadai-3.0-axis-1.4-bin”-Dtomcat.dir=”D:\Program Files\Apache Software Foundation\Tomcat 5.02nd” deployToDRER

3.3.4 DQP Coordinator Installation

D:\ProgramFiles\ogsadai\ogsadqp-3.2.1-od30port\coordinator>ant deploy.axis121-Dogsadai.dir=”D:\Program Files\ogsadai\ogsadai-3.0-axis-1.4-bin”-Dtomcat.dir=”D:\Program Files\Apache Software Foundation\Tomcat 5.0″

D:\ProgramFiles\ogsadai\ogsadqp-3.2.1-od30port\coordinator>ant deploy.axis121-Dogsadai.dir=”D:\Program Files\ogsadai\ogsadai-3.0-axis-1.4-bin”-Dtomcat.dir=”D:\Program Files\Apache Software Foundation\Tomcat 5.02nd”

3.4 Deploy the Testbed of DQP

Tomcat Container running on 8080

  • OGSA-DAI Services exposing:

DQPFactoryResource (DQP Coordinator): Check if it is listed at http://localhost:8080/dai/dai-manager.jsp

  • DQP Evaluator Service, Check at http://localhost:8080/dqp-evaluator

Tomcat Container running on 8081

  • OGSA-DAI Service exposing relational data resources:

Check if it is listed at http://localhost:8081/dai/dai-manager.jsp

DataOne,DataTwo, DataThree, DataFour, DataFive

  • DQP Evaluator Service: Accessible at http://localhost:8081/dqp-evaluator

  • Entropy Analyser Service: Accesible at http://localhost:8081/entropy-analyser

Create five relational data source files on Tomcat-8081

Deploy the Entropy Analyser Service:

D:\ProgramFiles\ogsadai\ogsadqp-3.2.1-od30port\service>ant deploy.axis121-Dtomcat.dir=”D:\Program Files\Apache Software Foundation\Tomcat 5.02nd”

D:\Program Files\Apache Software Foundation\Tomcat 5.0 2nd\webapps\dai\WEB-INF\etc\dai\activities.txt 318 remove comment mark

3.5 Using the client

3.5.1 Building the DQP client

D:\ProgramFiles\ogsadai\ogsadqp-3.2.1-od30port\client>ant compile.axis121-Dogsadai.dir=”D:\Program Files\ogsadai\ogsadai-3.0-axis-1.4-bin”

3.5.2 Using the client– Creating a DQP Data Resource

D:\ProgramFiles\ogsadai\ogsadqp-3.2.1-od30port\client> ant factory-Ddqp.config.file=”D:\ProgramFiles\ogsadai\ogsadqp-3.2.1-od30port\examples\test-dqpconfig-axis121.xml”-Durl=http://localhost:8080/dai/services/-Dresource.id=DQPFactoryResource

[java] Created DQP Resource with id: ogsadai-11f84a2dfd8

3.5.3 Using the client– Querying the imported schemas property

cd D:\Program Files\ogsadai\ogsadqp-3.2.1-od30port\client

D:\Program Files\ogsadai\ogsadqp-3.2.1-od30port\client> ant getschemas -Durl=http://localhost:8080/dai/services/ -Dresource.id= ogsadai-11f84a2dfd8

3.5.4 Using the client– Executing a query

cd D:\Program Files\ogsadai\ogsadqp-3.2.1-od30port\client

D:\Program Files\ogsadai\ogsadqp-3.2.1-od30port\client> ant query -Durl=http://localhost:8080/dai/services/ -Dresource.id= ogsadai-11f84a2dfd8 -Dclient.query=“SELECTgoterm_goterm.name FROM proteinterm_protein_goterm, goterm_goterm WHEREproteinterm_protein_goterm.GOTermIdentifier=goterm_goterm.id ANDproteinterm_protein_goterm.ORF=’YBL037W’ AND goterm_goterm.name LIKE‘vesicle%’;”