Versions Compared

Key

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

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

...

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

...