Problem - Reportit Plugin template creation issues and DS's

[j-munroe]

Hi,

I'm having a problem with Reportit 0.7.5a (actually tried 0.7.0 and 0.6.0 as well) under Cacti 0.8.8a. The plugin installs fine however, when you create a report template (tried different data templates) there is no option to select the Date Template. If you just hit the create the error "No data source item selected". The following error occurs in the logs:

11/06/2012 06:11:29 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT data_source_alias FROM reportit_data_source_items WHERE id = 0 AND template_id = 0"
11/06/2012 06:11:29 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT a.id, a.data_source_name, b.data_source_alias, b.id as enabled FROM data_template_rrd as a LEFT JOIN (SELECT * FROM reportit_data_source_items WHERE template_id = 0 ) as b ON a.data_source_name = b.data_source_name WHERE a.local_data_id =0 AND a.data_template_id =38"

This is an upgrade of sorts...used Reportit many moons ago under 0.8.6 of Cacti. But would of uninstalled it shortly after. I am currently running this under Centos 6 (x64) with MySQL v. 5.1.61.

Anyone have any idea what would be required to make this plugin work? I'm included the Technical Support screen if that helps.

Any help would be greatly appreciated!!

Jim

[j-munroe]

Well, I think I've narrowed my problem down. For whatever reason, the reportit mysql tables aren't getting created properly during the install. So far I've had to manually drop and create new tables for reportit_data_source_items, reportit_templates, reportit_measurands, and reportit_data_items to just to get to the point where I could successfully run a report.

Does anyone out there either have...or know how to easily get the mysql table structure for reportit 0.7.5a...other than manually extracting from the setup.php file?

Thanks!