[SOLVED] RRD files not creating, not perms problem

[korwyn]

G'day. First things first, thank you devs for restarting development! I looked for the old donate link, but it is dead.

As far as my problem, I did extensive searching of the forums and googling, and no answer I found applied.

Environment:
Ubuntu 16.04 - new build
Cacti 1.1.16 installed from tarball
cacti running as www-data.

Poller (spine) is running fine.

Code: Select all

2017/08/11 11:00:00 - SYSTEM STATS: Time:298.6697 Method:spine Processes:1 Threads:10 Hosts:2 HostsPerProcess:2 DataSources:3 RRDsProcessed:0
2017/08/11 11:00:00 - POLLER: Poller[1] NOTE: Poller Int: '300', Cron Int: '300', Time Since Last: '299.68', Max Runtime '298', Poller Runs: '1'

It doesn't appear to be permissions since running RRDtool creation from data source debug as the cacti user ('www-data') works fine and creates the rrd file correctly.

Code: Select all

www-data@cacti:~/html/rra$ ls -la
total 12
drwxr-xr-x  2 www-data www-data 4096 Aug 11 11:12 .
drwxr-xr-x 17 root     root     4096 Aug 11 10:50 ..
-rw-r--r--  1 www-data www-data  170 Jul 29 19:00 .htaccess
www-data@cacti:~/html/rra$ /usr/bin/rrdtool create \
> /var/www/html/rra/it-cswcl-01_5min_cpu_103.rrd \
> --step 300  \
> DS:5min_cpu:GAUGE:600:0:100 \
> 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 \
>
www-data@cacti:~/html/rra$ ls -la
total 108
drwxr-xr-x  2 www-data www-data  4096 Aug 11 11:13 .
drwxr-xr-x 17 root     root      4096 Aug 11 10:50 ..
-rw-r--r--  1 www-data www-data   170 Jul 29 19:00 .htaccess
-rw-rw-r--  1 www-data www-data 95608 Aug 11 11:13 it-cswcl-01_5min_cpu_103.rrd
www-data@cacti:~/html/rra$

However even if I create the graph manually, the rra data doesn't populate.

I'm at a loss as to where to look for additional logging. I have log level set to DEBUG, but I'm not seeing any relevant data in log/cacti.log.

[korwyn]

Well, I found the problem. Cacti isn't passing the DB info to spine. The build and install for spine needs to have the config file copied over to /etc from the install directory, updated with the database information, chgrp to the cacti user, the chmod to 640 (or 440).

This fixed the problem entirely. I supposed if I'd not set up for spine right out the gate I might have seen this sooner.

The troubleshooting was that I ran the poller in debug mode from the command line and finally got the output below:

Code: Select all

2017/08/11 13:06:12 - POLLER: Poller[1] NOTE: Poller Int: '300', Cron Int: '300', Time Since Last: '70.27', Max Runtime '298', Poller Runs: '1'
2017/08/11 13:06:12 - POLLER: Poller[1] DEBUG: About to Spawn a Remote Process [CMD: /usr/local/spine/bin/spine, ARGS:  --poller=1 --first=0 --last=1 --mibs]
2017-08-11 13:06:12 - SPINE: Poller[1] FATAL: Unable to read configuration file! (Spine init)
2017/08/11 13:06:12 - POLLER: Poller[1] DEBUG: About to Spawn a Remote Process [CMD: /usr/local/spine/bin/spine, ARGS:  --poller=1 --first=2 --last=2]
2017-08-11 13:06:12 - SPINE: Poller[1] FATAL: Unable to read configuration file! (Spine init)
Waiting on 2 of 2 pollers.

This was not logged ANYWHERE that I could find, and I had all the logging options turned up.