Reporting: Top Talkers, busiest servers - PLUGIN AVAILABLE

[bradley]

See the URL in one of my original posts

http://forums.cacti.net/viewtopic.php?p=60241#60241

--
Brad.

[twelzy]

bradley,

I have some suggestions:

• - Option to choose the Consolidation Function (average, minimum, maximum, last) we want to view in the Report Plugin;
  (In some cases we want to see the average values, in others, the maximum values...)
  
  - Option to choose the Data Sources of a Graph/Data Template;
  (In graphs like Memory Utilization of a Unix/Linux host, I think that the important DSs to be reported/analysed are Phisical/Swap Memory Used, and not Phisical/Swap Memory Free...)

What do you think about?!

Thanks in advance!
(...and sorry for my poor English!)

[s16pt]

bradley,
Would you describe the installation more detailly ?
I follow your steps but I didn't get any Report buttom.
I would like to use this report function hungry.

Need your help .

Thanks.

[henryd31]

Still no word on this, can anyone advise ?

Here is what I get, does that tell you anything ? I am running on a FC3 and all the packages are rather old, they're running most updated ones available thru packages, but this being fc3 does not mean much...

mysql> show columns from plugin_reports;
+----------------------+---------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+---------+------+-----+---------+----------------+
| id | int(11) | | PRI | NULL | auto_increment |
| report_definition_id | int(11) | | MUL | 0 | |
| date_processed | int(11) | | | 0 | |
+----------------------+---------+------+-----+---------+----------------+
3 rows in set (0.00 sec)

mysql> show columns from plugin_report_items;
+---------------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------------------+--------------+------+-----+---------+----------------+
| id | int(11) | | PRI | NULL | auto_increment |
| report_id | int(11) | | MUL | 0 | |
| local_graph_id | int(11) | | | 0 | |
| consolidation_function_id | int(11) | | | 0 | |
| graph_item_name | varchar(255) | | | | |
| graph_item_units | varchar(255) | | | | |
| graph_item_value | double | YES | | NULL | |
+---------------------------+--------------+------+-----+---------+----------------+
7 rows in set (0.00 sec)

Falvour, in short, update DBI and DBD::mysql to the latest versions:


"for those having problems the report_id column of the plugin_report_items table will be NULL when it should not be. Can you confirm this?"

Brad.

[tobru]

hi

I tried to get this reports running on windows, but until now didn't have success.
On the website it shows only values of 0.
When I run the runReports.pl I see some error messages: "RRD Export Failed: Cannot parse DS in 'DEF:a=d:/wwwroot/monitoring.domain.ch/rra/sui_internet_traffic_in_206.rrd:cpu:AVERAGE'"
I use rrdtool version 1.2.12 (cygwin) in cacti, but the perl module for windows provided by tobi oetiker is version 1.2.10.
Is this a problem?

Best Regards
Tobias

[pepj]

Hi

Severall bugs after creating a "reports configuration" :
1/ when I save without graph template & save
--> Save OK. But no report are shown in "report_settings.php" !!!
--> You have no more chance to remove it
2/ you can create several reports with the same name !!!
3/ when you have create a good "report setting". If you later want to change something and choose for example "Data Template" or "Graph Template" the option "select one".
--> Save OK. But no report are shown in "report_settings.php" !!!
--> You have no more chance to change or remove it

A/ Could you also put a "paused/active" report setting ? Sometime we want to inactive a report scheduling but not remove it.

B/ will you put the option of "reports of Gigamits" in order to send E-mails ?

PS: I have seen you have the realms 60/61 for your plugin like my upload/download switch-router configuration. I will ask Gigamit, if there is a possibility/function to avoid these conficts.

Thanks
Jean-Michel

[flavour]

PS: I have seen you have the realms 60/61 for your plugin like my upload/download switch-router configuration. I will ask Gigamit, if there is a possibility/function to avoid these conficts.

In the absence of an automated method, here is the 'official' place for registering your realm IDs to avoid conflicts:
http://cactiusers.org/wiki/PluginRealms

F

[Exo7]

thanks for this great addon, it is working quite fine

I have tried to do some unexpected actions in the gui to find some bugs.
So far, I found one :
when selecting the same lower & higher bandings, the following error popup :
Notice: Undefined offset: 0 in /usr/share/cacti/site/plugins/reports/report_view.php on line 407
Notice: Undefined offset: 0 in /usr/share/cacti/site/plugins/reports/report_view.php on line 410

As others noticed, the daily reports produced so far seems to include only 23 hours of data

[bradley]

Thanks for the feedback Exo7,

Just to let you (and others) know, I am working on the fixes to the bugs mentioned here and
will publish a new version in the next few days.

--
Brad.

[jwatt]

Hi Bradley,

I really want to use your plugin, it seems very useful.

However, I'm having some trouble getting it to work.

I am running the Cacti 0.8.6h_41 port on FreeBSD 5.4 Stable Release.

Perl 5.8.8 and RRDTool 1.2.12_1.

I have the Cacti plugin arch installed and have a few plugins running fine.

I have followed your instructions from the beginning of this topic. I added one report using the web interface and then tried running runReports.pl manually:

# perl runReports.pl 1 -start
Using Data Template ID: 56 at runReports.pl line 546..


I had one issue with the instructions and that is that I don't have anywhere on my system a folder like /usr/local/rrdtool-1.2.11/lib/perl and I'm not sure what contents I that folder would usually contain so that I could locate the equivalent on my system.

I tried replacing the use lib qw( /usr/local/rrdtool-1.2.11/lib/perl ); line in my runReports.pl with other rrdtool modules to no effect.

Any clues as to why this might not be running?

Thanks!

J

[karthi]

HI,

In report how to create the tables -- which all tables need to create

pls help and perl the runReports.pl is not working please help on this

[bradley]

Jwat,

On FreeBSD systems where you have installed RRD-tool from the ports
collection, the required perl modules are actually installed in
/usr/local/lib/perl5/site_perl and so this line is not actually required.
If you comment it out altogether then it should work fine.

Karthi, when you log into Cacti with the web-front-end for the first time
after installing the plugin, the tables in the database will get created
automatically. Once you've logged in then you should be able to run the
report generator (runReports.pl).

Hope this helps!

--
Brad.

[Pumpi]

Hello,
when I run runReports.pl I get following error:

Using Data Template ID: 41 at /srv/www/htdocs/cacti/plugins/reports/runReports.pl line 546.
RRD Export Failed: Garbage ':' after command:
XPORT:cdefa:Inbound :

Any idea ?

Pumpi

[bradley]

Attached is the latest version of the Cacti Reports. Please download
it from the following URL:

http://www.kitefamily.co.uk/cacti-reports.zip

The most significant change is the ability to report on "real-time" values.

The periodic reports now calculate max/min/avg figures which you can
switch between on the web-front-end.


--
Brad.

[knobdy]

How do you report on the real-time values? Do you launch it manually, via CLI?

Is there a way to wipe the old reports, programmatically I mean?