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
On md_vpn database on prod-cacti02-vie-at.geant.net run all the queries below. (Use MySQL Workbench)
MD VPN Availability Summary
Please run the following SQL statements to initialise the data:
INSERT INTO msr_service_availability VALUES ('VPN','AMRES',2017,7,'00:00:00',1,'00:00:00',1);
INSERT INTO msr_service_availability VALUES ('VPN','BELnet',2017,7,'00:00:00',1,'00:00:00',1);
INSERT INTO msr_service_availability VALUES ('VPN','BREN',2017,7,'00:00:00',1,'00:00:00',1);
INSERT INTO msr_service_availability VALUES ('VPN','CARnet',2017,7,'00:00:00',1,'00:00:00',1);
INSERT INTO msr_service_availability VALUES ('VPN','DFN',2017,7,'00:00:00',1,'00:00:00',1);
INSERT INTO msr_service_availability VALUES ('VPN','FUnet',2017,7,'00:00:00',1,'00:00:00',1);
INSERT INTO msr_service_availability VALUES ('VPN','FCCN',2017,7,'00:00:00',1,'00:00:00',1);
INSERT INTO msr_service_availability VALUES ('VPN','GARR',2017,7,'00:00:00',1,'00:00:00',1);
INSERT INTO msr_service_availability VALUES ('VPN','GRnet',2017,7,'00:00:00',1,'00:00:00',1);
INSERT INTO msr_service_availability VALUES ('VPN','HEAnet',2017,7,'00:00:00',1,'00:00:00',1);
INSERT INTO msr_service_availability VALUES ('VPN','HUNGARnet',2017,7,'00:00:00',1,'00:00:00',1);
INSERT INTO msr_service_availability VALUES ('VPN','NORDUnet',2017,7,'00:00:00',1,'00:00:00',1);
INSERT INTO msr_service_availability VALUES ('VPN','PIONIER',2017,7,'00:00:00',1,'00:00:00',1);
INSERT INTO msr_service_availability VALUES ('VPN','RedIRIS',2017,7,'00:00:00',1,'00:00:00',1);
INSERT INTO msr_service_availability VALUES ('VPN','RENATER',2017,7,'00:00:00',1,'00:00:00',1);
INSERT INTO msr_service_availability VALUES ('VPN','SUnet',2017,7,'00:00:00',1,'00:00:00',1);
** Pay attention to the year and month values in the SQL statement
MD VPN Availability Detailed
Please run the following SQL statements to initialise the data:
INSERT INTO msr_vpn_availability (year,month,nren_name,bgp_lu_access_1,bgp_lu_access_1_maint,bgp_lu_access_2,bgp_lu_access_2_maint,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vr_peering_3,vr_peering_3_maint,vr_peering_4,vr_peering_4_maint,md_vpn_status,md_vpn_status_maint)
VALUES (2017,7,'AMRES',100,0,0,0,100,0,100,0,0,0,0,0,100,0);
INSERT INTO msr_vpn_availability (year,month,nren_name,bgp_lu_access_1,bgp_lu_access_1_maint,bgp_lu_access_2,bgp_lu_access_2_maint,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vr_peering_3,vr_peering_3_maint,vr_peering_4,vr_peering_4_maint,md_vpn_status,md_vpn_status_maint)
VALUES (2017,7,'BELnet',100,0,0,0,100,0,100,0,0,0,0,0,100,0);
INSERT INTO msr_vpn_availability (year,month,nren_name,bgp_lu_access_1,bgp_lu_access_1_maint,bgp_lu_access_2,bgp_lu_access_2_maint,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vr_peering_3,vr_peering_3_maint,vr_peering_4,vr_peering_4_maint,md_vpn_status,md_vpn_status_maint)
VALUES (2017,7,'BREN',100,0,0,0,100,0,100,0,0,0,0,0,100,0);
INSERT INTO msr_vpn_availability (year,month,nren_name,bgp_lu_access_1,bgp_lu_access_1_maint,bgp_lu_access_2,bgp_lu_access_2_maint,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vr_peering_3,vr_peering_3_maint,vr_peering_4,vr_peering_4_maint,md_vpn_status,md_vpn_status_maint)
VALUES (2017,7,'CARnet',100,0,0,0,100,0,100,0,0,0,0,0,100,0);
INSERT INTO msr_vpn_availability (year,month,nren_name,bgp_lu_access_1,bgp_lu_access_1_maint,bgp_lu_access_2,bgp_lu_access_2_maint,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vr_peering_3,vr_peering_3_maint,vr_peering_4,vr_peering_4_maint,md_vpn_status,md_vpn_status_maint)
VALUES (2017,7,'CESnet',100,0,0,0,100,0,100,0,0,0,0,0,100,0);
INSERT INTO msr_vpn_availability (year,month,nren_name,bgp_lu_access_1,bgp_lu_access_1_maint,bgp_lu_access_2,bgp_lu_access_2_maint,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vr_peering_3,vr_peering_3_maint,vr_peering_4,vr_peering_4_maint,md_vpn_status,md_vpn_status_maint)
VALUES (2017,7,'DFN',100,0,0,0,100,0,100,0,0,0,0,0,100,0);
INSERT INTO msr_vpn_availability (year,month,nren_name,bgp_lu_access_1,bgp_lu_access_1_maint,bgp_lu_access_2,bgp_lu_access_2_maint,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vr_peering_3,vr_peering_3_maint,vr_peering_4,vr_peering_4_maint,md_vpn_status,md_vpn_status_maint)
VALUES (2017,7,'FCCN',100,0,0,0,100,0,100,0,0,0,0,0,100,0);INSERT INTO msr_vpn_availability (year,month,nren_name,bgp_lu_access_1,bgp_lu_access_1_maint,bgp_lu_access_2,bgp_lu_access_2_maint,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vr_peering_3,vr_peering_3_maint,vr_peering_4,vr_peering_4_maint,md_vpn_status,md_vpn_status_maint)
VALUES (2017,7,'FUnet',100,0,0,0,100,0,100,0,0,0,0,0,100,0);
INSERT INTO msr_vpn_availability (year,month,nren_name,bgp_lu_access_1,bgp_lu_access_1_maint,bgp_lu_access_2,bgp_lu_access_2_maint,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vr_peering_3,vr_peering_3_maint,vr_peering_4,vr_peering_4_maint,md_vpn_status,md_vpn_status_maint)
VALUES (2017,7,'GARR',100,0,0,0,100,0,100,0,0,0,0,0,100,0);
INSERT INTO msr_vpn_availability (year,month,nren_name,bgp_lu_access_1,bgp_lu_access_1_maint,bgp_lu_access_2,bgp_lu_access_2_maint,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vr_peering_3,vr_peering_3_maint,vr_peering_4,vr_peering_4_maint,md_vpn_status,md_vpn_status_maint)
VALUES (2017,7,'GRnet',100,0,0,0,100,0,100,0,0,0,0,0,100,0);
INSERT INTO msr_vpn_availability (year,month,nren_name,bgp_lu_access_1,bgp_lu_access_1_maint,bgp_lu_access_2,bgp_lu_access_2_maint,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vr_peering_3,vr_peering_3_maint,vr_peering_4,vr_peering_4_maint,md_vpn_status,md_vpn_status_maint)
VALUES (2017,7,'HEAnet',100,0,0,0,100,0,100,0,0,0,0,0,100,0);
INSERT INTO msr_vpn_availability (year,month,nren_name,bgp_lu_access_1,bgp_lu_access_1_maint,bgp_lu_access_2,bgp_lu_access_2_maint,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vr_peering_3,vr_peering_3_maint,vr_peering_4,vr_peering_4_maint,md_vpn_status,md_vpn_status_maint)
VALUES (2017,7,'HUNGARnet',100,0,0,0,100,0,100,0,0,0,0,0,100,0);
INSERT INTO msr_vpn_availability (year,month,nren_name,bgp_lu_access_1,bgp_lu_access_1_maint,bgp_lu_access_2,bgp_lu_access_2_maint,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vr_peering_3,vr_peering_3_maint,vr_peering_4,vr_peering_4_maint,md_vpn_status,md_vpn_status_maint)
VALUES (2017,7,'NORDUnet',100,0,0,0,100,0,100,0,0,0,0,0,100,0);
INSERT INTO msr_vpn_availability (year,month,nren_name,bgp_lu_access_1,bgp_lu_access_1_maint,bgp_lu_access_2,bgp_lu_access_2_maint,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vr_peering_3,vr_peering_3_maint,vr_peering_4,vr_peering_4_maint,md_vpn_status,md_vpn_status_maint)
VALUES (2017,7,'PIONIER',100,0,0,0,100,0,100,0,0,0,0,0,100,0);
INSERT INTO msr_vpn_availability (year,month,nren_name,bgp_lu_access_1,bgp_lu_access_1_maint,bgp_lu_access_2,bgp_lu_access_2_maint,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vr_peering_3,vr_peering_3_maint,vr_peering_4,vr_peering_4_maint,md_vpn_status,md_vpn_status_maint)
VALUES (2017,7,'RENATER',100,0,0,0,100,0,100,0,0,0,0,0,100,0);
INSERT INTO msr_vpn_availability (year,month,nren_name,bgp_lu_access_1,bgp_lu_access_1_maint,bgp_lu_access_2,bgp_lu_access_2_maint,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vr_peering_3,vr_peering_3_maint,vr_peering_4,vr_peering_4_maint,md_vpn_status,md_vpn_status_maint)
VALUES (2017,7,'RedIRIS',100,0,0,0,100,0,100,0,0,0,0,0,100,0);
INSERT INTO msr_vpn_availability (year,month,nren_name,bgp_lu_access_1,bgp_lu_access_1_maint,bgp_lu_access_2,bgp_lu_access_2_maint,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vr_peering_3,vr_peering_3_maint,vr_peering_4,vr_peering_4_maint,md_vpn_status,md_vpn_status_maint)
VALUES (2017,7,'SUnet',100,0,0,0,100,0,100,0,0,0,0,0,100,0);
** Pay attention to the year and month values in the SQL statement
VPN Proxy Availability Summary
Please run the following SQL statements to initialise the data:
INSERT INTO msr_vpn_proxy (year,month,proxy_name,nren_name,internal_lu_access,internal_lu_access_maint,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,proxy_status,proxy_status_maint)
VALUES (2017,7,'Prague','CESnet',100,0,100,0,100,0,100,0);
INSERT INTO msr_vpn_proxy (year,month,proxy_name,nren_name,internal_lu_access,internal_lu_access_maint,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,proxy_status,proxy_status_maint)
VALUES (2017,7,'Geneva','SWITCH',100,0,100,0,100,0,100,0);
INSERT INTO msr_vpn_proxy (year,month,proxy_name,nren_name,internal_lu_access,internal_lu_access_maint,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,proxy_status,proxy_status_maint)
VALUES (2017,7,'Marseille','RedIRIS',100,0,100,0,100,0,100,0);
INSERT INTO msr_vpn_proxy (year,month,proxy_name,nren_name,internal_lu_access,internal_lu_access_maint,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,proxy_status,proxy_status_maint)
VALUES (2017,7,'Amsterdam','SURFnet',100,0,100,0,100,0,100,0);
INSERT INTO msr_vpn_proxy (year,month,proxy_name,nren_name,internal_lu_access,internal_lu_access_maint,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,proxy_status,proxy_status_maint)
VALUES (2017,7,'Vienna','ARNES',100,0,100,0,100,0,100,0);
INSERT INTO msr_vpn_proxy (year,month,proxy_name,nren_name,internal_lu_access,internal_lu_access_maint,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,proxy_status,proxy_status_maint)
VALUES (2017,7,'Frankfurt','CYNET',100,0,100,0,100,0,100,0);
INSERT INTO msr_vpn_proxy (year,month,proxy_name,nren_name,internal_lu_access,internal_lu_access_maint,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,proxy_status,proxy_status_maint)
VALUES (2017,7,'London','CYNET',100,0,100,0,100,0,100,0);
** Pay attention to the year and month values in the SQL statement
VPNRR Availability Summary
Please run the following SQL statements to initialise the data:
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Paris','AMRES',100,0,0,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Ljubljana','AMRES',100,0,0,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Paris','BREN',100,0,0,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Ljubljana','BREN',100,0,0,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Paris','BELnet',100,0,100,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Ljubljana','BELnet',100,0,100,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Paris','CARnet',100,0,0,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Ljubljana','CARnet',100,0,0,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Paris','DFN',100,0,100,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Ljubljana','DFN',100,0,100,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Paris','FCCN',100,0,0,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Ljubljana','FCCN',100,0,0,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Paris','FUnet',100,0,0,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Ljubljana','FUnet',100,0,0,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Paris','GRnet',100,0,0,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Ljubljana','GRnet',100,0,0,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Paris','HEAnet',100,0,100,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Ljubljana','HEAnet',100,0,100,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Paris','HUNGARnet',100,0,0,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Ljubljana','HUNGARnet',100,0,0,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Paris','NORDUnet',100,0,0,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Ljubljana','NORDUnet',100,0,0,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Paris','PIONIER',100,0,0,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Ljubljana','PIONIER',100,0,0,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Paris','RENATER',100,0,0,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Ljubljana','RENATER',100,0,0,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Paris','SUnet',100,0,0,0,100,100);
insert into msr_vpn_vrr (year,month,vrr_name,nren_name,vr_peering_1,vr_peering_1_maint,vr_peering_2,vr_peering_2_maint,vrr_status,vrr_status_maint) values (2017,7,'Ljubljana','SUnet',100,0,0,0,100,100);
** Pay attention to the year and month values in the SQL statement