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

Step One: Export to local machine from test-msr

  1. SSH to test-msr.geant.net and cd to "/var/lib/tomcat6/webapps/msr/media/", then copy the topology directory from the /var/lib/tomcat6/webapps/msr/media/ directory to your home directory on test-msr:  sudo cp -r topology/ /home/local/GEANT/omar.qouqas. Then use WinSCP to copy that directory to your laptop.

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

      NOTE: 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.

       

      2. SSH to test-msr.geant.net and cd to "/var/lib/tomcat6/webapps/msr/media/", then copy the graphs directory from the /var/lib/tomcat6/webapps/msr/media/ directory to your home directory on test-msr:  sudo cp -r graphs/ /home/local/GEANT/omar.qouqas.  Then use WinSCP to copy that directory to your laptop.

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


     3. Use MySQL Workbench to export the reports database tables:  From the Menu bar go to "Server" then "Data Export", choose "reports" database (excluding views and tables starting with the word backup_outage ): see below:


Step Two: Import to prod-msr from local machine


1- Use WinSCP to copy the topology directory from your laptop to your home directory on prod-msr then SSH to prod-msr and copy that directory to  /var/lib/tomcat6/webapps/msr/media/ on prod-msr.geant.net. (sudo cp -r topology/ /var/lib/tomcat6/webapps/msr/media/)

2- Use WinSCP to copy the graphs directory from your laptop to your home directory on prod-msr then SSH to prod-msr and copy that directory to  /var/lib/tomcat6/webapps/msr/media/ on prod-msr.geant.net. (sudo cp -r graphs/ /var/lib/tomcat6/webapps/msr/media/)

3- Use MySQL Workbench to import the reports database tables from your laptop onto prod-msr.geant.net. From the Menu bar go to "Server" then "Data Import", locate the database dump on your machine and then click "start import" see below:


4- Lastly, you need to edit the /var/lib/tomcat6/webapps/msr/includes/mainmenu.jsp on prod-msr.geant.net to include the new report in the Previous Reports section of the menu

**Make sure to make the changes in local repository ("Eclipse") and push the changes to Master branch

i.e. "<li><a id="menu.Jun.lmi" href="set_report_period.jsp?shift=0&year=2018&month=6&menu=left" target="_top">June</a></li>"


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&Eacute;ANT instead.

  • No labels