no graphs || cmd.php error

[sachar]

Hello,

When running cmd.php from the command line, I'm seeing the following errors:

ERROR: unknown option '--alt-autoscale-max'
ERROR: unknown option '--alt-autoscale-max'
ERROR: unknown option '--alt-autoscale-max'

which are also in my httpd log.
My rrd.log file doesn't show strange things, and it looks like data is being collected (http://hobbes.sa-char.net/cacti/log/rrd.log)

Also when using the cron printout, I also do get data returned.

But still all the graphs (except the system processes) aren't being displayed, and I can't find the reason why this is happening. Any help would be appreciated

[raX]

It almost looks as if you are using an older version of rrdtool. I suggest downloading and compiling a new one:

http://people.ee.ethz.ch/~oetiker/webto ... .35.tar.gz

See if that helps.

-Ian

[sachar]

No I'm running the stable version (debian package)

stable rrdtool 1.0.7-5


What I also noticed, is that my rra.log is being updated every 5 minutes like it should, but the files in the rra/ folder aren't (they are when I run cmd.php from the commandline)

when checing the source of a graph, I'm seing the following

Warning: Supplied argument is not a valid MySQL result resource in include/rrd_functions.php on line 573

/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start="-86400" \
--title="Apache Web Hits" \
--rigid \
--base=1000 \
--height=150 \
--width=500 \
--alt-autoscale \
--vertical-label="Hits" \
DEF:a="/var/www/cacti/rra/system_webhits.rrd":system_webhits:AVERAGE \
CDEF:cdefa= \
AREA:cdefa#7EE600:"Web Hits" \
GPRINT:cdefa:LAST:"Current\:%8.2lf %s" \
GPRINT:cdefa:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:cdefa:MAX:"Maximum\:%8.2lf %s\n"

[raX]

Actually, the version you have: 'rrdtool 1.0.7-5' appears to be older. The newest stable release is 1.0.35. I am pretty sure that your older version of rrdtool does not support the '--alt-autoscale-max' function, therefore you are getting an error.

See what happens if you compile the newest stable release of rrdtool.

-Ian

[sachar]

Installed the 1.0.35 release (although debian still thinks it's unstable) but the '--alt-autoscale-max" function still doesn't work. But using '--alt-autoscale' gets the graphs displayed.

So now I'm down to one problem

Which is that the Apache webhits graph isn't displayed. When having CDEF displayed it gives the following mysql error:

Warning: Supplied argument is not a valid MySQL result resource in include/rrd_functions.php on line

cmd.php =>
ERROR: can't parse CDEF 'cdefa='

when switching the CDEF fucntion off on the grap it does work, but shows a total of 300 m hits

[raX]

Can you print out the complete error with the line number the error is occuring on? It appears as if a SQL query is failing for some reason, which could be due to a missing CDEF in cacti.

-Ian

[sachar]

Warning: Supplied argument is not a valid MySQL result resource in include/rrd_functions.php on line 573

/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start="-86400" \
--title="Apache Web Hits" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale \
--vertical-label="Connections" \
DEF:a="/var/www/cacti/rra/system_webhits.rrd":system_webhits:AVERAGE \
CDEF:cdefa=a \
AREA:cdefa#005199:"Web Hits" \
GPRINTLAST:"Current\:%8.2lf %s" \
GPRINTAVERAGE:"Average\:%8.2lf %s" \
GPRINTMAX:"Maximum\:%8.2lf %s\n"


is the complete info "source" gives.

cheers