Report plugin ''ReportIt" - v0.6.1 (released 05/29/08)

crackrocksteady · Joined: 06 Dec 2006 Posts: 45 Location: Perth , Australia

Would someone be so kind as to post some instruction's on how to install under windows....

Fletch

browniebraun · Posted: Tue Feb 13, 2007 10:50 pm Post subject:

- Unpack the tar-file into the plugins folder. (It contains a folder called 'reportit')
- Edit /include/config.php and add " plugins[] = 'reportit'; "
- Then you will have to update your realm permissions under "Utilities/User Management".
- Update reportit's settings under "Configuration/Settings/Reports". Select under "RRDtool Connection" -> "RRDtool Cacti(slow)"

bengelly · Joined: 26 Jan 2007 Posts: 49

Hi,

I'm a new user to reportit and I think this plugin is great... tested it this morning and got this error:

browniebraun · Posted: Wed Feb 14, 2007 4:01 am Post subject:

At first, check your settings under "RRDtool Connection". Go to Configuration: settings/reports.
If you are using the php_binding for RRDtool under Linux it's better to select "PHP BINDINGS (FAST)".

Please edit your php.ini and check the setting "memory_limit".
For great reports (2000 data items) it should be 128M or higher.

Best regards

Andreas

bengelly · Joined: 26 Jan 2007 Posts: 49

Hi,

thanks for being so reactive... I applied you recommandations and this the error I get (look at the attached file)... note that I already have php4-rrdtool package installed !!!

also, I have one question: do I have to edit the php.ini under /etc/php4/apache2/ or /etc/php4/cli/... I edited both of them with a memory_limit of 128 Mb...

Thanks

browniebraun · Posted: Thu Feb 15, 2007 5:15 am Post subject:

Sorry, you don't have to increase the memory_limit up to 128 MB.
I've forgotten that I've optimized the code of the current release to use lesser memory. So I've just tried to create a report (with ~2000 data items, last 7 days and 8h of working time) by using a memory_limit 8 MB and it was successfull (instead of v0.3 beta). But I think Reinhard (gandalf) has said that 8 MB is not enough for Cacti or some plugins.

To give you a house number how long it takes with my linux server:

~2000 data items, last 7 days, 8h of working time, Monday-Sunday, average funktion:

So, we need 8,5% of our time to read out the rrd-files by using "PHP Bindings". 81,5% will be "loosed" for calculating and saving.
As I've written this plugin I've decided to hold the number of fetchs as little as possible. In this case we've 1957 fetchs.
By using the classic way the time to read out the rrd-files will increase to ~74% (~81% with RRDtool Server).

But why does the calculation take so long? Remember: We have 2 data sources per interface and a step of 1800s between two measuring points (MPs).
Than we've 2*48*7*1957 = ~1,3 million of MPs and "reportit" has to find the right ones for your working hours. If you have configured some special working days (e.g. Mo - Wed.) the selection of MPs will be improved by using time vectors.

>"also, I have one question: do I have to edit the php.ini under /etc/php4/apache2/ or /etc/php4/cli/... I edited both of them with a memory_limit of 128 Mb..."

To find out the correct path you can use phpinfo(). Take a look at "Configure Command" '--with-config-file-path=/ .....

>"and this the error I get (look at the attached file)..."
The error occurs because reportit looks for an extension called "rrdtool" not "RRDtool". I don't know if this versions of RPM-packet differs to the files I've uploaded, because I use to compile this extension manually.

Best regards
-Andreas-

pwan · Joined: 19 Feb 2007 Posts: 1

Excellent report plugin...

Would there be a 95th percentile in the works for the calculation function?

gandalf · Posted: Mon Feb 19, 2007 11:50 am Post subject:

You may want to consider this thread http://forums.cacti.net/viewtopic.php?t=17073
Reinhard

echelon360 · Joined: 28 Mar 2006 Posts: 24

My specs
Cacti Veri 0.8.6h
Windows xp with 2GB RAM

I have no problems creating the report template but when i start creating a report to run, i get nothing.

Example

-Create report template called MPLS
-Create new report called Hub Routers
>From here, once i create the report, nothing happens.

looking at the log, here's what i found

02/22/2007 10:58:34 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "CREATE TABLE reportit_rrdlist_0 ( id INT PRIMARY KEY, start_day VARCHAR(255) NOT NULL DEFAULT 'Monday', end_day VARCHAR(255) NOT NULL DEFAULT 'Sunday', start_time TIME NOT NULL DEFAULT '00:00:00', end_time TIME NOT NULL DEFAULT '24:00:00', timezone VARCHAR(255) NOT NULL DEFAULT 'GMT' )TYPE=MyISAM"

can someone advice what's going on pls?

browniebraun · Posted: Thu Feb 22, 2007 2:15 am Post subject:

Please give me some more details:
- Version of reportit
- Have all standard tables been created?

- Are there any other SQL errors?

>SQL Exec Failed "CREATE TABLE reportit_rrdlist_0
A zero at the end of the table's name is invalid. Maybe the table "reportit_reports" has not been created.

Best regards

Andreas

airwalk · Posted: Thu Feb 22, 2007 4:59 am Post subject:

Excellent! Works like a charm on Windows.

Thank you for the "retail" plugin!

echelon360 · Joined: 28 Mar 2006 Posts: 24

gg234 · Cacti User Joined: 07 Oct 2005 Posts: 62

I am clicking on .csv file to export in csv format i am getting the following error

Warning: fopen(/var/www/cacti//cacti_report3.csv): failed to open stream: Permission denied in /var/www/cacti/plugins/reportit/lib_int/funct_export.php on line 76

Warning: fwrite(): supplied argument is not a valid stream resource in /var/www/cacti/plugins/reportit/lib_int/funct_export.php on line 82

Warning: fwrite(): supplied argument is not a valid stream resource in /var/www/cacti/plugins/reportit/lib_int/funct_export.php on line 99

Warning: fwrite(): supplied argument is not a valid stream resource in /var/www/cacti/plugins/reportit/lib_int/funct_export.php on line 109

Warning: fwrite(): supplied argument is not a valid stream resource in /var/www/cacti/plugins/reportit/lib_int/funct_export.php on line 117

Warning: fwrite(): supplied argument is not a valid stream resource in /var/www/cacti/plugins/reportit/lib_int/funct_export.php on line 133

Warning: fclose(): supplied argument is not a valid stream resource in /var/www/cacti/plugins/reportit/lib_int/funct_export.php on line 138

Warning: Cannot modify header information - headers already sent by (output started at /var/www/cacti/plugins/reportit/lib_int/funct_export.php:76) in /var/www/cacti/plugins/reportit/cc_view.php on line 99

I have checked the /var/www/cacti/plugins/reportit/lib_int folder permissions and the permissions are fine

Thanks for your help

browniebraun · Posted: Fri Feb 23, 2007 9:31 am Post subject:

Check the csv path you've defined under settings/reports. There should not be an slash at the end of it.
I suggest to create a separate sub folder first, instead of using the root of cacti's folder in your case (/var/www/cacti//). For this folder the apache needs right access.

Best regards

-Andreas-

gg234 · Cacti User Joined: 07 Oct 2005 Posts: 62

Thanks for your help

Now i have created a new subfolder for reports with my web server users as owner and now i am having the problem of downloading the cvs file

When i click on .csv file i am seeing the following URL

http://192.169.1.41w/cacti/reports/cacti_report4.csv

I am not sure why it is showing wrong url correct url is as follows

http://192.169.1.41/cacti/reports/cacti_report4.csv

difference is after ip address it is showing extra w

Thanks for your help