please help, there is no data in my graph

[kaisimok]

hello, i have recently installed a windows cacti on a win2008, package was downloaded via the forum.

now i can see the graph but there is no data, please masters help me!

there are some logs in attached.


thanks in advance.

[netniV]

You have numerous issues going on here. Firstly, your settings for MySQL are below the recommendations on a lot of the lines. Secondly, you are having issues querying for data (hence most of the orange lines), thirdly, you are hitting the ASSERT RECACHE issue that is a known issue in the 1.1.x branch and has been fixed in the 1.2 development branch (that is currently in beta).

[kaisimok]

You have numerous issues going on here. Firstly, your settings for MySQL are below the recommendations on a lot of the lines. Secondly, you are having issues querying for data (hence most of the orange lines), thirdly, you are hitting the ASSERT RECACHE issue that is a known issue in the 1.1.x branch and has been fixed in the 1.2 development branch (that is currently in beta).

thank you so much for pointing them out, sadly i'm not familiar with SQL, how can i fix that.......

[kaisimok]

and how can i solve the 2nd issue please?

[netniV]

Either put the device in question into debug mode, or raise you entire logging level to HIGH (the former is recommended since it only affects that specific device so reduces log spam).

[kaisimok]

Either put the device in question into debug mode, or raise you entire logging level to HIGH (the former is recommended since it only affects that specific device so reduces log spam).

thank you very much, i've turned on the high logging, since it is only a startup cacti, only 2 devices there, and only "local win machine" is active.



Log [Total Lines: 6228 - Admin View - No Other Filter in Affect]
2018/11/15 10:35:12 - RECACHE STATS: Poller: RecacheTime:8.1202 DevicesRecached:1
AND enabled='on' - found: 0
WHERE snmp_query_id=7
FROM automation_graph_rules AS agr
agr.snmp_query_id, agr.graph_type_id
2018/11/15 10:35:12 - AUTOM8 TRACE automation_execute_data_query Device[1] Device[Local Windows Machine] - sql: SELECT agr.id, agr.name,
2018/11/15 10:35:12 - AUTOM8 TRACE automation_execute_data_query Device[1] Device[Local Windows Machine] - start - data query: 7
AND enabled='on' - found: 0
WHERE snmp_query_id=6
FROM automation_graph_rules AS agr
agr.snmp_query_id, agr.graph_type_id
2018/11/15 10:35:09 - AUTOM8 TRACE automation_execute_data_query Device[1] Device[Local Windows Machine] - sql: SELECT agr.id, agr.name,
2018/11/15 10:35:09 - AUTOM8 TRACE automation_execute_data_query Device[1] Device[Local Windows Machine] - start - data query: 6
AND enabled='on' - found: 0
WHERE snmp_query_id=3
FROM automation_graph_rules AS agr
agr.snmp_query_id, agr.graph_type_id
2018/11/15 10:35:04 - AUTOM8 TRACE automation_execute_data_query Device[1] Device[Local Windows Machine] - sql: SELECT agr.id, agr.name,
2018/11/15 10:35:04 - AUTOM8 TRACE automation_execute_data_query Device[1] Device[Local Windows Machine] - start - data query: 3
2018/11/15 10:35:03 - PCOMMAND Device[1] Device[Local Windows Machine] WARNING: Recache Event Detected for Device
2018/11/15 10:35:03 - SYSTEM STATS: Time:2.8535 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:29 RRDsProcessed:17
2018/11/15 10:35:03 - POLLER: Poller[Main Poller] Time: 1.0606 s, Poller: , Theads: N/A, Devices: 1
2018/11/15 10:35:03 - PING Device[2] Device[172.12.199.41] SNMP: Device did not respond to SNMP
2018/11/15 10:35:03 - CMDPHP WARNING: SNMP Error:'Timeout (500 ms)', Device:'172.12.199.41', OID:'.1.3.6.1.2.1.1.3.0'
2018/11/15 10:35:02 - POLLER: Poller[Main Poller] Time: 1.3291 s, Poller: , Theads: N/A, Devices: 1
2018/11/15 10:35:02 - POLLER: Poller[Main Poller] WARNING: Invalid Response(s), Errors[11] Device[1] Device[Local Windows Machine] Thread[1] Graphs[Local Windows Machine - CPU Utilization, Local Windows Machine - CPU Utilization] Graphs[Local Windows Machine - CPU Utilization, Local Windows Machine - CPU Utilization] Graphs[Local Windows Machine - CPU Utilization, Local Windows Machine - CPU Utilization] Graphs[Local Windows Machine - CPU Utilization, Local Windows Machine - CPU Utilization] Graphs[Local Windows Machine - CPU Utilization, Local Windows Machine - CPU Utilization] Graphs[Local Windows Machine - CPU Utilization, Local Windows Machine - CPU Utilization] Graphs[Local Windows Machine - Traffic - ethernet_5, Local Windows Machine - Traffic - ethernet_5] Graphs[Local Windows Machine - Memory Usage, Local Windows Machine - Memory Usage] Graphs[Local Windows Machine - Memory Usage, Local Windows Machine - Memory Usage] Graphs[Local Windows Machine - Memory Usage, Local Windows Machine - Memory Usage] Graphs[Local Windows Machine - Memory Usage, Local Windows Machine - Memory Usage] DS[Local Windows Machine - CPU - Idle, Local Windows Machine - CPU - System, Local Windows Machine - CPU - User, Local Windows Machine - CPU - Idle, Local Windows Machine - CPU - System, Local Windows Machine - CPU - User, Local Windows Machine - Traffic - 172.30.0.2 - ethernet_5, Local Windows Machine - Memory - Buffers, Local Windows Machine - Memory - Cache, Local Windows Machine - Memory - Free, Local Windows Machine - Memory - Total]
2018/11/15 10:35:02 - POLLER: Poller[Main Poller] Device[1] Device[Local Windows Machine] Graphs[Local Windows Machine - Traffic - 172.30.0.2 (Tencent VirtIO Ethernet Adapter.), Local Windows Machine - Traffic - 172.30.0.2 (Tencent VirtIO Ethernet Adapter.)] DS[Local Windows Machine - Traffic - 172.30.0.2 - ethernet_5] SNMP: v2: 127.30.0.2, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.13, output: 127463593
2018/11/15 10:35:02 - POLLER: Poller[Main Poller] Device[1] Device[Local Windows Machine] Graphs[Local Windows Machine - Traffic - 172.30.0.2 (Tencent VirtIO Ethernet Adapter.), Local Windows Machine - Traffic - 172.30.0.2 (Tencent VirtIO Ethernet Adapter.)] DS[Local Windows Machine - Traffic - 172.30.0.2 - ethernet_5] SNMP: v2: 127.30.0.2, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.13, output: 100413643
2018/11/15 10:35:02 - POLLER: Poller[Main Poller] Device[1] Device[Local Windows Machine] Graphs[Local Windows Machine - Memory Usage, Local Windows Machine - Memory Usage] DS[Local Windows Machine - Memory - Total] SNMP: v2: 127.30.0.2, dsname: mem_total, oid: .1.3.6.1.4.1.2021.4.5.0, output: U
2018/11/15 10:35:02 - POLLER: Poller[Main Poller] Device[1] Device[Local Windows Machine] Graphs[Local Windows Machine - Memory Usage, Local Windows Machine - Memory Usage] DS[Local Windows Machine - Memory - Total] WARNING: Result from SNMP not valid. Partial Result: U
2018/11/15 10:35:02 - POLLER: Poller[Main Poller] Device[1] Device[Local Windows Machine] Graphs[Local Windows Machine - Memory Usage, Local Windows Machine - Memory Usage] DS[Local Windows Machine - Memory - Free] SNMP: v2: 127.30.0.2, dsname: mem_free, oid: .1.3.6.1.4.1.2021.4.6.0, output: U
2018/11/15 10:35:02 - POLLER: Poller[Main Poller] Device[1] Device[Local Windows Machine] Graphs[Local Windows Machine - Memory Usage, Local Windows Machine - Memory Usage] DS[Local Windows Machine - Memory - Free] WARNING: Result from SNMP not valid. Partial Result: U
2018/11/15 10:35:02 - POLLER: Poller[Main Poller] Device[1] Device[Local Windows Machine] Graphs[Local Windows Machine - Memory Usage, Local Windows Machine - Memory Usage] DS[Local Windows Machine - Memory - Cache] SNMP: v2: 127.30.0.2, dsname: mem_cache, oid: .1.3.6.1.4.1.2021.4.15.0, output: U
2018/11/15 10:35:02 - POLLER: Poller[Main Poller] Device[1] Device[Local Windows Machine] Graphs[Local Windows Machine - Memory Usage, Local Windows Machine - Memory Usage] DS[Local Windows Machine - Memory - Cache] WARNING: Result from SNMP not valid. Partial Result: U
2018/11/15 10:35:02 - POLLER: Poller[Main Poller] Device[1] Device[Local Windows Machine] Graphs[Local Windows Machine - Memory Usage, Local Windows Machine - Memory Usage] DS[Local Windows Machine - Memory - Buffers] SNMP: v2: 127.30.0.2, dsname: mem_buffers, oid: .1.3.6.1.4.1.2021.4.14.0, output: U
2018/11/15 10:35:02 - POLLER: Poller[Main Poller] Device[1] Device[Local Windows Machine] Graphs[Local Windows Machine - Memory Usage, Local Windows Machine - Memory Usage] DS[Local Windows Machine - Memory - Buffers] WARNING: Result from SNMP not valid. Partial Result: U
2018/11/15 10:35:02 - POLLER: Poller[Main Poller] Device[1] Device[Local Windows Machine] Graphs[Local Windows Machine - Traffic - ethernet_5, Local Windows Machine - Traffic - ethernet_5] DS[Local Windows Machine - Traffic - 172.30.0.2 - ethernet_5] SNMP: v2: 127.30.0.2, dsname: traffic_out, oid: .1.3.6.1.2.1.31.1.1.1.10.13, output: U
2018/11/15 10:35:02 - POLLER: Poller[Main Poller] Device[1] Device[Local Windows Machine] Graphs[Local Windows Machine - Traffic - ethernet_5, Local Windows Machine - Traffic - ethernet_5] DS[Local Windows Machine - Traffic - 172.30.0.2 - ethernet_5] WARNING: Result from SNMP not valid. Partial Result: U
2018/11/15 10:35:02 - POLLER: Poller[Main Poller] Device[1] Device[Local Windows Machine] Graphs[Local Windows Machine - Traffic - ethernet_5, Local Windows Machine - Traffic - ethernet_5] DS[Local Windows Machine - Traffic - 172.30.0.2 - ethernet_5] SNMP: v2: 127.30.0.2, dsname: traffic_in, oid: .1.3.6.1.2.1.31.1.1.1.6.13, output: U
2018/11/15 10:35:02 - POLLER: Poller[Main Poller] Device[1] Device[Local Windows Machine] Graphs[Local Windows Machine - Traffic - ethernet_5, Local Windows Machine - Traffic - ethernet_5] DS[Local Windows Machine - Traffic - 172.30.0.2 - ethernet_5] WARNING: Result from SNMP not valid. Partial Result: U
2018/11/15 10:35:02 - POLLER: Poller[Main Poller] Device[1] Device[Local Windows Machine] Graphs[Local Windows Machine - Used Space - Physical Memory, Local Windows Machine - Used Space - Physical Memory] DS[Local Windows Machine - Used Space - Physical Memory] SERVER: C:\Apache24\htdocs\cacti\scripts\ss_host_disk.php ss_host_disk "127.30.0.2" "1" "2:161:500:1:10:public::::::" "get" "total" "4", output: 4294377472
2018/11/15 10:35:02 - POLLER: Poller[Main Poller] Device[1] Device[Local Windows Machine] Graphs[Local Windows Machine - Used Space - Physical Memory, Local Windows Machine - Used Space - Physical Memory] DS[Local Windows Machine - Used Space - Physical Memory] SERVER: C:\Apache24\htdocs\cacti\scripts\ss_host_disk.php ss_host_disk "127.30.0.2" "1" "2:161:500:1:10:public::::::" "get" "used" "4", output: 1729429504
2018/11/15 10:35:02 - POLLER: Poller[Main Poller] Device[1] Device[Local Windows Machine] Graphs[Local Windows Machine - Used Space - Virtual Memory, Local Windows Machine - Used Space - Virtual Memory] DS[Local Windows Machine - Used Space - Virtual Memory] SERVER: C:\Apache24\htdocs\cacti\scripts\ss_host_disk.php ss_host_disk "127.30.0.2" "1" "2:161:500:1:10:public::::::" "get" "total" "3", output: 5341052928
2018/11/15 10:35:02 - POLLER: Poller[Main Poller] Device[1] Device[Local Windows Machine] Graphs[Local Windows Machine - Used Space - Virtual Memory, Local Windows Machine - Used Space - Virtual Memory] DS[Local Windows Machine - Used Space - Virtual Memory] SERVER: C:\Apache24\htdocs\cacti\scripts\ss_host_disk.php ss_host_disk "127.30.0.2" "1" "2:161:500:1:10:public::::::" "get" "used" "3", output: 1870790656
2018/11/15 10:35:02 - POLLER: Poller[Main Poller] Device[1] Device[Local Windows Machine] Graphs[Local Windows Machine - Used Space - C: Label: Serial Number 7cc31a9a, Local Windows Machine - Used Space - C: Label: Serial Number 7cc31a9a] DS[Local Windows Machine - Used Space - C: Label: Serial Number 7cc31a9a] SERVER: C:\Apache24\htdocs\cacti\scripts\ss_host_disk.php ss_host_disk "127.30.0.2" "1" "2:161:500:1:10:public::::::" "get" "total" "1", output: 53631537152
2018/11/15 10:35:02 - POLLER: Poller[Main Poller] Device[1] Device[Local Windows Machine] Graphs[Local Windows Machine - Used Space - C: Label: Serial Number 7cc31a9a, Local Windows Machine - Used Space - C: Label: Serial Number 7cc31a9a] DS[Local Windows Machine - Used Space - C: Label: Serial Number 7cc31a9a] SERVER: C:\Apache24\htdocs\cacti\scripts\ss_host_disk.php ss_host_disk "127.30.0.2" "1" "2:161:500:1:10:public::::::" "get" "used" "1", output: 19681189888
2018/11/15 10:35:02 - POLLER: Poller[Main Poller] Device[1] Device[Local Windows Machine] Graphs[Local Windows Machine - CPU Utilization, Local Windows Machine - CPU Utilization] DS[Local Windows Machine - CPU - User] SNMP: v2: 127.30.0.2, dsname: ssCpuUser, oid: .1.3.6.1.4.1.2021.11.9.0, output: U
2018/11/15 10:35:02 - POLLER: Poller[Main Poller] Device[1] Device[Local Windows Machine] Graphs[Local Windows Machine - CPU Utilization, Local Windows Machine - CPU Utilization] DS[Local Windows Machine - CPU - User] WARNING: Result from SNMP not valid. Partial Result: U
2018/11/15 10:35:02 - POLLER: Poller[Main Poller] Device[1] Device[Local Windows Machine] Graphs[Local Windows Machine - CPU Utilization, Local Windows Machine - CPU Utilization] DS[Local Windows Machine - CPU - System] SNMP: v2: 127.30.0.2, dsname: ssCpuSystem, oid: .1.3.6.1.4.1.2021.11.10.0, output: U
2018/11/15 10:35:02 - POLLER: Poller[Main Poller] Device[1] Device[Local Windows Machine] Graphs[Local Windows Machine - CPU Utilization, Local Windows Machine - CPU Utilization] DS[Local Windows Machine - CPU - System] WARNING: Result from SNMP not valid. Partial Result: U
2018/11/15 10:35:02 - POLLER: Poller[Main Poller] Device[1] Device[Local Windows Machine] Graphs[Local Windows Machine - CPU Utilization, Local Windows Machine - CPU Utilization] DS[Local Windows Machine - CPU - Idle] SNMP: v2: 127.30.0.2, dsname: ssCpuIdle, oid: .1.3.6.1.4.1.2021.11.11.0, output: U
2018/11/15 10:35:02 - POLLER: Poller[Main Poller] Device[1] Device[Local Windows Machine] Graphs[Local Windows Machine - CPU Utilization, Local Windows Machine - CPU Utilization] DS[Local Windows Machine - CPU - Idle] WARNING: Result from SNMP not valid. Partial Result: U
2018/11/15 10:35:02 - POLLER: Poller[Main Poller] Device[1] Device[Local Windows Machine] Graphs[Local Windows Machine - CPU Utilization, Local Windows Machine - CPU Utilization] DS[Local Windows Machine - CPU - User] SNMP: v2: 127.30.0.2, dsname: ssCpuUser, oid: .1.3.6.1.4.1.2021.11.9.0, output: U
2018/11/15 10:35:02 - POLLER: Poller[Main Poller] Device[1] Device[Local Windows Machine] Graphs[Local Windows Machine - CPU Utilization, Local Windows Machine - CPU Utilization] DS[Local Windows Machine - CPU - User] WARNING: Result from SNMP not valid. Partial Result: U
2018/11/15 10:35:02 - POLLER: Poller[Main Poller] Device[1] Device[Local Windows Machine] Graphs[Local Windows Machine - CPU Utilization, Local Windows Machine - CPU Utilization] DS[Local Windows Machine - CPU - System] SNMP: v2: 127.30.0.2, dsname: ssCpuSystem, oid: .1.3.6.1.4.1.2021.11.10.0, output: U
2018/11/15 10:35:02 - POLLER: Poller[Main Poller] Device[1] Device[Local Windows Machine] Graphs[Local Windows Machine - CPU Utilization, Local Windows Machine - CPU Utilization] DS[Local Windows Machine - CPU - System] WARNING: Result from SNMP not valid. Partial Result: U
2018/11/15 10:35:02 - POLLER: Poller[Main Poller] Device[1] Device[Local Windows Machine] Graphs[Local Windows Machine - CPU Utilization, Local Windows Machine - CPU Utilization] DS[Local Windows Machine - CPU - Idle] SNMP: v2: 127.30.0.2, dsname: ssCpuIdle, oid: .1.3.6.1.4.1.2021.11.11.0, output: U
2018/11/15 10:35:02 - POLLER: Poller[Main Poller] Device[1] Device[Local Windows Machine] Graphs[Local Windows Machine - CPU Utilization, Local Windows Machine - CPU Utilization] DS[Local Windows Machine - CPU - Idle] WARNING: Result from SNMP not valid. Partial Result: U
2018/11/15 10:35:02 - POLLER: Poller[Main Poller] Device[1] Device[Local Windows Machine] Graphs[Local Windows Machine - Processes, Local Windows Machine - Processes] DS[Local Windows Machine - Processes] SNMP: v2: 127.30.0.2, dsname: proc, oid: .1.3.6.1.2.1.25.1.6.0, output: 56
2018/11/15 10:35:02 - POLLER: Poller[Main Poller] Device[1] Device[Local Windows Machine] Graphs[Local Windows Machine - Logged in Users, Local Windows Machine - Logged in Users] DS[Local Windows Machine - Logged in Users] SNMP: v2: 127.30.0.2, dsname: users, oid: .1.3.6.1.2.1.25.1.5.0, output: 1
2018/11/15 10:35:02 - POLLER: Poller[Main Poller] Device[1] Device[Local Windows Machine] NOTICE: Spike Kill in Effect for '127.30.0.2'.
2018/11/15 10:35:02 - POLLER: Poller[Main Poller] ASSERT: '8273322<0:23:03:43.94' failed. Recaching host '127.30.0.2', data query #7
2018/11/15 10:35:02 - POLLER: Poller[Main Poller] Device[1] Device[Local Windows Machine] RECACHE DQ[SNMP - Get Processor Information] OID: .1.3.6.1.2.1.1.3.0, output: 0:23:03:43.94
2018/11/15 10:35:02 - POLLER: Poller[Main Poller] Device[1] Device[Local Windows Machine] NOTICE: Spike Kill in Effect for '127.30.0.2'.
2018/11/15 10:35:02 - POLLER: Poller[Main Poller] ASSERT: '8273125<0:23:03:43.93' failed. Recaching host '127.30.0.2', data query #6
2018/11/15 10:35:02 - POLLER: Poller[Main Poller] Device[1] Device[Local Windows Machine] RECACHE DQ[SNMP - Get Mounted Partitions] OID: .1.3.6.1.2.1.1.3.0, output: 0:23:03:43.93
2018/11/15 10:35:02 - POLLER: Poller[Main Poller] Device[1] Device[Local Windows Machine] NOTICE: Spike Kill in Effect for '127.30.0.2'.
2018/11/15 10:35:02 - POLLER: Poller[Main Poller] ASSERT: '8272589<0:23:03:43.87' failed. Recaching host '127.30.0.2', data query #3
2018/11/15 10:35:02 - POLLER: Poller[Main Poller] Device[1] Device[Local Windows Machine] RECACHE DQ[SNMP - Interface Statistics] OID: .1.3.6.1.2.1.1.3.0, output: 0:23:03:43.87
2018/11/15 10:35:02 - POLLER: Poller[Main Poller] Device[1] Device[Local Windows Machine] RECACHE: Processing 3 items in the auto reindex cache for '127.30.0.2'.
2018/11/15 10:35:02 - POLLER: Poller[Main Poller] Device[1] Device[Local Windows Machine] STATUS: Device '127.30.0.2' is UP.
2018/11/15 10:35:02 - PING Device[1] Device[Local Windows Machine] SNMP: Device responded to SNMP
2018/11/15 10:35:02 - POLLER: Poller[Main Poller] PHP Script Server Started Properly
2018/11/15 10:35:02 - PHPSVR PHP Script Server has Started - Parent is cmd
2018/11/15 10:35:00 - POLLER: Poller[Main Poller] NOTE: Poller Int: '300', Scheduled Task Int: '300', Time Since Last: '300.52', Max Runtime '298', Poller Runs: '1'

[netniV]

So, the answer appears to be pretty simple, either you don't have the SNMP service properly installed and configured or the Windows Firewall is blocking you from access the SNMP port that should be open.

If you try an snmpwalk at the command line using any of those OID's to your server, you'll likely get a timeout.