Files
The SQL MA snapshot perfSONAR-SQL_MA-src-snapshot-20060811 was used. Untar'd and linked from /opt/:
noformat
[ytl@net-desk1:/opt/perfSONAR]$ ls -lah
total 40K
drwxr-xr-x 3 ytl ytl 4.0K Aug 24 10:26 .
drwxr-xr-x 8 ytl ytl 4.0K Aug 24 10:39 ..
lrwxrwxrwx 1 ytl ytl 14 Aug 9 16:30 current -> perfSONAR-1.0/
lrwxrwxrwx 1 ytl ytl 38 Aug 24 10:26 current-SQL_MA -> \
perfSONAR-SQL_MA-src-snapshot-20060811
drwxrwxr-x 10 ytl ytl 4.0K Aug 9 16:51 perfSONAR-1.0
lrwxrwxrwx 1 ytl ytl 94 Aug 24 09:58 perfSONAR-SQL_MA-src-snapshot-20060811 -> \
/u/sf/ytl/Work/perfSONAR/SQLtypeMAService/java/20060811/perfSONAR-SQL_MA-src-snapshot-20060811
noformat
Library Installation
Ran ant -f build-sqlma.xml libs-sqlma inside the ant directory, which got a lot of jars etc from the wiki site and dumped then into /opt/perfSONAR/perfSONAR-SQL_MA-src-snapshot-20060811/perfsonar/lib
eXist User Account Creation
eXist is already installed, so just creating a sql user and password (sqlmaservice:sqlmaservice with group dba) on the Jetty server (port 8680).
eXist can be started with:
code
[ytl@net-desk1:/opt/exist/current/bin]$ ./startup.sh
Configuring eXist from /opt/exist/eXist-20060316/conf.xml
Found 1 catalog entries.
Loading catalog: /opt/exist/eXist-20060316/webapp/WEB-INF/catalog.xml
IN CONFIGURE
cluster.journal.maxStore 65000
cluster.journal.shift 100
29 Aug 2006 10:24:43,793 [main] INFO \
(FileResource.java [<clinit>]:60) - Checking Resource aliases
29 Aug 2006 10:24:43,996 [main] INFO \
(HttpServer.java [setStatsOn]:1068) - Statistics on = false for org.mortbay.jetty.Server@ee6681
29 Aug 2006 10:24:44,006 [main] INFO \
(HttpServer.java [start]:654) - Starting Jetty/5.0.0
29 Aug 2006 10:24:44,094 [main] INFO \
(HttpServer.java [start]:669) - Started org.mortbay.http.NCSARequestLog@ae3364
29 Aug 2006 10:24:44,576 [main] INFO \
(HttpContext.java [start]:1604) - Started WebApplicationContext[eXist Server,eXist Server]
Logging already initialized. Skipping...
29 Aug 2006 10:24:45,939 [main] WARN \
(JavaUtils.java [isAttachmentSupported]:1305) - Unable to find required classes (javax.activation.DataHandler and javax.mail.internet.MimeMultipart). Attachment support is disabled.
29 Aug 2006 10:24:46,376 [main] INFO \
(SocketListener.java [start]:204) - Started SocketListener on 0.0.0.0:8680
29 Aug 2006 10:24:46,376 [main] INFO \
(HttpServer.java [start]:690) - Started org.mortbay.jetty.Server@ee6681
code
IEPM-BW MA creation details
Ran ant -f build-sqlma.xml configure-sqlma, which creates a file at
/afs/slac.stanford.edu/g/scs/net/netmon/perfSONAR/SQLtypeMAService/java/20060811/perfSONAR-SQL_MA-src-snapshot-20060811/perfsonar/ant/const.properties
(reran with /opt/ path rather than afs paths where possble)
code
ytl@net-desk1:/opt/perfSONAR/perfSONAR-SQL_MA-src-snapshot-20060811/perfsonar/ant$ ant -f build-sqlma.xml configure-sqlma
Buildfile: build-sqlma.xml
configure-sqlma:
copy-initconfig-for-sqlma:
copy Copying 1 file to /afs/slac.stanford.edu/g/scs/net/netmon/perfSONAR/SQLtypeMAService/java/20060811/perfSONAR-SQL_MA-src-snapshot-20060811/perfsonar/ant
copy Copying 1 file to /afs/slac.stanford.edu/g/scs/net/netmon/perfSONAR/SQLtypeMAService/java/20060811/perfSONAR-SQL_MA-src-snapshot-20060811/perfsonar/conf
copy-properties:
copy Copying 1 file to /afs/slac.stanford.edu/g/scs/net/netmon/perfSONAR/SQLtypeMAService/java/20060811/perfSONAR-SQL_MA-src-snapshot-20060811/perfsonar/ant
copy Copying 1 file to /afs/slac.stanford.edu/g/scs/net/netmon/perfSONAR/SQLtypeMAService/java/20060811/perfSONAR-SQL_MA-src-snapshot-20060811/perfsonar/conf
copy Copying 1 file to /afs/slac.stanford.edu/g/scs/net/netmon/perfSONAR/SQLtypeMAService/java/20060811/perfSONAR-SQL_MA-src-snapshot-20060811/perfsonar/conf
get-message-1:
echo Start creating ant/const.properties file
echo -----------------------------------------------------------
_get-java-path:
get-java-path:
input Enter the path of Java /usr/local/java/current:
echo Accepted Java path: /usr/local/java/current
get-axis-path:
input Enter the path of Axis location /afs/slac.stanford.edu/g/scs/net/netmon/perfSONAR/SQLtypeMAService/java/20060811/perfSONAR-SQL_MA-src-snapshot-20060811/perfsonar/../apache-tomcat-5.5.17/webapps/axis:
/opt/tomcat/current/webapps/axis
echo Accepted Axis path: /opt/tomcat/current/webapps/axis
get-server-address:
input Enter the address of host (perfSONAR service location) localhost:
net-desk1.slac.stanford.edu
echo Accepted server address: net-desk1.slac.stanford.edu
get-server-port:
input Enter the port of server 8080:
80
echo Accepted server port: 80
set-const-properties-for-sqlma:
propertyfile Updating property file: /afs/slac.stanford.edu/g/scs/net/netmon/perfSONAR/SQLtypeMAService/java/20060811/perfSONAR-SQL_MA-src-snapshot-20060811/perfsonar/ant/const.properties
echo const.properties file created
input Press Return key ...
get-message-2:
echo Start creating conf/service.properties file
echo -----------------------------------------------------------
get-server-address:
input Enter the address of host (perfSONAR service location) localhost:
net-desk1.slac.stanford.edu
echo Accepted server address: net-desk1.slac.stanford.edu
get-xmldb-address:
input Enter the address of xmldb eXist localhost:
net-desk1.slac.stanford.edu
input Enter the port of xmldb eXist 8090:
8680
input Enter the type of access to xmldb eXist http:
echo Accepted xmldb server is http://net-desk1.slac.stanford.edu:8680/exist/rest/db/sqlmaconfig
__get-sql-config-file:
input Enter the path of sql metadata config file /afs/slac.stanford.edu/g/scs/net/netmon/perfSONAR/SQLtypeMAService/java/20060811/perfSONAR-SQL_MA-src-snapshot-20060811/perfsonar/conf/sql-database_TEST.xml:
/opt/perfSONAR/perfSONAR-SQ
L_MA-src-snapshot-20060811/perfsonar/conf/sql-database_TEST.xml
_get-sql-config-file_1:
_get-sql-config-file_2:
echo !!!!!! ERROR: Provided sql metadata config file does not exist !!!!!!
get-sql-config-file:
set-service-properties-for-sqlma:
propertyfile Updating property file: /afs/slac.stanford.edu/g/scs/net/netmon/perfSONAR/SQLtypeMAService/java/20060811/perfSONAR-SQL_MA-src-snapshot-20060811/perfsonar/conf/service.properties
echo service.properties file created
input Press Return key ...
get-message-3:
echo Start creating conf/log4j.properties file
echo -----------------------------------------------------------
set-log4j-properties:
propertyfile Updating property file: /afs/slac.stanford.edu/g/scs/net/netmon/perfSONAR/SQLtypeMAService/java/20060811/perfSONAR-SQL_MA-src-snapshot-20060811/perfsonar/conf/log4j.properties
echo log4j.properties file created
input Press Return key ...
get-message-4:
echo Start adding properties to Tomcat catalina.properties file
echo -----------------------------------------------------------
set-tomcat-properties:
input Enter the path of Tomcat location /afs/slac.stanford.edu/g/scs/net/netmon/perfSONAR/SQLtypeMAService/java/20060811/perfSONAR-SQL_MA-src-snapshot-20060811/perfsonar/../apache-tomcat-5.5.17:
/opt/tomcat/current
input Enter the path of service.properties file /afs/slac.stanford.edu/g/scs/net/netmon/perfSONAR/SQLtypeMAService/java/20060811/perfSONAR-SQL_MA-src-snapshot-20060811/perfsonar/conf/service.properties:
/opt/perfSONAR/perfSONAR-SQL_MA-src-snapshot-20060811/perfsonar/conf/service.properties
input Enter the path of components.properties file /afs/slac.stanford.edu/g/scs/net/netmon/perfSONAR/SQLtypeMAService/java/20060811/perfSONAR-SQL_MA-src-snapshot-20060811/perfsonar/conf/components.properties:
/opt/perfSONAR/perfSONAR-SQL_MA-src-snapshot-20060811/perfsonar/conf/components.properties
propertyfile Updating property file: /opt/tomcat/current/conf/catalina.properties
BUILD SUCCESSFUL
Total time: 6 minutes 26 seconds
code
- runing the xmldb-init-sqlma ant target results in
java.lang.NoSuchMethodError: org.exist.xmldb.XmldbURI.xmldbUriFor(Ljava/lang/String;)Lorg/exist/xmldb/XmldbURI