Help with RRD weirdness please

[stevecox]

So I am trying to graph 3 values from a host, using a Perl script. Here is the output of said script, running as the cacti user:

Code: Select all

[cacti@grvcacti rra]$ perl /var/www/html/cacti/resource/script_queries/AlphaDC.pl 10.34.218.144 161 public 2
sysVolts:54596, sysAmps:143590, psTemp:14932

My Graph template is set to divide by 1000 to make the numbers right, so no worries there. The script executes instantly.

Setting the Log to Debug I can run cmd.php and see the following:

Code: Select all

02/22/2017 11:32:19 AM - CMDPHP: Poller[0] Host[27] DS[94] CMD: perl /var/www/html/cacti/resource/script_queries/AlphaDC.pl 10.34.218.144 161 public 2, output: sysVolts:54610, sysAmps:143830, psTemp:14964
02/22/2017 11:32:19 AM - CMDPHP: Poller[0] Host[27] SNMP: Host responded to SNMP
02/22/2017 11:32:19 AM - CMDPHP: Poller[0] Host[27] PING: ICMP Ping Success (23.880 ms) 

Looking at the RRD file, you will see that psTemp is working fine, and is being graphed. But, all I get from the other two data points is "U", which works out to a NaN.

rrd_version = "0003"
step = 300
last_update = 1487781011
header_size = 6728
ds[sysVolts].index = 0
ds[sysVolts].type = "GAUGE"
ds[sysVolts].minimal_heartbeat = 600
ds[sysVolts].min = NaN
ds[sysVolts].max = NaN
ds[sysVolts].last_ds = "U"
ds[sysVolts].value = NaN
ds[sysVolts].unknown_sec = 11
ds[sysAmps].index = 1
ds[sysAmps].type = "GAUGE"
ds[sysAmps].minimal_heartbeat = 600
ds[sysAmps].min = NaN
ds[sysAmps].max = NaN
ds[sysAmps].last_ds = "U"
ds[sysAmps].value = NaN
ds[sysAmps].unknown_sec = 11
ds[psTemp].index = 2
ds[psTemp].type = "GAUGE"
ds[psTemp].minimal_heartbeat = 600
ds[psTemp].min = 0.0000000000e+00
ds[psTemp].max = NaN
ds[psTemp].last_ds = "14946"
ds[psTemp].value = 1.6440600000e+05
ds[psTemp].unknown_sec = 0


Here is the result of a LAST command on the rrd file:

Code: Select all

1487780400: -nan -nan 1.4964440000e+04
1487780700: -nan -nan 1.4978486667e+04
1487781000: -nan -nan 1.4947210000e+04
1487781300: -nan -nan 1.4983570000e+04

I have tried setting the Data Template to "0" Min and Max, to "U" Min and Max, and even "999999" Max, with no different results.

Can anyone give me a clue as to what is wrong here?

Every time I change any of the settings in the Data Template I have been deleting the RRD file and letting it be re-created from scratch.



Running Cacti 0.8.8h with PHP 2.4.0, MySQL 5.5.52-MariaDB, on Centos 7.

Using cmd.php because if I run Spine I get the following error:

Code: Select all

SPINE: Version 1.0.3 starting
2017-02-22 11:40:18 - SPINE: Poller[1] WARNING: PollerID > 0, but 'host' table does NOT contain the poller_id column!!
2017-02-22 11:40:18 - SPINE: Poller[1] FATAL: MySQL Error:'1054', Message:'Unknown column 'snmp_engine_id' in 'field list'' [0, Success] (Spine thread)

But the Spine thing is another issue entirely.

[cigamit]

First, remove the comma between your outputs.

As for Spine, you are using Spine 1.0.3 with Cacti 0.8.8h. That is bound to break anything and everything. Spine 1.X should only be compatible with Cacti 1.X

[stevecox]

First, remove the comma between your outputs.

As for Spine, you are using Spine 1.0.3 with Cacti 0.8.8h. That is bound to break anything and everything. Spine 1.X should only be compatible with Cacti 1.X

I have no idea how those commas crept in, but they were the problem. THANK YOU!

As for Spine, I compiled that when I was trying to get Cacti 1.0.2 to work, but finally I gave up and went back to 0.8.8h. I don't have the source for the older Spine, and wasn't able to find it easily.

Much appreciated!

[cigamit]

I don't have the source for the older Spine, and wasn't able to find it easily.

Its not the easiest to find. You should be able to get it here
http://www.cacti.net/downloads/spine/

[stevecox]

I don't have the source for the older Spine, and wasn't able to find it easily.

Its not the easiest to find. You should be able to get it here
http://www.cacti.net/downloads/spine/

I got it there, and it works great!

Thank you very much for your help.