UPDATE ......From Tuesday 8 April 2025 we have changed the way that Single Sign-on works on this wiki. Please see here for more information:
Update
The Monthly Service Report (MSR) is a combination of various scripts to obtain and mash network traffic availability and utilisation data. There is a front-end GUI based on Java Server Pages (JSP)
Every month the data is prepared on test-msr.geant.net (62.40.104.162) 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 (62.40.104.164). In addition, the graphs and topology images are also copied across from the test to the production server.
The URL for the test server is http://test-msr.geant.net:8888/msr/
The URL for the production server is either http://prod-msr.geant.net:8888/msr or https://tools.geant.net/portal/links/msr/ (You will need to have tools portal access for this and be a member of the TP_MSR Active Directory Group
The JSP scripts are stored in the /var/lib/tomcat6/webapps/msr/ file on the server. This scripts includes other scripts that are stored in the /var/lib/tomcat6/webapps/msr/includes directory. Two of the important include files are getGlobal.jsp and getSession.jsp which set some Global Variables that are used within the application.
*** Talk about differences in getSession.jsp file wrt user roles
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:
GraphGenerator (net.dante.msr.graphs.GraphGenerator) - used by the Graph Generation page: http://test-msr.geant.net:8888/msr/ad_graphs.jsp in the Administration section
ExcelExport (net.dante.msr.CSVExport) - used by each page that has the Excel Export icon in it
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