Files
The SQL MA snapshot perfSONAR-SQL_MA-src-snapshot-20060811 was used. Untar'd and linked from /opt/
:
[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
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:
\[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
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)
[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
eXist Database Configuration
- runing the
xmldb-init-sqlma
ant target results in
[ytl@net-desk1:/opt/perfSONAR/perfSONAR-SQL_MA-src-snapshot-20060811/perfsonar/ant]$ ant -f build-sqlma.xml xmldb-init-sqlma xmldb-init-sqlma: getresource-rrdma: xmldb-exist-rrdma: [exist] Checking collection: xmldb:exist://net-desk1.slac.stanford.edu:8680/exist/xmlrpc/db/sqlmaconfig __xmldb-init-rrdma: xmldb-init-rrdma: getdbroot-rrdma: get-xmldb-collection: xmldb-collection-rrdma: [create] Database driver already registered. BUILD FAILED /afs/slac.stanford.edu/g/scs/net/netmon/perfSONAR/SQLtypeMAService/java/20060811/perfSONAR-SQL_MA-src-snapshot-20060811/perfsonar/ant/sqlma/sqlma-exist-xmldb-targets.xml:29: The following error occurred while executing this line: /afs/slac.stanford.edu/g/scs/net/netmon/perfSONAR/SQLtypeMAService/java/20060811/perfSONAR-SQL_MA-src-snapshot-20060811/perfsonar/ant/rrdma/rrdma-exist-xmldb-targets.xml:147: The following error occurred while executing this line: java.lang.NoSuchMethodError: org.exist.xmldb.XmldbURI.xmldbUriFor(Ljava/lang/String;)Lorg/exist/xmldb/XmldbURI;