Aggregate, now at V0.66

[gandalf]

I suppose this will make it for a new howto:
Use "SIMILAR_DATA_SOURCES_NODUPS" in a new custom CDEF. This one will automagically sum up all data sources. You may graph the result of such a CDEF over time, just as the basic data sources. It sould yield the same results as stacking the data sources will do.
If you're graphing IN/OUT traffic seperatley, you will have to have two of them. When creating the Graph Item for this one, please do not forget to select a datasource for IN when summing IN traffic and a data source for OUT when summing OUT traffic.
Hope this is clear enough
Reinhard

[churchi]

I suppose this will make it for a new howto:
Use "SIMILAR_DATA_SOURCES_NODUPS" in a new custom CDEF. This one will automagically sum up all data sources. You may graph the result of such a CDEF over time, just as the basic data sources. It sould yield the same results as stacking the data sources will do.
If you're graphing IN/OUT traffic seperatley, you will have to have two of them. When creating the Graph Item for this one, please do not forget to select a datasource for IN when summing IN traffic and a data source for OUT when summing OUT traffic.
Hope this is clear enough
Reinhard

Hi Reinhard,

thank you for the lengthy tute. much apprecaited. however after reading a few other threads today, i have come across another thread that talks about this.
http://forums.cacti.net/viewtopic.php?p=100387#100387

it seems that the function to do what i have been trying to do doesn't exist in cacti yet. would this be true from that thread? i am pretty sure that it is the same thing i have been trying to get figured out in this thread? what do you think?

thank you

[gandalf]

Yep, I followed all those topics.
But please bear with me; I always get confused when it comes to "summing up" and/or "totalling". I'm not a native english speaker (well, you will have guessed this).

Let's talk about "Totals" this way: Add up all data points of a given timespan. Example: Show the amount of Bytes transmitted in a given timeframe. That one is described in http://docs.cacti.net/node/50 under Bandwitdh Summation. But it works for all kind of data sources. To be honest, I lost track about the "unit" issue that existed once (or still exists? I'm so confused!). Some time ago, cacti always printed "Bytes" as a Unit. If you summed up e.g. pages printed from a printer, this was not what you wanted it to be, for sure.

Let's talk about "Summing" this way: Suppose you have a graph showing more than one data source of same kind. Perhaps you've used AGGREGATE to get this. And now you want to sum up all Traffic In and all Traffic Out data sources, respectively. Well, you may want to solve this by stacking those items and you are correct. But if you need a Legend printed, you will need a "Special Data Source" for a custom CDEF that's known by "All Similar Datasources (no duplicates)". If you add a new graph item referring to a "Traffic IN" data source _and_ referring to your custom CDEF, you will be able to graph it. I'm not sure whether all "Traffic IN" data sources must be grouped together, but I'm quite sure that they must preceed this special item in the list of graph items.

Hope I did not confuse you. That's why I talked about a new HowTo. But you know, time is a precious thing

Reinhard

[ruud]

After installing and activating the plugin a bunch of errors eppear in cacti.

As soon as i login (admin level) i get :

Notice: Undefined index: index.php: in /var/www/localhost/htdocs/cacti/lib/functions.php on line 1422

When i select color templates :

Notice: Undefined index: index.php: in /var/www/localhost/htdocs/cacti/lib/functions.php on line 1432

Notice: Undefined index: index.php: in /var/www/localhost/htdocs/cacti/lib/functions.php on line 1451
-> Color Templates

Maybe i am missing somthing here, any hints ?

Cacti Version - 0.8.6j
Plugin Architecture - 1.1
Poller Type - Cactid v0.8.6i
Server Info - Linux 2.6.17-gentoo-r8
Web Server - Apache
PHP - 5.1.6-pl6-gentoo
PHP Extensions - libxml, xml, standard, SPL, sockets, snmp, session, Reflection, mysql, mcrypt, mbstring, iconv, gettext, gd, dom, dba, date, zlib, pcre, openssl, apache2handler, rrdtool, eAccelerator
MySQL - 5.0.26
RRDTool - 1.2.15
SNMP - 5.4
Plugins

• Thresholds (thold - v0.3.0)
  Device Monitoring (monitor - v0.7)
  Network Discovery (discovery - v0.7)
  report it! (report it! - v0.3.2)
  Network Tools (tools - v0.2)
  Host Info (hostinfo - v0.1)
  Poller Performance Report (pollperf - v0.2)
  killspike (killspike - v0.1.0a)
  Create Aggregate Graphs (aggregate - v0.62)

[timi]

after upgrading to from 0.61 to 0.62, I can not create graphs, how can I debug this problem ?

[timi]

graph debug mode tells this:

Code: Select all

 RRDTool Command:

/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="Aggregate TEST" \
--rigid \
--base=1000 \
--height=150 \
--width=650 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="bits per second" \
--slope-mode \
DEF:a="/srv/apache/htdocs/cacti/rra/ac1hub5_traffic_in_17555.rrd":traffic_in:AVERAGE \
DEF:b="/srv/apache/htdocs/cacti/rra/ac1hub5_traffic_in_17555.rrd":traffic_out:AVERAGE \
DEF:c="/srv/apache/htdocs/cacti/rra/ac1hub5_traffic_in_17559.rrd":traffic_in:AVERAGE \
DEF:d="/srv/apache/htdocs/cacti/rra/ac1hub5_traffic_in_17559.rrd":traffic_out:AVERAGE \
CDEF:cdefa=a,8,* \
CDEF:cdefc=a,8,100,*,*,1000000000,/ \
CDEF:cdefh=b,8,* \
CDEF:cdefj=b,8,100,*,*,1000000000,/ \
CDEF:cdefbg=c,8,* \
CDEF:cdefbi=c,8,100,*,*,1000000000,/ \
CDEF:cdefcd=d,8,* \
CDEF:cdefcf=d,8,100,*,*,1000000000,/ \
AREA:cdefa:"10.128.0.130 Inbound"  \
GPRINT:cdefa:LAST:" Current\:%8.2lf%s"  \
GPRINT:cdefc:LAST:"(%5.2lf %%)"  \
GPRINT:cdefa:AVERAGE:"Average\:%8.2lf%s"  \
GPRINT:cdefc:AVERAGE:"(%5.2lf %%)"  \
GPRINT:cdefa:MAX:"Maximum\:%8.2lf%s"  \
GPRINT:cdefc:MAX:"(%5.2lf %%)\n"  \
LINE1:cdefh:"10.128.0.130 Outbound"  \
GPRINT:cdefh:LAST:"Current\:%8.2lf%s"  \
GPRINT:cdefj:LAST:"(%5.2lf %%)"  \
GPRINT:cdefh:AVERAGE:"Average\:%8.2lf%s"  \
GPRINT:cdefj:AVERAGE:"(%5.2lf %%)"  \
GPRINT:cdefh:MAX:"Maximum\:%8.2lf%s"  \
GPRINT:cdefj:MAX:"(%5.2lf %%)\n"  \
COMMENT:"10.128.0.130 Total speed\: (234.42 Mbit in+out)\n"  \
COMMENT:"10.128.0.130 Forwarded"  \
AREA:cdefbg:"10.128.0.130 Inbound"  \
GPRINT:cdefbg:LAST:" Current\:%8.2lf%s"  \
GPRINT:cdefbi:LAST:"(%5.2lf %%)"  \
GPRINT:cdefbg:AVERAGE:"Average\:%8.2lf%s"  \
GPRINT:cdefbi:AVERAGE:"(%5.2lf %%)"  \
GPRINT:cdefbg:MAX:"Maximum\:%8.2lf%s"  \
GPRINT:cdefbi:MAX:"(%5.2lf %%)\n"  \
LINE1:cdefcd:"10.128.0.130 Outbound"  \
GPRINT:cdefcd:LAST:"Current\:%8.2lf%s"  \
GPRINT:cdefcf:LAST:"(%5.2lf %%)"  \
GPRINT:cdefcd:AVERAGE:"Average\:%8.2lf%s"  \
GPRINT:cdefcf:AVERAGE:"(%5.2lf %%)"  \
GPRINT:cdefcd:MAX:"Maximum\:%8.2lf%s"  \
GPRINT:cdefcf:MAX:"(%5.2lf %%)\n"  \
COMMENT:"10.128.0.130 Total speed\: (234.42 Mbit in+out)\n"  \
COMMENT:"10.128.0.130 Forwarded" 

RRDTool Says:

ERROR: Legend set but no color: 10.128.0.130 Inbound

any idea ? I;m using cacti 0.8.6h with PA 1.0

[gandalf]

After installing and activating the plugin a bunch of errors eppear in cacti.

Which version of Aggregate, Which Version of cacti and PIA?
Reinhard

[gandalf]

graph debug mode tells this:

Code: Select all

 LINE1:cdefh:"10.128.0.130 Outbound"  \

any idea ? I;m using cacti 0.8.6h with PA 1.0

Please show me the graph debug of the graph that holds the line above
Reinhard

[timi]

graph debug mode tells this:

Code: Select all

 LINE1:cdefh:"10.128.0.130 Outbound"  \

any idea ? I;m using cacti 0.8.6h with PA 1.0

Please show me the graph debug of the graph that holds the line above
Reinhard

Code: Select all

RRDTool Command:

/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="ac1.hub4 - Traffic - Gi0/6" \
--rigid \
--base=1000 \
--height=150 \
--width=650 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="bits per second" \
--slope-mode \
DEF:a="/srv/apache/htdocs/cacti/rra/ac1hub5_traffic_in_17555.rrd":traffic_in:AVERAGE \
DEF:b="/srv/apache/htdocs/cacti/rra/ac1hub5_traffic_in_17555.rrd":traffic_out:AVERAGE \
CDEF:cdefa=a,8,* \
CDEF:cdefc=a,8,100,*,*,1000000000,/ \
CDEF:cdefh=b,8,* \
CDEF:cdefj=b,8,100,*,*,1000000000,/ \
AREA:cdefa#00CF00:"Inbound"  \
GPRINT:cdefa:LAST:" Current\:%8.2lf%s"  \
GPRINT:cdefc:LAST:"(%5.2lf %%)"  \
GPRINT:cdefa:AVERAGE:"Average\:%8.2lf%s"  \
GPRINT:cdefc:AVERAGE:"(%5.2lf %%)"  \
GPRINT:cdefa:MAX:"Maximum\:%8.2lf%s"  \
GPRINT:cdefc:MAX:"(%5.2lf %%)\n"  \
LINE1:cdefh#002A97:"Outbound"  \
GPRINT:cdefh:LAST:"Current\:%8.2lf%s"  \
GPRINT:cdefj:LAST:"(%5.2lf %%)"  \
GPRINT:cdefh:AVERAGE:"Average\:%8.2lf%s"  \
GPRINT:cdefj:AVERAGE:"(%5.2lf %%)"  \
GPRINT:cdefh:MAX:"Maximum\:%8.2lf%s"  \
GPRINT:cdefj:MAX:"(%5.2lf %%)\n"  \
COMMENT:"Total speed\: (99.32 Mbit in+out)\n"  \
COMMENT:"Forwarded" 

RRDTool Says:

OK

for ac1hub5_traffic_in_17555.rrd

[gandalf]

Fine, then. Last question: Did you use any Color Template when creating the Aggregate. If you did, which one did you choose? Does it hold at least that many entries taht are needed for the sum of all graph items?
Reinhard

[timi]

I did not chose any template, just selected the sources and then select "create aggregate graphs" -> Go and then chose Yes, thats all I did, all was fine with 0.61, but with 0.62 not ...

[jafne]

I am unable to see the "Create Aggregate Graphs" entry. I installed the 0.62 version on 0.8.6j, with plugin architecture 1.1, inserted the aggregate.sql into the database, added the aggregate plugin to the config file and gave the user accounts permission to use the plugin, but I don't see the "Create Aggregate Graphs". What did I miss?

EDIT: Never mind, I was looking in the wrong place.


Thank you,

Steve

[gandalf]

Published version 0.63. See first post
Reinhard

[Kernel Panic]

Published version 0.63. See first post
Reinhard

Great stuff.

Your initial graph offerings aren't what I am looking for but it did allow me to move things around, play with the data, and create this sort of graph for four interfaces (two interfaces on two different routers):


I tried creating this sort of graph manually. But for whatever reason cacti would just revert the datasources to be for just one of the two routers I was trying to graph.
That is something I would consider a bug. When creating a generic graph any datasource from any device should be fair game.

Other notes:
The STACK trick I used to make the Outbound LINE1 "aggregation" is a total hackjob (i.e. making the underlying ones white and printing them first) I suppose you could make the bottom ones green if your Inbound outweighed your Outbound but when you get a mix, there just isn't a clean way to do it in cacti as far as I know.

The Totals at the bottom are created with these two simple CDEFs:

Code: Select all

CDEF:cdefe=a,b,+,c,+,d,+,8,*
CDEF:cdefbb=e,f,+,g,+,h,+,8,*

The first is for the outbound datasources, the second is for the inbound datasources.

[X505]

Published version 0.63. See first post
Reinhard

thanks, this plugin rocks for my TSE servers