RRD files not being created with Spine running

[mrheavydee95]

SNMP is configured.
When I switch the poller to cmd.php, the files get created and are updated.

I can't use cmd.php because I have a lot of devices to add and the poller times out which is why I need to use Spine.
One more thing to add. It seems Spine has no issues updating the local Linux Machine device.

Hoping this helps identify what's going on.

[macan]

Try to stop spine in cron and run manually
./spine --first=5 --last=5 -V=3

[mrheavydee95]

:/usr/local/spine/bin$ ./spine --first=5 --last=5 -V=3
SPINE: Using spine config file [/etc/spine.conf]
Version 1.2.26 starting
2024-03-20 12:33:37 - SPINE: Poller[1] PID[159345] PT[127980681758528] No Device 0 Poller Items found.
ERROR: Spine Log File Could Not Be Opened/Created
2024-03-20 12:33:37 - SPINE: Poller[1] PID[159345] PT[127980681758528] Time: 0.0188 s, Threads: 12, Devices: 0

[mrheavydee95]

If I run the command with sudo in front of it, I don't get the message regarding the spine log file, see below:

:/usr/local/spine/bin$ sudo ./spine --first=5 --last=5 -V=3
SPINE: Using spine config file [/etc/spine.conf]
Version 1.2.26 starting
2024-03-20 12:43:28 - SPINE: Poller[1] PID[161125] PT[126273089398592] No Device 0 Poller Items found.
2024-03-20 12:43:28 - SPINE: Poller[1] PID[161125] PT[126273089398592] Time: 0.0182 s, Threads: 12, Devices: 0

[macan]

wrong! Change permission on cacti/rra to www-data:
chown -R www-data /your/path/to/cacti/rra
chmod 664 /your/path/to/cacti/rra/*

su www-data
spine --first=5 --last=5 -V=3

And check /your/path/to/cacti/rra
Are files updated?

[mrheavydee95]

I tried what you recommended and the files are still not being created.
Please note that when I typed "su www-data" it asked me for a password and it wouldn't allow me to continue by just hitting enter without a password so I used the below command, I didn't use 5 in the command because that belongs to the local-linux server which is populating using spine as I mentioned in a previous post.

sudo -u www-data /usr/local/spine/bin/spine --first=8 --last=8 -V=3

See results below:
$ sudo -u www-data /usr/local/spine/bin/spine --first=8 --last=8 -V=3
SPINE: Using spine config file [/etc/spine.conf]
Version 1.2.26 starting
2024-03-20 13:55:44 - SPINE: Poller[1] PID[171541] PT[124391765948224] No Device 0 Poller Items found.
2024-03-20 13:55:44 - SPINE: Poller[1] PID[171541] PT[124391765948224] Time: 0.0324 s, Threads: 12, Devices: 0

:/var/www/html/cacti/rra$ ll
total 672
drwxr-xr-x 2 www-data www-data 4096 Mar 20 13:55 ./
drwxr-xr-x 22 www-data www-data 4096 Mar 19 19:35 ../
-rwxr-xr-x 1 www-data www-data 1731 Mar 19 19:07 .htaccess*
-rw-rw-r-- 1 www-data www-data 282440 Mar 20 13:55 local_linux_machine_load_1min_2.rrd
-rw-rw-r-- 1 www-data www-data 95608 Mar 20 13:55 local_linux_machine_mem_buffers_4.rrd
-rw-rw-r-- 1 www-data www-data 95608 Mar 20 13:55 local_linux_machine_mem_swap_5.rrd
-rw-rw-r-- 1 www-data www-data 95608 Mar 20 13:55 local_linux_machine_proc_1.rrd
-rw-rw-r-- 1 www-data www-data 95608 Mar 20 13:55 local_linux_machine_users_3.rrd

[macan]

Threads: 12, Devices: 0
It seems that you inserted incorrect device ID. You can run it for all devicess
sudo -u www-data /usr/local/spine/bin/spine -V=3

[mrheavydee95]

Here's the output.

$ sudo -u www-data /usr/local/spine/bin/spine -V=3
SPINE: Using spine config file [/etc/spine.conf]
Version 1.2.26 starting
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571183101760] No Device 0 Poller Items found.
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132570465429056] Device[1] HT[1] NOTE: There are '5' Polling Items for this Device
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132570465429056] Device[1] HT[1] DS[1] TT[8.51] SCRIPT: perl /var/www/html/cacti/scripts/unix_processes.pl, output: 170
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132570465429056] Device[1] HT[1] DS[2] TT[4.08] SCRIPT: perl /var/www/html/cacti/scripts/loadavg_multi.pl, output: 1min:0.00 5min:0.02 10min:0.04
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132570465429056] Device[1] HT[1] DS[3] TT[4.13] SCRIPT: perl /var/www/html/cacti/scripts/unix_users.pl '', output: 2
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132570465429056] Device[1] HT[1] DS[4] TT[4.27] SCRIPT: perl /var/www/html/cacti/scripts/linux_memory.pl 'MemFree:', output: 10021564
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132570465429056] Device[1] HT[1] DS[5] TT[4.22] SCRIPT: perl /var/www/html/cacti/scripts/linux_memory.pl 'SwapFree:', output: 0
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132570465429056] Device[1] HT[1] Updating Poller Items for Next Poll
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132570465429056] Device[1] HT[1] Total Time: 0.032 Seconds
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132570473821760] Device[2] INFO: ICMP Device Alive, Try Count:1, Time:111.8340 ms
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571170076224] Device[2] INFO: ICMP Device Alive, Try Count:1, Time:3.0251 ms
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571035838016] Device[2] INFO: ICMP Device Alive, Try Count:1, Time:112.4351 ms
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571027445312] Device[2] INFO: ICMP Device Alive, Try Count:1, Time:112.0620 ms
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571077801536] Device[2] INFO: ICMP Device Alive, Try Count:1, Time:2.3720 ms
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571044230720] Device[2] INFO: ICMP Device Alive, Try Count:1, Time:113.2109 ms
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571161683520] Device[2] INFO: ICMP Device Alive, Try Count:1, Time:115.2999 ms
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571069408832] Device[2] INFO: ICMP Device Alive, Try Count:1, Time:114.4221 ms
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571052623424] Device[2] INFO: ICMP Device Alive, Try Count:1, Time:114.0192 ms
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571061016128] Device[2] INFO: ICMP Device Alive, Try Count:1, Time:114.8610 ms
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571077801536] Device[2] HT[3] DQ[16] Legacy Uptime Result: U, Is Numeric: 0
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571077801536] Device[2] HT[3] DQ[16] Extended Uptime Result: , Is Numeric: 0
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571077801536] Device[2] HT[3] DQ[16] RECACHE OID: .1.3.6.1.2.1.1.3.0, (assert: < output: )
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132570473821760] Device[2] HT[10] DQ[16] Legacy Uptime Result: U, Is Numeric: 0
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132570473821760] Device[2] HT[10] DQ[16] Extended Uptime Result: , Is Numeric: 0
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132570473821760] Device[2] HT[10] DQ[16] RECACHE OID: .1.3.6.1.2.1.1.3.0, (assert: < output: )
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571077801536] Device[2] HT[3] NOTE: There are '2' Polling Items for this Device
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571077801536] Device[2] HT[3] Total Time: 0.22 Seconds
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132570473821760] Device[2] HT[10] Updating Poller Items for Next Poll
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132570473821760] Device[2] HT[10] Total Time: 0.22 Seconds
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571061016128] Device[2] HT[5] DQ[16] Legacy Uptime Result: U, Is Numeric: 0
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571061016128] Device[2] HT[5] DQ[16] Extended Uptime Result: , Is Numeric: 0
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571061016128] Device[2] HT[5] DQ[16] RECACHE OID: .1.3.6.1.2.1.1.3.0, (assert: < output: )
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571061016128] Device[2] HT[5] NOTE: There are '2' Polling Items for this Device
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571061016128] Device[2] HT[5] Total Time: 0.23 Seconds
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571170076224] Device[2] HT[1] DQ[16] Legacy Uptime Result: U, Is Numeric: 0
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571170076224] Device[2] HT[1] DQ[16] Extended Uptime Result: , Is Numeric: 0
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571170076224] Device[2] HT[1] DQ[16] RECACHE OID: .1.3.6.1.2.1.1.3.0, (assert: < output: )
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571170076224] Device[2] HT[1] NOTE: There are '2' Polling Items for this Device
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571170076224] Device[2] HT[1] Total Time: 0.23 Seconds
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571035838016] Device[2] HT[8] DQ[16] Legacy Uptime Result: U, Is Numeric: 0
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571052623424] Device[2] HT[6] DQ[16] Legacy Uptime Result: U, Is Numeric: 0
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571035838016] Device[2] HT[8] DQ[16] Extended Uptime Result: , Is Numeric: 0
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571052623424] Device[2] HT[6] DQ[16] Extended Uptime Result: , Is Numeric: 0
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571035838016] Device[2] HT[8] DQ[16] RECACHE OID: .1.3.6.1.2.1.1.3.0, (assert: < output: )
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571052623424] Device[2] HT[6] DQ[16] RECACHE OID: .1.3.6.1.2.1.1.3.0, (assert: < output: )
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571035838016] Device[2] HT[8] NOTE: There are '2' Polling Items for this Device
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571052623424] Device[2] HT[6] NOTE: There are '2' Polling Items for this Device
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571035838016] Device[2] HT[8] Total Time: 0.24 Seconds
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571052623424] Device[2] HT[6] Total Time: 0.24 Seconds
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571161683520] Device[2] HT[2] DQ[16] Legacy Uptime Result: U, Is Numeric: 0
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571027445312] Device[2] HT[9] DQ[16] Legacy Uptime Result: U, Is Numeric: 0
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571161683520] Device[2] HT[2] DQ[16] Extended Uptime Result: , Is Numeric: 0
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571027445312] Device[2] HT[9] DQ[16] Extended Uptime Result: , Is Numeric: 0
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571161683520] Device[2] HT[2] DQ[16] RECACHE OID: .1.3.6.1.2.1.1.3.0, (assert: < output: )
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571027445312] Device[2] HT[9] DQ[16] RECACHE OID: .1.3.6.1.2.1.1.3.0, (assert: < output: )
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571161683520] Device[2] HT[2] NOTE: There are '2' Polling Items for this Device
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571027445312] Device[2] HT[9] NOTE: There are '2' Polling Items for this Device
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571161683520] Device[2] HT[2] Total Time: 0.25 Seconds
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571027445312] Device[2] HT[9] Total Time: 0.25 Seconds
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571069408832] Device[2] HT[4] DQ[16] Legacy Uptime Result: U, Is Numeric: 0
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571069408832] Device[2] HT[4] DQ[16] Extended Uptime Result: , Is Numeric: 0
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571069408832] Device[2] HT[4] DQ[16] RECACHE OID: .1.3.6.1.2.1.1.3.0, (assert: < output: )
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571044230720] Device[2] HT[7] DQ[16] Legacy Uptime Result: U, Is Numeric: 0
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571044230720] Device[2] HT[7] DQ[16] Extended Uptime Result: , Is Numeric: 0
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571044230720] Device[2] HT[7] DQ[16] RECACHE OID: .1.3.6.1.2.1.1.3.0, (assert: < output: )
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571069408832] Device[2] HT[4] NOTE: There are '2' Polling Items for this Device
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571069408832] Device[2] HT[4] Total Time: 0.26 Seconds
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571044230720] Device[2] HT[7] NOTE: There are '2' Polling Items for this Device
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571044230720] Device[2] HT[7] Total Time: 0.26 Seconds
2024-03-25 16:29:55 - SPINE: Poller[1] PID[1203986] PT[132571183101760] Time: 0.6394 s, Threads: 12, Devices: 2

[macan]

You got snmp anwers for device with ID 1, it is ok.
It seems that device with ID 2 didn't respond to snmp.
So try snmpwalk for device 2 and show result.

[mrheavydee95]

See Below:

$ snmpwalk -v 2c -c ED******** 10.1xx.x.x
SNMPv2-MIB::sysDescr.0 = STRING: Meraki MX100 Cloud Managed Router
SNMPv2-MIB::sysObjectID.0 = OID: SNMPv2-SMI::enterprises.29671.2.106
SNMPv2-MIB::sysName.0 = STRING: Edmonton Firewall
SNMPv2-MIB::sysORID.1 = OID: SNMPv2-MIB::snmpMIB
SNMPv2-MIB::sysORID.2 = OID: SNMP-VIEW-BASED-ACM-MIB::vacmBasicGroup
SNMPv2-MIB::sysORID.3 = OID: IF-MIB::ifMIB
SNMPv2-MIB::sysORDescr.1 = STRING: The MIB module for SNMPv2 entities
SNMPv2-MIB::sysORDescr.2 = STRING: View-based Access Control Model for SNMP.
SNMPv2-MIB::sysORDescr.3 = STRING: The MIB module to describe generic objects for network interface sub-layers
SNMPv2-MIB::sysORUpTime.1 = Timeticks: (0) 0:00:00.00
SNMPv2-MIB::sysORUpTime.2 = Timeticks: (0) 0:00:00.00
SNMPv2-MIB::sysORUpTime.3 = Timeticks: (0) 0:00:00.00
IF-MIB::ifNumber.0 = INTEGER: 11
IF-MIB::ifIndex.1 = INTEGER: 1
IF-MIB::ifIndex.2 = INTEGER: 2
IF-MIB::ifIndex.3 = INTEGER: 3
IF-MIB::ifIndex.4 = INTEGER: 4
IF-MIB::ifIndex.5 = INTEGER: 5
IF-MIB::ifIndex.6 = INTEGER: 6
IF-MIB::ifIndex.7 = INTEGER: 7
IF-MIB::ifIndex.8 = INTEGER: 8
IF-MIB::ifIndex.9 = INTEGER: 9
IF-MIB::ifIndex.10 = INTEGER: 10
IF-MIB::ifIndex.11 = INTEGER: 11
IF-MIB::ifDescr.1 = STRING: port1
IF-MIB::ifDescr.2 = STRING: port2
IF-MIB::ifDescr.3 = STRING: port3
IF-MIB::ifDescr.4 = STRING: port4
IF-MIB::ifDescr.5 = STRING: port5
IF-MIB::ifDescr.6 = STRING: port6
IF-MIB::ifDescr.7 = STRING: port7
IF-MIB::ifDescr.8 = STRING: port8
IF-MIB::ifDescr.9 = STRING: port9
IF-MIB::ifDescr.10 = STRING: port10
IF-MIB::ifDescr.11 = STRING: port11
IF-MIB::ifType.1 = INTEGER: ethernetCsmacd(6)
IF-MIB::ifType.2 = INTEGER: ethernetCsmacd(6)
IF-MIB::ifType.3 = INTEGER: ethernetCsmacd(6)
IF-MIB::ifType.4 = INTEGER: ethernetCsmacd(6)
IF-MIB::ifType.5 = INTEGER: ethernetCsmacd(6)
IF-MIB::ifType.6 = INTEGER: ethernetCsmacd(6)
IF-MIB::ifType.7 = INTEGER: ethernetCsmacd(6)

[macan]

Try delete problematic from cacti and start again. Will you see something like this after adding host?

[mrheavydee95]

Device was deleted and added back in. See attached.
I also created "Errors/Discrards" and "64-Bit" graphs for all UP Interfaces.

I waited about 10 minutes before responding, graphs were not created.

[macan]

Go to Console -> troubleshooting -> data source -> run check on any problematic data source and show result

[mrheavydee95]

See attached.

[macan]

Any other graphs are working fine?

Which poller interval and cron/daemon interval you have in COnfiguration->Settings->Poller tab?

Try to set correct path to php in cron, your actual record. Maybe it isn't necessary:
*/1 * * * * www-data php /var/www/html/cacti/poller.php > /dev/null 2>&1
better:
*/1 * * * * www-data /correct/path/to/php /var/www/html/cacti/poller.php > /dev/null 2>&1