Unable to use data query after upgrade to 1.1.32

[Dalamir2]

I only noticed it after my upgrade to 1.1.33, but I think it may have happened in the earlier upgrade.
When I add a new device, I no longer have the option to use the SNMP Interface Statistics data query.
The xml file is present and cacti acknowledges it's presence. Older devices still have the query in their list of data query option.
New devices only have 3 data queries left : SNMP Get Mounted partitions, SNMP Get Processor Information and Unic Get Mounted Partitions.
All current graphs have no problem with the query and graphs are still being filled.

I removed the new device and re-added it, no change. Server has been rebooted as well.

Any help is appreciated.

[netniV]

Have you added any other templates or plugins? The chances are that these templates have overriden that template with a new name. HostMIB is one of the plugins that can do this as I found out recently.

In MySQL try the following query:

Code: Select all

select id, hash, name from snmp_query where hash = 'd75e406fdeca4fcef45b8be3a9a63cbc';

If that doesn't return any results, try

Code: Select all

select * from snmp_query

and paste the results here.

[Dalamir2]

First command, after selecting cacti database yields:

mysql> select id, hash, name from snmp_query where hash = 'd75e406fdeca4fcef45b8be3a9a63cbc';
+----+----------------------------------+-----------------------------+
| id | hash | name |
+----+----------------------------------+-----------------------------+
| 1 | d75e406fdeca4fcef45b8be3a9a63cbc | SNMP - Interface Statistics |
+----+----------------------------------+-----------------------------+
1 row in set (0.00 sec)

[Dalamir2]

The second commands yields the following:

mysql> mysql> select * from snmp_query;
+----+----------------------------------+------------------------------------------------------------------------+----------------------------------------------+-----------------------------------------------------------------------------------------+-------------------+---------------+
| id | hash | xml_path | name | description | graph_template_id | data_input_id |
+----+----------------------------------+------------------------------------------------------------------------+----------------------------------------------+-----------------------------------------------------------------------------------------+-------------------+---------------+
| 1 | d75e406fdeca4fcef45b8be3a9a63cbc | <path_cacti>/resource/snmp_queries/interface.xml | SNMP - Interface Statistics | Queries a host for a list of monitorable interfaces | 0 | 2 |
| 2 | 3c1b27d94ad208a0090f293deadde753 | <path_cacti>/resource/snmp_queries/net-snmp_disk.xml | ucd/net - Get Monitored Partitions | Retrieves a list of monitored partitions/disks from a net-snmp enabled host. | 0 | 2 |
| 3 | 59aab7b0feddc7860002ed9303085ba5 | <path_cacti>/resource/snmp_queries/kbridge.xml | Karlnet - Wireless Bridge Statistics | Gets information about the wireless connectivity of each station from a Karlnet bridge. | 0 | 2 |
| 4 | ad06f46e22e991cb47c95c7233cfaee8 | <path_cacti>/resource/snmp_queries/netware_disk.xml | Netware - Get Available Volumes | Retrieves a list of volumes from a Netware server. | 0 | 2 |
| 6 | 8ffa36c1864124b38bcda2ae9bd61f46 | <path_cacti>/resource/script_queries/unix_disk.xml | Unix - Get Mounted Partitions | Queries a list of mounted partitions on a unix-based host with the | 0 | 11 |
| 7 | 30ec734bc0ae81a3d995be82c73f46c1 | <path_cacti>/resource/snmp_queries/netware_cpu.xml | Netware - Get Processor Information | Gets information about running processors in a Netware server | 0 | 2 |
| 8 | 9343eab1f4d88b0e61ffc9d020f35414 | <path_cacti>/resource/script_server/host_disk.xml | SNMP - Get Mounted Partitions | Gets a list of partitions using SNMP | 0 | 12 |
| 9 | 0d1ab53fe37487a5d0b9e1d3ee8c1d0d | <path_cacti>/resource/script_server/host_cpu.xml | SNMP - Get Processor Information | Gets usage for each processor in the system using the host MIB. | 0 | 12 |
| 10 | 72ccd11613ba583f8414745ce9ecbaed | <path_cacti>/resource/snmp_queries/snmp_informant_standard_disk.xml | SNMP_Informant_Standard - Disk Statistics | Query Disk Stats | 0 | 2 |
| 11 | 96962f601f431a22a513307bf76b70e1 | <path_cacti>/resource/snmp_queries/snmp_informant_standard_memory.xml | SNMP_Informant_Standard - Memory Statistics | Query Memory Statistics | 0 | 2 |
| 12 | db5fe4291ef46d2eeffceb5acf57a268 | <path_cacti>/resource/snmp_queries/snmp_informant_standard_network.xml | SNMP_Informant_Standard - Network Statistics | Query Network Stats | 0 | 2 |
| 13 | 402301c99ebc9f50793e1c7b93c50ec4 | <path_cacti>/resource/snmp_queries/snmp_informant_standard_objects.xml | SNMP_Informant_Standard - Objects Statistics | Query Object Stats | 0 | 2 |
| 14 | 951e3c86c2d1e2cb3e270c8ae30ba17a | <path_cacti>/resource/snmp_queries/snmp_informant_standard_cpu.xml | SNMP_Informant_Standard - CPU Statistics | Query CPU Stats | 0 | 2 |
| 15 | 099130fa409bce5a7d65ca0940ede02e | <path_cacti>/resource/snmp_queries/hrStorageTable.xml | SNMP - hrStorageTable | Get SNMP based Partition Information out of hrStorageTable | 0 | 2 |
| 16 | 69b4882aa4021a9fa67a0a2123ea65dc | <path_cacti>/resource/snmp_queries/Cisco_Airespace_AP_Interface.xml | Cisco WLC - AP Radios | Get Cisco AIRESPACE-WIRELESS-MIB::BsnAPIfEntry table | 0 | 2 |
+----+----------------------------------+------------------------------------------------------------------------+----------------------------------------------+-----------------------------------------------------------------------------------------+-------------------+---------------+
15 rows in set (0.01 sec)

[netniV]

So it would appear that you still have the data query and it is using data_input method 2. This matches up with my system.

Data Input method 2 should be SNMP Indexed, and I'd be surprised if it wasn't. Does the template this device is based upon have SNMP Interfaces in it's list of associated data queries?

[Dalamir2]

I very rarely use a device template, so I have not used one for this device.

[netniV]

OK, I'll create a test device and use no template, see whether there are any differences for me as all my other devices are based on templates.

[Dalamir2]

I have found a workaround.
If I give the device the Generic snmp-enabled host template, the snmp interfaces are automagically added as a data query again.
Bug or feature?

[Dalamir2]

Addendum: Even though I now have the data query available, there is no graph.
Error opening /usr/share/cacti/rra/<rra file for switch>
I checked the permissions in the directory and they look legit to me, I compared them with the backup I made before upgrading and they match.
But it looks like cacti is unable or unwilling to create an .rrd file...

[netniV]

The poller is the code that creates the rrd file. That runs under root normally via the /etc/cron.d/cacti file.

Check that you have that file and it is calling the poller.

Out of curiosity, what values do you get if you run the verbose queries when editing the device under console -> management -> devices?

[cigamit]

You can try using this plugin to determine where exactly the issue is. Not creating the RRD can be anything from permissions to not getting data from the host. It will only create the RRD if it receives valid data.
https://github.com/cigamit/plugin_debug/

[Dalamir2]

The plot thickens.

The suggested plugin is incompatible according to Cacti.

Logs show the following when creating a new interface graph:
06-02-2018 11:59:34 - CMDPHP ERROR: Suggested value column error. Column PrefTitle for Data Query ID 1 and Graph Template ID 79 is not a compatible field name. Please correct this suggested value mapping
06-02-2018 11:59:35 - CMDPHP ERROR: Suggested value column error. Column PrefTitle for Data Query ID 1 and Graph Template ID 79 is not a compatible field name. Please correct this suggested value mapping

[cigamit]

The plugin should work with any version after 1.0. Did you rename the folder to just "debug"?

[Dalamir2]

I did at that:

root@cacti03:/usr/share/cacti/plugins/debug# ls
debug.php debug.sql index.php INFO README.md setup.php
root@cacti03:/usr/share/cacti/plugins/debug#

But there are errors in the cacti.log:

06-02-2018 17:22:57 - ERROR PHP NOTICE in Plugin 'debug': Undefined index: info in file: /usr/share/cacti/plugins/debug/setup.php on line: 29
06-02-2018 17:22:57 - CMDPHP PHP ERROR NOTICE Backtrace: (/poller.php: 715 snmpagent_poller_bottom)(/lib/snmpagent.php: 457 snmpagent_get_pluginslist)(/lib/snmpagent.php: 559 plugin_debug_version)(/plugins/debug/setup.php: 29 CactiErrorHandler)(/lib/functions.php: 4482 cacti_debug_backtrace)

And before that I needed to create an INFO file as that was called for in line 28 in the setup.php:
$info = parse_ini_file($config['base_path'] . '/plugins/debug/INFO', true)

[cigamit]

The info file is in the repo, so it shouldnt need to be created. You will have to also import the sql file into your DB, I haven't made it auto set that up yet, I will get that done shortly.