14.0 Publishing The Report

In order to publish the report on to prod-msr.geant.net please carry out the following:

Copy the topology diagrams from the /var/lib/tomcat6/webapps/msr/media/toplogy directory on test-msr.geant.net to your laptop

** Please note the year and month format of the file name e.g. BACKBONE_201707.png

If either of the topology diagrams (BACKBONE_YYYYMM.png, GLOBAL_YYYYMM.jpg) are not present, copy the previous period's and rename to the current period.

Copy the graphs generated from the /var/lib/tomcat6/webapps/msr/media/graphs directory on test-msr.geant.net to your laptop

** Please note the year and month format of the file name e.g. NREN_201707.png

Using MySQL Workbench, export the otrs database to your laptop

Using MySQL Workbench export the reports database tables (excluding views and tables started with the word backup_outage)

Copy the topology diagrams from your laptop to the /var/lib/tomcat6/media/toplogy directory on prod-msr.geant.net 

Copy the graphs from your laptop to the /var/lib/tomcat6/media/graphs directory on prod-msr.geant.net

Using MySQL Workbench, import the otrs database from your laptop onto prod-msr.geant.net

Using MySQL Workbench import the reports database tables from your laptop onto prod-msr.geant.net

Edit the /var/lib/tomcat6/includes/mainmenu.jsp on prod-msr.geant.net to include the new report in the Previous Reports section of the menu

The final report can be reviewed from these URLs: http://prod-msr.geant.net:8888/msr/ and https://tools.geant.net/portal/links/msr/

** WARNING - Sometimes the MSR, when viewed from the tools portal does not display the É character of GÉANT properly. To overcome this, you may have to change the data in the database to be GÉANT instead.