Report plugin ''ReportIt" - v0.7.5a (released 23/12/11)

[dononeil]

The caluculation bug appears to be in v.61 as well.... see the attached image.

As you can see, the max bandwidth of the circuit is 1.54 Mbps… but the calculated peak shows up as 1.91 M.

My measureands are pretty basic, just showing the peak, interface speed and average.

[Heiko]

Hello,

i downloaded the new version and unpacked it into the plugins folder, this has overwritten the old folder.
But when I open cacti all that reportit stuff is gone, also there is nothing under "Plugin Management".

What am I missing here?


cheers

.h


EDIT: i logged into cacti with a different user, than I could use install the plugin and enable it. After giving my users the right to view/edit reportit is now works fine.
Sorry for waisting precious cactiforum space...

[browniebraun]

Hi Heiko!

Please a take a look at the log if there are some SQL errors.
Generally when you click on "enable" for the first time the old realm ids of all ReportIt users (PIA 1.x) will be automatically updated to the new ones given by PIA 2.x.

Best regards
-Andreas-

[MarvinSG]

Hi,
i have succesfully installed Cacti-ReportIt, but it won't save the reports.
Every button works etc, i have added Templates and unlocked them.
I can see the templates in the Report Configuration.
But when i press ADD report, it says Save Successful. But the actual report never shows up in the list ?:(

How can i fix this??

Kind Regards,
Marvin.
(edit)
Log:
04/09/2009 02:29:08 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT DISTINCT a.user_id as id, c.username FROM reportit_reports AS a LEFT JOIN reportit_templates AS b ON b.id = a.template_id LEFT JOIN user_auth AS c ON c.id = a.user_id ORDER BY c.username"
04/09/2009 02:29:08 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT DISTINCT b.id, b.description FROM reportit_reports AS a INNER JOIN reportit_templates AS b ON b.id = a.template_id"
04/09/2009 02:29:08 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT COUNT(a.id) FROM reportit_reports AS a WHERE a.description like '%'"
04/09/2009 02:29:08 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT a.*, b.description AS template_description, c.ds_cnt, d.username, b.locked FROM reportit_reports AS a LEFT JOIN reportit_templates AS b ON b.id = a.template_id LEFT JOIN (SELECT report_id, count(*) as ds_cnt FROM `reportit_data_items` GROUP BY report_id) AS c ON c.report_id = a.id LEFT JOIN user_auth AS d ON d.id = a.user_id WHERE a.description like '%' ORDER BY id ASC LIMIT 0,25"

[browniebraun]

Hi Marvin!

First off... give me some more information about your system, please.
(Version of Cacti, PHP, MySQL, ReportIt). Did you install ReportIt for the first time or was it an upgrade?

Change to the MySQL command line interface (or use phpMyAdmin) and check if there are all tables available. (DB model of 0.7.0). Try to execute some of the SQL commands failed before and send the me the error message via email or pm.

Best regards
-Andreas-

[MarvinSG]

Hi Andreas,

Thank you for your reply

Sys info:
OS: Win2k3
PHP: 5.1.1.4
MySQL: 4.1.7
Cacti: 0.8.7b
ReportIt: 0.7.0

Yes the SQL Tables are made, i can view them.

Let me know if you need any more info
The error is on the bottom side of my other post, i copied it from the cacti.log

Kind Regards,
Marvin

[browniebraun]

0.7.0 does not support MySQL 4.

Best regards
-Andreas-

[MarvinSG]

Ok thanks for the update, which mysql should i use?

Kind regards,
Marvin

[browniebraun]

Ok thanks for the update, which mysql should i use?

Kind regards,
Marvin

MySQL 5.0.3 or above.
(Till know I do not plan to write a patch for using MySQL 4 ).

Best regards
-Andreas-

[istein001]

Disregard, missing admin rights for user.

[browniebraun]

Disregard, missing admin rights for user.

???

[istein001]

After the upgrade my "report template" editor option was missing, i had somehow lost admin priviledges. I had posted a question regarding DEBUG but found the answer just shortly after asking.

[browniebraun]

Some words about ReportIt 0.7.0 and a bug fix regarding the DST issue can be found here.

Best regards
-Andreas-

[feskens]

Hi all,

I'm reading al threads about the 95 percentile output but I can't find a solution that fit my needs. I've got my 95% graphs running without any problems. But instead of manually read it in the graphs I would like to get it in a simple output like a CSV or other document. Now I installed reportit but I don't get the output I want (the same as in the interface graphs).

I also read the post about the ISP billing script (allso contacted him), but I don't like to pay that amount of money for a culculation which I hope, is also possible to make in another way.

Can anybody help me with this?

Regards Frank.

[browniebraun]

Hi Frank!

Send me the report template you're using. I'll take at it this evening.

Best regards
-Andreas-