Reporting: Top Talkers, busiest servers - PLUGIN AVAILABLE

[gandalf]

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.

Bradley,
I appreciate the effort you've put into this plugin. Currently, I'm struggeling wth the installation, cause there are duplicates with the reports plugin found at http://cactiusers.org. So I second the request of pepj and flavour to coordinate not only the realms but also the names of plugins. As cigamit is with the cacti devs team to create cacti 0.9, I suppose it would be best to talk to him.
I hope to resolve all those issues and would be able to post an updated set of files, if, and only if you would like it.
Reinhard

[gandalf]

Please find attached a patch to the latest version of Bradley and a full zip archive with the following changes:

- changed "reports" to "cactireports" to avoid duplicates with another plugin called reports So this plugin must be registered in config.php as "cactireports"
- changed realm id's from 60 to 70 and from 61 to 71 to avoid duplicates with already existing plugins (see above)
- fixed an issue with new table column named "enabled" that was not created on fesh installs

Apply the patch using

Code: Select all

patch -bp1 < cactireports.patch

from the plugins directory. Please notice, that I've uncommented the path to the perl RRDs.pm. If you need it, please uncomment and rename it to teh correct path of your installation of RRDs.pm

Reinhard

[gandalf]

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.

Please find my patch above to cope with this. But, having looked at cigamits realm list lately, I can't find your numbers in there
Reinhard

[Arsemis]

Somebody smack me if I'm asking a dumb question here, but I've downloaded the most recent cactireports.zip and patch (see above), enabled the plugin and have the ability to create a Report Name, however, I'm seeing some SQL errors when I visit the Report tab, perhaps someone can point me in the correct direction to solve this issue;

11/01/2006 08:32:12 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "SELECT
plugin_cactireport_last_values.id,
plugin_cactireport_last_values.local_graph_id,
plugin_cactireport_items.consolidation_function_id
graph_templates_item.text_format,
graph_templates_graph.vertical_label,
plugin_cactireport_last_values.graph_item_last_value as graph_item_value
FROM
plugin_cactireport_last_values,
graph_templates_item,
graph_templates_graph
WHERE
report_definition_id =
AND
plugin_cactireport_items.local_graph_id = graph_templates_item.local_graph_id
AND
plugin_cactireport_items.graph_item_id = graph_templates_item.id
AND
plugin_cactireport_items.local_graph_id = graph_templates_graph.local_graph_id
"
11/01/2006 08:32:12 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "SELECT DISTINCT
plugin_cactireport_last_values.graph_item_id,
graph_templates_item.text_format
FROM
plugin_cactireport_last_values,
graph_templates_item
WHERE
graph_templates_item.id = plugin_cactireport_last_values.graph_item_id
AND
plugin_cactireport_last_values.report_definition_id = "

The databases do exist;

| plugin_cactireport_definitions |
| plugin_cactireport_items |
| plugin_cactireport_last_values |
| plugin_cactireports |

So do the columns;

+------------------------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------------------------+------------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| report_name | varchar(255) | YES | | NULL | |
| data_template_id | int(11) | YES | | NULL | |
| graph_template_id | int(11) | YES | | NULL | |
| rra_id | int(11) | YES | MUL | NULL | |
| include_data_from_start_hour | int(11) | YES | | NULL | |
| include_data_from_end_hour | int(11) | YES | | NULL | |
| include_data_from_start_day | int(11) | YES | | NULL | |
| include_data_from_end_day | int(11) | YES | | NULL | |
| enabled | enum('on','off') | NO | | on | |
+------------------------------+------------------+------+-----+---------+----------------+


This is Cacti Version 0.8.6h running on FC5,
mysql Ver 14.12 Distrib 5.0.22
perl v5.8.8

Let me know if you need any additional information...

[bambid]

I have same problem, I think there is missing SQL file for creation of tables which are needed for this plugin.

Another problem is, that there are missing at least on PHP file

http://....../cacti/plugins/cactireports/data_templates.php

Thanks



David

[gandalf]

To all,

my patch was primarily addressed to the author and should be committed by him. I do not feel encouraged changing this template without approval of the author himself
Reinhard

[Arsemis]

To all,

my patch was primarily addressed to the author and should be committed by him. I do not feel encouraged changing this template without approval of the author himself
Reinhard

Completely understandable, did not mean to step on any toes doing so. I used the author's original plugin, with similar problems (enabled not added, so I added it myself) I was trying your patch to see if it fixed my other issues. I'll just be patient, and if not, I'll learn how to code plug-ins myself!

[gandalf]

11/01/2006 08:32:12 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "SELECT
plugin_cactireport_last_values.id,
...WHERE
report_definition_id =
AND
..."
11/01/2006 08:32:12 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "SELECT DISTINCT
plugin_cactireport_last_values.graph_item_id,
...plugin_cactireport_last_values.report_definition_id = "

Please perform

Code: Select all

SELECT *
FROM `plugin_cactireport_last_values`
LIMIT 0 , 30

to see, if there's data in that table.
Reinhard

[Arsemis]

Please perform

Code: Select all

SELECT *
FROM `plugin_cactireport_last_values`
LIMIT 0 , 30

to see, if there's data in that table.
Reinhard

MySQL returned an empty result set (i.e. zero rows). (Query took 0.0006 sec)

Obviously, that's why the query is failing, no data...

Additional notes, the SELECT fails when initially opening up the Reports tab in Cacti. The Cron job is set (I have also run it manually), the report type is available, and there are also report dates listed, but not data.

Don't really worry about, I know you have much more going on than trying to help fix my issue.

[gandalf]

But you did create a report (see first image)?
And then you've run it (see second image)?
Reinhard

[bambid]

Our major problem is, that we do not get any data. I tried to launch runReports.pl manually :

perl /usr/local/groundwork/cacti/plugins/cactireports/runReports.pl 1

and got this message :

Using Data Template ID: 19 at /usr/local/groundwork/cacti/plugins/cactireports/runReports.pl line 636.

I do not know if this is an error, but I does not pull any data in database.


David

[Arsemis]

But you did create a report (see first image)?

Yes...

And then you've run it (see second image)?

Also, yes...

[tbaror]

Hello All,

I have added a nice plug-in "Reporting: Top Talkers " by using the cactireports who is the only one showing reports setting after adding it and its shows the reports but I have few major issues.
There is no data showed on reports and on cacti log there

[ebuttice]

Hi All,

I read through all the postings I could find on the subject of getting cactireports running but I still can't get it to work.

I can see the report tab in cacti and the report settings option in Console.
report settings shows no reports.

I get the following when running runReports.pl :
No report definitions found for RRA ID --start at ./runReports.pl line 154

The tables seem to be empty.

plugin_cactireport_definitions
plugin_cactireport_items
plugin_cactireport_last_values
plugin_cactireports


Also, there is still the issue of that missing file http://....../cacti/plugins/cactireports/data_templates.php


I had lots of trouble with RRDs.pm, is there a way to avoid using this and still get things to work ?



Environment

Redhat AS 4
RRDtool 1.0.49
Cacti-0.8.6i
PatchArchitecture
Latest cactireports and patch cactireports_668
PHP 4.4.2-1+b1


Thanks

[ravton]

v0.3 is UNOFFICIAL! I posted since the creators web site has been down for a long while.

This contains multiple patches that have been posted to the forums.

Other Improvements & Fixes:
Fixed bugs in SQL
Fixed reports so they always display in the "Report Settings" view.
Fixed runReports.pl so it works with non SNMP data
Added "Clear Reports" to actions.

This has worked for 2 installs - better then the original (at least on Unix - not tested on Windows)