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

[linuxmancy]

Hello!

Just got ReportIt 0.6.1 installed in Cacti 0.8.7b. Things are looking okay so far - created a report template and am about to create a report. I noticed something very odd when I tried to actually CREATE the report, however.

Notice anything missing? That's right! A Save or a Next button! Also, two of the three tabs are greyed.

http://i31.tinypic.com/2qn019i.png

Am I missing something, or just going insane? I granted all ReportIt permissions to this user. The PHP version is 5.2.4, Fedora 7, Cacti 0.8.7b, plugin arch 2.1.

Thanks in advance! My supe's been riding me all day to get this working, and I think I'm nearly there.

[browniebraun]

I assume that your MySQL server does not support the newer varchar type with more than 255 chars. (ReportIt requires MySQL 5.0.3 or higher)
Please check if the following default tables are in your Cacti DB:

Code: Select all

reportit_cache_measurands    0  MyISAM  latin1_swedish_ci   OK
reportit_cache_reports       0  MyISAM  latin1_swedish_ci   OK
reportit_cache_variables     0  MyISAM  latin1_swedish_ci   OK
reportit_measurands         20  MyISAM  latin1_swedish_ci   OK
reportit_presets             7  MyISAM  latin1_swedish_ci   OK
reportit_recipients          8  MyISAM  latin1_swedish_ci   OK
reportit_reports             7  MyISAM  latin1_swedish_ci   OK
reportit_rvars               2  MyISAM  latin1_swedish_ci   OK
reportit_templates           8  MyISAM  latin1_swedish_ci   OK
reportit_variables           8  MyISAM  latin1_swedish_ci   OK

If there are some tables missing then implement the patch for older MySQL versions.

Best regards
-Andreas-

[palbandoz]

Is there any way to add different fields in the same graphs? I mean that I'd like to create combined report graphs that include, i.e. incoming and outgoing traffic measurands.

The only kind of graphs I've noticed are the default "1-measurand - many-Dataitems" ones.

Thanks

[jcotton]

aaa.

[browniebraun]

Is there any way to add different fields in the same graphs? I mean that I'd like to create combined report graphs that include, i.e. incoming and outgoing traffic measurands.

The only kind of graphs I've noticed are the default "1-measurand - many-Dataitems" ones.

Thanks

I've planned to integrate that feature in a later release, but it's not on the top of my "to-do-list".
Next release will have an extensions for "multiple exports".

Best regards
-Andreas-

[linuxmancy]

OK, apparently I needed to leave the Variables screen alone when creating the report template. It works now. *head desk*

[palbandoz]

Thanks for the last answer... here you are a new one (the last I guess):
how can I export-import my Report Templates? I know (you told me, Andreas) that this feature doesn't exist right now, but you suggested me to try it by copying something on the databases. Will you explain me (us) exactly what should I do in which database(s) to export and import the related tables?

Thank u again.

[jcotton]

fixed

[browniebraun]

Thanks for the last answer... here you are a new one (the last I guess):
how can I export-import my Report Templates? I know (you told me, Andreas) that this feature doesn't exist right now, but you suggested me to try it by copying something on the databases. Will you explain me (us) exactly what should I do in which database(s) to export and import the related tables?

Thank u again.

Hi palbandoz,

here's is a little example you can use to copy existing templates from an existing instance of ReportIt to a new (fresh) one.
Please do not use it to transfer templates to a an existing installation of ReportIt, because the correlation of indexes will fail in that case.
I guess it's time to plan the introduction of an ex- and import function in 0.6.4.

Best regards
-Andreas-

Code: Select all

Export:
mysqldump -u<cactiuser> -p<Password> <Cacti Database> reportit_templates reportit_variables reportit_measurands > templates.sql

Import:
mysql -u<cactiuser> -p<Password> cacti < templates.sql


e.g.:

C:\MySQL\bin>mysqldump -ucactiuser -pcactipw cacti reportit_templates reportit_variables reportit_measurands > templates.sql

C:\MySQL\bin>mysql -ucactiuser -pcactipw cacti < templates.sql

[browniebraun]

When i click to view a report I get the following error:

Abort pclzip.lib.php : Missing zlib extensions

Here is the output of php -m:

[PHP Modules]
ctype
mysql
oci8
overload
pcre
posix
session
snmp
standard
tokenizer
xml
zlib

Any ideas what is going wrong?

Cacti 0.8.7b
MySQL 4 (patched)
PHP 4.3.9

To ensure that Zlib is working Pclzip checks if a function called "gzopen" is available. If it's not defined then it will end with the error message above. To be honest I haven't checked that feature with PHP 4, but it's compatible to PHP4. Anybody here who use it with that version?
So, please check which version of Zlib you're using. You can also try to compile Zlib 1.2.3 and to include it as a dynamic library.

Best regards
-Andreas-

[jcotton]

When i click to view a report I get the following error:

Abort pclzip.lib.php : Missing zlib extensions

Here is the output of php -m:

[PHP Modules]
ctype
mysql
oci8
overload
pcre
posix
session
snmp
standard
tokenizer
xml
zlib

Any ideas what is going wrong?

Cacti 0.8.7b
MySQL 4 (patched)
PHP 4.3.9

To ensure that Zlib is working Pclzip checks if a function called "gzopen" is available. If it's not defined then it will end with the error message above. To be honest I haven't checked that feature with PHP 4, but it's compatible to PHP4. Anybody here who use it with that version?
So, please check which version of Zlib you're using. You can also try to compile Zlib 1.2.3 and to include it as a dynamic library.

Best regards
-Andreas-

I fixed the issue by commenting out the check The tabular reports run fine.

[jcotton]

Is the graphing feature of ReportIt enabled? (The little colored bar chart icon in the upper right of the report)

I get the following error when I click on it....

GD library not available - Check your systems configuration

I am running PHP 4 with GD compiled and enabled...

<h2><a name="module_gd">gd</a></h2>
<table border="0" cellpadding="3" width="600">
<tr><td class="e">GD Support </td><td class="v">enabled </td></tr>
<tr><td class="e">GD Version </td><td class="v">bundled (2.0.28 compatible) </td></tr>
<tr><td class="e">FreeType Support </td><td class="v">enabled </td></tr>
<tr><td class="e">FreeType Linkage </td><td class="v">with freetype </td></tr>
<tr><td class="e">GIF Read Support </td><td class="v">enabled </td></tr>
<tr><td class="e">GIF Create Support </td><td class="v">enabled </td></tr>
<tr><td class="e">JPG Support </td><td class="v">enabled </td></tr>
<tr><td class="e">PNG Support </td><td class="v">enabled </td></tr>
<tr><td class="e">WBMP Support </td><td class="v">enabled </td></tr>
<tr><td class="e">XBM Support </td><td class="v">enabled </td></tr>
</table><br />

Any ideas?

GREAT plugin BTW!!

[browniebraun]

Is the graphing feature of ReportIt enabled? (The little colored bar chart icon in the upper right of the report)

I get the following error when I click on it....

GD library not available - Check your systems configuration

I am running PHP 4 with GD compiled and enabled...

<h2><a name="module_gd">gd</a></h2>
<table border="0" cellpadding="3" width="600">
<tr><td class="e">GD Support </td><td class="v">enabled </td></tr>
<tr><td class="e">GD Version </td><td class="v">bundled (2.0.28 compatible) </td></tr>
<tr><td class="e">FreeType Support </td><td class="v">enabled </td></tr>
<tr><td class="e">FreeType Linkage </td><td class="v">with freetype </td></tr>
<tr><td class="e">GIF Read Support </td><td class="v">enabled </td></tr>
<tr><td class="e">GIF Create Support </td><td class="v">enabled </td></tr>
<tr><td class="e">JPG Support </td><td class="v">enabled </td></tr>
<tr><td class="e">PNG Support </td><td class="v">enabled </td></tr>
<tr><td class="e">WBMP Support </td><td class="v">enabled </td></tr>
<tr><td class="e">XBM Support </td><td class="v">enabled </td></tr>
</table><br />

Any ideas?

GREAT plugin BTW!!

You can do it in a similar way: Exclude the function call "check_graph_support()" on line 775 of cc_view.php. It it'll work, then please add "print_r($loaded_extensions);" on line 158 of /lib/function_online.php and send me the output.

Best regards
-Andreas-

[jcotton]

You can do it in a similar way: Exclude the function call "check_graph_support()" on line 775 of cc_view.php. It it'll work, then please add "print_r($loaded_extensions);" on line 158 of /lib/function_online.php and send me the output.

Best regards
-Andreas-

I tried this, re-ran a report, and clicked the graph icon. There was some processing for about a second, but no graph was produced, just a blank page. I added the print_r statement in the funct_online file, directly after the "$loaded_extensions = get_loaded_extensions()" statement, but no extension list was printed to the screen.

[jcotton]

You can do it in a similar way: Exclude the function call "check_graph_support()" on line 775 of cc_view.php. It it'll work, then please add "print_r($loaded_extensions);" on line 158 of /lib/function_online.php and send me the output.

Best regards
-Andreas-

I tried this, re-ran a report, and clicked the graph icon. There was some processing for about a second, but no graph was produced, just a blank page. I added the print_r statement in the funct_online file, directly after the "$loaded_extensions = get_loaded_extensions()" statement, but no extension list was printed to the screen.

Duh. I realized I needed to uncomment the check_graph_support function to print the extension list. Here is the output:

Array ( [0] => xmlwriter [1] => libxml [2] => dom [3] => xmlreader [4] => xml [5] => tokenizer [6] => session [7] => pcre [8] => SimpleXML [9] => SPL [10] => PDO [11] => SQLite [12] => standard [13] => Reflection [14] => posix [15] => pdo_sqlite [16] => mysql [17] => json [18] => iconv [19] => hash [20] => filter [21] => date [22] => ctype [23] => apache2handler [24] => oci8 ) GD library not available - Check your systems configuration

Funny thing is GD does not show up in the list, yet it does in php -m and php -i.

Thanks very much for your help Andreas.