Creating Graph with combined data from multiple ports

opt8low · Post by **opt8low** » Wed Apr 19, 2006 9:36 am

I want to take multiple ports SNMP data and combine this data on one graph to get a total. Can this be done? If it can, how would I go about it?

I have managed to get the data graphing on one graph but each port has it's data showing, not a total. I am sure I am missing something stupid. I have looked and looked but with no luck. Any help would be appreciated.

Thanks,

Dana

Post by **gandalf** » Wed Apr 19, 2006 2:08 pm

You may find hints when seacrhing for "Overview Graphs" in the Forum.
1. Goto Graph Management and ADD
2. Leave Template and Host to NONE and Create
3. Fill main Graph Data as usual for Graph Templates
4. Then select each Graph Item you want to see on the Graph (and Legends, of course)
5. Place this new Graph on a Tree of your liking

Attention: on large installations, Step 4 will be time-consuming

Reinhard

opt8low · Post by **opt8low** » Thu Apr 20, 2006 9:00 am

Thanks for the info. I am having problems understanding your directions. I go to graph management and create a graph with none and none. Then I pick a graph template and give it a title and go to save. Get to this point then I am lost. (Happens a lot

I have done a search a couple of times with no luck. I am pretty sure I am missing something stupid. So any more help would be appreciated.

Thanks again,

Dana

Post by **gandalf** » Sun Apr 23, 2006 1:57 pm

opt8low wrote:Thanks for the info. I am having problems understanding your directions. I go to graph management and create a graph with none and none. Then I pick a graph template and give it a title and go to save. Get to this point then I am lost. (Happens a lot

I have done a search a couple of times with no luck. I am pretty sure I am missing something stupid. So any more help would be appreciated.
Thanks again,
Dana

Well done, so far. Now you've reached Step 4 of my description. See the Add link for Graph Items, select this to find a list of all possible data sources to select for Graphing. If in doubt, please send a screenshot of the last step you finished successfully
Reinhard

Skaven · Post by **Skaven** » Mon Apr 24, 2006 9:06 am

I got a problem when creating these graphs..

I do it exactly the same way as Linegod explained in: http://forums.cacti.net/about5703-0-asc-0.html

But when i have added all the different data sources + total, and save, it doesn't exist in the Graph Management overview..
No predefined graph template or host is chosen since i cant choose specific data sources then.

Post by **gandalf** » Mon Apr 24, 2006 10:01 am

Skaven wrote:I got a problem when creating these graphs..

I do it exactly the same way as Linegod explained in: http://forums.cacti.net/about5703-0-asc-0.html

But when i have added all the different data sources + total, and save, it doesn't exist in the Graph Management overview..
No predefined graph template or host is chosen since i cant choose specific data sources then.

Yep, the link is the correct one. Please scroll to the last page of Graph Management, perhaps you'll find it there
Reinhard

Skaven · Post by **Skaven** » Tue Apr 25, 2006 3:44 am

I've checked everywhere. And i still cant find it..

In the cacti.log this appears right after i click save:

Code: Select all

04/25/2006 10:34:41 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select id,column_name from graph_template_input where graph_template_id="

Post by **gandalf** » Tue Apr 25, 2006 11:23 am

Please post this as a bug to http://bugs.cacti.net
Reinhard

opt8low · Post by **opt8low** » Tue May 02, 2006 2:05 pm

Reinhard,

Thanks again for you reply. I will add a screen shot here of the point were you last responded. In this screen shot I am done with step 4 of your instuctions. Do I need to pick a graph templete for this step? IF I do I want total bandwidth/ Bits for the total of all ports. When I pick that templete Cacti asks to change the graph, when I save it, The graph disappears.
I am sure I am missing more then one thing in your steps, but can't tell what. Any more help would be appreciated.

Thanks,

Dana

jay · Post by **jay** » Tue May 02, 2006 2:47 pm

Hi Dana

You have only added comments as your graph items. You need to create this as you would if you were creating items for a graph template except this time you use the host DS that you want.

Here is an example where i have just added a gprint for only the last data collected. You can of course collect minimum and maximum and average if you want to, its very time consuming though.

Jay

Post by **gandalf** » Thu May 04, 2006 10:02 am

opt8low wrote:Reinhard,

Thanks again for you reply. I will add a screen shot here of the point were you last responded. In this screen shot I am done with step 4 of your instuctions. Do I need to pick a graph templete for this step? IF I do I want total bandwidth/ Bits for the total of all ports. When I pick that templete Cacti asks to change the graph, when I save it, The graph disappears.
I am sure I am missing more then one thing in your steps, but can't tell what. Any more help would be appreciated.

Thanks,

Dana

I should have been more precise. You picked the data sources using "COMMENT", but it is necessary to choose LINx or AREA/STACK to create the DEF statement needed for rrdtool
Reinhard

Brif8 · Post by **Brif8** » Fri May 05, 2006 7:37 am

How did you create the Data Source

Traffic: Port 21
How did you specify the port ?

jay · Post by **jay** » Fri May 05, 2006 8:06 am

Hi

I initially created the graphs for all the live ports on that switch. This then creates the data sources for traffic in and out for each live port. I then used the data sources which were created in the new combined graph.

I have attached the screenshot so you can see for yourself.

Jay

Cacti