RRDTool not creating rrd files

[Paul.Shiner]

Hi All,

Hope someone can help, installed cacti and RRDTool from Ubuntu 9.04 package manager and the RRDTool is 1.3.7 and Cacti is 0.8.7.b

Basically when I create new data source it doesn't create the file in /var/lib/cacti/rra as it's supposed to... so when I crete graph I get debug info saying it can't fine file.

Its not a permission issue as its chmod'd to 777. Creating file from OS command line gets the graphing working but I don't want to create rrd manually each time.

I believe it could be that the create statement in cacti has \ on end which needs to be left off the create from command line but I'm not sure:
/usr/bin/rrdtool create \
/var/lib/cacti/rra/uksl-mgt01_cpu_load_1064.rrd \
--step 300 \
DS:cpu_load:GAUGE:600:0:101 \
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:MIN:0.5:1:600 \
RRA:MIN:0.5:6:700 \
RRA:MIN:0.5:24:775 \
RRA:MIN: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 \
RRA:LAST:0.5:1:600 \
RRA:LAST:0.5:6:700 \
RRA:LAST:0.5:24:775 \
RRA:LAST:0.5:288:797 \

Any help would be really appreciated!

Thanks,

Paul

[gandalf]

Please see 2nd link of my sig. I suspect a downed host detection issue. This will result in no file being created. The ending slash should not cause a problem, IMHO. At least on my Linuxes it does not ...
Reinhard

[Paul.Shiner]

Hi Reinhard,

Maybe I'm going slightly mad, but I can't see your signature!

I thought it was a downed host issue too, after reading all the posts in this forum and the toubleshooting guide, however I've tried changing it from ping detection, to SNMP, to both and ensure the host was considered up according to cacti. However it doesn't work against any host at all.

The only thing I did, that I can see potentially causing an issue was copy the database from old server. But I thought it was working as all graphs were created and working (rrd files were created after db migration as I didn't copy them from old server). The only thing I can't do is create new graphs/data sources on either new or existing hosts

Any other help would be greatly appreciated as I'm monitoring/graphing over 500 things and I really don't have time to start from scratch and manully create all graphs again!

Thanks,

Paul

[gandalf]

Hi Reinhard,

Maybe I'm going slightly mad, but I can't see your signature!

Please login to find it
Reinhard

[Paul.Shiner]

Aaah that makes sense, can see the sig link now. Unfortuntely I have already seen and followed that guide and all is exaclty as it should be but new RRD files are not created

It so weird because once they are manually created through CLI cacti works perfectly.

The only other thing I can think of trying is updating cacti to version D but it isn't available via ubuntu debian installer and I would have to manually install from tar.gz which is likely to have differences in rrd and log file locations just as an example. I might try that soon if no one has any ideas to help further. Luckily it's a VM and I have the blessing of snapshots

[Paul.Shiner]

Ok - I just tried an update of cacti to 0.8.7d and make sure rra, log etc were own by cactiuser but still no luck - no rrd files are being created? Anybody got any ideas?

Thanks,

Paul

[Paul.Shiner]

Ok I've managed to get it all working. I rolled back to cacti 0.8.7b debian install from snapshot as the upgrade to 0.8.7d tar.gz version killed everything - it stop graphing everything even after fixing up all directory changes like /var/lib/cacti/rra to /usr/share/cacti/rra. Lesson here is only use debian install on debian machine if available.

Anyway I changed following to get 0.8.7b debian install to create rrd files initially as far as I know although I was fiddling with a few other things:

Changed permissions on /etc/cacti/debian.php so www-data could read.

Thanks for your help and suggestions Reinhard,

Paul

Gotta say loving cacti now it's finally all working well - great tool

[gandalf]

Fine that you resolved it.
To be honest, I don't love all the distro dependencies. Our default file layout is matching RH better than the debian family
Reinhard

[emiel]

Changed permissions on /etc/cacti/debian.php so www-data could read.

i have exactly the same problem as you, i tried changing the permissions on /debian.php but that doesnt work for me....

i still get the same error:

RRDTool Command:

/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="AP-SVR01 - Logged in Users" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="users" \
--slope-mode \
--font TITLE:12: \
--font AXIS:8: \
--font LEGEND:10: \
--font UNIT:8: \
DEF:a="/var/lib/cacti/rra/ap-svr01_users_8.rrd":users:AVERAGE \
AREA:a#4668E4FF:"Users" \
GPRINTLAST:"Current\:%8.0lf" \
GPRINTAVERAGE:"Average\:%8.0lf" \
GPRINTMAX:"Maximum\:%8.0lf"

RRDTool Says:

ERROR: opening '/var/lib/cacti/rra/ap-svr01_users_8.rrd': No such file or directory


hope somebody can help me out with this

[TheWitness]

You should start a separate post for this. However, you need to first review your Cacti log for issues and to verify that the poller is actually running. Beyond that, you need to make sure your permissions are correct.

From the prior posts, it looks like whoever did the debian package, may have made a few assumptions, that are causing issues. Please open a Debian bug once you find the issue.

TheWitness

[emiel]

i did (http://forums.cacti.net/viewtopic.php?t=32717)

but i searched a bit and found the same problem

[TheWitness]

Code: Select all

su - <cacti_cron_user>
cd /var/www/html/cacti
php -q poller.php -f

Post results.

TheWitness

[emiel]

root@mt-svr01:/usr/share/cacti/site# php -q poller.php --force
*** buffer overflow detected ***: /usr/sbin/spine terminated
======= Backtrace: =========
/lib/libc.so.6(__fortify_fail+0x37)[0x7f96b22682c7]
/lib/libc.so.6[0x7f96b2266170]
/lib/libc.so.6[0x7f96b22657ab]
/lib/libc.so.6(__snprintf_chk+0x7b)[0x7f96b226567b]
/usr/sbin/spine[0x40a08a]
/usr/sbin/spine[0x40a2f3]
/lib/libpthread.so.0[0x7f96b29813ba]
/lib/libc.so.6(clone+0x6d)[0x7f96b224efcd]
======= Memory map: ========
00400000-00413000 r-xp 00000000 08:01 331795 /usr/sbin/spine
00612000-00613000 r--p 00012000 08:01 331795 /usr/sbin/spine
00613000-00614000 rw-p 00013000 08:01 331795 /usr/sbin/spine
00614000-00616000 rw-p 00614000 00:00 0
00f5b000-01082000 rw-p 00f5b000 00:00 0 [heap]
7f96b133f000-7f96b134b000 r-xp 00000000 08:01 718109 /lib/libnss_files-2.9.so
7f96b134b000-7f96b154a000 ---p 0000c000 08:01 718109 /lib/libnss_files-2.9.so
7f96b154a000-7f96b154b000 r--p 0000b000 08:01 718109 /lib/libnss_files-2.9.so
7f96b154b000-7f96b154c000 rw-p 0000c000 08:01 718109 /lib/libnss_files-2.9.so
7f96b154c000-7f96b1562000 r-xp 00000000 08:01 718093 /lib/libgcc_s.so.1
7f96b1562000-7f96b1762000 ---p 00016000 08:01 718093 /lib/libgcc_s.so.1
7f96b1762000-7f96b1763000 r--p 00016000 08:01 718093 /lib/libgcc_s.so.1
7f96b1763000-7f96b1764000 rw-p 00017000 08:01 718093 /lib/libgcc_s.so.1
7f96b1764000-7f96b1765000 ---p 7f96b1764000 00:00 0
7f96b1765000-7f96b1f65000 rw-p 7f96b1765000 00:00 0
7f96b1f65000-7f96b1f67000 r-xp 00000000 08:01 718103 /lib/libdl-2.9.so
7f96b1f67000-7f96b2167000 ---p 00002000 08:01 718103 /lib/libdl-2.9.so
7f96b2167000-7f96b2168000 r--p 00002000 08:01 718103 /lib/libdl-2.9.so
7f96b2168000-7f96b2169000 rw-p 00003000 08:01 718103 /lib/libdl-2.9.so
7f96b2169000-7f96b22d1000 r-xp 00000000 08:01 718100 /lib/libc-2.9.so
7f96b22d1000-7f96b24d1000 ---p 00168000 08:01 718100 /lib/libc-2.9.so
7f96b24d1000-7f96b24d5000 r--p 00168000 08:01 718100 /lib/libc-2.9.so
7f96b24d5000-7f96b24d6000 rw-p 0016c000 08:01 718100 /lib/libc-2.9.so
7f96b24d6000-7f96b24db000 rw-p 7f96b24d6000 00:00 0
7f96b24db000-7f96b24f1000 r-xp 00000000 08:01 718106 /lib/libnsl-2.9.so
7f96b24f1000-7f96b26f1000 ---p 00016000 08:01 718106 /lib/libnsl-2.9.so
7f96b26f1000-7f96b26f2000 r--p 00016000 08:01 718106 /lib/libnsl-2.9.so
7f96b26f2000-7f96b26f3000 rw-p 00017000 08:01 718106 /lib/libnsl-2.9.so
7f96b26f3000-7f96b26f5000 rw-p 7f96b26f3000 00:00 0
7f96b26f5000-7f96b2779000 r-xp 00000000 08:01 718104 /lib/libm-2.9.so
7f96b2779000-7f96b2978000 ---p 00084000 08:01 718104 /lib/libm-2.9.so
7f96b2978000-7f96b2979000 r--p 00083000 08:01 718104 /lib/libm-2.9.so
7f96b2979000-7f96b297a000 rw-p 00084000 08:01 718104 /lib/libm-2.9.so
7f96b297a000-7f96b2991000 r-xp 00000000 08:01 718114 /lib/libpthread-2.9.so
7f96b2991000-7f96b2b90000 ---p 00017000 08:01 718114 /lib/libpthread-2.9.so
7f96b2b90000-7f96b2b91000 r--p 00016000 08:01 718114 /lib/libpthread-2.9.so
7f96b2b91000-7f96b2b92000 rw-p 00017000 08:01 718114 /lib/libpthread-2.9.so
7f96b2b92000-7f96b2b96000 rw-p 7f96b2b92000 00:00 0
7f96b2b96000-7f96b2bad000 r-xp 00000000 08:01 718219 /lib/libz.so.1.2.3.3
7f96b2bad000-7f96b2dac000 ---p 00017000 08:01 718219 /lib/libz.so.1.2.3.3
7f96b2dac000-7f96b2dad000 r--p 00016000 08:01 718219 /lib/libz.so.1.2.3.3
7f96b2dad000-7f96b2dae000 rw-p 00017000 08:01 718219 /lib/libz.so.1.2.3.3
OK u:0.00 s:0.00 r:1.02
OK u:0.00 s:0.00 r:1.02
OK u:0.00 s:0.00 r:1.02
OK u:0.00 s:0.00 r:1.02
OK u:0.00 s:0.00 r:1.02

[TheWitness]

Use 0.8.7d located in the announcements forum. Prior 0.8.7x releases were unstable.

TheWitness

[emiel]

so you mean to upgrade from 0.8.7b to 0.8.7d ?