Page History

...

       mysql -ureportsUser -p -htest-msr.geant.net reports     ### Password for "reportsUser" user is on LastPass. Shared with Erik and Mark.

Run the below queries:       

         truncate 1. truncate table reports.infinera_dna_outages;

       LOAD  2. LOAD DATA LOCAL INFILE '/var/tmp/filename.csv' (e.g. 2017-08-01_event-export.csv) INTO TABLE reports.infinera_dna_outages FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' LINES TERMINATED BY '\n' IGNORE 10 LINES;

...

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

     3. update reports.infinera_dna_outages set event_sub_type = 'ALARM' where message like 'Restoration%';
     4. update reports.infinera_dna_outages set circuit_id = additional_text where message like 'Restoration%';
     5. update reports.infinera_dna_outages set severity = 'CR' where message like 'Restoration due to SNC Fault%'; update infinera_dna_outages set severity = 'Clear' where message like 'Restoration Successful.%';

    6. delete from reports.infinera_dna_outages where event_sub_type != 'ALARM';

We now need to populate a table called reports.infinera_outage_ci. :

on prod-cacti01  cd to /home/cactiuser/scripts/

execute exportoutages.sh as cactiuser user  (run "sudo ./exportoutages.sh")

This will create a log file INFINERA-Extraction-Log-yyyymmdd.log that can be used for any debugging

...