"Reporting tool for Cacti" under Plugin Permissions shows multiple times

Cacti / plugin_reportit

ReportIt Plugin for Cacti

GNU General Public License v2.0

7 stars 9 forks source link

"Reporting tool for Cacti" under Plugin Permissions shows multiple times #49

Closed ikorzha closed 6 years ago

ikorzha commented 6 years ago

I noticed that under Console->Users->Permissions->Reporting Tool for Cacti Settings for Create Reports and View Reports show multiple times. Cleanup needed...

netniV commented 6 years ago

So, this is probably a REALM issue. You likely have multiple realms for the same plugin, or the plugin is actually listed twice in the plugins table.

select * from plugin_config where directory = 'reportit'
select * from plugin_realms where plugin = 'reportit'

netniV commented 6 years ago

Did you have chance to run this query @ikorzha ?

ikorzha commented 6 years ago

My apologies for the delay. I suspect this doubling behavior occurs when you uninstall and re-install plugin a few times. Probably no proper cleanup by plugin is taking place...

Results are below.

netniV commented 6 years ago

OK so the problem here is that the upgrade has messed up because it's given you two sets of realms. One for the old (all those cc) and one for the new (non-cc). Simple answer here is to run the following query:

DELETE FROM `plugin_realms` where id in (99, 101, 102)

As long as you are working on with ReportIT 1.x

ikorzha commented 6 years ago

netniV would you believe me that they get AUTO RECREATED after I delete them under different IDs? Can you take a look at that portion of the code in upcoming release

netniV commented 6 years ago

This means you must have the pre-1.x code still running... check your plugins folder.

ikorzha commented 6 years ago

netniV I do not have pre-1.x code running. 0.8 branch isn't even compatible to install on 1.x Not to mention my current Cacti 1.1.38 was build from ground up, I never did any migration from 0.8.8x builds.

netniV commented 6 years ago

Something somewhere must be running it... cc_ is only present in pre-1.x code:

/usr/share/cacti/site/plugins/reportit$ grep "cc_" * -R
README.md:* bug#00089: Wrong include path in cc_graph.php
README.md:* feature: New graphic module based on "Graidle" (cc_graph has been completely
README.md:* bug#00066: Changing a lot of cc_reports.php to get more compatible to Cacti's

ikorzha commented 6 years ago

My apologies, I have realized what was happening. reportit folder in remote pollers did contain outdated reportIT files with cc_ naming convention, they were repopulating master poller plugin_realms. I sync them manually, by deleting and re-copy from GIT and deleting entries from plugin_realm that were irrelevant. Thank you for your help in determining root cause.