No rrd file

[rufiao]

I've installed Cacti on my NSLU2 running Debian over OpenSlug. It installed fine, could query SNMP data from my WRT54G router nicely, but it seems to be having trouble generating graphs through RRD. Turning on the graph debug mode, it says:

RRDTool Says:
ERROR: opening '/usr/share/cacti/site/rra/linksys_wrt54g_traffic_in_11.rrd': No such file or directory

This happens even if /usr/share/cacti/site/rra/ is set to 777.

The logs show the following command being executed:

/usr/bin/rrdtool graph - --imgformat=PNG --start=-86400 --end=-300 --title="Linksys WRT54G - Traffic - 192.168.1.1 (br0)" --rigid --base=1000 --height=120 --width=500 --alt-autoscale-max --lower-limit=0 --vertical-label="bytes per second" DEF:a="/usr/share/cacti/site/rra/linksys_wrt54g_traffic_in_11.rrd":traffic_in:AVERAGE DEF:b="/usr/share/cacti/site/rra/linksys_wrt54g_traffic_in_11.rrd":traffic_out:AVERAGE AREA:a#00CF00:"Inbound" GPRINTLAST:" Current\:%8.2lf %s" GPRINTAVERAGE:"Average\:%8.2lf %s" GPRINTMAX:"Maximum\:%8.2lf %s\n" LINE1:b#002A97:"Outbound" GPRINTLAST:"Current\:%8.2lf %s" GPRINTAVERAGE:"Average\:%8.2lf %s" GPRINTMAX:"Maximum\:%8.2lf %s"

Which seems to expect the existence of /usr/share/cacti/site/rra/linksys_wrt54g_traffic_in_11.rrd.
I could manage to create it using:

/usr/bin/rrdtool create \
/usr/share/cacti/site/rra/linksys_wrt54g_traffic_in_11.rrd \
--step 300 \
DS:traffic_in:GAUGE:600:0:U \
DS:traffic_out:GAUGE:600:0:U \
RRA:AVERAGE:0.5:1:600 \
RRA:AVERAGE:0.5:6:700 \
RRA:AVERAGE:0.5:24:775 \
RRA:AVERAGE:0.5:288:797 \
RRA:MAX:0.5:1:600 \
RRA:MAX:0.5:6:700 \
RRA:MAX:0.5:24:775 \
RRA:MAX:0.5:288:797

Then Cacti is able to generate graphs, but it doesn't show any data on them.

Any ideas on how to make it work, or at least some possible problems to be investigated?

[slack]

Did you install cacti via apt-get from debian stable? If so you're running an out of date version. I had the same problem. Either grab the source from here or "upgrade" to unstable.

[rufiao]

I did a 'dpkg --purge cacti' and manually installed the latest tarball for cacti, it blows the same way... Have you upgraded cacti alone, or did you upgrade other packages such as rrdtool? (my system has rrdtool 1.0.49, is this an issue?)

[rufiao]

Ok, found the issue. By running 'php /var/www/cacti/poller.php' manually it threw the following error:

Fatal error: Call to undefined function: mysql_pconnect() in /var/www/cacti/lib/adodb/drivers/adodb-mysql.inc.php on line 356

For some reason, the php4-mysql package was not configured properly by Debian. To fix it, a simple 'dpkg-reconfigure php4-mysql' sufficed.