3.2 Utilisation

Log into prod-cacti01-fra-de.geant.net as yourself (using dante.surname credentials)

change directory to /home/cactiuser/scripts

** Are you able to sudo as cactiuser?

Run the following command:

./fix_monthly_utilisation.sh -y 2017 -m 7

** Pay attention to the year and the month value in the above command.

This scripts calls the following scripts:

echo "*** IP Access *** `date`"
./fix_ip_access.sh -y $year -m $month >> /tmp/cacti_util_ip_access_$year_$month.log

echo "*** IP Access IAS *** `date`"
./fix_ip_access_ias.sh -y $year -m $month >> /tmp/cacti_util_ip_access_ias_$year_$month.log

echo "*** IP Access IPv6 *** `date`"
./fix_ip_access_ipv6.sh -y $year -m $month >> /tmp/cacti_util_ip_access_ipv6_$year_$month.log

echo "*** Interconnect *** `date`"
./fix_interconnect.sh -y $year -m $month >> /tmp/cacti_util_interconnect_$year_$month.log

echo "*** Interconnect Port Summary *** `date`"
./interconnect_port_summ.sh -y $year -m $month >> /tmp/cacti_util_interconnect_port_summ_$year_$month.log

echo "*** Interconnect IPv6 *** `date`"
./fix_interconnect_ipv6.sh -y $year -m $month >> /tmp/cacti_util_interconnect_ipv6_$year_$month.log

echo "*** Trunks *** `date`"
./fix_trunks.sh -y $year -m $month >> /tmp/cacti_util_trunks_$year_$month.log

echo "*** DWS *** `date`"
./fix_dws.sh -y $year -m $month >> /tmp/cacti_util_dws_$year_$month.log

echo "*** GEANT Plus *** `date`"
./fix_plus.sh -y $year -m $month >> /tmp/cacti_util_plus_$year_$month.log

echo "*** LHCone *** `date`"
./fix_lhcone.sh -y $year -m $month >> /tmp/cacti_util_lhcone_$year_$month.log

echo "*** EAP *** `date`"
./fix_eap.sh -y $year -m $month >> /tmp/cacti_util_eap_$year_$month.log

** You can see that log files are produced in the /tmp direcory of prod-cacti-fra-de.geant.net. These are useful when diagnosing zero values displayed in the MSR utilisation pages.

All these scripts rely on the following Java batch program called RRDDump

RRDDump takes 8 parameters: 

#1 RRD file name that will be read

#2 The capacity of the circuit in Bytes

#3 The year you require

#4 The month you require

#5 The from date and time in the format dd-mm-yyyy 00:00:00

#6 The to date and time in the format dd-mm-yyyy 23:59:59

#7 The absid of the corresponding circuit with OpsDB.

#8 The service type of the circuit

** Check users can run this Java program

E.g.

echo "*** ACONET AP *** `date`"
java -cp ".:mysql-connector-java-5.1.16-bin.jar" RRDDump "rt1_vie_at_traffic_in_1404.rrd" "20000000000" "$year" "$month" "" "" "31467" "CCT"

** Improvement - Have a link table that links rrd file names to the name of the circuit, similar to the SPLUNK_LINK table. Then you can use the name to link to the opsdb_circuit table to find the absid of the operational circuit with that name.

Two tables are updated by RRDDump, reports.report_utilization and reports.report_dante_service_utilization. Which table is updated is dependant on the value of the service type parameter.