snmp_query_graph table missing IPv4/IPv6 Counters in Dropdown

[reubenfarrelly]

Following on from https://github.com/Cacti/cacti/issues/261 - I believe something was missed in this enhancement. While the .xml file is now correct, we are not seeing the IPv4/IPv6 specific counters in the Graph Type dropdown when creating graphs for a device.

I suspect this could be due to missing entries in the snmp_query_graph table.

This is with a clean install of Cacti 1.0.2 (I haven't even run the poller for the first time yet...)

[cigamit]

Well, we only added the counters, we don't have any templates associated with them yet. If you would like to submit your suggestions via a pull request, we could evaluate.

[reubenfarrelly]

I'm not even slightly capable of writing code so this may well not be all that is needed, but I imagine we'd need something like this:

--- cacti.sql 2017-02-13 19:42:52.719450668 +1100 +++ cacti.sql 2017-02-13 20:36:12.662376812 +1100 @@ -3092,6 +3092,10 @@ INSERT INTO snmp_query_graph VALUES (20,'ed7f68175d7bb83db8ead332fc945720',1,'In/Out Bits with 95th Percentile',31); INSERT INTO snmp_query_graph VALUES (21,'f85386cd2fc94634ef167c7f1e5fbcd0',1,'In/Out Bits with Total Bandwidth',32); INSERT INTO snmp_query_graph VALUES (22,'7d309bf200b6e3cdb59a33493c2e58e0',1,'In/Out Bytes with Total Bandwidth',33); +INSERT INTO snmp_query_graph VALUES (25, '5ab534a5a4e4438589672577f9d052cd', 1, 'In/Out Bits IPv4', 2); +INSERT INTO snmp_query_graph VALUES (26, 'c9a4727b57704a7207b73512f1049ca4', 1, 'In/Out Bits IPv6', 2); +INSERT INTO snmp_query_graph VALUES (38, '6ed8b5cefa6c1e5f34d7f91a63f603ad', 1, 'In/Out Bits IPv4 (64 Bit Counters)', 2), +INSERT INTO snmp_query_graph VALUES (39, 'e586df2678b6752e3fa084241606d062', 1, 'In/Out Bits IPv6 (64 Bit Counters)', 2);

-- -- Table structure for table snmp_query_graph_rrd

I have created my graphs in the web interface so it's not clear if the creation process touched more than just this SQL table or not. What I do in my legacy system is just use the existing graph template but use a slightly different SNMP OID to feed into the data source.

[ronytomen]

@reubenfarrelly you could just export the data query and then we can work from there to integrate it. Please attach your data query export with all children.

[reubenfarrelly]

Sure. Here you go... cacti_data_query_snmp_-_interface_statistics.zip

[cigamit]

Thanks Reuben. Are these included in your other ticket?

[reubenfarrelly]

I think this may have been Part 2 that follows on from the previous ticket. It has been a while now so I can't be 100% sure.