Page History

To add an entry to "VPN Status Through Proxy XXXX" section follow all instructions

To add an entry to "MD-VPN Status For NRENs" section follow instructions 1-5 but change the name of the table you create accordingly e.g. SURFnet_BGP_LU or SURFnet_VRR_Paris

In this example, we are creating a VPN-Proxy for SURFnet

1. Login into prod-cacti02-vie-at-geant.net   ---- Step 1 and Step 2 can be done in MySQL Workbench by logging to "MDVPN" database on prod-cacti02-vie-at-geant.net 

 $> sudo mysql-as-root

2. 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

another example: (note nren name, this needs to be changed according to the request we receive) i.e. ticket (2018071634000816)

CREATE TABLE `JANET_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 

3. Create a new data source in Cacti to store the BGP Peering Status, an example is given below: - Step 3 and 4 can be done by Network Engineers in Operations team (i.e. Niall, Cristian ...)

http://prod-cacti02-vie-at.geant.net/cacti/data_sources.php?action=ds_edit&id=32008 . You can fetch a cacti login admin account in the password manager.

...

 5. A row needs to be added to the msr_vpn_status_proxy table: can be done in MySQL Workbench by logging to "MDVPN" database on prod-cacti02-vie-at-geant.net 

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); Values in Red to be provided by the requester

 The NREN name must match (it’s case sensitive) the NREN name of the new table that has been created.

 <---------------------This sections section below needs to be reviewed, as its it's prone to a number of problems: first test-vms are shut down by IT to save resources, and breaks separarion separation of concerns principles etc ------------------>

...

http://test-msr.geant.net:8888/mdvpn/ms_status_dashboard.jsp

You will need to change the following in the "ms_status_dashboard.jsp" page:

1. PreparedStatement, ResultSet and boolean resultset10HasData as in lines (17 - 59)
2. String sqlString10 = ""; as in lines (63 - 73)
3. sqlString10 as in lines (106 - 149)
4. statement10 = conn.prepareStatement(sqlString); ..etc as in lines (156 - 198)
5. add a new table as in lines (797 -  840)

TODO: To script the database tasks