...
| Code Block |
|---|
[ytl@net-desk1:/opt/perfSONAR/current-SQL_MA/perfsonar/ant]$ ant -f build-sqlma.xml run-sqlma-client-key-L2status-1
Buildfile: build-sqlma.xml
run-sqlma-client-key-L2status-1:
[java] End point: http://net-desk1.slac.stanford.edu:80/axis/services/MeasurementArchiveService
[java] Request file: \
/afs/slac.stanford.edu/g/scs/net/netmon/perfSONAR/SQLtypeMAService/java/20060901/\
perfSONAR-SQL_MA-src-snapshot-20060901/perfsonar/schema/example-instances/sonar/\
MetadataKey-L2status-Req-1.xml
[java] Response file: \
/afs/slac.stanford.edu/g/scs/net/netmon/perfSONAR/SQLtypeMAService/java/20060901/\
perfSONAR-SQL_MA-src-snapshot-20060901/perfsonar/schema/example-instances/sonar/\
response.xml
[java] [#document: null]
[java] time taken :4.407 secs
[java] Client exiting
BUILD SUCCESSFUL
Total time: 9 seconds
|
| Code Block |
|---|
[ytl@net-desk1:/opt/perfSONAR/current-SQL_MA/perfsonar/ant]$ ant -f build-sqlma.xml run-sqlma-client-key-util |
...
Buildfile: build-sqlma.xml |
...
run-sqlma-client-key-util: |
...
[java] End point: http://net-desk1.slac.stanford.edu:80/axis/services/MeasurementArchiveService |
...
[java] Request file: \ |
...
/afs/slac.stanford.edu/g/scs/net/netmon/perfSONAR/SQLtypeMAService/java/20060901/\ |
...
perfSONAR-SQL_MA-src-snapshot-20060901/perfsonar/schema/example-instances/sonar/\ |
...
MetadataKey-Req.xml |
...
[java] Response file: \ |
...
/afs/slac.stanford.edu/g/scs/net/netmon/perfSONAR/SQLtypeMAService/java/20060901/\ |
...
perfSONAR-SQL_MA-src-snapshot-20060901/perfsonar/schema/example-instances/sonar/\ |
...
response.xml |
...
[java] [#document: null] [java] time taken :0.202 |
...
secs
[java] Client exiting
BUILD SUCCESSFUL
Total time: 3 seconds
|
| Code Block |
|---|
[ |
BUILD SUCCESSFUL
Total time: 3 seconds
| Code Block |
|---|
ytl@net-desk1:/opt/perfSONAR/current-SQL_MA/perfsonar/ant]$ ant -f build-sqlma.xml run-sqlma-client-data-util-1Buildfile: build-sqlma.xml |
...
run-sqlma-client-data-util-1: |
...
[java] End point: http://net-desk1.slac.stanford.edu:80/axis/services/MeasurementArchiveService |
...
[java] Request file: \ |
...
/afs/slac.stanford.edu/g/scs/net/netmon/perfSONAR/SQLtypeMAService/java/20060901/\ |
...
perfSONAR-SQL_MA-src-snapshot-20060901/perfsonar/schema/example-instances/sonar/\ |
...
SetupDataRequest-FilterRRDSelect-2.xml |
...
[java] Response file: \ |
...
/afs/slac.stanford.edu/g/scs/net/netmon/perfSONAR/SQLtypeMAService/java/20060901/\ |
...
perfSONAR-SQL_MA-src-snapshot-20060901/perfsonar/schema/example-instances/sonar/\ |
...
response.xml |
...
[java] [#document: null] [java] time taken :0.202 |
...
secs
[java] Client exiting
BUILD SUCCESSFUL
Total time: 3 seconds
|
Just to make sure there's data in the tables;
| Code Block |
|---|
[ |
BUILD SUCCESSFUL
Total time: 3 seconds
| Code Block |
|---|
Just to make sure there's data in the tables;
|
ytl@net-desk1:/opt/perfSONAR/current-SQL_MA/perfsonar/ant]$ mysql -u perfsonar_ma -p |
...
Enter password: |
...
Welcome to the MySQL monitor. Commands end with ; or \g. |
...
Your MySQL connection id is 19 to server version: 5.0.24-standard |
...
Type 'help;' or '\h' for help. Type '\c' to clear the buffer. |
...
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> select * from perfsonar_utilization; |
...
+------------+--------+------------+------------+-------------------- |
...
metadataId | value | valueUnits | timeValue | ts |
-+ | metadataId | value | valueUnits | timeValue | ts | +------------+--------+------------+------------+--------------- |
...
meta1-test
------+ | meta1-test | 2.0000 |
...
bps
...
1143034705
| bps | 1143034705 | 2006-08-30 11:34:05 |
...
| | meta2-test |
...
| 3.0000 |
...
bps
...
1143034706
| bps | 1143034706 | 2006-08-30 11:34:05 |
...
| | meta3-test |
...
| 4.0000 |
...
bps
...
1143034707
| bps | 1143034707 | 2006-08-30 11:34:05 |
...
| | meta4-test |
...
| 5.0000 |
...
bps
...
1143034709
| bps | 1143034709 | 2006-08-30 11:34:05 |
...
| +------------+--------+------------+------------+--------------------- |
...
+ 4 rows in set (0.02 sec) |
...
mysql> select * from interdomain_link; |
...
Empty set (0.00 sec) |
...
mysql> select * from domain_link; |
...
+------------------------+---------------------+-------------+--------------+--------------+ |
...
id
...
time
...
status_oper
...
status_admin
----------+ | id | time | status_oper | status_admin | alarm_id_set |
...
comments
| comments | +------------------------+---------------------+-------------+--------------+--------------+------- |
...
---+ | DFN-link-1234 |
...
| 2006-04-06 12:15:23 |
...
down
...
UNKNOWN
...
NULL
...
NULL
| down | UNKNOWN | NULL | NULL | | DFN-Surfnet-Link-5678 |
...
| 2006-04-06 12:15:24 |
...
up
...
UNKNOWN
...
NULL
...
NULL
| up | UNKNOWN | NULL | NULL | | PSNC-DFN-MUE-Link-1001 |
...
| 2006-04-06 12:15:25 |
...
down
...
UNKNOWN
...
NULL
...
NULL
| down | UNKNOWN | NULL | NULL | +------------------------+---------------------+-------------+--------------+--------------+----------+ |
...
3 rows in set (0.01 sec) |
...
|