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:
#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
#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
# $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 #...
#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