Page History

...

Every month the data is prepared on test-msr.geant.net (6283.4097.10492.162151) and stored within a MySQL database on the same machine. The databases that the MSR uses are called reports and otrs. The MySQL user that is used to access the database is reportsUser. The password is stored within KeyPass

At the end of the process, the data is exported using MySQL Workbench and copied over to the production server prod-msr.geant.net (6283.4097.10493.1647). In addition, the graphs and topology images are also copied across from the test to the production server.

...

*** Talk about differences in getSession.jsp file wrt user roles

You need to clone 3 repositories to your local development environment:

https://gitlab.geant.net/live-projects/webapps-msr

https://gitlab.geant.net/msr-automation/msrgenerator

...

The below scripts rely on a couple of includes:

includes/getSession.jsp

includes/getGlobal.jsp

Click link in ad_roll_report.jsp

Goes to http://test-msr.geant.net:8888/msr/ad_etl_confirm_new.jsp?DATA=Roll%20Report%20Period

After confirmation the browser is redirected to ad_etl_status_new.jsp?DATA=Roll%20Report%20Period

This page retrieves the month and year of the latest published MSR provided by the getSession.jsp script, rolls the month and year values as appropriate and initialises a few other variables

Updates the only record in the msr_control table with the new month and year values

Adds new entries into the following tables:

msr_reports

msr_reports_gn3

Updates the following table

msr_control

Redirects to the root of the application

If there is an extra period/month rolled (like rolling a month ahead) you need to do the below:

1. Delete the month record from "msr_reports" table
2. Delete the month record from "msr_reports_gn3" table
3. update the month record in "msr_contol " table

If you examine the /var/lib/tomcat6/webapps/msr/WEB-INF/web.xml file on the server, you will notice that the MSR also uses three Java Servlets:

...

TrendAnalysis (net.dante.msr.graphs.TrendAnalysis) - used by Individual graph pages: http://test-msr.geant.net:8888/msr/ms_nren_ip_util.jsp and http://test-msr.geant.net:8888/msr/ms_nren_int_util.jsp in the Trend Analysis section 

*** Add Source Code Repository information

You need to clone 4 repositories to your local development environment:

https://gitlab.geant.net/live-projects/webapps-msr ### JSP pages that contain MSR GUI interface

https://gitlab.geant.net/msr-automation/msrgenerator

https://gitlab.geant.net/msr-automation/cacti-utilisation

Graphs: https://gitlab.geant.net/live-projects/msr/-/tree/master/src/main/java/net/dante/msr ### These are the Java files responsible for graphs. Won't be changed frequently.