No Graphs Found in graph preview mode

[SwitchNikky]

Hi all,

I have installed cacti on a Windows 2012 R2 with IIS/Web Platform Installer/PHP and MySQL 5.6.

Everything was good and worked as a new installation should pretend. But I have started to customize... and all the graphs are now gone.

What I did:
I am trying to monitor my routers. One of my routers is a Microsoft ISA server. I performed http://docs.cacti.net/manual:087:2_basi ... irst_graph:
1 - Create a Device
2 - Create the graph

To be able to do that, I had to configure snmp-data queries and it seems to work, here the cacti logs:

02/24/2015 02:50:16 PM - SYSTEM STATS: Time:1.5060 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:16 RRDsProcessed:6
02/24/2015 02:50:15 PM - CMDPHP: Poller[0] Time: 1.0546 s, Theads: N/A, Hosts: 2
02/24/2015 02:50:15 PM - CMDPHP: Poller[0] Host[2] DS[17] SNMP: v1: ISA, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.131075, output: 1846831015
02/24/2015 02:50:15 PM - CMDPHP: Poller[0] Host[2] DS[17] SNMP: v1: ISA, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.131075, output: 3271765112
02/24/2015 02:50:15 PM - CMDPHP: Poller[0] Host[2] DS[16] SNMP: v1: ISA, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.65540, output: 3684445962
02/24/2015 02:50:15 PM - CMDPHP: Poller[0] Host[2] DS[16] SNMP: v1: ISA, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.65540, output: 587369097
02/24/2015 02:50:15 PM - CMDPHP: Poller[0] Host[2] DS[15] SNMP: v1: ISA, dsname: errors_out, oid: .1.3.6.1.2.1.2.2.1.20.131075, output: 0
02/24/2015 02:50:15 PM - CMDPHP: Poller[0] Host[2] DS[15] SNMP: v1: ISA, dsname: discards_out, oid: .1.3.6.1.2.1.2.2.1.19.131075, output: 0
02/24/2015 02:50:15 PM - CMDPHP: Poller[0] Host[2] DS[15] SNMP: v1: ISA, dsname: discards_in, oid: .1.3.6.1.2.1.2.2.1.13.131075, output: 0
02/24/2015 02:50:15 PM - CMDPHP: Poller[0] Host[2] DS[15] SNMP: v1: ISA, dsname: errors_in, oid: .1.3.6.1.2.1.2.2.1.14.131075, output: 0
02/24/2015 02:50:15 PM - CMDPHP: Poller[0] Host[2] DS[14] SNMP: v1: ISA, dsname: errors_out, oid: .1.3.6.1.2.1.2.2.1.20.65540, output: 0
02/24/2015 02:50:15 PM - CMDPHP: Poller[0] Host[2] DS[14] SNMP: v1: ISA, dsname: discards_out, oid: .1.3.6.1.2.1.2.2.1.19.65540, output: 0
02/24/2015 02:50:15 PM - CMDPHP: Poller[0] Host[2] DS[11] SNMP: v1: ISA, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.131075, output: 1846831015
02/24/2015 02:50:15 PM - CMDPHP: Poller[0] Host[2] DS[11] SNMP: v1: ISA, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.131075, output: 3271765112
02/24/2015 02:50:15 PM - CMDPHP: Poller[0] Host[2] DS[10] SNMP: v1: ISA, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.65540, output: 3684445962
02/24/2015 02:50:15 PM - CMDPHP: Poller[0] Host[2] DS[10] SNMP: v1: ISA, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.65540, output: 587369097
02/24/2015 02:50:15 PM - CMDPHP: Poller[0] Host[2] DS[14] SNMP: v1: ISA, dsname: errors_in, oid: .1.3.6.1.2.1.2.2.1.14.65540, output: 0
02/24/2015 02:50:15 PM - CMDPHP: Poller[0] Host[2] DS[14] SNMP: v1: ISA, dsname: discards_in, oid: .1.3.6.1.2.1.2.2.1.13.65540, output: 0
02/24/2015 02:50:15 PM - CMDPHP: Poller[0] Host[2] RECACHE DQ[9] OID: .1.3.6.1.2.1.1.3.0, output: 34861386
02/24/2015 02:50:15 PM - CMDPHP: Poller[0] Host[2] RECACHE DQ[8] OID: .1.3.6.1.2.1.1.3.0, output: 34861386
02/24/2015 02:50:15 PM - CMDPHP: Poller[0] Host[2] RECACHE DQ[3] OID: .1.3.6.1.2.1.1.3.0, output: 34861384
02/24/2015 02:50:15 PM - CMDPHP: Poller[0] Host[2] RECACHE DQ[1] OID: .1.3.6.1.2.1.1.3.0, output: 34861384
02/24/2015 02:50:15 PM - CMDPHP: Poller[0] Host[2] PING: ICMP Ping Success (0 ms)
02/24/2015 02:50:14 PM - POLLER: Poller[0] NOTE: Poller Int: '300', Scheduled Task Int: '300', Time Since Last: '300', Max Runtime '298', Poller Runs: '1'

I also "cleaned" the graphs "not needed from my perspective..." (List of all graphs in cacti):

ISA server - Errors - 192.168.110.1 (Broadcom NetXtr) 11 Interface - Errors/Discards 120x500
ISA server - Errors - 192.168.10.1 (D-Link DGE-528T) 12 Interface - Errors/Discards 120x500
ISA server - Traffic - 192.168.110.1 (Broadcom NetXtr) 13 Interface - Traffic (bytes/sec, Total Bandwidth) 120x500
ISA server - Traffic - 192.168.10.1 (D-Link DGE-528T) 14 Interface - Traffic (bytes/sec, Total Bandwidth) 120x500

the rrd files are well created in cacti/rrd:

16:50 188.352 isa_server_errors_in_14.rrd
16:50 188.352 isa_server_errors_in_15.rrd
16:50 94.704 isa_server_traffic_in_10.rrd
16:50 94.704 isa_server_traffic_in_11.rrd
16:50 94.704 isa_server_traffic_in_16.rrd
16:50 94.704 isa_server_traffic_in_17.rrd

I have tried to repair the graphs with the Data template:

Interface - Errors/Discards 38 Get SNMP Data (Indexed) Active
Interface - Non-Unicast Packets 40 Get SNMP Data (Indexed) Active
Interface - Traffic 41 Get SNMP Data (Indexed) Active

here the commands:

C:\inetpub\cacti\cli>php repair_graphs.php --check --data-template-id=38 --graph-template-id=12
NOTE: Performing Check of Graphs

C:\inetpub\cacti\cli>php repair_graphs.php --check --data-template-id=38 --graph-template-id=11
NOTE: Performing Check of Graphs

C:\inetpub\cacti\cli>php repair_graphs.php --check --data-template-id=41 --graph-template-id=14
NOTE: Performing Check of Graphs

C:\inetpub\cacti\cli>php repair_graphs.php --check --data-template-id=41 --graph-template-id=13
NOTE: Performing Check of Graphs

I still not have graphs.
As I did something wrong and my feeling seems bad on the resolution, I prefer to post this help message.

So, how can I repair my cacti installation?

Best regards,
Nikky

(And anyway, thanks for the job you do with cacti.)

[BSOD2600]

But I have started to customize... and all the graphs are now gone.

Tried clearing the filters at the top of the page?

If you go to [Graph Trees] and start to add, are any items listed?

[SwitchNikky]

I have tried a lot of filter options... Without result. Even from a "brand new" session, with Any host, any template, graphs default, Columns default. No graphs found

This is my default graph tree:

Graph Trees [edit: Default Tree]
Name
A useful name for this graph tree.
Sorting Type
Choose how items in this tree will be sorted.

Tree Items Add
Item Value
Host: ISA server (ISA) (Edit host) Host
ISA server - Errors - 192.168.110.1 (Broadcom NetXtr) Graph
ISA server - Traffic - 192.168.10.1 (D-Link DGE-528T) Graph
ISA server - Traffic - 192.168.110.1 (Broadcom NetXtr) Graph

And I have tried to create a new one:
Graph Trees [edit: Network]
Name
A useful name for this graph tree.
Sorting Type
Choose how items in this tree will be sorted.

Tree Items Add
Item Value
ISA server - Errors - 192.168.10.1 (D-Link DGE-528T) Graph

I can see in the Graph tree mode:

Graphs -> Tree Mode Logged in as admin (Logout)

Default Tree
Network

[BSOD2600]

In Console -> Graph Management, are there any graphs?
The only correct way of creating graphs is via Devices -> select device -> Create Graphs for this Host (top right corner) -> select the entries you want -> click create.

The poller running every 5 min?
Any errors in the cacti log file?

[SwitchNikky]

Thanks to confirm me I reasonably understood Cacti... Unfortunately, something goes wrong.

The cacti log:
02/26/2015 09:20:15 AM - SYSTEM STATS: Time:1.4684 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:16 RRDsProcessed:6
02/26/2015 09:15:15 AM - SYSTEM STATS: Time:1.4546 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:16 RRDsProcessed:6
02/26/2015 09:10:15 AM - SYSTEM STATS: Time:1.4512 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:16 RRDsProcessed:6
02/26/2015 09:05:15 AM - SYSTEM STATS: Time:1.4529 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:16 RRDsProcessed:6
02/26/2015 09:00:15 AM - SYSTEM STATS: Time:1.4652 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:16 RRDsProcessed:6
02/26/2015 08:55:15 AM - SYSTEM STATS: Time:1.4645 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:16 RRDsProcessed:6
02/26/2015 08:50:15 AM - SYSTEM STATS: Time:1.4537 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:16 RRDsProcessed:6
02/26/2015 08:45:15 AM - SYSTEM STATS: Time:1.4518 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:16 RRDsProcessed:6
02/26/2015 08:40:15 AM - SYSTEM STATS: Time:1.4681 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:16 RRDsProcessed:6
02/26/2015 08:35:15 AM - SYSTEM STATS: Time:1.4495 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:16 RRDsProcessed:6
02/26/2015 08:30:15 AM - SYSTEM STATS: Time:1.4500 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:16 RRDsProcessed:6
02/26/2015 08:25:15 AM - SYSTEM STATS: Time:1.4467 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:16 RRDsProcessed:6
02/26/2015 08:20:15 AM - SYSTEM STATS: Time:1.4697 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:16 RRDsProcessed:6
02/26/2015 08:15:15 AM - SYSTEM STATS: Time:1.4505 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:16 RRDsProcessed:6
02/26/2015 08:10:15 AM - SYSTEM STATS: Time:1.4868 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:16 RRDsProcessed:6
02/26/2015 08:05:15 AM - SYSTEM STATS: Time:1.4524 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:16 RRDsProcessed:6
02/26/2015 08:00:15 AM - SYSTEM STATS: Time:1.4529 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:16 RRDsProcessed:6
02/26/2015 07:55:15 AM - SYSTEM STATS: Time:1.4521 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:16 RRDsProcessed:6
02/26/2015 07:50:15 AM - SYSTEM STATS: Time:1.4468 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:16 RRDsProcessed:6
02/26/2015 07:45:15 AM - SYSTEM STATS: Time:1.4522 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:16 RRDsProcessed:6
02/26/2015 07:40:15 AM - SYSTEM STATS: Time:1.4653 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:16 RRDsProcessed:6
02/26/2015 07:35:15 AM - SYSTEM STATS: Time:1.4432 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:16 RRDsProcessed:6
02/26/2015 07:30:15 AM - SYSTEM STATS: Time:1.4489 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:16 RRDsProcessed:6
02/26/2015 07:25:15 AM - SYSTEM STATS: Time:1.4537 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:16 RRDsProcessed:6
02/26/2015 07:20:15 AM - SYSTEM STATS: Time:1.4653 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:16 RRDsProcessed:6
02/26/2015 07:15:15 AM - SYSTEM STATS: Time:1.4539 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:16 RRDsProcessed:6
02/26/2015 07:10:15 AM - SYSTEM STATS: Time:1.4528 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:16 RRDsProcessed:6
02/26/2015 07:05:15 AM - SYSTEM STATS: Time:1.4502 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:16 RRDsProcessed:6

So, yes, it's running every 5 minutes without error...

I have join 2 screenshots:
1 with the graph management console

Cacti-2015-02-26 09_11_41-Console -_ Graph Management.gif (94.99 KiB) Viewed 2334 times

1 with the graphs tree mode

Cacti-2015-02-26 09_12_45-Graphs -_ Tree Mode.gif (21.06 KiB) Viewed 2334 times

[BSOD2600]

ah-ha. Do you have anything created under the Default Graph tree? What about Network?
When you're in Graph Management and click on a graph (lets say traffic), does it render properly? If so, then it's just a problem with the Tree layout and not the data collection/graphing.

The tree code was overhauled in 0.8.8c and there are still a few things to work out

[SwitchNikky]

ah-ha. Do you have anything created under the Default Graph tree? What about Network?

Yes I did (or I have expected to do...):

Cacti-2015-02-27 11_09_59-Console -_ Graph Trees -_ (Edit).gif (28.96 KiB) Viewed 2307 times

Cacti-2015-02-27 11_08_36-Console -_ Graph Trees -_ (Edit).gif (23.6 KiB) Viewed 2307 times

When you're in Graph Management and click on a graph (lets say traffic), does it render properly?

If you mean the screen below; I cannot see a graph. So it seems to be a graphing problem instead a "Tree Layout" problem?

Cacti-2015-02-27 10_20_45-Console -_ Graph Management -_ (Edit).gif (46.27 KiB) Viewed 2307 times

[BSOD2600]

If you mean the screen below; I cannot see a graph. So it seems to be a graphing problem instead a "Tree Layout" problem?

Probably. turn on graph debug. Paste the output.

Do any of the graphs correctly render?

[SwitchNikky]

Finally solved and I thank you to put me on the way. It was a problem with the "user permission" of the admin account. I do not know how this "allow Graph by devices" appears but it overwrites all other "default" rights. It was the first time I set something in the user permission setting (or my memory fails). Yeah... In my mind, we do not manage permissions for admins. All or nothing is my understanding of rights management for admin

I have just removed the Graph Permissions (by device):

Cacti-2015-03-03 16_41_44-Console -_ User Management -_ (Edit).gif (36.1 KiB) Viewed 2256 times

[BSOD2600]

Glad you were able to figure it out.

In the next version of Cacti, the permission system was completely re-written and its now FAR more intuitive for whats allowed/denied.