mulitple data on same graph

[veraz01170]

Hello experts,

i am still new to Cacti and after doing a few nice single input graph, I am now trying to graph 8 data outputs... all coming from same script.
Maybe this is ambitious :>


Output of the shell script is as the following:
GoogleBot:0 YahooSlurp:0 MsnBot:0 YodaoBot:0 GigaBot:0 WebSpider:1 BaiduBot:0 Akamai:151


I have set the Data Input Method , as seen in attached img1.gif.
Then set the Graph Template , as seen in attached img2.gif

Everything is going apparently fine until I get the following error when creating the Graph template :

RRDTool Command:

/usr/local/rrdtool/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="BotsHits" \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="" \
--slope-mode \
--font TITLE:12: \
--font AXIS:8: \
--font LEGEND:10: \
--font UNIT:8: \
DEF:a="/var/www/cacti/scripts/BotsHits.sh":GoogleBot:AVERAGE \
DEF:b="/var/www/cacti/scripts/BotsHits.sh":YahooSlurp:AVERAGE \
DEF:c="/var/www/cacti/scripts/BotsHits.sh":MsnBot:AVERAGE \
DEF:d="/var/www/cacti/scripts/BotsHits.sh":YodaoBot:AVERAGE \
DEF:e="/var/www/cacti/scripts/BotsHits.sh":Gigabot:AVERAGE \
DEF:f="/var/www/cacti/scripts/BotsHits.sh":WebSpider:AVERAGE \
DEF:g="/var/www/cacti/scripts/BotsHits.sh":Baidu:AVERAGE \
DEF:h="/var/www/cacti/scripts/BotsHits.sh":AkamaiHits:AVERAGE \
\
\
\
\
\
\
\

RRDTool Says:

ERROR: '/var/www/cacti/scripts/BotsHits.sh' is not an RRD file


Any idea where i have done something wrong ?


Thanks a lot
Veraz

[Linegod]

Search the forums for 'aggregate' and/or use the Aggregate plugin.

[veraz01170]

Thanks for input!

I installed the Pluggin Arch via the patch method cacti-plugin-0.8.7b-PA-v2.1, and agregate V0.65.
But i don't get the "agragete option" when creating my graph template.

Also I now get these errors in cacti.log :


Log File [Total Lines: 50 - All Items Shown]

05/27/2008 02:34:14 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
05/27/2008 02:34:14 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_arrays'"
05/27/2008 02:34:14 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_arrays'"
05/27/2008 02:34:14 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
05/27/2008 02:34:14 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'draw_navigation_text'"
05/27/2008 02:34:14 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'draw_navigation_text'"
05/27/2008 02:34:14 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'top_header_tabs'"
05/27/2008 02:34:14 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'top_header_tabs'"
05/27/2008 02:34:14 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'page_head'"
05/27/2008 02:34:14 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'page_head'"
05/27/2008 02:34:14 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'page_title'"
05/27/2008 02:34:14 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'page_title'"
05/27/2008 02:34:14 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'top_header'"

From http://forums.cacti.net/viewtopic.php?t=19443, it looks like no mysql update is needed anymore ?


Here is the extract from my global.php :
$plugins = array();
$plugins[] = 'aggregate';

/* Do not edit this line */
$config = array();

/*


Any idea ?

Veraz

[Linegod]

Where you using the Cacti tarball downloaded from the main site, or where you using a distro's package?

[veraz01170]

I used the tarball from cacti website and I went through the long process of compiling it by hand.

cacti works, I have a mix of shell scripts, embedded and smtp-jmx Jboss based graphs that work perfectly.


Veraz

[gandalf]

I suppose that's on my plate. Unfortunately, you're not the first complaining about PIA2.1/aggregate 0.65 incompatibilities. I've not sorted it out, yet. It's working fine for me with PIA2.0 and PIA2.2beta
Reinhard