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

[Jem]

Thanks and sorry for the stupid question

[browniebraun]

No, it wasn't a stupid question!

Best regards
-Andreas-

[Toons59]

Hi,

How can I find which Architecture plugin version I'm using ?
I'm trying to install "Reportit plugin" but I'm totally lost in the different steps.
I'm using the latest version of cacti. Should have I to upgrade Architecture plugin before, or is the Architecture plugin already up to date ?

Thanks (and sorry for my poor english writing )

[browniebraun]

Hi,

How can I find which Architecture plugin version I'm using ?
I'm trying to install "Reportit plugin" but I'm totally lost in the different steps.
I'm using the latest version of cacti. Should have I to upgrade Architecture plugin before, or is the Architecture plugin already up to date ?

Thanks (and sorry for my poor english writing )

Mmmh. I always wonder which version of the PIA belongs to which version of older releases like 0.8.6i, so you're not the only one.
If you're using Cacti 0.8.7b you should use PIA 2.1 or 2.2beta.
Where did you loose the thread?

Best regards
-Andreas-

[Toons59]

Firstly, I didn't have a plugins subfolder in my cacti folder (It's why I'm wondering which is my PIA version). So I created it and unzip the archive on it (C:\Inetpub\wwwroot\cacti\plugins\reportit).
After, when I take a look at my global.php file, there's not a section relating to plugins (unlike to the global.php file in the last PIA version).

$plugins = array();
//$plugins[] = 'thold';

So, I added this in my global.php file:

$plugins = array();
$plugins[] = 'Reportit';

But nothing news appears in my realm permissions.

I did the same in my config.php file and obtained the same results ... i.e nothing !

[browniebraun]

Firstly, I didn't have a plugins subfolder in my cacti folder (It's why I'm wondering which is my PIA version). So I created it and unzip the archive on it (C:\Inetpub\wwwroot\cacti\plugins\reportit).
After, when I take a look at my global.php file, there's not a section relating to plugins (unlike to the global.php file in the last PIA version).

$plugins = array();
//$plugins[] = 'thold';

So, I added this in my global.php file:

$plugins = array();
$plugins[] = 'Reportit';

But nothing news appears in my realm permissions.

I did the same in my config.php file and obtained the same results ... i.e nothing !

The standard version of Cacti does not contain the PIA (not yet), so you have to install it first. (see www.cactiusers.org)
Overwrite the existing files of Cacti with the patched ones contained the archive. After that check/update your MySQL settings in "/include/global.php" and then you're back on track.

Best regards
-Andreas-

[killshoot]

Hi all,

I've successfully installed reportit

But... It's difficult to find information about how to configure it. I can't find the mentionnened powerpoint on the first page of this thread.

Is there a tutorial anywhere?

Best regards,

Vince

[Toons59]

The standard version of Cacti does not contain the PIA (not yet), so you have to install it first. (see www.cactiusers.org)
Overwrite the existing files of Cacti with the patched ones contained the archive. After that check/update your MySQL settings in "/include/global.php" and then you're back on track.

Ok, I'll do that.

Thanks for your help

[bgp2002]

I get a segmentation fault from CLI in runtime.php at this line:
$rrd_data = rrd_fetch($data_source_path, $rrd_options, count($rrd_options));

This happens only (with php_bindings) from the commandline, not from webinterface

All software and OS 64-bit
Red Hat Enterprise Linux Server release 5.2
OS: 2.6.18-92.1.1.el5 #1 SMP Thu May 22 09:01:47 EDT 2008 x86_64 x86_64 x86_64 GNU/Linux
rrdtool: rrdtool-1.2.27-3.el5
php: php-5.1.6-20.el5
php_bindings: rrdtool-php-1.2.27-3.el5
cacti: 0.87b (with pa 2.1 and patches)
spine: 0.87a (self-compiled)

With 32-bit and mandriva, I don't have the problem. Unfortunately the 64-bit fedora is our production system

[browniebraun]

I get a segmentation fault from CLI in runtime.php at this line:
$rrd_data = rrd_fetch($data_source_path, $rrd_options, count($rrd_options));

This happens only (with php_bindings) from the commandline, not from webinterface

All software and OS 64-bit
Red Hat Enterprise Linux Server release 5.2
OS: 2.6.18-92.1.1.el5 #1 SMP Thu May 22 09:01:47 EDT 2008 x86_64 x86_64 x86_64 GNU/Linux
rrdtool: rrdtool-1.2.27-3.el5
php: php-5.1.6-20.el5
php_bindings: rrdtool-php-1.2.27-3.el5
cacti: 0.87b (with pa 2.1 and patches)
spine: 0.87a (self-compiled)

With 32-bit and mandriva, I don't have the problem. Unfortunately the 64-bit fedora is our production system

Please take a look at the following postings:

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

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


Best regards
-Andreas-

[bgp2002]

Thank you for your great and super fast support. Thanks for the links. I will try to recompile php and rrdtools

[rtorti19]

I managed to read through most of this thread, but might have missed a couple sections, so forgive me if this has already been asked.

Has anyone figured out a way to add multiple data templates to a single report? From what I see it doesn't look to be possible at this time unless someone has come up with a work around.

[toe_cutter]

Hi

I like the idea of reportit, but damn is it hard to figure out what to do to create a report
Currently im trying to figure out how to get top10 bandwidth using interfaces but its not easy...

Anyway, i managed to create one report, after that im getting this error:

Code: Select all

09/15/2008 04:38:55 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"SELECT a.*, b.*, c.name_cache FROM reportit_results_1 AS a INNER JOIN reportit_rrdlist_1 AS b ON a.id = b.id INNER JOIN data_template_data AS c ON c.local_data_id = a.id WHERE c.name_cache LIKE '%%%%' ORDER BY spanned__1 DESC LIMIT 0,30"

And in phpmyadmin:

Code: Select all

SQL query: 

SELECT a . * , b . * , c.name_cache
FROM reportit_results_1 AS a
INNER JOIN reportit_rrdlist_1 AS b ON a.id = b.id
INNER JOIN data_template_data AS c ON c.local_data_id = a.id
WHERE c.name_cache LIKE  '%%%%'
ORDER BY spanned__1 DESC 
LIMIT 0 , 30

MySQL said: 

#1054 - Unknown column 'spanned__1' in 'order clause'

Ideas?

Edit: Solved by removing Report configuration and adding it again. Seems to happen when i change a Report template or one of its measurands/variables, dont know which.

[browniebraun]

Edit: Solved by removing Report configuration and adding it again. Seems to happen when i change a Report template or one of its measurands/variables, dont know which.

Hi!
Can you try to reconstruct that issue, please?

Best regards
-Andreas-

[browniebraun]

I managed to read through most of this thread, but might have missed a couple sections, so forgive me if this has already been asked.

Has anyone figured out a way to add multiple data templates to a single report? From what I see it doesn't look to be possible at this time unless someone has come up with a work around.

Currently not, but I'll work on it. At first I've to finish some other jobs. (Import/export of report templates, multiple export to spreadsheetML, report templates with more than one consolidation function (average, min, max, last)).

Best regards
-Andreas-