New graphs with same template no longer work

Post general support questions here that do not specifically fall into the Linux or Windows categories.

Moderators: Developers, Moderators

Post Reply
tl1997
Posts: 19
Joined: Sat Feb 03, 2007 1:07 am
Location: Coral Gables, FL

New graphs with same template no longer work

Post by tl1997 »

Hello fellow Cacti users,

For some reason, all of the sudden, any new graphs I create using the same template I've been using for the last year or two, don't work, with rrdtool failing to be able to produce a graph. However, existing graphs that were created awhile ago using the same template still work just fine, and continue to be updated. The template is In/Out Bits 95th percentile with 64-bit counters.

I'm not very well versed in rrdtool (which is why I installed cacti in the first place :) ) Does anyone have any ideas on what I should check? Here's the debug output from one of the failing graphs:

RRDTool Command:
/usr/local/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="Orovitz 12k - Traffic" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="bits per second" \
--slope-mode \
--font TITLE:12: \
--font AXIS:8: \
--font LEGEND:10: \
--font UNIT:8: \
DEF:a="/usr/local/share/cacti/rra/orovitz_12k_traffic_in_2121.rrd":traffic_in:AVERAGE \
DEF:b="/usr/local/share/cacti/rra/orovitz_12k_traffic_in_2121.rrd":traffic_in:LAST \
DEF:c="/usr/local/share/cacti/rra/orovitz_12k_traffic_in_2121.rrd":traffic_in:MIN \
DEF:d="/usr/local/share/cacti/rra/orovitz_12k_traffic_in_2121.rrd":traffic_in:MAX \
DEF:e="/usr/local/share/cacti/rra/orovitz_12k_traffic_in_2121.rrd":traffic_out:AVERAGE \
DEF:f="/usr/local/share/cacti/rra/orovitz_12k_traffic_in_2121.rrd":traffic_out:LAST \
DEF:g="/usr/local/share/cacti/rra/orovitz_12k_traffic_in_2121.rrd":traffic_out:MIN \
DEF:h="/usr/local/share/cacti/rra/orovitz_12k_traffic_in_2121.rrd":traffic_out:MAX \
CDEF:cdefa=a,8,* \
CDEF:cdefb=b,8,* \
CDEF:cdefd=d,8,* \
CDEF:cdefh=e,8,* \
CDEF:cdefi=f,8,* \
CDEF:cdefba=h,8,* \
CDEF:cdefbb=a,UN,INF,UNKN,IF \
CDEF:cdefbg=TIME,1226519973,GT,a,a,UN,0,a,IF,IF,TIME,1226519973,GT,e,e,UN,0,e,IF,IF,+ \
AREA:cdefa#157419FF:"In" \
GPRINT:cdefb:LAST:" Cur\:%8.2lf %s" \
GPRINT:cdefa:AVERAGE:"Av\:%8.2lf %s" \
GPRINT:cdefd:MAX:"Max\:%8.2lf %s" \
COMMENT:"Transfer\: 2.71 MB" \
HRULE:|95\:bits\:0\:current|#00FF00FF:"95%\:" \
COMMENT:"|95\:bits\:6\:current| mbit\n" \
LINE1:cdefh#002A8FFF:"Out" \
GPRINT:cdefi:LAST:"Cur\:%8.2lf %s" \
GPRINT:cdefh:AVERAGE:"Av\:%8.2lf %s" \
GPRINT:cdefba:MAX:"Max\:%8.2lf %s" \
AREA:cdefbb#8F9286FF:"" \
COMMENT:"Transfer\: 2.69 MB" \
HRULE:|95\:bits\:0\:current|#0000FFFF:"95%\:" \
COMMENT:"|95\:bits\:6\:current| mbit\n" \
COMMENT:"\n" \
HRULE:143998.74#FF0000FF:"Total 95%\:" \
COMMENT:"0.14 mbit" \
COMMENT:"Total Transfer\: 5.4 MB\n"
RRDTool Says:

The part after "RRDTool Says" is completely blank, I didn't truncate the post. Again, other templates work, and even the same template works for graphs that were created awhile back.

Here's the output from a working graph of the same template. Towards the end of the rrd command, its quite different. Is my template somehow corrupt? If the template somehow changes, does it only affect new graphs and not old ones? Working graph of (supposedly) same template:

RRDTool Command:
/usr/local/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="Pentland Core - Traffic - To-Pentland-10k - Te7/4" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="bits per second" \
--slope-mode \
--font TITLE:12: \
--font AXIS:8: \
--font LEGEND:10: \
--font UNIT:8: \
DEF:a="/usr/local/share/cacti/rra/pentland_core_traffic_in_1339.rrd":traffic_in:AVERAGE \
DEF:b="/usr/local/share/cacti/rra/pentland_core_traffic_in_1339.rrd":traffic_in:LAST \
DEF:c="/usr/local/share/cacti/rra/pentland_core_traffic_in_1339.rrd":traffic_in:MIN \
DEF:d="/usr/local/share/cacti/rra/pentland_core_traffic_in_1339.rrd":traffic_in:MAX \
DEF:e="/usr/local/share/cacti/rra/pentland_core_traffic_in_1339.rrd":traffic_out:AVERAGE \
DEF:f="/usr/local/share/cacti/rra/pentland_core_traffic_in_1339.rrd":traffic_out:LAST \
DEF:g="/usr/local/share/cacti/rra/pentland_core_traffic_in_1339.rrd":traffic_out:MIN \
DEF:h="/usr/local/share/cacti/rra/pentland_core_traffic_in_1339.rrd":traffic_out:MAX \
CDEF:cdefa=a,8,* \
CDEF:cdefb=b,8,* \
CDEF:cdefd=d,8,* \
CDEF:cdefe=e,8,* \
CDEF:cdeff=f,8,* \
CDEF:cdefh=h,8,* \
AREA:cdefa#00CF00FF:"Inbound" \
GPRINT:cdefb:LAST:" Current\:%8.2lf %s" \
GPRINT:cdefa:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:cdefd:MAX:"Maximum\:%8.2lf %s\n" \
LINE1:cdefe#002A97FF:"Outbound" \
GPRINT:cdeff:LAST:"Current\:%8.2lf %s" \
GPRINT:cdefe:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:cdefh:MAX:"Maximum\:%8.2lf %s\n" \
COMMENT:"\n" \
HRULE:2667.75#FF0000FF:"95th Percentile" \
COMMENT:"(0 mbit in+out)"
RRDTool Says:
OK

Any suggestions would be greatly appreciated.

My system:
Cacti Version - 0.8.7b
Plugin Architecture - 2.1
Poller Type - CMD.php
Server Info - FreeBSD 7.0-RELEASE
Web Server - Apache/2.2.8 (FreeBSD) mod_ssl/2.2.8 OpenSSL/0.9.8e DAV/2 PHP/5.2.6 with Suhosin-Patch mod_perl/2.0.3 Perl/v5.8.8
PHP - 5.2.6
PHP Extensions - session, Reflection, date, libxml, apache2handler, mysql, pcre, xml, gettext, gd, sockets, standard, snmp, zlib, ldap, posix, filter, SimpleXML, SPL, mysqli
MySQL - 5.1.28-rc
RRDTool - 1.2.26
SNMP - 5.4.1
Plugins
  • Global Plugin Settings (settings - v0.4)
    Thresholds (thold - v0.3.9)
    PHP Network Weathermap (weathermap - v0.95b)
    Network Tools (tools - v0.2)
    Device Tracking (mactrack - v1.1)
    Network Discovery (discovery - v0.8.3)
    Host Info (hostinfo - v0.2)
    SuperLinks (superlinks - v0.72)
    Create Aggregate Graphs (aggregate - v0.65)
    ReportIt (ReportIt - v0.5.1)
    Update Checker (update - v0.4)
    Syslog Monitoring (syslog - v0.5.2)
    Configuration manager (configmanager - v0.76)
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Post by gandalf »

The HRULE statement is broken. It prints the plain text instead of calculating a number as required. Strange and unknown behaviour, especially because its working on the second graph
Reinhard
tl1997
Posts: 19
Joined: Sat Feb 03, 2007 1:07 am
Location: Coral Gables, FL

Post by tl1997 »

Thanks...I did reach the conclusion that after the graph is made, the template doesn't matter. It appears that some how my template got messed up, maybe during an import or something.

Can anyone export a "fresh" Interface - Traffic (bits/sec, 95th Percentile) graph template and post it here? I figure if I can delete and re-add a clean one, I should be able to create new graphs again.
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Post by gandalf »

Please create a second db, let's call it "cactibkup". Then import cacti.sql into it. Point your config.php to that db and export the template from cactibkip.
Then, point config.php back to your cacti db and import.
That's how you can do it on your own
Reinhard
Post Reply

Who is online

Users browsing this forum: No registered users and 7 guests