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

mcutting · Cacti Pro User Joined: 16 Oct 2006 Posts: 989

Hi BrownieBraun,

When will this great plugin have the ability to monitor other data sources, for example, i'd like to choose my own, rather than the drop-down list ?

Regds

browniebraun · Posted: Mon Feb 26, 2007 2:48 pm Post subject:

Hi Cacti community!

Sorry for my late answer, but I'm a little busy at the moment.

I've uploaded the current version v0.3.1. It includes 3 bug fixes / changes:

- (a)Fixed definition of table reportit_reports
- (b)Separate sub folder for csv export (The webserver needs read/write access for it.)
- (c)Export header has been moved from "graph settings" (user) to settings/reports (global)

a: There seems to be some versions of MySQL which are not able to translate BOOL into TINYINT. To my dishonor I've to admit that I've only worked with Microsoft SQL Servers before, so I write automatically and unconsciously in this syntax sometimes.
b: I think it would be better to hold the plugin and it's export files together, because it isn't guaranteed that the necessary server variables are available on every system.
c: IMO, it makes more sense to maintain an universal header for every csv file.

>When will this great plugin have the ability to monitor other data sources, for example, i'd like to choose my own, rather than the drop-down list ?
v0.4 will give you the option to create your own measurands. Some test script are running on my Linux Server, so I'm working on it.

Best regards
-Andreas-

zeki · Joined: 09 Feb 2007 Posts: 47

fmangeant · Posted: Wed Feb 28, 2007 3:17 am Post subject:

fmangeant · Posted: Wed Feb 28, 2007 5:33 am Post subject:

mcutting · Cacti Pro User Joined: 16 Oct 2006 Posts: 989

Ditto - I would like to be able to run reports on the data sources I have...

egarnel · Posted: Wed Feb 28, 2007 9:50 am Post subject:

browniebraun · Posted: Wed Feb 28, 2007 2:02 pm Post subject:

Hi Cacti community!

>i don't know where the php root is. possibly /var/lib/php? or /usr/lib64/php4?
Take a look at this posting, but you can use "reportit" without php bindings too.

>what happens to reportit after i untar it? should i put it in the cacti folder and overwrite some files or setup a web folder for it?
It's the same like installing one of the other plugins:
- Install Jimmy's plugin architecture if don't have it.
- 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".
- Check that your web server has read/write permissions for the csv folder (reportit/exports/csv)
- If you are running Cacti on Linux/Unix you can install the php bindings for RRDtool additionally.

>Do you have any ETA for the 0.4 release ?
End of march. (to Fizz: 4 Yusufs

)
Some parts of it are finished, but there a some changes of reportit's table architecture necessary. So, I'll have to write a script for updating previous versions to v0.4 additionally.

Best regards
-Andreas-

mcutting · Cacti Pro User Joined: 16 Oct 2006 Posts: 989

Just a question - if most of it is finished, but you need to write an upgrade script, could the likes of me not just drop the existing tables, and start from scratch using the newer version ? Really keen to try the new version out.

Thanks

fmangeant · Posted: Thu Mar 01, 2007 4:18 am Post subject:

Skram · Joined: 01 Mar 2007 Posts: 2 Location: Boeblingen, Germany

Hi together,

does anybody use the cron job to process a daily report?
Because i would like to get a daily report of the average interfaces traffic from last day. Therefore I've created already some reports in reportit.
But with following cron job,
----------------------------
#Daily
0 0 * * * /usr/bin/php /var/www/html/cacti/plugins/reportit/runtime.php -d > /dev/null 2>&1
----------------------------
I've got always following error:
-----------------------------------------
PHP Warning: Call-time pass-by-reference has been deprecated - argument passed by value; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. However, future versions may not support this any longer. in /var/www/html/cacti/plugins/reportit/runtime.php on line 467
PHP Warning: Call-time pass-by-reference has been deprecated - argument passed by value; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. However, future versions may not support this any longer. in /var/www/html/cacti/plugins/reportit/runtime.php on line 467
PHP Notice: Undefined index: SCRIPT_FILENAME in /var/www/html/cacti/plugins/reportit/runtime.php on line 36
Content-type: text/html
X-Powered-By: PHP/4.3.9
-----------------------------------------

I use already version 0.3.1, but saw this problem also in version 0.3.0.
Does anyone had the same problem?
Any hints or solutions are welcome.

browniebraun · Posted: Thu Mar 01, 2007 7:38 am Post subject:

So, erst mal viele Gruesse von Koeln nach Boeblingen!

Thank you for posting this bug. The issue is that the call of this function in line 467 includes references. Normally references should be defined in the declaration part. This is not forbidden but it's really ugly. I'll change it.

Best regards
-Andreas-

browniebraun · Posted: Thu Mar 01, 2007 3:12 pm Post subject:

browniebraun · Posted: Fri Mar 02, 2007 2:36 am Post subject:

Skram · Joined: 01 Mar 2007 Posts: 2 Location: Boeblingen, Germany

Hallo Andreas, Gruesse nach Koeln.
Don't forget your rainwear for "Foehr".

Many thanks for your fast help. I've test the new version right this morning and the cron job works now without errors.

Nevertheless the corn job works daily, but my created daily reports were not updated. From my knowledge this reports should be updated every day (configuration below) with the cron job?

It would be useful the csv files would created automaticaly and not only after clicking on ".csv" and/or send this reports via sendmail. Maybe as option in version 0.4.

I will think about to participate on the next beta tests.