In this example, we are creating a VPN-Proxy for SURFnet
Create a new table in the MySQL database called SURFnet_VPN_Proxy . The MySQL database is called md_vpn and is located on the prod-cacti02-vie-at-geant.net server
CREATE TABLE `SURFnet_VPN_Proxy` (
`utc_time_stored` bigint(20) NOT NULL,
`availability` smallint(6) NOT NULL DEFAULT '0',
PRIMARY KEY (`utc_time_stored`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Create a new data source in Cacti to store the BGP Peering Status, an example is given below:
http://prod-cacti02-vie-at.geant.net/cacti/data_sources.php?action=ds_edit&id=32008
The Table Name in the data source has to match completely (it’s case sensitive) to the Table Name in the MySQL database.
A row needs to be added to the msr_vpn_status_proxy table:
insert into msr_vpn_status_proxy (vpn_proxy_name,ip_address,nren_name,vpn_number,vpn_type,vpn_status) values ('VPN-Proxy Amsterdam','62.40.97.11','SURFnet','PRACE','L3',1);
The NREN name must match (it’s case sensitive) the NREN name of the new table that has been created.
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.
This program gets the last status value from the <NREN_NAME>_VPN_Proxy tables and updates the msr_vpn_status_proxy table, with either 0 or 1.
Last thing is to update the /var/lib/tomcat6/webapps/mdvpn/ms_status_dashboard.jsp on test-msr.geant.net server to add the new table at the bottom of the page.
http://test-msr.geant.net:8888/mdvpn/ms_status_dashboard.jsp