CSV Export with Summation Rows

[fnasib]

Hello,

I have scoured the forums and I have only seen fragments that would seem to address my issues but nothing conclusive. I'll consolidate the issue and see if this is something that can be addressed.

First of all thank you for maintaining such great support!

Interface-Traffic-bits-per-second.PNG (243.45 KiB) Viewed 2796 times

This is the Interface Traffic configuration for a new Cacti 1.2.14 deploymen, it graphs appropriately and presents bandwidth summation data. This is the same configuration running on version 0.8.7g. Where the issue starts is when the export to CSV via the web console (GUI) is selected. Only the graphed "input" data is exported but it does not export the "Summation Total In:" or "Summation Total Out:" data.

I by no means am a SQL DBA nor a PHP developer but from the limited understanding these do not appear to be the cause. In version 0.8.7g and earlier this functions works without issue. The Summation data is always generated in the CSV export file as rows 9 and 10.

csv_export_summation-0.8.7.png (19.84 KiB) Viewed 2796 times

Ignore the 0 byte data in this example.

The only variations that can be identified is that the graph_xport.php file has changed significantly over the years along with the cacti.sql file. Having said this, we suspect that this is configuration related and not PHP or SQL related, since software has developed and become more secure over the years. Hence the assumption is the graph template could be incorrectly configured, since it was modeled off Cacti 0.8.7g.

The interface traffic bit/sec bandwidth graph template/data query has not worked either.

If any further data/information is required please do let me know. Or of this has been answered in a different thread then please do direct me accordingly.

Many thanks!

[Hmiddelhoek]

I have the same problem. Total in and total out are correctly shown on the graph but when exported to csv this data isn't shown, only Title, Verticle label, start/end date, step, total rows, graph ID and host ID are shown followed by the rrd data export (many rows). It also occurs for 95th percentile.
This is a new 1.2.14 install with rrdtool 1.6.0 on Debian 9.13, manual Cacti install from tar.gz on PHP 7.3.22. In graph_xport.php I see the definition of $xport_meta array but I can't find where this array is filled with data, I don't think that's happening. On line 130 of graph_xport.php the variable $xport_meta['NthPercentile'] is checked and if it exists the 95th percentile value is shown but the variable doesn't exist. The same applies for $xport_meta['Summation'] on line 136.

I think this needs a fix but probably I'm doing something wrong. Thanks!

[Osiris]

Log on github. Provide good data when you do.

[fnasib]

I got a message via Github from TheWitness.

To paraphrase "The code had been removed sometime in 2016". The fix will be released in 1.2.16.

Github ref: https://github.com/Cacti/cacti/issues/3920

[TheWitness]

Yea, it's fixed.

[fnasib]

I have deployed the update and it now shows the summation field in the export.

Many thanks!!