[HOWTO] How can I make SUM of graphs

[Magistrator]

I wonder if it isn’t more practical to create new RRDs based
on the result of arithmetic operations over other existing RRDs.
This approach would simplify the graphic making process a lot. And
would relocate each processes, of “graphic making” and
“data treatment”, to different areas.

I work my ass out to create nice data summations of interfaces
and network traffic. With the above approach it would be much easier.

Cacti Rules!

[TheWitness]

Hey Judgeman,

Please submit a feature request in Mantis so that we can track this. No promises.

TheWitness

[TimmiT.nl]

Is it possible to sum the inbound and outbound traffic on one graph?

That is the online feature I would really like!

[TheWitness]

There is a CDEF for "Total of All Data Sources". You should consider this one.

TheWitness

[mafiaid]

Yeah, that's definitely one place it could go. I would send you the work I did previously, but it is not an isolated script and fairly tied into Cacti itself. What I did for them was basically create a table that gave GB transfered for each month for each user that logged in.

-Ian

Yea, something like that would be very useful. Right now, the summation feature works fine on the graphs themselves, but I'm still forced to use MRTS to get traffic sum data for specific time periods, e.g. per day, week, month, with the ability to go back several months.

--Mike

[sini]

Finally I made what I (and all of this topic readers) was looking for.
First I `d like to say thank for Chad who send me great instructions on cacti list.
What I want is to graph two agregated interface in one graph.
Create new RRDs based aggregted graph on the result of arithmetic operations over other existing RRDs.
with the rrdtool command its looks like this.

rrdtool graph summ.png --title="Summ.png" \
DEF:in1="traffic_in_1.rrd":traffic_in:AVERAGE \
DEF:out1="traffic_in_1.rrd":traffic_out:AVERAGE \
DEF:in2="traffic_in_2.rrd":traffic_in:AVERAGE \
DEF:out2="traffic_in_2.rrd":traffic_out:AVERAGE \
CDEF:agginput=in1,in2,+,8,* \
CDEF:aggoutput=out1,out2,+,8,* \
AREA:agginput#00cc00:"Input Aggregate" \
GPRINT:agginput:LAST:" Current\:%8.2lf %s" \
GPRINT:agginput:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:agginput:MAX:"Maximum\:%8.2lf %s\n" \
LINE1:aggoutput#0000FF:"Output Aggregate" \
GPRINT:aggoutput:LAST:" Current\:%8.2lf %s" \
GPRINT:aggoutput:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:aggoutput:MAX:"Maximum\:%8.2lf %s\n" \

In this example the image shows the correct aggregated in/out traffic and also the agregated legend values.
In cacti it was a bit difficult to create a graph like that (to me). As I read over the forum everybody was operating with te stack graph item type. Including me. But with this I had some problem. No correct aggregated valus and, after zoom no graph generation. All of this works with this new method.
I attached a template for the new approach of this problem. And also a screenshot.
After import you have 2 custom CDEF ("combine 2 in" and "combine 2 out") and a new graph template "Aggregate 2 graph"
Take a look at it, try it out and write down your feelings.

[eberkut]

Has anybody got this template working ?

Would it be possible to get a screenshot of the Graph Template for those of us desesperate users stuck with an old non-upgradable Cacti version and with limited access to any CLI ?

Thanks.

[firestarter]

I am a new cacti user and is really impressed about it. I want to configure it such a way that I can get the total bandwidth used embedded in the graphs.

I read all of the above posts, but could not create a template that will show something like the following. I need to show the total bandwidth used in mbits and sum of in+out or even in GB.

These will be SNMP enabled hosts not the router/switch interfaces.

Please advise me in details as I am a newbie here

[superonline]

Hi there,

I loved cacti first of all; but I couldnt find a easy way to do :

Directory[ttnet-total]: ttnet-total
Target[ttnet-total]: /195.xxx.51.206:xxx@212.xxx.5.180:::::2 + /212.xxx.230.198:xxx@212.xxx.5.122:::::2

in cacti.

All I saw is to do some workarounds in order to be able to do such graphs. But imagine ( which is the fact i have ) that you have thousands of such graphs, there should be a rational way to do such sum-up graphs in cacti, otherwise it will be very hard to use cacti for sysadms in big ISPs such as me :(

Levent Kurt
Superonline
SysAdm

[sini]

Has anybody got this template working ?

Would it be possible to get a screenshot of the Graph Template for those of us desesperate users stuck with an old non-upgradable Cacti version and with limited access to any CLI ?

Thanks.

Yes, see attached file!

[kubilay]

Hi All,

I import the template run it succesfully.

What should I have to do to sum 3+ graphs.

I look at cdef Combine 2 IN and its value is a,b,+,8,*
What should I write for 3 graphs? a,b,c??

Thanks

Zeki Kubilay Akyol

[kubilay]

I found it thanks anyway.

For 3 items; a,b,c,+,+,8,* in and d,e,f,+,+,8,*
For 4 items; a,b,c,d,+,+,+,8,* in and e,f,g,h,+,+,+,8,*

[peppermint]

Hi,

I imported the templete from Sini, it worked great, thanks.

However, I then tried to get the sum out of 3 and 4 items by setting up CDEF as mentioned in kubilay's post,

-----
For 3 items; a,b,c,+,+,8,* in and d,e,f,+,+,8,*
For 4 items; a,b,c,d,+,+,+,8,* in and e,f,g,h,+,+,+,8,*
-----

then Outbound sum did not come out correctly, for example, the Avarage shoud be around 30M, but the Sum data became 270MB.

My questions is was the CDEF set up alright? Shall I change to the different forms?

Here are what Graph debug says:
----
RRDTool Command:

/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-60 \
--title="Aggregated_SUM_3" \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="bits per second" \
--slope-mode \
DEF:a="/var/www/html/cacti/rra/sw7_traffic_out_827.rrd":traffic_in:AVERAGE \
DEF:b="/var/www/html/cacti/rra/sw7_traffic_out_828.rrd":traffic_in:AVERAGE \
DEF:c="/var/www/html/cacti/rra/sw7_traffic_out_827.rrd":traffic_out:AVERAGE \
DEF:d="/var/www/html/cacti/rra/sw7_traffic_out_828.rrd":traffic_out:AVERAGE \
DEF:e="/var/www/html/cacti/rra/sw7_traffic_out_830.rrd":traffic_in:AVERAGE \
DEF:f="/var/www/html/cacti/rra/sw7_traffic_out_830.rrd":traffic_out:AVERAGE \
CDEF:cdefa=a,8,* \
CDEF:cdefb=b,8,* \
CDEF:cdefc=a,b,c,+,+,8,* \
CDEF:cdefg=c,8,* \
CDEF:cdefh=d,8,* \
CDEF:cdefi=d,e,f,+,+,8,* \
CDEF:cdefbc=e,8,* \
CDEF:cdefbd=f,8,* \
AREA:cdefa:"" \
AREA:cdefb:"" \
AREA:cdefc#6EA100:"Inbound" \
GPRINT:cdefc:LAST:"Current\:%8.2lf %s" \
GPRINT:cdefc:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:cdefc:MAX:"Maximum\:%8.2lf %s\n" \
LINE1:cdefg:"" \
LINE1:cdefh:"" \
LINE1:cdefi#4444FF:"Outbound" \
GPRINT:cdefi:LAST:"Current\:%8.2lf %s" \
GPRINT:cdefi:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:cdefi:MAX:"Maximum\:%8.2lf %s\n" \
AREA:cdefbc:"" \
LINE1:cdefbd:""

RRDTool Says:

OK
----------------

The 2nd thing I observed is I then set up the templetes for the sum out of 5+, 6+..items (because I eventually need sum out of 13 interfaces), what happens is after 7 items, the chart no longer shows Outbound info at the bottom of the graph, it only shows Inbound, does anyone ever set up sum for itemos more than 7?

Thanks!

Peppermint

[peppermint]

Actually there is a plugin called 'aggreation' available at:
http://forums.cacti.net/viewtopic.php?p=96774#96774

It'll require Plugin Architecture to be implemented though, I tested that out, everything worked pefect..

Peppermint

[asdfg]

Finally I made what I (and all of this topic readers) was looking for.
First I `d like to say thank for Chad who send me great instructions on cacti list.
What I want is to graph two agregated interface in one graph.
Create new RRDs based aggregted graph on the result of arithmetic operations over other existing RRDs.
with the rrdtool command its looks like this.

rrdtool graph summ.png --title="Summ.png" \
DEF:in1="traffic_in_1.rrd":traffic_in:AVERAGE \
DEF:out1="traffic_in_1.rrd":traffic_out:AVERAGE \
DEF:in2="traffic_in_2.rrd":traffic_in:AVERAGE \
DEF:out2="traffic_in_2.rrd":traffic_out:AVERAGE \
CDEF:agginput=in1,in2,+,8,* \
CDEF:aggoutput=out1,out2,+,8,* \
AREA:agginput#00cc00:"Input Aggregate" \
GPRINT:agginput:LAST:" Current\:%8.2lf %s" \
GPRINT:agginput:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:agginput:MAX:"Maximum\:%8.2lf %s\n" \
LINE1:aggoutput#0000FF:"Output Aggregate" \
GPRINT:aggoutput:LAST:" Current\:%8.2lf %s" \
GPRINT:aggoutput:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:aggoutput:MAX:"Maximum\:%8.2lf %s\n" \

In this example the image shows the correct aggregated in/out traffic and also the agregated legend values.
In cacti it was a bit difficult to create a graph like that (to me). As I read over the forum everybody was operating with te stack graph item type. Including me. But with this I had some problem. No correct aggregated valus and, after zoom no graph generation. All of this works with this new method.
I attached a template for the new approach of this problem. And also a screenshot.
After import you have 2 custom CDEF ("combine 2 in" and "combine 2 out") and a new graph template "Aggregate 2 graph"
Take a look at it, try it out and write down your feelings.

Is possible sum for more interface?