The Administration sub sections are completed by the Operations team.

Tip: Software Development team needs to do section Generate Graphs below:

Management Summary

The Operations team use the following link to update this section: http://test-msr.geant.net:8888/msr/ad_summary.jsp 

...

Check the results by using the link: http://test-msr.geant.net:8888/msr/mo_services.jsp

Point To Point Services

The Operations team Business Development use the following link to update this section: http://test-msr.geant.net:8888/msr/ad_p2p.jsp

Image Added

Click the icon indicated by the Red arrow and answer Yes to the question Are you sure you wish to Reload Point-to-Point Services?

The main MySQL Tables used are: reports.msr_p2p_services

...

Check the results by using the links: http://test-msr.geant.net:8888/msr/gi_topology1.jsp and http://test-msr.geant.net:8888/msr/gi_topology.jsp

Generate Graphs

The Operations team use Use the following link to update this section: http://test-msr.geant.net:8888/msr/ad_graphs.jsp

Prior to generating the Interconnect Traffic graph, you will need to run the following query: (Use either MySQL Workbench or Heidi-SQL clients to run the 2 queries below)

1:

SELECT ROUND(volume_in,1) as 'Volume In',ROUND(volume_out,1) as 'Volume Out'
FROM reports.excel_yearly_volumes
WHERE project='GEANT2'
AND circuit_usage='Interconnect'
AND period = 201706 201707;

** Pay attention to the concatenated year and month values in the SQL statement

...

Take a note of the volume_in and volume_out values and then insert a record in the reports.msr_graphical_data table using the following SQL statement:

2:

INSERT INTO reports.msr_graphical_data (period,year,month,from_data,to_data) values ('201707',2017,7, 5675.2,5427.3);

** Pay attention to the concatenated year and month values in the SQL statement

*** The from_data field value should be set to the value of volume_in and the to_data field value should be set to the value of volume_out 

Now, Please click the Generate Graph button for the following graphs:

...

Interconnect Traffic

DWS Traffic

IPv6 TraffTraffic

LHCONE

INFO: When you click the Generate Graph button, a call is made to the GraphGenerator servlet (net.dante.msr.graphs.GraphGenerator), which constructs the graphs. The generated images are stored in the /var/lib/tomcat6/webapps/msr/media/images directory on the server.

** Warning - Sometimes there is a browser caching issue and you may have to refresh the page (Press F5 button) to see the generated graph appear at the bottom of the page. Or, you might need to restart tomcat on test MSR. Run command: “sudo service tomcat6 restart”

INFO: The main MySQL Tables used are: reports.report_utilization, reports.opsdb_circuit and reports.msr_graphical_data

...