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! Issues
Moderators: Developers, Moderators
-
- Posts: 45
- Joined: Fri Jan 04, 2008 11:45 am
Re: ReportIt! Issues
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.
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.
-
- Posts: 45
- Joined: Fri Jan 04, 2008 11:45 am
Re: ReportIt! Issues
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:
ANY idea at all why there is no data when I view the report or try to export it?
Here's a screenshot of one of them:
ANY idea at all why there is no data when I view the report or try to export it?
-
- Posts: 45
- Joined: Fri Jan 04, 2008 11:45 am
Re: ReportIt! Issues
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:
I did this and everything is working properly now...
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';
Who is online
Users browsing this forum: No registered users and 3 guests