Step 1: Adding entry to Configuration files

  1. Add traceroute metadata information to $PERFSONAR/conf/sql_database_TEST.xml (e.g)
    • Make sure you declare correct namespaces.
  2. Make ibatis configuration files
    1. Write Ibatis-SQL-Map-Config: provide JDBC connection parameters for the traceroute datasource.
    2. Write SQL queries for fetching data in ibatis-SQL-Map files for respective metrics. Examples are there in $PERFSONAR/conf/ directory.

Step 2: MetadataQueryGenerator

Implement an interface org.perfsonar.service.measurementArchive.metadataConfig.queryGenerator.MetadataQueryGenerator.
view: TracerouteMetadataQueryGenerator.java

 Step 3: ResponseGenerator

 Implmeent an Interface org.perfsonar.service.measurementArchive.sqlType.fetch.ResponseGenerator.
view: TracerouteResponseGenerator.java

 Step 4: Adding Mapping entry of new Metric to the service

Add the implmented classes entry into the $PERFSONAR/conf/eventType_map.xml

<eventType>
      <name>traceroute</name>
 <metadataQueryGenerator>org.perfsonar.service.measurementArchive.metadataConfig.queryGenerator.TracerouteQueryGenerator</metadataQueryGenerator>
<responseGenerator>org.perfsonar.service.measurementArchive.sqlType.fetch.TracerouteResponseGenerator</responseGenerator>
</eventType>

 Step 5: Recompile and redeploy the service

Executing the following commands in order from $PERFSONAR/ant directory and enter the exact information asked for the configuration 

  1. ant -f build-sqlma.xml xmldb-init-sqlma
  2. ant -f build-sqlma.xml configure-sqlma
  3. start/restart tomcat
  4. ant -f build-sqlma.xml undeploy-sqlma
  5. ant -f build-sqlma.xml deploy-sqlma

Step 6: Testing

  • No labels