[solved] Graphs not showing data,

[XMConsole]

Problem: Graphs are not showing any values
Screenshot of graphs attached

Steps taken:
- Tested net-snmp per documentation, returns proper responses and service runs properly.
- tested running poller.php manually and via scheduled job, runs properly, logs below (cacti.log)
- Run cmd.php manually, appears to run, logs below


OS: Windows 2008 Server R2
Current Versions Installed:
-Cacti 0.8.8a
--Patches:
---SNMPv3 Privilege Protocol None
-Spine 0.8.8a (x86)
-Apache 2.2.22 (x86)
-MySQL 5.5.27 (x86/x64)
-PHP 5.3.17 (x86)
-Net-SNMP 5.6.1.1 (x86/x64)
-RRDTool 1.4.5 (x86)
-GetIF 2.3.1 (x86)
-- Latest Cygwin
-- Latest Activestate Perl

-------------
RRDTool Debug Output: (returns ok)
-------------

d:/rrdtool/rrdtool.exe graph - \
--imgformat=PNG \
--start=1400432308 \
--end=1400518708 \
--title="Localhost - Memory Usage" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit="0" \
COMMENT:"From 2014/05/18 09\:58\:28 To 2014/05/19 09\:58\:28\c" \
COMMENT:" \n" \
--vertical-label="kilobytes" \
--slope-mode \
--font TITLE:10: \
--font AXIS:7: \
--font LEGEND:8: \
--font UNIT:7: \
DEF:a="C\:/inetpub/wwwroot/cacti/rra/localhost_mem_buffers_3.rrd":"mem_buffers":AVERAGE \
DEF:b="C\:/inetpub/wwwroot/cacti/rra/localhost_mem_swap_4.rrd":"mem_swap":AVERAGE \
AREA:a#FF4105FF:"Free" \
GPRINTLAST:"Current\:%8.2lf %s" \
GPRINTAVERAGE:"Average\:%8.2lf %s" \
GPRINTMAX:"Maximum\:%8.2lf %s\n" \
AREA:b#FFC73BFF:"Swap":STACK \
GPRINTLAST:"Current\:%8.2lf %s" \
GPRINTAVERAGE:"Average\:%8.2lf %s" \
GPRINTMAX:"Maximum\:%8.2lf %s\n"



--------------
cacti.log
--------------
] WARNING: Result from CMD not valid. Partial Result: U
05/19/2014 09:55:03 AM - CMDPHP: Poller[0] Host[1] DS[3] CMD: perl C:/inetpub/wwwroot/cacti/scripts/linux_memory.pl MemFree:, output: U
05/19/2014 09:55:03 AM - CMDPHP: Poller[0] Host[1] DS[4] WARNING: Result from CMD not valid. Partial Result: U
05/19/2014 09:55:03 AM - CMDPHP: Poller[0] Host[1] DS[4] CMD: perl C:/inetpub/wwwroot/cacti/scripts/linux_memory.pl SwapFree:, output: U
05/19/2014 09:55:03 AM - CMDPHP: Poller[0] Host[1] DS[5] WARNING: Result from CMD not valid. Partial Result: U
05/19/2014 09:55:03 AM - CMDPHP: Poller[0] Host[1] DS[5] CMD: perl C:/inetpub/wwwroot/cacti/scripts/loadavg_multi.pl, output: U
05/19/2014 09:55:03 AM - CMDPHP: Poller[0] Host[1] DS[6] WARNING: Result from CMD not valid. Partial Result: U
05/19/2014 09:55:03 AM - CMDPHP: Poller[0] Host[1] DS[6] CMD: perl C:/inetpub/wwwroot/cacti/scripts/unix_users.pl , output: U
05/19/2014 09:55:03 AM - CMDPHP: Poller[0] Host[1] DS[7] WARNING: Result from CMD not valid. Partial Result: U
05/19/2014 09:55:03 AM - CMDPHP: Poller[0] Host[1] DS[7] CMD: perl C:/inetpub/wwwroot/cacti/scripts/unix_processes.pl, output: U
05/19/2014 09:55:03 AM - CMDPHP: Poller[0] Host[1] DS[8] WARNING: Result from CMD not valid. Partial Result: U
05/19/2014 09:55:03 AM - CMDPHP: Poller[0] Host[1] DS[8] CMD: perl C:/inetpub/wwwroot/cacti/scripts/ping.pl 127.0.0.1, output: U
05/19/2014 09:55:03 AM - CMDPHP: Poller[0] Host[3] SNMP: Host responded to SNMP
05/19/2014 09:55:03 AM - CMDPHP: Poller[0] Host[3] DS[12] WARNING: Result from CMD not valid. Partial Result: U
05/19/2014 09:55:03 AM - CMDPHP: Poller[0] Host[3] DS[12] CMD: perl C:/inetpub/wwwroot/cacti/scripts/loadavg_multi.pl, output: U
05/19/2014 09:55:03 AM - CMDPHP: Poller[0] Host[3] DS[11] WARNING: Result from CMD not valid. Partial Result: U
05/19/2014 09:55:03 AM - CMDPHP: Poller[0] Host[3] DS[11] CMD: perl C:/inetpub/wwwroot/cacti/scripts/loadavg_multi.pl, output: U
05/19/2014 09:55:03 AM - CMDPHP: Poller[0] Host[3] DS[13] WARNING: Result from CMD not valid. Partial Result: U
05/19/2014 09:55:03 AM - CMDPHP: Poller[0] Host[3] DS[13] CMD: perl C:/inetpub/wwwroot/cacti/scripts/ping.pl 192.168.224.168, output: U
05/19/2014 09:55:03 AM - CMDPHP: Poller[0] Time: 0.3039 s, Theads: N/A, Hosts: 2
05/19/2014 09:55:03 AM - POLLER: Poller[0] CACTI2RRD: d:/rrdtool/rrdtool.exe update C:\inetpub\wwwroot\cacti\rra\localhost_users_6.rrd --template users 1400507703:U
05/19/2014 09:55:03 AM - POLLER: Poller[0] CACTI2RRD: d:/rrdtool/rrdtool.exe update C:\inetpub\wwwroot\cacti\rra\localhost_load_1min_5.rrd --template 1400507703:U
05/19/2014 09:55:03 AM - POLLER: Poller[0] CACTI2RRD: d:/rrdtool/rrdtool.exe update C:\inetpub\wwwroot\cacti\rra\localhost_mem_buffers_3.rrd --template mem_buffers 1400507703:U
05/19/2014 09:55:03 AM - POLLER: Poller[0] CACTI2RRD: d:/rrdtool/rrdtool.exe update C:\inetpub\wwwroot\cacti\rra\localhost_mem_swap_4.rrd --template mem_swap 1400507703:U
05/19/2014 09:55:03 AM - POLLER: Poller[0] CACTI2RRD: d:/rrdtool/rrdtool.exe update C:\inetpub\wwwroot\cacti\rra\localhost_ping_8.rrd --template ping 1400507703:U
05/19/2014 09:55:03 AM - POLLER: Poller[0] CACTI2RRD: d:/rrdtool/rrdtool.exe update C:\inetpub\wwwroot\cacti\rra\localhost_proc_7.rrd --template proc 1400507703:U
05/19/2014 09:55:03 AM - POLLER: Poller[0] CACTI2RRD: d:/rrdtool/rrdtool.exe update C:\inetpub\wwwroot\cacti\rra\websense_ping_13.rrd --template ping 1400507703:U
05/19/2014 09:55:03 AM - POLLER: Poller[0] CACTI2RRD: d:/rrdtool/rrdtool.exe update C:\inetpub\wwwroot\cacti\rra\websense_load_1min_11.rrd --template 1400507703:U
05/19/2014 09:55:03 AM - POLLER: Poller[0] CACTI2RRD: d:/rrdtool/rrdtool.exe update C:\inetpub\wwwroot\cacti\rra\websense_load_1min_12.rrd --template 1400507703:U
05/19/2014 09:55:03 AM - SYSTEM STATS: Time:2.1571 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:9 RRDsProcessed:9

[cigamit]

Your best bet may to be to execute this command and see what it tells you

Code: Select all

perl C:/inetpub/wwwroot/cacti/scripts/loadavg_multi.pl

I don't run Cacti on Windows but it seems odd that you would run a lot of scripts generally made for Unix systems on Windows.

[XMConsole]

Well that may be an aside as the data is being gathered and hopefully graphed from the Websense Appliance which is a Linux server or all intents and purposes.

The main issue is simply that the data is collected, the files are generated, but the graphs are not being created/updated.

I rebooted the server and was able to see graph data finally, however now adding in new graphs they remain blank so something is still broken.

[BSOD2600]

Same perl scripts or different ones? Consult the output in the cacti.log to determine where the issue resides.

[XMConsole]

The cacti.log is not very helpful...

Basically when I review the export for each graph I get NaN in every single column. I have no idea whats broken at this point. Here is one example, it seems to be logging times in PST whereas the office this runs in is EST, which is a whole other issue.

5/20/2014 7:05 NaN
5/20/2014 7:10 NaN
5/20/2014 7:15 NaN
5/20/2014 7:20 NaN
5/20/2014 7:25 1.00E+00
5/20/2014 7:30 1.00E+00
5/20/2014 7:35 NaN
5/20/2014 7:40 NaN
5/20/2014 7:45 NaN
5/20/2014 7:50 NaN
5/20/2014 7:55 NaN
5/20/2014 8:00 NaN
5/20/2014 8:05 NaN


----------
Cacti Log
----------

014 10:20:20 AM - CMDPHP: Poller[0] Host[3] DS[27] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:20:20 AM - CMDPHP: Poller[0] Host[3] DS[26] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:20:21 AM - CMDPHP: Poller[0] Host[3] DS[12] WARNING: Result from CMD not valid. Partial Result: 1min: 5min: 10
05/20/2014 10:20:21 AM - CMDPHP: Poller[0] Host[3] DS[11] WARNING: Result from CMD not valid. Partial Result: 1min: 5min: 10
05/20/2014 10:20:22 AM - CMDPHP: Poller[0] Host[3] DS[13] WARNING: Result from CMD not valid. Partial Result: U
05/20/2014 10:20:22 AM - CMDPHP: Poller[0] Host[3] DS[14] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:20:22 AM - CMDPHP: Poller[0] Host[3] DS[15] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:20:22 AM - CMDPHP: Poller[0] Host[3] DS[16] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:20:22 AM - CMDPHP: Poller[0] Host[3] DS[17] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:20:22 AM - CMDPHP: Poller[0] Host[3] DS[18] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:20:22 AM - CMDPHP: Poller[0] Host[3] DS[19] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:20:22 AM - CMDPHP: Poller[0] Host[3] DS[20] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:20:22 AM - CMDPHP: Poller[0] Host[3] DS[21] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:20:22 AM - CMDPHP: Poller[0] Host[3] DS[22] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:20:22 AM - CMDPHP: Poller[0] Host[3] DS[23] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:20:22 AM - CMDPHP: Poller[0] Host[3] DS[24] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:20:22 AM - CMDPHP: Poller[0] Host[3] DS[25] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:20:24 AM - CMDPHP: Poller[0] Host[4] DS[41] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:20:24 AM - CMDPHP: Poller[0] Host[4] DS[42] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:20:24 AM - CMDPHP: Poller[0] Host[4] DS[43] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:20:24 AM - CMDPHP: Poller[0] Host[4] DS[44] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:20:24 AM - CMDPHP: Poller[0] Host[4] DS[45] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:20:24 AM - CMDPHP: Poller[0] Host[4] DS[46] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:20:24 AM - CMDPHP: Poller[0] Host[4] DS[47] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:20:24 AM - CMDPHP: Poller[0] Host[4] DS[48] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:20:24 AM - CMDPHP: Poller[0] Host[4] DS[49] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:20:24 AM - CMDPHP: Poller[0] Host[4] DS[50] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:20:24 AM - CMDPHP: Poller[0] Host[4] DS[51] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:20:24 AM - CMDPHP: Poller[0] Host[4] DS[52] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:20:24 AM - CMDPHP: Poller[0] Host[5] DS[57] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:20:24 AM - CMDPHP: Poller[0] Host[5] DS[56] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:20:24 AM - CMDPHP: Poller[0] Host[5] DS[58] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:20:24 AM - CMDPHP: Poller[0] Host[5] DS[59] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:20:24 AM - CMDPHP: Poller[0] Host[5] DS[60] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:20:24 AM - CMDPHP: Poller[0] Host[5] DS[61] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:20:24 AM - CMDPHP: Poller[0] Host[5] DS[62] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:20:24 AM - CMDPHP: Poller[0] Host[5] DS[63] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:20:24 AM - CMDPHP: Poller[0] Host[5] DS[64] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:20:24 AM - CMDPHP: Poller[0] Host[5] DS[65] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:20:24 AM - CMDPHP: Poller[0] Host[5] DS[66] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:20:24 AM - CMDPHP: Poller[0] Host[5] DS[67] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:20:24 AM - SYSTEM STATS: Time:8.5789 Method:cmd.php Processes:1 Threads:N/A Hosts:4 HostsPerProcess:4 DataSources:64 RRDsProcessed:56
05/20/2014 10:22:12 AM - AUTH LOGIN: User 'admin' Authenticated
05/20/2014 10:25:06 AM - CMDPHP: Poller[0] Host[3] DS[27] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:25:06 AM - CMDPHP: Poller[0] Host[3] DS[26] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:25:06 AM - CMDPHP: Poller[0] Host[3] DS[12] WARNING: Result from CMD not valid. Partial Result: 1min: 5min: 10
05/20/2014 10:25:06 AM - CMDPHP: Poller[0] Host[3] DS[11] WARNING: Result from CMD not valid. Partial Result: 1min: 5min: 10
05/20/2014 10:25:07 AM - CMDPHP: Poller[0] Host[3] DS[13] WARNING: Result from CMD not valid. Partial Result: U
05/20/2014 10:25:07 AM - CMDPHP: Poller[0] Host[3] DS[14] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:25:07 AM - CMDPHP: Poller[0] Host[3] DS[15] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:25:07 AM - CMDPHP: Poller[0] Host[3] DS[16] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:25:07 AM - CMDPHP: Poller[0] Host[3] DS[17] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:25:07 AM - CMDPHP: Poller[0] Host[3] DS[18] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:25:07 AM - CMDPHP: Poller[0] Host[3] DS[19] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:25:07 AM - CMDPHP: Poller[0] Host[3] DS[20] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:25:07 AM - CMDPHP: Poller[0] Host[3] DS[21] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:25:07 AM - CMDPHP: Poller[0] Host[3] DS[22] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:25:07 AM - CMDPHP: Poller[0] Host[3] DS[23] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:25:07 AM - CMDPHP: Poller[0] Host[3] DS[24] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:25:07 AM - CMDPHP: Poller[0] Host[3] DS[25] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:25:08 AM - CMDPHP: Poller[0] Host[4] DS[41] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:25:08 AM - CMDPHP: Poller[0] Host[4] DS[42] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:25:08 AM - CMDPHP: Poller[0] Host[4] DS[43] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:25:08 AM - CMDPHP: Poller[0] Host[4] DS[44] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:25:08 AM - CMDPHP: Poller[0] Host[4] DS[45] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:25:08 AM - CMDPHP: Poller[0] Host[4] DS[46] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:25:08 AM - CMDPHP: Poller[0] Host[4] DS[47] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:25:08 AM - CMDPHP: Poller[0] Host[4] DS[48] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:25:08 AM - CMDPHP: Poller[0] Host[4] DS[49] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:25:08 AM - CMDPHP: Poller[0] Host[4] DS[50] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:25:08 AM - CMDPHP: Poller[0] Host[4] DS[51] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:25:08 AM - CMDPHP: Poller[0] Host[4] DS[52] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:25:08 AM - CMDPHP: Poller[0] Host[5] DS[57] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:25:08 AM - CMDPHP: Poller[0] Host[5] DS[56] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:25:08 AM - CMDPHP: Poller[0] Host[5] DS[58] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:25:08 AM - CMDPHP: Poller[0] Host[5] DS[59] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:25:08 AM - CMDPHP: Poller[0] Host[5] DS[60] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:25:08 AM - CMDPHP: Poller[0] Host[5] DS[61] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:25:08 AM - CMDPHP: Poller[0] Host[5] DS[62] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:25:08 AM - CMDPHP: Poller[0] Host[5] DS[63] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:25:08 AM - CMDPHP: Poller[0] Host[5] DS[64] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:25:08 AM - CMDPHP: Poller[0] Host[5] DS[65] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:25:08 AM - CMDPHP: Poller[0] Host[5] DS[66] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:25:08 AM - CMDPHP: Poller[0] Host[5] DS[67] WARNING: Result from SNMP not valid. Partial Result: U
05/20/2014 10:25:08 AM - SYSTEM STATS: Time:6.0514 Method:cmd.php Processes:1 Threads:N/A Hosts:4 HostsPerProcess:4 DataSources:64 RRDsProcessed:56

[BSOD2600]

Per the debugging guide, you need to change the logging level to high or debug to see the details on why these are failing.

[XMConsole]

I switched over to using Spine and recreated my data sources. All is well now.

[tiniturtle]

Hi XMConsole,
You can send guide for me, please ?

[LucasGrzybowski]

Hi XMConsole,
You can send guide for me, please ?

Ma friend go to Cacti Console > Configuration : Settings
Click on Poller and Select in poller Type if will works with cmd.php or Spine.


Good lucky!!!

[mrpaytowin69]

I switched over to using Spine and recreated my data sources. All is well now.

I have the same problem as you but what did you do to recreate you're data source ? Thanks