Support_MDVPN

Tip: This report needs to be generated monthly, and you need Splunk data for the month before you can create the report. I'd finish off MSR report then come to generate this report.

The Multi-Domain Virtual Private Network Monthly Service Report (MDVPN 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)

CACTI (http://cacti.geant.net/cacti/) is used to poll the VPN Proxy devices to ascertain the BGP Status of the connections. No RRD files are updated as the status of the service is recorded within the md_vpn database on the Cacti machine. In addition the two VPN Route Refelector (VPNRR) devices (Ljubljana and Paris) are also polled. All the data sources use the BGP Status MySQL data input template 

Every month the data is prepared on prod-cacti02-vie-at.geant.net (62.40.104.148) and stored within a MySQL database on the same machine. The database that the MDVPN MSR uses is called md_vpn. The MySQL user that is used to access the database is mdvpnUser. The password is stored within LastPass and KeyPass

The URL for the test server is http://test-msr.geant.net:8888/mdvpn/

The URL for the production server is either http://test-msr.geant.net:8888/mdvpn/ or https://tools.geant.net/portal/links/mdvpn/ (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/mdvpn/ file on test-msr.geant.net. This scripts includes other scripts that are stored in the  /var/lib/tomcat6/webapps/mdvpn/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.

Every 5 minutes, a CRON job runs on the test-msr.geant.net server and executes /home/local/GEANT/dante.sanigar/scripts/mdvpn_status.sh. This calls a JAVA batch program called net.dante.md_vpn.MDVPNStatus.

** IMPROVEMENT - Copy the application over to prod-msr.geant.net