Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Connect to the md_vpn database on prod-cacti02-vie-at.geant.net  use the user mdvpnUser and the password stored in keypass.

In the back-end database, a table called md_vpn.msr_control needs to be updated with the correct year and month. This is acheived using the folowing SQL statement:

UPDATE md_vpn.msr_control
SET year = 2017,
month = 7
WHERE absid = 1;

Tip: you can run this query, it returns one record only. You need to change year and month here: "select * from md_vpn.msr_control;"

** Pay attention to the year and month values in the SQL statement

...