...
| Code Block |
|---|
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.
| Code Block |
|---|
[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:
| Code Block |
|---|
| title | 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
|
| Code Block |
|---|
| title | 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
|
| Code Block |
|---|
| title | 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
#...
|
| Code Block |
|---|
| title | /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
|