Page History

...

Now we need to update the service availability by running the following SQL statementsstatement:

UPDATE msr_vpn_availability
SET md_vpn_status = bgp_lu_access_1
where nren_name in ('AMRES','BELnet','BREN','CARnet','CESnet','GRnet','HUNGARnet')
and year = 2017
and month = 8;

...

*** With NRENS with a single connection, if the bgp_lu_access_1 fails then the whole service fails.

Now we need to run the following SQL statement to correct the bgp_lu_access_2 availability

update msr_vpn_availability set bgp_lu_access_2 = 100
where nren_name in ('DFN','FUnet','GARR','HEAnet','NORDUnet','PIONIER','RENATER','RedIRIS','SUnet')
and bgp_lu_access_2 = 0
and year = 2017
and month = 8;

*** Note the year and the month values