No graphs after upgrade to 0.8.8b

[bagheera]

Hi to all, i need help resolving critical issues after upgrade cacti to version 0.8.8b.
I don't remember previous version, it was probably installed from debian repository, because directory structure was slightly different.
Web interface is working, but no data is being graphed since then. Machine was rebooted.

I have checked first obvious location for logs:

Code: Select all

root@SLX-LU-LINUX:~# tail /var/log/cacti/cacti.log
04/18/2014 04:35:20 PM - CMDPHP: Poller[0] Host[30] DS[191] WARNING: Result from SNMP not valid.  Partial Result: U
04/18/2014 04:35:22 PM - CMDPHP: Poller[0] WARNING: SNMP Get Timeout for Host:'192.168.4.244', and OID:'.1.3.6.1.4.1.12356.1.10.0'
04/18/2014 04:35:22 PM - CMDPHP: Poller[0] Host[30] DS[190] WARNING: Result from SNMP not valid.  Partial Result: U
04/18/2014 04:35:24 PM - CMDPHP: Poller[0] WARNING: SNMP Get Timeout for Host:'192.168.4.244', and OID:'.1.3.6.1.4.1.12356.101.4.1.4.0'
04/18/2014 04:35:24 PM - CMDPHP: Poller[0] Host[30] DS[189] WARNING: Result from SNMP not valid.  Partial Result: U
04/18/2014 04:35:26 PM - CMDPHP: Poller[0] WARNING: SNMP Get Timeout for Host:'192.168.4.244', and OID:'.1.3.6.1.4.1.12356.101.9.2.1.1.2.1'
04/18/2014 04:35:26 PM - CMDPHP: Poller[0] Host[30] DS[188] WARNING: Result from SNMP not valid.  Partial Result: U
04/18/2014 04:35:28 PM - CMDPHP: Poller[0] WARNING: SNMP Get Timeout for Host:'192.168.4.244', and OID:'.1.3.6.1.4.1.12356.101.4.1.3.0'
04/18/2014 04:35:28 PM - CMDPHP: Poller[0] Host[30] DS[187] WARNING: Result from SNMP not valid.  Partial Result: U
04/18/2014 04:35:28 PM - SYSTEM STATS: Time:27.8101 Method:cmd.php Processes:1 Threads:N/A Hosts:31 HostsPerProcess:31 DataSources:166 RRDsProcessed:106
root@SLX-LU-LINUX:~# tail /var/log/cacti/poller-error.log

I don't know, what should i check now in order to resolve the issue, and that's where Your help is needed.
I will provide any significant information, if needed.

Thanks in advance.

[thuck]

What is the output if you run a snmpwalk on the ip 192.168.4.244 using the oid .1.3.6.1.4.1.12356?
Something like:
snmpwalk -v2c -cpublic 192.168.4.244:161 .1.3.6.1.4.1.12356

[bagheera]

Thank You for the response. Actually we can ignore host 192.168.4.244, it's not configured properly.

Let's check host, witch is configured. An APC UPS.

Code: Select all

root@SLX-LU-LINUX:~# snmpwalk -v1 -c public 192.168.1.228
iso.3.6.1.2.1.1.1.0 = STRING: "APC Web/SNMP Management Card (MB:v3.6.8 PF:v2.6.4 PN:apc_hw02_aos_264.bin AF1:v2.6.1 AN1:apc_hw02_sumx_261.bin MN:AP9619 HR:A10) (Embedded PowerNet SNMP Agent SW v2.2 compatible)"
iso.3.6.1.2.1.1.2.0 = OID: iso.3.6.1.4.1.318.1.3.2.15
iso.3.6.1.2.1.1.3.0 = Timeticks: (1351955240) 156 days, 11:25:52.40
iso.3.6.1.2.1.1.4.0 = STRING: "Unknown"
iso.3.6.1.2.1.1.5.0 = STRING: "test"
iso.3.6.1.2.1.1.6.0 = STRING: "test"
iso.3.6.1.2.1.1.7.0 = INTEGER: 72
iso.3.6.1.2.1.2.1.0 = INTEGER: 1
iso.3.6.1.2.1.2.2.1.1.1 = INTEGER: 1
...

So it is not the data pooling problem. What can i check now? None of the valid host is now being graphed, after the unfortunate upgrade.

[bagheera]

Hi again,
Following debugging guide, i managed to find out, that rrd files are not being updated.

Code: Select all

RRDTool Command:
/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title='UPS ENERGETYKOW - Voltage' \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit='0' \
--vertical-label='VAC' \
--slope-mode \
--font TITLE:10: \
--font AXIS:7: \
--font LEGEND:8: \
--font UNIT:7: \
DEF:a='/usr/share/cacti/rra/ups_energetykow_apc_line_voltage_170.rrd':'APC_line_voltage':AVERAGE \
DEF:b='/usr/share/cacti/rra/ups_energetykow_apc_output_voltage_171.rrd':'APC_output_voltage':AVERAGE \
AREA:a#00004DFF:'Input Line voltage'  \
GPRINT:a:LAST:'Current\:%8.2lf %s'  \
GPRINT:a:MIN:'Min\:%8.2lf %s'  \
GPRINT:a:MAX:'Max\:%8.2lf %s\n'  \
LINE3:b#FF5700FF:'APC Output voltage'  \
GPRINT:b:LAST:'Current\:%8.2lf %s'  \
GPRINT:b:MIN:'Min\:%8.2lf %s'  \
GPRINT:b:MAX:'Max\:%8.2lf %s\n' 
RRDTool Says:
OK

Code: Select all

root@SLX-LU-LINUX:~# ls -l /usr/share/cacti/rra/ups_energetykow_apc_line_voltage_170.rrd
-rw-r--r-- 1 www-data www-data 56228 03-17 12:40 /usr/share/cacti/rra/ups_energetykow_apc_line_voltage_170.rrd

I don't know, if it's relevant, but files are owned by www-data user, it's user that apache2 processes is running at.

Code: Select all

root@SLX-LU-LINUX:~# rrdtool fetch /usr/share/cacti/rra/ups_energetykow_apc_line_voltage_170.rrd AVERAGE | tail -n 30
1398335700: -nan
1398336000: -nan
1398336300: -nan
1398336600: -nan
1398336900: -nan
1398337200: -nan
1398337500: -nan
1398337800: -nan
1398338100: -nan
1398338400: -nan
1398338700: -nan
1398339000: -nan
1398339300: -nan
1398339600: -nan
1398339900: -nan
1398340200: -nan
1398340500: -nan
1398340800: -nan
1398341100: -nan
1398341400: -nan
1398341700: -nan
1398342000: -nan
1398342300: -nan
1398342600: -nan
1398342900: -nan
1398343200: -nan
1398343500: -nan
1398343800: -nan
1398344100: -nan
1398344400: -nan

Code: Select all

root@SLX-LU-LINUX:~# rrdtool info /usr/share/cacti/rra/ups_energetykow_apc_line_voltage_170.rrd
filename = "/usr/share/cacti/rra/ups_energetykow_apc_line_voltage_170.rrd"
rrd_version = "0003"
step = 300
last_update = 1395056404
header_size = 2276
ds[APC_line_voltage].index = 0
ds[APC_line_voltage].type = "GAUGE"
ds[APC_line_voltage].minimal_heartbeat = 600
ds[APC_line_voltage].min = 0,0000000000e+00
ds[APC_line_voltage].max = 2,8000000000e+02
ds[APC_line_voltage].last_ds = "231"
ds[APC_line_voltage].value = 9,2400000000e+02
ds[APC_line_voltage].unknown_sec = 0
rra[0].cf = "AVERAGE"
rra[0].rows = 500
rra[0].cur_row = 73
rra[0].pdp_per_row = 1
rra[0].xff = 5,0000000000e-01
rra[0].cdp_prep[0].value = NaN
rra[0].cdp_prep[0].unknown_datapoints = 0
rra[1].cf = "AVERAGE"
rra[1].rows = 600
rra[1].cur_row = 533
rra[1].pdp_per_row = 1
rra[1].xff = 5,0000000000e-01
rra[1].cdp_prep[0].value = NaN
rra[1].cdp_prep[0].unknown_datapoints = 0
rra[2].cf = "AVERAGE"
rra[2].rows = 700
rra[2].cur_row = 381
rra[2].pdp_per_row = 6
rra[2].xff = 5,0000000000e-01
rra[2].cdp_prep[0].value = 4,6098333333e+02
rra[2].cdp_prep[0].unknown_datapoints = 0
rra[3].cf = "AVERAGE"
rra[3].rows = 775
rra[3].cur_row = 180
rra[3].pdp_per_row = 24
rra[3].xff = 5,0000000000e-01
rra[3].cdp_prep[0].value = 4,5859366667e+03
rra[3].cdp_prep[0].unknown_datapoints = 0
rra[4].cf = "AVERAGE"
rra[4].rows = 797
rra[4].cur_row = 131
rra[4].pdp_per_row = 288
rra[4].xff = 5,0000000000e-01
rra[4].cdp_prep[0].value = 3,2692060000e+04
rra[4].cdp_prep[0].unknown_datapoints = 0
rra[5].cf = "MAX"
rra[5].rows = 500
rra[5].cur_row = 458
rra[5].pdp_per_row = 1
rra[5].xff = 5,0000000000e-01
rra[5].cdp_prep[0].value = NaN
rra[5].cdp_prep[0].unknown_datapoints = 0
rra[6].cf = "MAX"
rra[6].rows = 600
rra[6].cur_row = 543
rra[6].pdp_per_row = 1
rra[6].xff = 5,0000000000e-01
rra[6].cdp_prep[0].value = NaN
rra[6].cdp_prep[0].unknown_datapoints = 0
rra[7].cf = "MAX"
rra[7].rows = 700
rra[7].cur_row = 418
rra[7].pdp_per_row = 6
rra[7].xff = 5,0000000000e-01
rra[7].cdp_prep[0].value = 2,3098333333e+02
rra[7].cdp_prep[0].unknown_datapoints = 0
rra[8].cf = "MAX"
rra[8].rows = 775
rra[8].cur_row = 770
rra[8].pdp_per_row = 24
rra[8].xff = 5,0000000000e-01
rra[8].cdp_prep[0].value = 2,3098333333e+02
rra[8].cdp_prep[0].unknown_datapoints = 0
rra[9].cf = "MAX"
rra[9].rows = 797
rra[9].cur_row = 103
rra[9].pdp_per_row = 288
rra[9].xff = 5,0000000000e-01
rra[9].cdp_prep[0].value = 2,3900000000e+02
rra[9].cdp_prep[0].unknown_datapoints = 0

Database is accessible. What can i check now?

Executing poller.php as www-data user gives to output.
Is that correct?

Code: Select all

$ php /usr/share/cacti/site/poller.php

Any ideas, what to do now? I don't want to reinstall cacti to solve that...

[bagheera]

BUMP!
Could You please take a look at my issue? It's quite important and i'm unable to resolve it by myself and i need help finding the cause and solution.
Tanks in advance.

[dvc]

BUMP!
Could You please take a look at my issue? It's quite important and i'm unable to resolve it by myself and i need help finding the cause and solution.
Tanks in advance.

This is probably too late but the files need to be writable by whatever account is running the poller. Apache doesn't write to the rrd files, the poller does, separate process.

[fansari]

I have the same issue. Sometimes it works after the installation and sometimes not. No idea what this is. Also I don't understand why I see useful data with "rrdtool info" but get only nan values with "rrdtool fetch ... AVERAGE".

See here:

https://github.com/oetiker/rrdtool-1.x/issues/503