Aggregate, now at V0.66

Announcements concerning Plugins for Cacti

Moderators: Developers, Moderators

Locked
siafu_kali
Posts: 23
Joined: Mon Dec 10, 2007 9:19 pm

Post by siafu_kali »

timi wrote:v0.64 works with 0.8.7a and pa 1.4 ?
Yes! Perfectly!! (as far as I can tell)
Top
keefe007
Posts: 24
Joined: Fri Sep 23, 2005 11:33 pm

Post by keefe007 »

From what I can tell this isn't actually merging two sets of data together, its just overlaying two graphs.

Can you make it so the graph will actually show the values of X + Y, instead of showing X and Y on the graph over eachother?
Top
siafu_kali
Posts: 23
Joined: Mon Dec 10, 2007 9:19 pm

Post by siafu_kali »

keefe007 wrote:From what I can tell this isn't actually merging two sets of data together, its just overlaying two graphs.

Can you make it so the graph will actually show the values of X + Y, instead of showing X and Y on the graph over eachother?
If you make the aggregate a area/stack graph, then you can easily see X + Y. There are probably more sophisticated ways you could do this type of thing as well, but I'm not an expert. I think this is the sort of thing CDEFs can be used for, but I don't know how myself.
Top
keefe007
Posts: 24
Joined: Fri Sep 23, 2005 11:33 pm

Post by keefe007 »

I've tried that, but that didn't aggregate the bandwidths together, it just should the two over each other in different colors.
Top
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:
Contact gandalf

Post by gandalf »

Please post a screenshot of your aggregate when visiting the aggregate graph at Graph Management and switching to DEBUG mode
Reinhard
Top
User avatar
timi
Cacti User
Posts: 240
Joined: Wed Nov 09, 2005 8:35 am
Location: Timisoara, Romania
Contact:
Contact timi

Post by timi »

hmm, there is something strange:

have a lok before creating an aggregate graph and after :)
there is a new host, but when I select the () it says "Validation error. "

cacti 0.8.7a and pa 1.4
Attachments
before.PNG
before.PNG (10.29 KiB) Viewed 6554 times
after.PNG
after.PNG (11.21 KiB) Viewed 6554 times
Top
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:
Contact gandalf

Post by gandalf »

timi wrote:hmm, there is something strange:

have a lok before creating an aggregate graph and after :)
there is a new host, but when I select the () it says "Validation error. "

cacti 0.8.7a and pa 1.4
I suppose it is now time to add the fifth cacti installation to my laptop: 087a with PIA ...
ATM, I can't test this.
Reinhard
Top
kuma3
Posts: 25
Joined: Tue Oct 02, 2007 1:17 pm

problem with my aggregation

Post by kuma3 »

Just install the plugin, everything works except rrdtool complained.

cacti Version 0.8.6j
aggreator = 0.64
plugin = 1.1

Looks like it doesn't have any DEF defined. I just picked couple graphs that's using the same graph templates and create a test aggregation graph. Where can I debug this further?

thanks,
mark

Code: Select all

/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="CPC - app request at 99th" \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="" \
--slope-mode \
AREA:#FFD660:"app201.x.y.com 99th Percentile\n"  \
GPRINT::LAST:"app201.x.y.com Current\:%8.2lf %s"  \
GPRINT::AVERAGE:"Average\:%8.2lf %s"  \
GPRINT::MAX:"Maximum\:%8.2lf %s\n"  \
AREA:#FFD660:"app202.x.y.com 99th Percentile\n":STACK \
GPRINT::LAST:"app202.x.y.com Current\:%8.2lf %s"  \
GPRINT::AVERAGE:"Average\:%8.2lf %s"  \
GPRINT::MAX:"Maximum\:%8.2lf %s\n"  \
AREA:#FFD660:"app204.x.y.com 99th Percentile\n":STACK \
GPRINT::LAST:"app204.x.y.com Current\:%8.2lf %s"  \
GPRINT::AVERAGE:"Average\:%8.2lf %s"  \
GPRINT::MAX:"Maximum\:%8.2lf %s\n"  \
AREA:#FFD660:"app206.x.y.com 99th Percentile\n":STACK \
GPRINT::LAST:"app206.x.y.com Current\:%8.2lf %s"  \
GPRINT::AVERAGE:"Average\:%8.2lf %s"  \
GPRINT::MAX:"Maximum\:%8.2lf %s\n"  \
AREA:#FFD660:"app207.x.y.com 99th Percentile\n":STACK \
GPRINT::LAST:"app207.x.y.com Current\:%8.2lf %s"  \
GPRINT::AVERAGE:"Average\:%8.2lf %s"  \
GPRINT::MAX:"Maximum\:%8.2lf %s\n"  \
AREA:#FFD660:"app208.x.y.com 99th Percentile\n":STACK \
GPRINT::LAST:"app208.x.y.com Current\:%8.2lf %s"  \
GPRINT::AVERAGE:"Average\:%8.2lf %s"  \
GPRINT::MAX:"Maximum\:%8.2lf %s\n"  \
AREA:#FFD660:"app209.x.y.com 99th Percentile\n":STACK \
GPRINT::LAST:"app209.x.y.com Current\:%8.2lf %s"  \
GPRINT::AVERAGE:"Average\:%8.2lf %s"  \
GPRINT::MAX:"Maximum\:%8.2lf %s\n"  \
AREA:#FFD660:"app210.x.y.com 99th Percentile\n":STACK \
GPRINT::LAST:"app210.x.y.com Current\:%8.2lf %s"  \
GPRINT::AVERAGE:"Average\:%8.2lf %s"  \
GPRINT::MAX:"Maximum\:%8.2lf %s\n"  \
AREA:#FFD660:"app211.x.y.com 99th Percentile\n":STACK \
GPRINT::LAST:"app211.x.y.com Current\:%8.2lf %s"  \
GPRINT::AVERAGE:"Average\:%8.2lf %s"  \
GPRINT::MAX:"Maximum\:%8.2lf %s\n"  \
AREA:#FFD660:"app212.x.y.com 99th Percentile\n":STACK \
GPRINT::LAST:"app212.x.y.com Current\:%8.2lf %s"  \
GPRINT::AVERAGE:"Average\:%8.2lf %s"  \
GPRINT::MAX:"Maximum\:%8.2lf %s\n"  \
AREA:#FFD660:"app213.x.y.com 99th Percentile\n":STACK \
GPRINT::LAST:"app213.x.y.com Current\:%8.2lf %s"  \
GPRINT::AVERAGE:"Average\:%8.2lf %s"  \
GPRINT::MAX:"Maximum\:%8.2lf %s\n"  \
AREA:#FFD660:"app214.x.y.com 99th Percentile\n":STACK \
GPRINT::LAST:"app214.x.y.com Current\:%8.2lf %s"  \
GPRINT::AVERAGE:"Average\:%8.2lf %s"  \
GPRINT::MAX:"Maximum\:%8.2lf %s\n"  \
AREA:#FFD660:"app215.x.y.com 99th Percentile\n":STACK \
GPRINT::LAST:"app215.x.y.com Current\:%8.2lf %s"  \
GPRINT::AVERAGE:"Average\:%8.2lf %s"  \
GPRINT::MAX:"Maximum\:%8.2lf %s\n"  \
AREA:#FFD660:"app216.x.y.com 99th Percentile\n":STACK \
GPRINT::LAST:"app216.x.y.com Current\:%8.2lf %s"  \
GPRINT::AVERAGE:"Average\:%8.2lf %s"  \
GPRINT::MAX:"Maximum\:%8.2lf %s\n"  \
AREA:#FFD660:"app217.x.y.com 99th Percentile\n":STACK \
GPRINT::LAST:"app217.x.y.com Current\:%8.2lf %s"  \
GPRINT::AVERAGE:"Average\:%8.2lf %s"  \
GPRINT::MAX:"Maximum\:%8.2lf %s\n"  \
AREA:#FFD660:"app251.x.y.com 99th Percentile\n":STACK \
GPRINT::LAST:"app251.x.y.com Current\:%8.2lf %s"  \
GPRINT::AVERAGE:"Average\:%8.2lf %s"  \
GPRINT::MAX:"Maximum\:%8.2lf %s\n"  \
AREA:#FFD660:"app252.x.y.com 99th Percentile\n":STACK \
GPRINT::LAST:"app252.x.y.com Current\:%8.2lf %s"  \
GPRINT::AVERAGE:"Average\:%8.2lf %s"  \
GPRINT::MAX:"Maximum\:%8.2lf %s\n" 

RRDTool Says:

ERROR: parameter '#FFD660' does not represent a number in line AREA:#FFD660:app201.x.y.com 99th Percentile\n
Top
kuma3
Posts: 25
Joined: Tue Oct 02, 2007 1:17 pm

reply

Post by kuma3 »

To reply my own question, it looks like all my data sources for those graphs were gone after I aggregate them. I am trying to reproduce it again now.

I am pretty sure those graph I selected for aggregation where there.
Top
User avatar
timi
Cacti User
Posts: 240
Joined: Wed Nov 09, 2005 8:35 am
Location: Timisoara, Romania
Contact:
Contact timi

Post by timi »

gandalf wrote:
timi wrote:hmm, there is something strange:

have a lok before creating an aggregate graph and after :)
there is a new host, but when I select the () it says "Validation error. "

cacti 0.8.7a and pa 1.4
I suppose it is now time to add the fifth cacti installation to my laptop: 087a with PIA ...
ATM, I can't test this.
Reinhard
oh well, I can live with that, the aggregated graphs are showing correctly anyway...
Top
keefe007
Posts: 24
Joined: Fri Sep 23, 2005 11:33 pm

Post by keefe007 »

gandalf wrote:Please post a screenshot of your aggregate when visiting the aggregate graph at Graph Management and switching to DEBUG mode
Reinhard
Since most of my traffic is one-way I didn't notice this until now. My graph is actually aggregating but its doing it backwards. Inbound on graph 1 is being added to Outbound on graph 2 and Outbound on graph 1 is being added to inbound on graph 2. Any suggestions?
Top
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:
Contact gandalf

Post by gandalf »

Please make sure to convert to STACKed graph if you want AGGREGATE to do it correctly
Reinhard
Top
basf_audio
Posts: 40
Joined: Thu Feb 26, 2004 10:30 am
Location: Saint Louis

Error: Save Failed.

Post by basf_audio »

I'm trying to create new color templates... None exist after the install so when going to the "add", enter my name and hit save - I get a response "Error: Save Failed."

I didn't see anything in the debug logs:

Code: Select all

01/23/2008 03:43:04 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
01/23/2008 03:43:04 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
01/23/2008 03:43:04 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='15'"
01/23/2008 03:43:04 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='anonymous'"
01/23/2008 03:43:04 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
01/23/2008 03:43:01 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
01/23/2008 03:43:01 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
01/23/2008 03:43:01 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='15'"
01/23/2008 03:43:01 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='anonymous'"
01/23/2008 03:43:01 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
01/23/2008 03:42:55 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
01/23/2008 03:42:55 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
01/23/2008 03:42:55 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='72'"
01/23/2008 03:42:55 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='anonymous'"
01/23/2008 03:42:55 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
01/23/2008 03:42:55 PM - CMDPHP: Poller[0] AGGREGATE Saved ID: 0
01/23/2008 03:42:55 PM - CMDPHP: Poller[0] AGGREGATE Save ID: 0 Name: test
01/23/2008 03:42:55 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='72'"
01/23/2008 03:42:55 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='anonymous'"
01/23/2008 03:42:55 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
01/23/2008 03:42:52 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
01/23/2008 03:42:52 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
01/23/2008 03:42:52 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='72'"
01/23/2008 03:42:52 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='anonymous'"
01/23/2008 03:42:52 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
01/23/2008 03:42:50 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT plugin_color_templates.color_template_id, plugin_color_templates.name FROM plugin_color_templates WHERE (plugin_color_templates.name LIKE '%%%%') ORDER BY name ASC LIMIT 0,45"
01/23/2008 03:42:50 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT plugin_color_templates.color_template_id, plugin_color_templates.name FROM plugin_color_templates WHERE (plugin_color_templates.name LIKE '%%%%') ORDER BY name ASC LIMIT 0,45"
01/23/2008 03:42:50 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT COUNT(plugin_color_templates.color_template_id) FROM plugin_color_templates WHERE (plugin_color_templates.name LIKE '%%%%')"
01/23/2008 03:42:50 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "SELECT COUNT(plugin_color_templates.color_template_id) FROM plugin_color_templates WHERE (plugin_color_templates.name LIKE '%%%%')"
01/23/2008 03:42:50 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
01/23/2008 03:42:50 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
01/23/2008 03:42:50 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='72'"
01/23/2008 03:42:50 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='anonymous'"
01/23/2008 03:42:50 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
Info:
Cacti Version - 0.8.7a
Plugin Architecture - 1.4
Poller Type - CMD.php
Server Info - AIX 3
Web Server - Apache/1.3.27 (Unix) PHP/4.3.10
PHP - 4.3.10
PHP Extensions - xml, tokenizer, standard, session, posix, pcre, overload, mysql, ctype, apache
MySQL - 3.23.47
RRDTool - 1.2.13
SNMP - /usr/local/bin/snmpwalk: not found.
Plugins
  • Thresholds (thold - v0.3.8)
    Host Info (hostinfo - v0.2)
    Global Plugin Settings (settings - v0.3)
    Create Aggregate Graphs (aggregate - v0.64)
This was a brand new install...

Any ideas?
Top
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:
Contact gandalf

Post by gandalf »

Please check, wether the table plugin_color_templates exists in your cacti database. If not, I suppose this is due to some mysql strict checking (which may be a result of my sub-optimal SQL definition :wink: )
Reinhard
Top
basf_audio
Posts: 40
Joined: Thu Feb 26, 2004 10:30 am
Location: Saint Louis

MIA

Post by basf_audio »

gandalf wrote:Please check, wether the table plugin_color_templates exists in your cacti database. If not, I suppose this is due to some mysql strict checking (which may be a result of my sub-optimal SQL definition :wink: )
Reinhard
That was my first thought but I didn't have the two minutes to look through your setup files to see where the SQL was that created the tables.

The plugin_color_templates is actually missing.

I know that earlier versions had some SQL that could be run - or do you have the snippit of SQL that I can run to create the table?

Thanks!

_DS
Top
Locked

Return to “Plugin Announcements”

Who is online

Users browsing this forum: No registered users and 4 guests