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

[gandalf]

Hey, that's a marvellous plugin, Andreas!
The new forumlae extensions are GREAT!
But I must admit, that I did not yet understand everything. Especially the "variable" stuff hurts me. I tried to copy settings from your "Interface Traffic" measurables screenshot, but the variable stuff won't work.
And I'm _really_ impressed by all those links and shortcuts to create a Report Template and Reports themselves!
But some questions are left:
- is it possible/planned, to export/import report templates?
- if not, would it be a good idea to ship some few report templates with the plugin to ease usage for first-time-users like me? Perhaps as a SQL file? I volunteer for creating some of them.
- is scheduling of reports possible? Did I miss sth?

And still I'm comparing results to other sources (e.g. Total bandwidth, 95th percentile ...)

Reinhard

[zeki]

i found that for total in and total out is just f_sum*step. i called the measurand abbreviation AOD
in his picture it it multiplied by 8.
for sum of total in + totalout = its (AOD:traffic_in+AOD:traffic_out)

i also unchecked visible for aod, but it is still visible in the reports

[browniebraun]

Good morning Cacti community!

- is it possible/planned, to export/import report templates?
Not at the moment. It's planned for a later release. The final version v0.4.0 won't support it.
- if not, would it be a good idea to ship some few report templates with the plugin to ease usage for first-time-users like me? Perhaps as a SQL file? I volunteer for creating some of them.
Yes.
- is scheduling of reports possible?
Yes.
in his picture it it multiplied by 8.
I have choosen 'Bits' as unit, so that it has to be multiplied with 8 in this case.
i also unchecked visible for aod, but it is still visible in the reports
Yes, you're right. The alpha version has some bugs and parts without function.

Best regards
-Andreas-

[browniebraun]

-Andreas-

Is it possible to change the names of the datasources. Now we only have the interface name (not even the alias) and for the people who have to read the report that is not very handy. They prefer the computer name connected to the port instead of the portname.

Great plugin though,

Michael

Reportit v0.4.0 will support additional subheads. I think this should be in your sense.
Many thanks for your idea!

Best regards
-Andreas-

[tclark]

Great plugin! I've been using the v4.0a version creating reports etc without problems until this morning. This is the error in the cacti.log.

04/22/2007 11:12:55 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "ALTER TABLE `poller_time` ADD COLUMN `pid` INTEGER UNSIGNED NOT NULL DEFAULT 0 AFTER `id`;"


any ideas?

[browniebraun]

Great plugin! I've been using the v4.0a version creating reports etc without problems until this morning. This is the error in the cacti.log.

04/22/2007 11:12:55 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "ALTER TABLE `poller_time` ADD COLUMN `pid` INTEGER UNSIGNED NOT NULL DEFAULT 0 AFTER `id`;"


any ideas?

Hi tclark,
At first this SQL call won't be executed by reportit.
But please check if you have added or changed a report so that the time span for reporting includes a change of DST. Jorge (aka tgk) has found that this old alpha version will run into a infinite loop under this conditions. Take a look at your process list.

Best regards
-Andreas-

[browniebraun]

Hi Cacti Community!

Here it is: ReportIt v0.4.0

Please take a look at the readme.txt before installing this plugin! Versions of "reportit" prior to 0.4.0 has to be completely (mysql tables as well) uninstalled! Its also not compatible with the alpha version!
I hope you'll enjoy this new version although I know that it is a little bit complex.


A second developer has teamed up with me: Gandalf
At the moment we're working on some documentation and the next release v0.5.0.

Last but not least:

Many, many thanks to the testers for your great ideas and improvements:

• Clive Barker
  Jorge Prado
  Taka Masuda

Best regards
-Andreas-


-Download removed- (06/28/07)

[tclark]

You mention all previous version must be uninstalled including the alpha version. Can you provide the steps to remove the mysql tables from the alpha version as part of the uninstall?

Thanks in advance.

[browniebraun]

Okay, here is a little script for uninstalling that I've written this morning between showers and breakfast. I've found no errors but I've only made a short test on my two servers.
Put it into your reportit folder and start it from the command line interface.

Best regards
-Andreas-

[wrusman]

Hello,
When trying to get reportit 0.4.0 running on windows i got the problem stated in the README

Code: Select all

----[ Well-known Bugs
    Some systems aren't able to save new report configurations. Seems to be a SQL issue.

It seems the MySQL installer on windows runs mysql in strict mode by default.

In my.ini add a comment sign (#) in front of the line

Code: Select all

sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" 

and restart mysql.

I also had to remove the reportit tables and let cacti create them again to make it work.

All that is left is the question wether it is still necessary rrdtool has to run as a service and listen to port 13900/tcp, because i wonder how to do this in windows

[browniebraun]

All that is left is the question wether it is still necessary rrdtool has to run as a service and listen to port 13900/tcp, because i wonder how to do this in windows

But it's possible with Linux.


ReportIt supports three ways to connect with rrdtool:

• RRDTOOL CACTI (SLOW) -> Windows, Linux
  RRDTOOL SERVER (SLOW) -> Linux (requires that rrdtool runs as service)
  PHP BINDINGS (FAST) -> Linux (requires the php binding for RRDtool)

Compiling the php bindings for Windows seems to be possible (http://www.gknw.de/phpbb/viewforum.php?f=17) but I've no experiences how to do this and I've never tried one of these versions.

Best regards
-Andreas-

[tclark]

The uninstall you provided worked great and was able to successfully install the new version, thanks for you efforts.

After installing the new version, I did notice a small bug. When exporting to .csv, under user managment, graph settings tab you can select the "Decimal Seperator" to be either a comma or a decimal point. If comma is selected it properly places the comma in the .csv output, but if decimal point is selected, it places a semi-colon in the .csv output.

[wrusman]

But it's possible with Linux.

I know, that's what's running at my home network...
But these *@#$%& managers want me to run it on windows at work

ReportIt supports three ways to connect with rrdtool:

• RRDTOOL CACTI (SLOW) -> Windows, Linux
  RRDTOOL SERVER (SLOW) -> Linux (requires that rrdtool runs as service)
  PHP BINDINGS (FAST) -> Linux (requires the php binding for RRDtool)

so it's not needed for windows to run it as a daemon when using RRDTOOL CACTI ... That is what i needed to know, thanks

[FinboySlick]

I'm using RRDTOOL CACTI as a connection. Cacti 0.8.6j, php 5, mysql 5 and reportit 0.4. Everything works fine as long as I don't use f_avg in an mesurand. If I do, all the other mesurands (including f_max, f_min) turn to value "NA". It's a bummer because f_avg is exactly the one I need.

Is there a way to get a bit more debugging info as to what calls are being made and where the error could present itself?

I've posted a couple screenshots for clarity.

Thanks

[browniebraun]

The current version does not have a debug mode.

Can you post an overview with your measurands like I did in http://forums.cacti.net/viewtopic.php?p=96475&highlight=#96475, please? And please add the template configuration (data template, consolidation function).

Best regards,
-Andreas-