[solved] New Interface Graphs Not Plotting

[rosique]

Hi,

I am having problems when I add new devices and I create an interface graph. The graph will display, but I get no plot on the graph. I can use realtime and I get the graph and the plot on the graph. All of my old graphs are good. I only have problems when I add a new interface graph. I do not have a problem when I add other types of graphs. I looked in the rrd directory and the new interface files are there. Do I have a database problem? What table should I look in and what should I be looking for?

Here is information about my system:

Cacti Version - 0.8.7d
Plugin Architecture - 2.4
Poller Type - CMD.php
Server Info - Linux 2.6.27.19-server-1mnb
Web Server - Apache/2.2.9 (Mandriva Linux/PREFORK-12mdv2009.0)
PHP - 5.2.6
PHP Extensions - session, pcre, libxml, SimpleXML, SPL, Reflection, date, apache2handler, ctype, dom, openssl, zlib, ftp, gd, gettext, mhash, mysql, mysqli, pgsql, posix, standard, snmp, sockets, hash, sysvsem, sysvshm, tokenizer, xml, xmlrpc, xmlreader, xmlwriter, bcmath, PDO, SQLite, filter, json, radius, rar, suhosin
MySQL - 5.0.77
RRDTool - 1.3.3
SNMP - 5.4.2
Plugins

• Global Plugin Settings (settings - v0.5)
  Thresholds (thold - v0.4.1)
  Cacti Log View (CLog - v1.21)
  Device Monitoring (monitor - v0.8.2)
  Network Discovery (discovery - v0.8.5)
  Network Tools (tools - v0.3)
  Syslog Monitoring (syslog - v0.5.2)
  Login Page Mod (loginmod - v1.0)
  Update Checker (update - v0.4)
  Host Info (hostinfo - v0.2)
  Error Images (errorimage - v0.1)
  Documents (docs - v0.1)
  Cacti-ReportIt (reportit - v0.6.1)
  Router Configs (routerconfigs - v0.1)
  WMI Query (wmi - v0.1)
  Realtime for Cacti (realtime - v0.32)
  Login Page Mod (loginmod - v1.0)

Here is information about one of the graphs:

/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=1241639713 \
--end=1241726113 \
--title="A Test - Traffic - Gi0/3" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
COMMENT:"From 2009/05/06 12\:55\:13 To 2009/05/07 12\:55\:13\c" \
COMMENT:" \n" \
--vertical-label="bits per second" \
--slope-mode \
--font TITLE:10: \
--font AXIS:8: \
--font LEGEND:8: \
--font UNIT:8: \
DEF:a="/var/www/html/cacti/rra/a_test_traffic_in_20053.rrd":traffic_in:MAX \
DEF:b="/var/www/html/cacti/rra/a_test_traffic_in_20053.rrd":traffic_in:AVERAGE \
DEF:c="/var/www/html/cacti/rra/a_test_traffic_in_20053.rrd":traffic_out:MAX \
DEF:d="/var/www/html/cacti/rra/a_test_traffic_in_20053.rrd":traffic_out:AVERAGE \
CDEF:cdefa=a,8,* \
CDEF:cdefc=b,8,* \
CDEF:cdefg=c,8,* \
CDEF:cdefi=d,8,* \
AREA:cdefa#AAAAAAFF:"Max In" \
GPRINT:cdefa:MAX:" Per Five Minute Interval\:%8.2lf %s\n" \
AREA:cdefc#00CF00FF:"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#FF00FFFF:"Max Out" \
GPRINT:cdefg:MAX:" Per Five Minute Interval\:%8.2lf %s\n" \
LINE1:cdefi#002A97FF:"Outbound" \
GPRINT:cdefi:LAST:"Current\:%8.2lf %s" \
GPRINT:cdefi:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:cdefi:MAX:"Maximum\:%8.2lf %s\n"


Thanks,

John

[gandalf]

Please see Graph Management for that graph and switch to DEBUG mode. What is your finding?
Reinhard

[rosique]

Here it is:

RRDTool Command:

/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-60 \
--title="A Test - Traffic - Gi0/3" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="bits per second" \
--slope-mode \
--font TITLE:10: \
--font AXIS:8: \
--font LEGEND:8: \
--font UNIT:8: \
DEF:a="/var/www/html/cacti/rra/a_test_traffic_in_20053.rrd":traffic_in:MAX \
DEF:b="/var/www/html/cacti/rra/a_test_traffic_in_20053.rrd":traffic_in:AVERAGE \
DEF:c="/var/www/html/cacti/rra/a_test_traffic_in_20053.rrd":traffic_out:MAX \
DEF:d="/var/www/html/cacti/rra/a_test_traffic_in_20053.rrd":traffic_out:AVERAGE \
CDEF:cdefa=a,8,* \
CDEF:cdefc=b,8,* \
CDEF:cdefg=c,8,* \
CDEF:cdefi=d,8,* \
AREA:cdefa#AAAAAAFF:"Max In" \
GPRINT:cdefa:MAX:" Per Five Minute Interval\:%8.2lf %s\n" \
AREA:cdefc#00CF00FF:"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#FF00FFFF:"Max Out" \
GPRINT:cdefg:MAX:" Per Five Minute Interval\:%8.2lf %s\n" \
LINE1:cdefi#002A97FF:"Outbound" \
GPRINT:cdefi:LAST:"Current\:%8.2lf %s" \
GPRINT:cdefi:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:cdefi:MAX:"Maximum\:%8.2lf %s\n"

RRDTool Says:

OK

As far as I know rrdtool is updating the rrd file. The problem is that the graph that is displayed does not have a plot or any input/output data on it. It does have the date and time on it.

Thanks,

John

[rosique]

Here is the graph from the same switch and the same port. This graph was created several months ago.

Thanks,

John

[gandalf]

Please use 2nd link of my sig for debugging
Reinhard

[rosique]

Thanks, the debug link was very helpfull. I found out that the graphs that I am having a problem with had heartbeat = 120 and step = 60. I looked at the data template and changed heartbeat - 600 and step = 300. I changed my php.ini file to max_execution_time = 0 and max_input_time = 0 because I have 19431 datasources and php may timeout making the changes. I saved the changes on the data template and after about 10 or 15 minutes it finished saving the changes. I checked my graphs and they are the same. I did the rrdtool info and the heartbeat and step were not changed. How do I make the changes from the command line? Where can I find out how to use each command and what they do with rrdtool? I have been to their web site and I was not able to find that information.

Thanks,

John

[gandalf]

Changing existing rrd files is an adventure. There are only few parameters that CAN be changed. STEP size is NOT among them. You will have to recreate those rrd files. This is a limitation of rrdtool itself, not cacti. The command "rrdtool tune" is the only one that may change existing rrd files; see the parms allowed for it using man rrdtune
Reinhard

[rosique]

Hi,

Thanks for your help. I did use rrdtune to make some changes. Since the graphs were new, I found it faster to recreate them. Again, thanks for all of your help.

John