Files
The latest snapshot was recommended: SQL-MA
[ytl@net-desk1:/opt/perfSONAR]$ ls -lah
total 56K
drwxr-xr-x 3 ytl ytl 4.0K Aug 30 10:25 .
drwxr-xr-x 9 ytl ytl 4.0K Aug 29 12:18 ..
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-20060828
-rw-rw-r-- 1 ytl ytl 2.4K Aug 29 11:54 mysql-sqlma-dbsetup.sql
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
lrwxrwxrwx 1 ytl ytl 94 Aug 30 10:25 perfSONAR-SQL_MA-src-snapshot-20060828 -> \
/u/sf/ytl/Work/perfSONAR/SQLtypeMAService/java/20060828/\
perfSONAR-SQL_MA-src-snapshot-20060828
Note that the snapshot files are actually located on AFS space.
Exist Installation
Exist is already installed on net-desk1:8680.
Server 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 30 Aug 2006 10:31:36,020 [main] INFO \ (FileResource.java [<clinit>]:60) - Checking Resource aliases 30 Aug 2006 10:31:36,231 [main] INFO \ (HttpServer.java [setStatsOn]:1068) - Statistics on = false for org.mortbay.jetty.Server@97eded 30 Aug 2006 10:31:36,240 [main] INFO \ (HttpServer.java [start]:654) - Starting Jetty/5.0.0 30 Aug 2006 10:31:36,320 [main] INFO \ (HttpServer.java [start]:669) - Started org.mortbay.http.NCSARequestLog@1a897a9 30 Aug 2006 10:31:36,786 [main] INFO \ (HttpContext.java [start]:1604) - Started WebApplicationContext[eXist Server,eXist Server] Logging already initialized. Skipping... 30 Aug 2006 10:31:38,173 [main] WARN \ (JavaUtils.java [isAttachmentSupported]:1305) \ - Unable to find required classes \ (javax.activation.DataHandler and javax.mail.internet.MimeMultipart). \ Attachment support is disabled. 30 Aug 2006 10:31:38,686 [main] INFO \ (SocketListener.java [start]:204) - Started SocketListener on 0.0.0.0:8680 30 Aug 2006 10:31:38,687 [main] INFO \ (HttpServer.java [start]:690) - Started org.mortbay.jetty.Server@97eded
Just to make sure the eXist DB is running, run the X11 client:
[ytl@net-desk1:/opt/exist/current/bin]$ ./client.sh eXist version 1.0, Copyright (C) 2001-2006 Wolfgang Meier eXist comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to redistribute it under certain conditions; for details read the license file. GNU Readline found. IMPORTANT: Don't use GNU Readline to work with other character encodings than ISO-8859-1.
The sqlmaservice user was already added from a previous configuration.
Seems like everything is set up!
Conflicting MA Service
Noticed that the perfSONAR service runs the RRD MA Service also (as per my installation instructions):
Therefore undeployed the MA Service by:
[ytl@net-desk1:/opt/perfSONAR/current/scripts]$ ./MAAxisUndeploy.sh Processing file /opt/perfSONAR/perfSONAR-1.0/wsdd/ma-service-undeploy.wsdd <Admin>Done processing</Admin>
MySQL Database Setup
Downloaded a standalone version of MySQL:
[ytl@net-desk1:/opt/mysql]$ ls -lah total 42M drwxrwxr-x 3 ytl ytl 4.0K Aug 29 11:41 . drwxr-xr-x 9 ytl ytl 4.0K Aug 29 12:18 .. lrwxrwxrwx 1 ytl ytl 40 Aug 24 10:39 current -> mysql-standard-5.0.24-linux-i686-glibc23 -rw-rw-r-- 1 ytl ytl 13M Aug 1 06:25 MySQL-server-standard-5.0.24-0.rhel4.i386.rpm drwxr-xr-x 14 ytl ytl 4.0K Jul 27 20:55 mysql-standard-5.0.24-linux-i686-glibc23 -rw-r--r-- 1 ytl ytl 29M Aug 24 10:41 mysql-standard-5.0.24-linux-i686-glibc23.tar.gz
Added a MySQL user:
[ytl@net-desk1:/opt/mysql/current/bin]$ sudo /usr/sbin/luseradd mysql
Tried to start the server and got:
[ytl@net-desk1:/opt/mysql/current/bin]$ sudo ./mysqld_safe The file /usr/local/mysql/bin/mysqld doesn't exist or is not executable Please do a cd to the mysql installation directory and restart this script from there as follows: ./bin/mysqld_safe. See http://dev.mysql.com/doc/mysql/en/mysqld_safe.html for more information
Edited /opt/mysql/current/bin/mysqld_safe to move all links to /opt/mysql/current/ rather than /usr/local/mysql.
Tried to start server again:
[ytl@net-desk1:/opt/mysql/current/bin]$ sudo ./e Starting mysqld daemon with databases from /var/lib/mysql STOPPING server from pid file /var/run/mysqld/mysqld.pid 060830 11:03:17 mysqld ended
Somethings gone wrong.
[ytl@net-desk1:/opt/mysql/current/bin]$ sudo -s [root@net-desk1 bin]# cat /var/lib/mysql/net-desk1.slac.stanford.edu.err 060830 11:03:15 mysqld started InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 060830 11:03:15 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 060830 11:03:16 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 060830 11:03:16 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 060830 11:03:17 InnoDB: Started; log sequence number 0 0 060830 11:03:17 [ERROR] /opt/mysql/current/bin/mysqld: \ Can't create/write to file '/var/run/mysqld/mysqld.pid' (Errcode: 2) 060830 11:03:17 [ERROR] Can't start server: can't create PID file: No such file or directory 060830 11:03:17 mysqld ended
Looks like it can't create the pid file in the mysqld directory - so created it manually:
[root@net-desk1 bin]# cd /var/run/ [root@net-desk1 run]# mkdir mysqld
Tried to restart the server; same thing - log says:
060830 11:06:10 mysqld started 060830 11:06:10 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 060830 11:06:10 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 36808. InnoDB: Doing recovery: scanned up to log sequence number 0 43655 060830 11:06:10 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20\ 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50\ 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80\ 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed 060830 11:06:10 InnoDB: Started; log sequence number 0 43655 060830 11:06:10 [ERROR] /opt/mysql/current/bin/mysqld: \ Can't create/write to file '/var/run/mysqld/mysqld.pid' (Errcode: 13) 060830 11:06:10 [ERROR] Can't start server: can't create PID file: Permission denied 060830 11:06:10 mysqld ended
Make sure all permissions are set:
[ytl@net-desk1:/opt/mysql/current/bin]$ sudo chown -R mysql:mysql \
/var/lib/mysql/ \
/opt/mysql/current \
/var/run/mysqld
Ran the configuration for MySQL:
[ytl@net-desk1:/opt/mysql/current]$ sudo -s [root@net-desk1 current]# scripts/mysql_install_db --user=mysql Installing all prepared tables Fill help tables To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! To do so, start the server, then issue the following commands: ./bin/mysqladmin -u root password 'new-password' ./bin/mysqladmin -u root -h net-desk1.slac.stanford.edu password 'new-password' See the manual for more instructions. You can start the MySQL daemon with: cd . ; ./bin/mysqld_safe & You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; perl run-all-tests Please report any problems with the ./bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at http://shop.mysql.com
And started the daemon:
[ytl@net-desk1:/opt/mysql/current/bin]$ sudo ./mysqld_safe --user=mysql Starting mysqld daemon with databases from /var/lib/mysql
- assumed the previous errors were due to permission conflicts.
Connect to MySQL DB through the new socket, as the configuration appears to point to a socket file which doesn't exist:
[ytl@net-desk1:/opt/mysql/current/bin]$ mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Need to make sure we can access the socket file located in /var/lib/mysql
[root@net-desk1 mysql]# pwd /var/lib/mysql [root@net-desk1 mysql]# chmod o+x .
Finally:
[ytl@net-desk1:/opt/mysql/current/bin]$ mysql --socket=/var/lib/mysql/mysql.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 5.0.24-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql>
Make sure we set the root passwords:
[ytl@net-desk1:/opt/mysql/current/bin]$ \
./mysqladmin --socket=/var/lib/mysql/mysql.sock -u root password '#######'
[ytl@net-desk1:/opt/mysql/current/bin]$ \
./mysqladmin --socket=/var/lib/mysql/mysql.sock -u root \
-h net-desk1.slac.stanford.edu password '########'
Lets initiate the SQL MA databases from the SQL file mysql-sqlma-dbsetup.sql
[ytl@net-desk1:/opt/perfSONAR]$ mysql --socket=/var/lib/mysql/mysql.sock \ -u root -p < mysql-sqlma-dbsetup.sql Enter password:
This results in the following tables being created:
mysql> use perfsonar_ma; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> show tables; +------------------------+ | Tables_in_perfsonar_ma | +------------------------+ | domain_link | | interdomain_link | | perfsonar_utilization | +------------------------+ 3 rows in set (0.00 sec) mysql> describe domain_link; +--------------+--------------+------+-----+-------------------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+--------------+------+-----+-------------------+-------+ | id | varchar(255) | NO | | | | | time | timestamp | YES | | CURRENT_TIMESTAMP | | | status_oper | varchar(255) | YES | | UNKNOWN | | | status_admin | varchar(255) | YES | | UNKNOWN | | | alarm_id_set | varchar(255) | YES | | NULL | | | comments | varchar(255) | YES | | NULL | | +--------------+--------------+------+-----+-------------------+-------+ 6 rows in set (0.00 sec) mysql> describe interdomain_link; +--------------+--------------+------+-----+-------------------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+--------------+------+-----+-------------------+-------+ | id | varchar(255) | NO | | | | | time | timestamp | YES | | CURRENT_TIMESTAMP | | | status_oper | varchar(255) | YES | | UNKNOWN | | | status_admin | varchar(255) | YES | | UNKNOWN | | | alarm_id_set | varchar(255) | YES | | NULL | | | comments | varchar(255) | YES | | NULL | | +--------------+--------------+------+-----+-------------------+-------+ 6 rows in set (0.00 sec) mysql> describe perfsonar_utilization; +------------+-------------+------+-----+-------------------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+-------------+------+-----+-------------------+-------+ | metadataId | varchar(30) | NO | | | | | value | float(16,4) | NO | | | | | valueUnits | varchar(30) | YES | | NULL | | | timeValue | int(11) | NO | | | | | ts | timestamp | YES | | CURRENT_TIMESTAMP | | +------------+-------------+------+-----+-------------------+-------+ 5 rows in set (0.01 sec)
SQL-MA Configuration
Ran the ant target configure-sqlma to generate all the configuration files required for the MA service.
Note that /afs/slac.stanford.edu/g/scs/net/netmon/perfSONAR/SQLtypeMAService/java/20060828/
perfSONAR-SQL_MA-src-snapshot-20060828 is the same as /opt/perfsonar/current-SQL_MA - ie they are symlinked.
[ytl@net-desk1:/opt/perfSONAR/current-SQL_MA/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/20060828/\
perfSONAR-SQL_MA-src-snapshot-20060828/perfsonar/ant
[copy] Copying 1 file to \
/afs/slac.stanford.edu/g/scs/net/netmon/perfSONAR/SQLtypeMAService/java/20060828/\
perfSONAR-SQL_MA-src-snapshot-20060828/perfsonar/conf
copy-properties:
[copy] Copying 1 file to \
/afs/slac.stanford.edu/g/scs/net/netmon/perfSONAR/SQLtypeMAService/java/20060828/\
perfSONAR-SQL_MA-src-snapshot-20060828/perfsonar/ant
[copy] Warning: Could not find file \
/afs/slac.stanford.edu/g/scs/net/netmon/perfSONAR/SQLtypeMAService/java/20060828/\
perfSONAR-SQL_MA-src-snapshot-20060828/perfsonar/conf/service.properties to copy.
[copy] Copying 1 file to \
/afs/slac.stanford.edu/g/scs/net/netmon/perfSONAR/SQLtypeMAService/java/20060828/\
perfSONAR-SQL_MA-src-snapshot-20060828/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/20060828/\
perfSONAR-SQL_MA-src-snapshot-20060828/perfsonar/../apache-tomcat-5.5.17/webapps/axis]:
/opt/axis/current
[echo] Accepted Axis path: /opt/axis/current
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/20060828/\
perfSONAR-SQL_MA-src-snapshot-20060828/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 [xmlrpc]:
[echo] Accepted xmldb server is \
xmldb:exist://net-desk1.slac.stanford.edu:8680/exist/xmlrpc/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/20060828/\
perfSONAR-SQL_MA-src-snapshot-20060828/perfsonar/conf/sql-database_TEST.xml]: \
/opt/perfSONAR/current-SQL_MA/perfsonar/conf/sql-database_TEST.xml
_get-sql-config-file_1:
[echo] Accepted sql metadata config file: \
/opt/perfSONAR/current-SQL_MA/perfsonar/conf/sql-database_TEST.xml
_get-sql-config-file_2:
get-sql-config-file:
set-service-properties-for-sqlma:
[propertyfile] Creating new property file: \
/afs/slac.stanford.edu/g/scs/net/netmon/perfSONAR/SQLtypeMAService/java/20060828/\
perfSONAR-SQL_MA-src-snapshot-20060828/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/20060828/\
perfSONAR-SQL_MA-src-snapshot-20060828/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/20060828/\
perfSONAR-SQL_MA-src-snapshot-20060828/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/20060828/\
perfSONAR-SQL_MA-src-snapshot-20060828/perfsonar/conf/service.properties]:
/opt/perfSONAR/current-SQL_MA/perfsonar/conf/service.properties
[input] Enter the path of components.properties file \
[/afs/slac.stanford.edu/g/scs/net/netmon/perfSONAR/SQLtypeMAService/java/20060828/\
perfSONAR-SQL_MA-src-snapshot-20060828/perfsonar/conf/components.properties]:
/opt/perfSONAR/current-SQL_MA/perfsonar/conf/components.properties
[propertyfile] Updating property file: /opt/tomcat/current/conf/catalina.properties
BUILD SUCCESSFUL
Total time: 2 minutes 27 seconds
[ytl@net-desk1:/opt/perfSONAR/current-SQL_MA/perfsonar/ant]$
This generated the following files:
perfsonar/ant/const.properties
#This file was created by the Ant configuration script. #Wed Aug 30 11:42:21 PDT 2006 package.root=org/perfsonar axis.home=/opt/axis/current target.port=80 api.windowtitle=perfSONAR release.basename=perfSONAR rrdjdir=/opt/sonar/rrdjtool rrdtool_path=/usr jdk_path=/usr/local/java/current api.bottom=JRA1 GEANT2 Project wsdd.path=org/perfsonar/service/web/wsdd release.servicename=RRD_MA build=build api.title=perfSONAR wsdd.home=service/web/wsdd package.nmwg.root=org/ggf api.location=doc/api wsdd.file.undeploy=ma-service-undeploy.wsdd webservice.name=MeasurementArchiveService release.version=0.2 target.server=net-desk1.slac.stanford.edu wsdd.file.deploy=ma-service-deploy.wsdd
perfsonar/conf/service.properties
#This file was created by the Ant configuration script. #Wed Aug 30 11:43:23 PDT 2006 service.r.service_type=SQL MA component.ma.xmldb.db_uri=\ xmldb\:exist\://net-desk1.slac.stanford.edu\:8680/exist/xmlrpc/db/sqlmaconfig component.ma.xmldb.db_password=sqlmaservice service.r.service_description=Java SQL MA, perfSONAR project component.ma.xmldb.db_status=on component.ma.xmldb.db_uri.xmlrpc=\ xmldb\:exist\://net-desk1.slac.stanford.edu\:8680/exist/xmlrpc/db/sqlmaconfig service.log.log4j.config= /afs/slac.stanford.edu/g/scs/net/netmon/perfSONAR/SQLtypeMAService/java/20060828/\ perfSONAR-SQL_MA-src-snapshot-20060828/perfsonar/conf/log4j.properties service.r.ls_url= service.r.type=ma service.r.access_point=\ http\://net-desk1.slac.stanford.edu\:8080/axis/services/MeasurementArchiveService component.registrator.scheduler_component=ma_scheduler service.ma.xmldb.db_store=off component.registrator.interval=30000 service.ma.class_name=\ org.perfsonar.service.measurementArchive.sqlType.SQLTypeMAServiceEngine service.ma.message_types=\ MetadataKeyRequest,SetupDataRequest,MeasurementArchiveStoreRequest service.sax_parser.config=\ /afs/slac.stanford.edu/g/scs/net/netmon/perfSONAR/SQLtypeMAService/java/20060828/\ perfSONAR-SQL_MA-src-snapshot-20060828/perfsonar/src/objects.config component.ma.xmldb.db_username=sqlmaservice component.ma.xmldb.db_access=xmlrpc service.r.service_name=Java SQL MA service.ma.conf_file=\ /opt/perfSONAR/current-SQL_MA/perfsonar/conf/sql-database_TEST.xml
perfsonar/conf/components.properties
# $Id: components.properties.ma 1556 2006-08-21 14:08:08Z roman $ # File contains components to load # Config and logger MUST be load as first! # Configuration component - must be the first one! config=\ org.perfsonar.commons.auxiliary.components.\ configuration.properties.PropertiesConfigurationComponent # Logger component - must be the second one! logger=org.perfsonar.commons.auxiliary.components.logger.log4j.Log4jLoggerComponent # Simple scheduler #ma_scheduler=org.perfsonar.commons.auxiliary.components.simplescheduler.Scheduler # Registration in LS #registrator=org.perfsonar.service.measurementArchive.register.LSRegistrationComponent eventType_config=\ org.perfsonar.service.measurementArchive.eventTypeConfig.EventTypeConfigurationComponent #Service specific components #...
/opt/tomcat/current/conf/catalina.properties
#tranformed by perfSONAR
#Wed Aug 30 11:44:01 PDT 2006
server.loader=${catalina.home}/server/classes,${catalina.home}/server/lib/*.jar
package.access=\
sun.,org.apache.catalina.,org.apache.coyote.,org.apache.tomcat.,org.apache.jasper.,sun.beans.
shared.loader=${catalina.base}/shared/classes,${catalina.base}/shared/lib/*.jar
package.definition=\
sun.,java.,org.apache.catalina.,org.apache.coyote.,org.apache.tomcat.,org.apache.jasper.
common.loader=\
${catalina.home}/common/classes,${catalina.home}/common/i18n/*.jar,\
${catalina.home}/common/endorsed/*.jar,${catalina.home}/common/lib/*.jar
service.properties=/opt/perfSONAR/current-SQL_MA/perfsonar/conf/service.properties
tomcat.util.buf.StringCache.byte.enabled=true
components.properties=/opt/perfSONAR/current-SQL_MA/perfsonar/conf/components.properties
eXist Database Initialisation
Ran the ant target xmldb-init-sqlma:
[ytl@net-desk1:/opt/perfSONAR/current-SQL_MA/perfsonar/ant]$ \ ant -f build-sqlma.xml xmldb-init-sqlma Buildfile: build-sqlma.xml xmldb-init-sqlma: getresource-rrdma: xmldb-exist-rrdma: BUILD FAILED /afs/slac.stanford.edu/g/scs/net/netmon/perfSONAR/SQLtypeMAService/java/20060828/\ perfSONAR-SQL_MA-src-snapshot-20060828/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/20060828/\ perfSONAR-SQL_MA-src-snapshot-20060828/perfsonar/ant/rrdma/rrdma-exist-xmldb-targets.xml:65:\ Class org.apache.tools.ant.taskdefs.ConditionTask doesn't support the nested "exist" element. Total time: 1 second
Darn.
Email from Roman suggested that the ant v1.6.2+ should support exist tasks. i'm using 1.6.5 tho. Anyway, he also said that I could just initiated it all manually.
So, created the collection via the eXist GUI and changed the properties:
Now need to create the store: the GUI asks for the location of an XML file to use. Looking throught the ant tasks shows that i need to find service.ma.conf_file which points to /opt/perfSONAR/current-SQL_MA/perfsonar/conf/sql-database_TEST.xml.
Selected and uploaded. Changed the ownership to me.
And the final list of eXist stuff is:
The ant list stuff didn't work. But assuming that the above configuration is okay.
SQL-MA Compilation
Download the jars and libs by using the command:
ant -f build-sqlma.xml libs-sqlma
This copies a load of stuff from the web into /opt/perfSONAR/current-SQL_MA/perfsonar/lib/repository. Took over 10 minutes.
Compiling the files results in an error:
[ytl@net-desk1:/opt/perfSONAR/current-SQL_MA/perfsonar/ant]$ ant -f build-sqlma.xml build-sqlma
Buildfile: build-sqlma.xml
build-sqlma:
clean-all:
[delete] Deleting directory /afs/slac.stanford.edu/g/scs/net/netmon/perfSONAR/\
SQLtypeMAService/java/20060828/perfSONAR-SQL_MA-src-snapshot-20060828/perfsonar/build/org
clean-jar-generic:
compile-generic:
[javac] Compiling 242 source files to /afs/slac.stanford.edu/g/scs/net/netmon/perfSONAR/\
SQLtypeMAService/java/20060828/perfSONAR-SQL_MA-src-snapshot-20060828/perfsonar/build
[javac] /afs/slac.stanford.edu/g/scs/net/netmon/perfSONAR/SQLtypeMAService/java/20060828/\
perfSONAR-SQL_MA-src-snapshot-20060828/perfsonar/src/org/perfsonar/client/testHarness/\
SOAPClient.java:129: cannot find symbol
[javac] symbol : method setFormat(org.jdom.output.Format)
[javac] location: class org.jdom.output.XMLOutputter
[javac] outputter.setFormat(format);
[javac] ^
[javac] /afs/slac.stanford.edu/g/scs/net/netmon/perfSONAR/SQLtypeMAService/java/20060828/\
perfSONAR-SQL_MA-src-snapshot-20060828/perfsonar/src/org/perfsonar/client/testHarness/\
SOAPClientMulti.java:192: cannot find symbol
[javac] symbol : method setFormat(org.jdom.output.Format)
[javac] location: class org.jdom.output.XMLOutputter
[javac] outputter.setFormat(format);
[javac] ^
[javac] Note: Some input files use unchecked or unsafe operations.
[javac] Note: Recompile with -Xlint:unchecked for details.
[javac] 2 errors
BUILD FAILED
/afs/slac.stanford.edu/g/scs/net/netmon/perfSONAR/SQLtypeMAService/java/20060828/\
perfSONAR-SQL_MA-src-snapshot-20060828/perfsonar/ant/sqlma/sqlma-java-compile-targets.xml:42:\
The following error occurred while executing this line:
/afs/slac.stanford.edu/g/scs/net/netmon/perfSONAR/SQLtypeMAService/java/20060828/\
perfSONAR-SQL_MA-src-snapshot-20060828/perfsonar/ant/java-compile-targets.xml:70:\
Compile failed; see the compiler error output for details.
Total time: 9 seconds