RRDTool version and Cacti not working

[AuroraMike]

I have a fresh brand new install of CentOS 5.3. I'm having two issues but we'll work one at a time to start. The first is with rrdtool. I installed from source, w/o errors (and I have verified that it's working) and it's currently at version 1.3.7.

RRDtool 1.3.7 Copyright 1997-2009 by Tobias Oetiker <tobi@oetiker.ch>
Compiled Apr 29 2009 16:06:48

Usage: rrdtool [options] command command_options

Valid commands: create, update, updatev, graph, graphv, dump, restore,
last, lastupdate, first, info, fetch, tune,
resize, xport

RRDtool is distributed under the Terms of the GNU General
Public License Version 2. (www.gnu.org/copyleft/gpl.html)

For more information read the RRD manpages

Now in Cacti, which is at version 0.8.7d, under the "Technical Support" page I'm getting:

ERROR: Installed RRDTool version does not match configured version.
Please visit the Configuration Settings and select the correct RRDTool Utility Version.

The problem is that on the config page I am selecting RRDTool 1.3.x in the dropdown box and saving. I have verified the path, cacti says

OK: FILE FOUND

and I only have a single install of rrdtool on my server (yes I did an updatedb before this):

# locate rrdtool
/usr/local/rrdtool
/usr/local/rrdtool/bin
/usr/local/rrdtool/include
/usr/local/rrdtool/lib
/usr/local/rrdtool/share
/usr/local/rrdtool/bin/rrdcgi
/usr/local/rrdtool/bin/rrdtool
/usr/local/rrdtool/bin/rrdupdate

I don't have SELinux enabled. I'm open to suggestion as to how to fix this. It's kind of a buzzkill at the moment.

[AuroraMike]

So for giggles and grins, I removed /usr/local/rrdtool and found a RPM flavor (not the x86_64 version, this install isn't a 64-bit one) and installed that w/ no errors. Problem is, despite rrdtool still saying that it's 1.3.7 (and rrdtool is now in the /usr/bin folder and I did update the link in the cacti config) Cacti still says that I don't have the correct version selected. When I select 1.0.x and 1.2.x I still get the same message.

I know rrdtool works because I have it working with MRTG and nTop. I'm still open to suggestion. Thanks.

[TheWitness]

What happens when you goto the Technical Support page. Can you post a screen shot. Does your web site have execute access on the rrdtool binary, or is it in Jail?

TheWitness

[AuroraMike]

I had almost given up hope of someone replying to this thread.

permissions are 755 and owned by apache:apache

[TheWitness]

So, are Cacti graphs not working, or is this just a nuisance error?

TheWitness

[AuroraMike]

none of the graphs are being created, even for the local ones that are installed by default.

I've verified directory/file permissions for the web user (I've even gone so far as to do 777 but currently at 755 on the dirs) but there aren't any rrd files being created by cacti.

I did note that the .rrds were not being created in /var/www/html/cacti/rra and if I ran the graph commands myself from the command line, the files would be created just fine (although updates aren't occuring). So I'm at a loss.

[alm]

Are you sure the user under which cacti runs can access the rrdtool? Is your MySQL database configured correctly in that the user running cacti can access it completely?

[TheWitness]

Goto Graph Management, bring up a graph and press the debug link. Post the output. Then take the graph syntax and copy and paste it to a command prompt and post your output. It may be a bunch of binary characters, but I suspect it will an error of some type.

TheWitness

[AuroraMike]

/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="Localhost - Processes" \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="processes" \
--slope-mode \
--font TITLE:12: \
--font AXIS:8: \
--font LEGEND:10: \
--font UNIT:8: \
DEF:a="/var/www/html/cacti/rra/localhost_proc_7.rrd":proc:AVERAGE \
AREA:a#F51D30FF:"Running Processes" \
GPRINTLAST:"Current\:%8.0lf" \
GPRINTAVERAGE:"Average\:%8.0lf" \
GPRINTMAX:"Maximum\:%8.0lf\n"

but yes, when I do this via SSH I get a bunch of characters I'm sure you'd rather not have in your database. No error though. Just about 1/2 a page of latin/greek/slavic characters and high numbered ASCII characters. Here's another graph source:

/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="Localhost - Load Average" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--units-exponent=0 \
--vertical-label="processes in the run queue" \
--slope-mode \
--font TITLE:12: \
--font AXIS:8: \
--font LEGEND:10: \
--font UNIT:8: \
DEF:a="/var/www/html/cacti/rra/localhost_load_1min_5.rrd":load_1min:AVERAGE \
DEF:b="/var/www/html/cacti/rra/localhost_load_1min_5.rrd":load_5min:AVERAGE \
DEF:c="/var/www/html/cacti/rra/localhost_load_1min_5.rrd":load_15min:AVERAGE \
CDEF:cdefg=TIME,1241882094,GT,a,a,UN,0,a,IF,IF,TIME,1241882094,GT,b,b,UN,0,b,IF,IF,TIME,1241882094,GT,c,c,UN,0,c,IF,IF,+,+ \
AREA:a#EACC00FF:"1 Minute Average" \
GPRINTLAST:" Current\:%8.2lf\n" \
AREA:b#EA8F00FF:"5 Minute Average":STACK \
GPRINTLAST:" Current\:%8.2lf\n" \
AREA:c#FF0000FF:"15 Minute Average":STACK \
GPRINT:c:LAST:"Current\:%8.2lf\n" \
LINE1:cdefg#000000FF:""

As you can see from the screenshot, cacti thinks it's graphing. I did check mySQL, no issues there, correct account setup and permissions. If I do a lot of the graph commands from the CLI, like the create commands, it all works. The .rrd files were not on in the /rra directory until I manually (i.e. myself) ran the create command found in cacti myself. Everything is owned by apache (or the webuser in this case) and apache does have access to the rrdtool.

[TheWitness]

So, it's the RRDtool creates that are failing. Could it be that mysql does not have a valid shell and is not authorized to run RRDtool. Being that the files are only create from the command prompt, this would appear to be related to the issue. I would also look at the apache error log file when viewing the graphs. Also, run the poller by hand and view the statistics. You should do this in low. Also, is the cron actually running? That could be the issue as well.

TheWitness

[AuroraMike]

So, it's the RRDtool creates that are failing. Could it be that mysql does not have a valid shell and is not authorized to run RRDtool. Being that the files are only create from the command prompt, this would appear to be related to the issue. I would also look at the apache error log file when viewing the graphs. Also, run the poller by hand and view the statistics. You should do this in low. Also, is the cron actually running? That could be the issue as well.

TheWitness

mysql needs access to rrdtool? eh...I didn't realize that. ok, I'll have to go back and dork with the permissions. Cron, however, is working, I did check the cron log and no errors there.

Appreciate the help. Thanks much!

[unixstate]

Hi All, I have the same issue, I try to resolv with install old version of rrdtool but I can't do. One time ago I can do with rrdtool 1.2.27 but just now nop. I try to get solve it, if I can do , I tell you.

Sorry for my poor english

Regards

[gandalf]

So, it's the RRDtool creates that are failing. Could it be that mysql does not have a valid shell and is not authorized to run RRDtool. Being that the files are only create from the command prompt, this would appear to be related to the issue. I would also look at the apache error log file when viewing the graphs. Also, run the poller by hand and view the statistics. You should do this in low. Also, is the cron actually running? That could be the issue as well.

TheWitness

mysql needs access to rrdtool? eh...I didn't realize that. ok, I'll have to go back and dork with the permissions. Cron, however, is working, I did check the cron log and no errors there.

Appreciate the help. Thanks much!

MySQL <-> httpd, I suppose. But viewing error log is a good idea.
Reinhard

[rigan123]

I had the same problem.But I already resolved.

If you use Windows check the RRDtool.exe path. Then manualy try to run RRDtool.exe It might not run because of some dll error.Download dll file manually and install.

The reason is very simple that RRDtool.exe is not running.You need to run rrdtool.exe by anyway

Cheers !

Rigan.