Reporting: Top Talkers, busiest servers - PLUGIN AVAILABLE

[gandalf]

[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

[gandalf]

[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]

[gandalf]

[Arsemis]

[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]

[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)