In order to publish the report on to prod-msr.geant.net please carry out the following:Copy the topology diagrams
Step One: Export to local machine from test-msr
- 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 Copy the graphs generated from the /var/lib/tomcat6/webapps/msr/media/graphs directory to your home directory on test-msr.geant.net: 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
Using 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 started 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 Copy the topology diagrams from your laptop to the your home directory on prod-msr then SSH to prod-msr and copy that directory to /var/lib/tomcat6/webapps/msr/media/topology directory on on prod-msr.geant.net (First copy the directory to your home directory(using WinScp) then copy them to /var/lib/tomcat6/webapps/msr/media/). (sudo cp -r topology/ /var/lib/tomcat6/webapps/msr/media/
Copy the graphs )
2- Use WinSCP to copy the graphs directory from your laptop to the /var/lib/tomcat6/webapps/msr/media/graphs your home directory on prod-msr .geant.net (First copy the directory to your home directory(using WinScp) then copy them to then SSH to prod-msr and copy that directory to /var/lib/tomcat6/webapps/msr/media/)i.e. sudo on prod-msr.geant.net. (sudo cp -r graphs/ /var/lib/tomcat6/webapps/msr/media/)
Using 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 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
...