ReportIt! Issues

[ptaylor874]

I'm running ReportIt 0.7.5a on a newly installed Cacti server. Previously, I was running with version 0.7.1 on my old Cacti server and it was working properly.

Anyhow, I backed up my DB from the old server to the new one, installed ReportIt 0.7.5a, and all my reports popped back into the listing.

Unfortunately, when I try to run the report on the new server, I don't get any values... But, it shows "Gi" and "Mi" for various columns - no values though ??

reportit.png (5.31 KiB) Viewed 2557 times

[ptaylor874]

More info:

It looks like it is actually generating these reports based on the actual data... I can sort on the column, and although it still shows just the "Gi" or "Mi", if I look at the actual graphs for specific devices, they ARE sorted in order from greatest to least.

When I do a CSV export, I only get the "Gi" and "Mi" in the cells where the byte counts should be.

[ptaylor874]

Ok, dug into it some more... I do have actual data in my reportit_results MySQL tables..

Here's a screenshot of one of them:

DB Info

reportit.png (9.39 KiB) Viewed 2545 times

ANY idea at all why there is no data when I view the report or try to export it?

[ptaylor874]

Found the answer in another post... Someone might have spotted this right if I had posted in the Plugins forum to start with... (Plugins... Addons... Not quite close enough, perhaps.)

Anyhow, here's the answer straight from the author of the Plugin:

Execute following commands using the MySQL CLI or e.g. phpMyAdmin:

Code: Select all

ALTER TABLE `reportit_measurands`
            ADD `data_type` SMALLINT NOT NULL DEFAULT '1',
            ADD `data_precision` SMALLINT NOT NULL DEFAULT '2';
ALTER TABLE `reportit_cache_measurands`
            ADD `data_type` SMALLINT NOT NULL DEFAULT '1',
            ADD `data_precision` SMALLINT NOT NULL DEFAULT '2';

I did this and everything is working properly now...