...
Code Block |
---|
[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 |
...
Code Block |
---|
[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
|
...
Code Block |
---|
[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!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:1517 InnoDB: SettingStarted; file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait...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:1617 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... [ERROR] Can't start server: can't create PID file: No such file or directory 060830 11:03:1617 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: waitmysqld ended |
Looks like it can't create the pid file in the mysqld directory - so created it manually:
Code Block |
---|
[root@net-desk1 bin]# cd /var/run/
[root@net-desk1 run]# mkdir mysqld
|
Tried to restart the server; same thing - log says:
Code Block |
---|
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: DoublewriteRestoring bufferpossible not found: creating newhalf-written data pages from the doublewrite InnoDB: Doublewrite buffer created buffer... 060830 11:06:10 InnoDB: CreatingStarting log foreignscan keybased constrainton systemcheckpoint tablesat InnoDB: Foreignlog keysequence constraintnumber system tables created 060830 11:03:17 InnoDB: Started;0 36808. InnoDB: Doing recovery: scanned up to log sequence number 0 043655 060830 11:0306:1710 [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:
Code Block |
---|
[root@net-desk1 bin]# cd /var/run/
[root@net-desk1 run]# mkdir mysqld
|
Tried to restart the server; same thing - log says:
Code Block |
---|
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:
Code Block |
---|
[ytl@net-desk1:/opt/mysql/current/bin]$ sudo chown -R mysql:mysql \
/var/lib/mysql/ \
/opt/mysql/current \
/var/run/mysqld
|
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:
Code Block |
---|
[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:
Code Block |
---|
[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 daemonRan the configuration for MySQL:
Code Block |
---|
[ytl@net-desk1:/opt/mysql/current/bin]$ sudo -s [root@net-desk1 current]# scripts/mysql_install_db./mysqld_safe --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:
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:
Code Block |
---|
[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
Code Block |
---|
[root@net-desk1 mysql]# pwd
/var/lib/mysql
[root@net-desk1 mysql]# chmod o+x .
|
Finally:
Code Block |
---|
[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:
Code Block |
---|
[ytl@net-desk1:/opt/mysql/current/bin]$ \
./mysqladmin --socket=/var/lib/mysql/mysql.sock -u root password '#######' |
Code Block |
[ytl@net-desk1:/opt/mysql/current/bin]$ sudo\ ./mysqld_safemysqladmin --usersocket=/var/lib/mysql Starting mysqld daemon with databases from /var/lib/mysql |
- assumed the previous errors were due to permission conflicts.
/mysql.sock -u root \
-h net-desk1.slac.stanford.edu password '########'
|
Lets initiate the SQL MA databases from the SQL file mysql-sqlma-dbsetup.sqlConnect to MySQL DB through the new socket, as the configuration appears to point to a socket file which doesn't exist:
Code Block |
---|
[ytl@net-desk1:/opt/perfSONAR]$ 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
Code Block |
---|
[root@net-desk1 mysql]# pwd
/var/lib/mysql
[root@net-desk1 mysql]# chmod o+x .
|
Finally:
Code Block |
---|
[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:
Code Block |
---|
[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
Code Block |
---|
[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:
--socket=/var/lib/mysql/mysql.sock \
-u root -p < mysql-sqlma-dbsetup.sql
Enter password:
|
This results in the following tables being created:
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 |
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_linkField | Type | | interdomain_link | Null | Key | | perfsonar_utilizationDefault | +------------------------+ 3 rows in set (0.00 sec) mysql> describe domain_link; | Extra | +--------------+--------------+------+-----+-------------------+-------+ | Fieldid | Type | varchar(255) | NO | Null | Key | Default | Extra | +--------------+--------------+------+-----+-------------------+-------+ | id | | varchar(255) | NO | time | | timestamp | | | 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) |
...
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]$ |
...
Code Block | ||
---|---|---|
| ||
#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 | ||
---|---|---|
| ||
# $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 |
---|
[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: : 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:
Code Block |
---|
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:
Code Block |
---|
[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-existjava-xmldbcompile-targets.xml:2942:\ 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/rrdmajava-existcompile-xmldb-targets.xml:6570:\ Class org.apache.tools.ant.taskdefs.ConditionTask doesn't support the nested "exist" element Compile failed; see the compiler error output for details. Total time: 19 secondseconds |
...