Page History

...

** Pay attention to the year and the month value in the above statement. The month value is the actual month you are preparing the report. E.g. the above example will contain the data for July and NOT for August

The command will copy off the monthly event log from the London instance of the Infinera DNA box (62.40.99.114) and store it in the /tmp directory of prod-cacti01-fra-de.geant.net

** Are you able to sudo as cactiuser?

SCP the csv file from the /tmp directory onto your laptop into a directory called C:\MSR\Lambda

Start MySQL Workbench and connect to the Connect to reports database on test-msr:

mysql -ureportsUser -p -htest-msr.geant.net

Now run the following SQL statements:

use reports;

truncate table reports.infinera_dna_outages;

LOAD DATA LOCAL INFILE 'c:\\MSR\\Lambda\\2017-08-01_event-export.csv' REPLACE /tmp/filename.csv INTO TABLE reports.infinera_dna_outages FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' LINES TERMINATED BY '\n' IGNORE 10 LINES;

** Richard to see if we can run this directly on the test msr box** Pay attention to the year and the month value in the above statement. The month value is the actual month you are preparing the report. E.g. the above example will contain the data for July and NOT for August** This will take some time, roughly 15-20 minutes. Time for a tea or coffee !

Because Lamdbas are clever, they can auto restore, so we need to turn these auto restoration events into alarms, using the following SQL statements:

...