Page History

[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

[ytl@net-desk1:/opt/mysql/current/bin]$ sudo -s
[root@net-desk1 bin]# cat /var/lib/mysql/
ibdata1                          ib_logfile1                      net-desk1.slac.stanford.edu.err  
ib_logfile0                      mysql.sock                       
[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

[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 '########'

[ytl@net-desk1:/opt/perfSONAR]$ mysql --socket=/var/lib/mysql/mysql.sock \
  -u root -p < mysql-sqlma-dbsetup.sql 
Enter password: 

[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 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
#...

[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