Report plugin ''ReportIt" - v0.7.5a (released 23/12/11)

Post by **browniebraun** » Tue Jan 13, 2009 1:07 pm

MagicOneXXX wrote:
Yep, you're right. As you know ReportIt has directly no influence to the resolution, so that the result seems to be correct.
What would be causing the 6 minute intervals then?

The definition of your data template, which will be used by Cacti for creating your RRD files. "Step" should be 300 instead of 360.

Best regards
-Andreas-

Post by **browniebraun** » Tue Jan 13, 2009 1:13 pm

Heiko wrote:I would like to create a report for our HP ProCurve switches..
Problem seems to be that there are no seperate data templates,
I onlye the the "Interface - Traffic (bits/sc) " in the HostTemplate but not under "Data Templates".
Therefore I cant select the "Interface - Traffic (bits/sc)" when I create a new graph.

How can I get through this?
I attached a screenshot of the host template.

thx and greetings

Mhmm... I never tried this before. I'll have to test it first.

Best regards
-Andreas-

MagicOneXXX · Post by **MagicOneXXX** » Tue Jan 13, 2009 3:16 pm

My data template should be fine, it pulls from the 1 minute polling template. The data template is set to a step of 60, heartbeat of 120. Here is the debug from the data source I am using:

--step 60 \
DS:traffic_in:COUNTER:120:0:100000000 \
DS:traffic_out:COUNTER:120:0:100000000 \
RRA:AVERAGE:0.5:1:500 \
RRA:AVERAGE:0.5:1:600 \
RRA:AVERAGE:0.5:6:700 \
RRA:AVERAGE:0.5:24:775 \
RRA:AVERAGE:0.5:288:797 \
RRA:MIN:0.5:1:500 \
RRA:MIN:0.5:1:600 \
RRA:MIN:0.5:6:700 \
RRA:MIN:0.5:24:775 \
RRA:MIN:0.5:288:797 \
RRA:MAX:0.5:1:500 \
RRA:MAX:0.5:1:600 \
RRA:MAX:0.5:6:700 \
RRA:MAX:0.5:24:775 \
RRA:MAX:0.5:288:797 \
RRA:LAST:0.5:1:500 \
RRA:LAST:0.5:1:600 \
RRA:LAST:0.5:6:700 \
RRA:LAST:0.5:24:775 \
RRA:LAST:0.5:288:797 \

Post by **browniebraun** » Tue Jan 13, 2009 11:47 pm

It depends on the definition of your RRAs. Sorry for my first misleading answer.

As you defined you want to go back in time for one day.
So RRDtool doesn't use the first and the second archive, because they are to small:
We need an archive with a range of more than 86400 seconds. The first one is defined as "RRA:AVERAGE:0.5:1:500", which means 1*60s*500 = 30000s.
The second archive contains only data for 10 hours (1*60*600s).

So RRDtool uses the third one, which is defined as "RRA:AVERAGE:0.5:6:700". It will consolidate 6 primary data points(60s) to one consolidated data point of 6*60s. So, we get 360s*700=252000s.

2,9 days of data are enough, so RRDtool will automatically use this one.

Best regards
-Andreas-

eterzella.r.t · Post by **eterzella.r.t** » Wed Jan 14, 2009 12:20 pm

The graph does not appear, I picked up the link and send grafico
open the message appear in the browser below.

Warning: imagefttext() [function.imagefttext]: Could not find/open font in /mnt/wwwfiler/var/www/cacti/plugins/reportit/lib_ext/graidle/graidle.php on line 443

Warning: imagefttext() [function.imagefttext]: Could not find/open font in /mnt/wwwfiler/var/www/cacti/plugins/reportit/lib_ext/graidle/graidle.php on line 444

Warning: imagefttext() [function.imagefttext]: Could not find/open font in /mnt/wwwfiler/var/www/cacti/plugins/reportit/lib_ext/graidle/graidle.php on line 445

Warning: imagefttext() [function.imagefttext]: Could not find/open font in /mnt/wwwfiler/var/www/cacti/plugins/reportit/lib_ext/graidle/graidle.php on line 486

Warning: imagefttext() [function.imagefttext]: Could not find/open font in /mnt/wwwfiler/var/www/cacti/plugins/reportit/lib_ext/graidle/graidle.php on line 504

Warning: imagefttext() [function.imagefttext]: Could not find/open font in /mnt/wwwfiler/var/www/cacti/plugins/reportit/lib_ext/graidle/graidle.php on line 504

Warning: imagefttext() [function.imagefttext]: Could not find/open font in /mnt/wwwfiler/var/www/cacti/plugins/reportit/lib_ext/graidle/graidle.php on line 504

Warning: imagefttext() [function.imagefttext]: Could not find/open font in /mnt/wwwfiler/var/www/cacti/plugins/reportit/lib_ext/graidle/graidle.php on line 504

Warning: imagefttext() [function.imagefttext]: Could not find/open font in /mnt/wwwfiler/var/www/cacti/plugins/reportit/lib_ext/graidle/graidle.php on line 504

Warning: imagefttext() [function.imagefttext]: Could not find/open font in /mnt/wwwfiler/var/www/cacti/plugins/reportit/lib_ext/graidle/graidle.php on line 504

Warning: imagefttext() [function.imagefttext]: Could not find/open font in /mnt/wwwfiler/var/www/cacti/plugins/reportit/lib_ext/graidle/graidle.php on line 504

MagicOneXXX · Post by **MagicOneXXX** » Wed Jan 14, 2009 2:14 pm

So technically it is looking at the weekly RRA, but it is getting resolution of the daily, which covers 10 hours - I think I understand that. Is that correct?

One feature I'd like to see added is stacking of the archived reports into a consolidated report. For instance, we're looking for the DOT for 90% of our bandwidth utilization, and would prefer to be fairly granular (between 1-5 minutes) in the inspection so we can get a more accurate number, so we'd be running it daily, but we only need the compiled data weekly. I can manually look at each report in the archive, but it would be simpler to view the sum of the week's results.

Post by **browniebraun** » Thu Jan 15, 2009 2:29 am

eterzella.r.t wrote:The graph does not appear, I picked up the link and send grafico
open the message appear in the browser below.

Warning: imagefttext() [function.imagefttext]: Could not find/open font in /mnt/wwwfiler/var/www/cacti/plugins/reportit/lib_ext/graidle/graidle.php on line 504

It seems to me that the paths to the font files are incorrect.
Please check them under "Console->Settings->Tab:Reports->Section:Graph Settings".
They will be checked automatically in the next release, so that 0.7.0 won't support Cacti 0.8.6x any longer.

Best regards
-Andreas-

Post by **browniebraun** » Thu Jan 15, 2009 2:51 am

MagicOneXXX wrote:So technically it is looking at the weekly RRA, but it is getting resolution of the daily, which covers 10 hours - I think I understand that. Is that correct?

One feature I'd like to see added is stacking of the archived reports into a consolidated report. For instance, we're looking for the DOT for 90% of our bandwidth utilization, and would prefer to be fairly granular (between 1-5 minutes) in the inspection so we can get a more accurate number, so we'd be running it daily, but we only need the compiled data weekly. I can manually look at each report in the archive, but it would be simpler to view the sum of the week's results.

If you look at the associated graph of that device with a time frame greater than 10 hours RDDtool will automatically choose the third RRA (360s).
If the time frame is between 10 and 8,33 hours it will choose the second one (60s). If its lower than the last 8,33 hours you will see the data from the first archive (60s). From my point of perspective this doesn't make sense, because the first and second archive are containing nearly the same data.

I like your idea, so please open a feature request under
http://sourceforge.net/tracker/?group_id=201406

Best regards
-Andreas-

eterzella.r.t · Post by **eterzella.r.t** » Thu Jan 15, 2009 6:19 am

browniebraun wrote:
eterzella.r.t wrote:The graph does not appear, I picked up the link and send grafico
open the message appear in the browser below.

Warning: imagefttext() [function.imagefttext]: Could not find/open font in /mnt/wwwfiler/var/www/cacti/plugins/reportit/lib_ext/graidle/graidle.php on line 504
It seems to me that the paths to the font files are incorrect.
Please check them under "Console->Settings->Tab:Reports->Section:Graph Settings".
They will be checked automatically in the next release, so that 0.7.0 won't support Cacti 0.8.6x any longer.

Best regards
-Andreas-

Thx, works.

Another question, in the reportit

That means the units?

mi, lo, ki?

Post by **browniebraun** » Thu Jan 15, 2009 7:26 am

These are the SI-Prefixes for binary multiples with base 2 instead of 10.
Hard disc manufactures for example use decimal SI-Prefixes, which is why your new HD is smaller than expected.

1MB = 1 Megabyte = 1000 Kilobytes
1MiB = 1 Megabinary Byte (short "mebi Byte") = 1024 Kilobytes

These binary prefixes are standardised by IEEE (1541) and IEC (60027-2.). I built in the possibility to ignore these official standards, because especially managers do not know them.

Therefore go to "Console->Settings->Tab:Reports->Section:General->SI-Prefixes".

A good article about this theme can be found under:
http://www.iec.ch/zone/si/si_bytes.htm

Best regards
-Andreas-

MagicOneXXX · Post by **MagicOneXXX** » Thu Jan 15, 2009 10:53 am

I've attached another debug file. I added another data source that uses the exact same data template/RRAs, but it is pulling 1440 data points (1 minute intervals). Another data source is still pulling 240. Any thoughts? I need these to be consistent either way.

Feature request has been added.

Post by **browniebraun** » Thu Jan 15, 2009 1:36 pm

Compare the debug of both RRD files, then you will see that their RRA definition differ from each other.
ReportIt has little to no effect on the raw data RRDtool returns, if working time is always the same. From my point of view you must have changed you RRA definitions sometimes before.

You can also define a measurand which only returns the "step". Then you can see how many data items of your system are affected.

Best regards
-Andreas-

MagicOneXXX · Post by **MagicOneXXX** » Thu Jan 15, 2009 2:38 pm

the only difference between the RRA's is the maxvalue. I don't think this would affect anything. Like I said, they are the same exact graph/data template, I modified the max value for the one later on. The steps and rows are the same:

--step 60 \
DS:traffic_in:COUNTER:120:0:100000000 \
DS:traffic_out:COUNTER:120:0:45045000 \
RRA:AVERAGE:0.5:1:500 \
RRA:AVERAGE:0.5:1:600 \
RRA:AVERAGE:0.5:6:700 \
RRA:AVERAGE:0.5:24:775 \
RRA:AVERAGE:0.5:288:797 \
RRA:MIN:0.5:1:500 \
RRA:MIN:0.5:1:600 \
RRA:MIN:0.5:6:700 \
RRA:MIN:0.5:24:775 \
RRA:MIN:0.5:288:797 \
RRA:MAX:0.5:1:500 \
RRA:MAX:0.5:1:600 \
RRA:MAX:0.5:6:700 \
RRA:MAX:0.5:24:775 \
RRA:MAX:0.5:288:797 \
RRA:LAST:0.5:1:500 \
RRA:LAST:0.5:1:600 \
RRA:LAST:0.5:6:700 \
RRA:LAST:0.5:24:775 \
RRA:LAST:0.5:288:797 \

and:

--step 60 \
DS:traffic_in:COUNTER:120:0:100000000 \
DS:traffic_out:COUNTER:120:0:100000000 \
RRA:AVERAGE:0.5:1:500 \
RRA:AVERAGE:0.5:1:600 \
RRA:AVERAGE:0.5:6:700 \
RRA:AVERAGE:0.5:24:775 \
RRA:AVERAGE:0.5:288:797 \
RRA:MIN:0.5:1:500 \
RRA:MIN:0.5:1:600 \
RRA:MIN:0.5:6:700 \
RRA:MIN:0.5:24:775 \
RRA:MIN:0.5:288:797 \
RRA:MAX:0.5:1:500 \
RRA:MAX:0.5:1:600 \
RRA:MAX:0.5:6:700 \
RRA:MAX:0.5:24:775 \
RRA:MAX:0.5:288:797 \
RRA:LAST:0.5:1:500 \
RRA:LAST:0.5:1:600 \
RRA:LAST:0.5:6:700 \
RRA:LAST:0.5:24:775 \
RRA:LAST:0.5:288:797 \

So I don't know why they are different.

Post by **browniebraun** » Thu Jan 15, 2009 3:39 pm

Can you please modify the file called runtime.php, so that we can compare the RRDfetch command ReportIt generates?

Please add after ~ line 511

Code: Select all

            case '1':
                //RRDtool Cacti ...."
                foreach($rra_types as $rra_type => $rra_index) {
                    $cmd_line               = "fetch $data_source_path $rra_type -s $f_sp -e $l_ep";

following command:

Code: Select all

debug($cmd_line, "RRDfetch command");

MagicOneXXX · Post by **MagicOneXXX** » Fri Jan 16, 2009 9:48 am

The fetch commands are the exact same. Running them manually produces two different results, one with a 6 minute step and one with a one minute step. It's probably a RRD tool/rrd/rra issue. I can post this on the general forum, maybe a rrd guru will know the answer

fetch /srv/www/htdocs/cacti/rra/_nameommitted_traffic_in_1548.rrd AVERAGE -s 1231995600 -e 1232082000
fetch /srv/www/htdocs/cacti/rra/_nameommitedagain_traffic_in_89.rrd AVERAGE -s 1231995600 -e 1232082000

Thanks for the help tracking this down!

Cacti

Report plugin ''ReportIt" - v0.7.5a (released 23/12/11)

Data template

inconsistent

Who is online