|
|
| Author |
Message |
linuxmancy
Joined: 18 Jun 2008
Posts: 2
|
 Posted: Wed Jun 18, 2008 8:27 pm Post subject: Cannot create report! |
 |
|
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. |
|
| Back to top |
|
 |
browniebraun
Cacti User
Joined: 13 Jun 2006
Posts: 333
Location: Cologne, Germany
|
| Posted: Wed Jun 18, 2008 10:51 pm Post subject: |
|
|
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: |
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- |
|
| Back to top |
|
|
palbandoz
Joined: 07 May 2008
Posts: 12
|
| Posted: Mon Jun 23, 2008 7:03 am Post subject: |
|
|
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 |
|
| Back to top |
|
|
jcotton
Joined: 27 Jun 2005
Posts: 25
|
| Posted: Mon Jun 23, 2008 11:54 am Post subject: |
|
|
| aaa. |
|
| Back to top |
|
|
browniebraun
Cacti User
Joined: 13 Jun 2006
Posts: 333
Location: Cologne, Germany
|
| Posted: Mon Jun 23, 2008 1:15 pm Post subject: |
|
|
| palbandoz wrote: | 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- |
|
| Back to top |
|
|
linuxmancy
Joined: 18 Jun 2008
Posts: 2
|
| Posted: Mon Jun 23, 2008 5:24 pm Post subject: Re: Cannot create report! |
|
|
| OK, apparently I needed to leave the Variables screen alone when creating the report template. It works now. *head desk* |
|
| Back to top |
|
|
palbandoz
Joined: 07 May 2008
Posts: 12
|
| Posted: Tue Jun 24, 2008 2:24 am Post subject: |
|
|
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. |
|
| Back to top |
|
|
jcotton
Joined: 27 Jun 2005
Posts: 25
|
| Posted: Tue Jun 24, 2008 12:54 pm Post subject: |
|
|
fixed
Last edited by jcotton on Thu Jun 26, 2008 5:30 pm; edited 1 time in total |
|
| Back to top |
|
|
browniebraun
Cacti User
Joined: 13 Jun 2006
Posts: 333
Location: Cologne, Germany
|
| Posted: Wed Jun 25, 2008 11:16 am Post subject: |
|
|
| palbandoz wrote: | 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: | 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 |
|
|
| Back to top |
|
|
browniebraun
Cacti User
Joined: 13 Jun 2006
Posts: 333
Location: Cologne, Germany
|
| Posted: Wed Jun 25, 2008 11:25 am Post subject: |
|
|
| jcotton wrote: | 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- |
|
| Back to top |
|
|
jcotton
Joined: 27 Jun 2005
Posts: 25
|
| Posted: Thu Jun 26, 2008 5:32 pm Post subject: |
|
|
| browniebraun wrote: | | jcotton wrote: | 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. |
|
| Back to top |
|
|
jcotton
Joined: 27 Jun 2005
Posts: 25
|
| Posted: Thu Jun 26, 2008 5:46 pm Post subject: |
|
|
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!! |
|
| Back to top |
|
|
browniebraun
Cacti User
Joined: 13 Jun 2006
Posts: 333
Location: Cologne, Germany
|
| Posted: Thu Jun 26, 2008 11:22 pm Post subject: |
|
|
| jcotton wrote: | 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- |
|
| Back to top |
|
|
jcotton
Joined: 27 Jun 2005
Posts: 25
|
| Posted: Fri Jun 27, 2008 12:49 pm Post subject: |
|
|
| Quote: |
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. |
|
| Back to top |
|
|
jcotton
Joined: 27 Jun 2005
Posts: 25
|
| Posted: Fri Jun 27, 2008 1:08 pm Post subject: |
|
|
| jcotton wrote: | | Quote: |
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. |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Register
Profile
Log in to check your private messages
Log in
