|
|
| Author |
Message |
guigzmorez
Joined: 03 Dec 2007
Posts: 6
|
 Posted: Wed May 21, 2008 6:58 am Post subject: Reportit template BUG ? |
 |
|
Hello
I have :
-cacti0.8.7b with PIA 2.1
-php 5.2.5 with apache 2.2.8
-redhat 4 with kernel 2.6.9-67.0.4
-mysql-4.1.20
reportit0.6 can't create report templates
reportit0.51 can create report templates
I don't know how it comes?
I have even tried to create a report template under version 0.51 ( tables are properly created ) then upgrade to reportit version 0.6 but it still don't work, report template can't be created.
Can you help me on this subject ?
Regards,
Guillaume |
|
| Back to top |
|
 |
Heiko
Joined: 23 Apr 2008
Posts: 23
|
| Posted: Fri May 23, 2008 7:43 am Post subject: |
|
|
Hello,
am I right that the function f_sum gives back a sum off all the traffic that flow trhough a deivce?
We have a loadbalancer(F5 BigIP) and would like to create a stastic where we see the monthly traffic.
As unit i used BIt/s and as the formula f_sum*8.
At the end I get 2.00 G, which cant be it should be arround 1TByte.
When I choose a longer timeframe the value is shrinking  .
what did i wrong |
|
| Back to top |
|
|
browniebraun
Cacti User
Joined: 13 Jun 2006
Posts: 306
Location: Cologne, Germany
|
| Posted: Fri May 23, 2008 10:59 am Post subject: |
|
|
| Heiko wrote: | Hello,
am I right that the function f_sum gives back a sum off all the traffic that flow trhough a deivce?
We have a loadbalancer(F5 BigIP) and would like to create a stastic where we see the monthly traffic.
As unit i used BIt/s and as the formula f_sum*8.
At the end I get 2.00 G, which cant be it should be arround 1TByte.
When I choose a longer timeframe the value is shrinking .
what did i wrong |
Heiko,
I could image that you want the amount of data in Bits. As you know RRDTool returns one measured value per time frame.
You have to multiply it with that step, so use "f_sum*8*step" instead.
If you choose a longer time frame it could be that RRDtool will change automatically to another archive to fulfill your request. This depends on the size your archives (e.g. a 5 min. granularity for 2 days, 30 min for 14 days and so on).
Remember that RRdtool is not a relational database, so the result has to be lower if you increase the reporting period and the report template uses the "Average" archive.
Best regards
-Andreas- |
|
| Back to top |
|
|
John77
Joined: 27 May 2008
Posts: 4
|
| Posted: Thu May 29, 2008 11:09 am Post subject: |
|
|
Hi,
We would like to use the maxValue variable, but the ifspeed of a WAN link is normally no correct, e.g. 100Mbit instead of 10Mbit.
Is there a way to define it manually in the cacti database?
Best Regards, John |
|
| Back to top |
|
|
browniebraun
Cacti User
Joined: 13 Jun 2006
Posts: 306
Location: Cologne, Germany
|
| Posted: Thu May 29, 2008 1:36 pm Post subject: |
|
|
Hi John,
that's more a question for Reinhard (Gandalf).
IMO it could be possible by defining the maximum value under "Data Source Item Fields" in (Console->Data Sources->edit a data source), but Reportit prioritize the ifspeed value over the manually defined maximum.
Best regards
-Andreas- |
|
| Back to top |
|
|
browniebraun
Cacti User
Joined: 13 Jun 2006
Posts: 306
Location: Cologne, Germany
|
| Posted: Thu May 29, 2008 1:54 pm Post subject: |
|
|
Hi Cacti Community!
Today I'm happy to publish the next minor release which contains four little new features beside some bug fixes.
Three bugs has been classified as critical, so that it's recommended to upgrade now.
Please note: ReportIt v0.6.x requires currently MySQL 5.0.3 or higher!
( I'll try to develop a workaround for users with a lower revision, but this would only be an interim solution. )
Best regards 
-Andreas-
| Code: | ---------------------------------------------------------------------------------------------------------------
Version 0.6.1:
---------------------------------------------------------------------------------------------------------------
Feature: (CLI) Debug option allows to view internal results / stati of the calculation process
Feature: (CLI) Report can be calculated singlarly
Feature: Graph type "Line (filled)" added
Feature: Email attachment can be disabled to send out a notification only
Bugfix(#00089): Wrong include path in cc_graph.php
Bugfix(#00088): Archived data source alias can't be unserialized if it contains double quotes
Bugfix(#00087): Resolution of subhead variables is not free from errors in exported reports
Bugfix(#00086): Incorrect definition of table "reportit_cache_variables"
Bugfix(#00085): Report view does not support output buffering to increase packet size (for WANs)
Bugfix(#00084): A SQL error will occur if a measurand is edited.
Bugfix(#00083): Critical: Undefined measured values (NANs) will be interpreted as "-1" on sytems with Windows
if the type of connection to RRDtool is set to "RRDTOOL CACTI(SLOW)"
Bugfix(#00082): User defined value won't be removed from database after template variable has been deleted
Bugfix(#00081): Separators for CSV exports (sent via email) does not match user defined settings
Bugfix(#00080): Input field for the subhead is too small
Bugfix(#00079): Special HTML tags (<br>,<p>,<b>,<i>,<u>) are not supported in the subhead like in v0.5.1
Bugfix(#00078): Critical: Quotes in a subhead impede to cache an archived report correctly
Bugfix(#00077): Duplicating a report template fails
Bugfix(#00076): Critical: Removing a report template that contains definitions of variables
could cause that user defined values of other variables, which are based on other templates,
will be removed instead
Bugfix(#00075): Logging verbosity will be ignored
Bugfix(#00074): If the data source alias is empty chart title won't contain the internal name
Bugfix(#00073): Graph View: Uncomplete parameter used in a function call causes SQL errors
Bugfix(#00072): Old field identifier inhibits that email settings can be saved
Bugfix(#00071): Url rewriting allows to configure email settings without beeing activated
Bugfix(#00070): An error in generating the titles for X and Y-axis causes that Bar, HBar, Line charts can fail
Bugfix(#00069): Saved data source alias are invalid in Cacti 0.8.6, because sanitizing of SQL commands has
changed with Cacti 0.8.7
Bugfix(#00068): Guest user can not view reports although permissions are correct |
Test environment:
| Code: |
#1 #2
Cacti Version 0.8.7b 0.8.7b
Cacti OS win32 unix
PHP Version 5.2.5 5.2.5
memory_limit 16M 16M
MySQL 5.0.51a 5.0.27
RRDTool 1.2.26 1.2.23
GD Version bundled (2.0.34 compatible) bundled (2.0.34 compatible)
FreeType Version 2.1.9 2.1.10
libXML Version 2.6.26 2.6.30
zlib 1.2.3 1.2.3
RRDTool Support enabled enabled
PHP bindings as dynamic lib (dll) PHP bindings as static lib (configure --with--rrdtool)
Graph Settings: 320x480, Quality "medium" 320x480, Quality "medium"
Number of data items 15 2500 |
|
|
| Back to top |
|
|
Heiko
Joined: 23 Apr 2008
Posts: 23
|
| Posted: Fri May 30, 2008 9:31 am Post subject: |
|
|
| Quote: |
Heiko,
I could image that you want the amount of data in Bits. As you know RRDTool returns one measured value per time frame.
You have to multiply it with that step, so use "f_sum*8*step" instead.
If you choose a longer time frame it could be that RRDtool will change automatically to another archive to fulfill your request. This depends on the size your archives (e.g. a 5 min. granularity for 2 days, 30 min for 14 days and so on).
Remember that RRdtool is not a relational database, so the result has to be lower if you increase the reporting period and the report template uses the "Average" archive.
Best regards
-Andreas- |
Hello Andreas,
so when i say generate a report for the last month and the the timeframe is "Monthly (2 Hour Average)", i have to calculate how many 2 hours are in 30 days? Or can i use the daily (5 minutes) to calculate the whole traffic of one month?
Wait "step" is a variable inside cacti, sorry.
Now the reported values look more like they should, but 6.13TB looks still a bit much
cheers
Heiko |
|
| Back to top |
|
|
John77
Joined: 27 May 2008
Posts: 4
|
| Posted: Fri May 30, 2008 9:53 am Post subject: |
|
|
| browniebraun wrote: | Hi John,
that's more a question for Reinhard (Gandalf).
IMO it could be possible by defining the maximum value under "Data Source Item Fields" in (Console->Data Sources->edit a data source), but Reportit prioritize the ifspeed value over the manually defined maximum.
Best regards
-Andreas- |
Hi Andreas,
That would be a nice feature, the possibility to use the "Data Source Item Fields". Maybe you can define a second maxValue: e.g. maxValueStatic?
Regards, Roger |
|
| Back to top |
|
|
browniebraun
Cacti User
Joined: 13 Jun 2006
Posts: 306
Location: Cologne, Germany
|
| Posted: Fri May 30, 2008 12:36 pm Post subject: |
|
|
| John77 wrote: | | browniebraun wrote: | Hi John,
that's more a question for Reinhard (Gandalf).
IMO it could be possible by defining the maximum value under "Data Source Item Fields" in (Console->Data Sources->edit a data source), but Reportit prioritize the ifspeed value over the manually defined maximum.
Best regards
-Andreas- |
Hi Andreas,
That would be a nice feature, the possibility to use the "Data Source Item Fields". Maybe you can define a second maxValue: e.g. maxValueStatic?
Regards, Roger |
I think it would be a reasonable expenditure, so please open a feature request under sourceforge.net. That's always necessary for me to keep things in mind, because this thread is not the smallest one.
Btw: Everyone, who wants to get automatically an email notification of new releases, can subscribe that with a click on the mail button of the download page after he has been registered.
Best regards
-Andreas- |
|
| Back to top |
|
|
browniebraun
Cacti User
Joined: 13 Jun 2006
Posts: 306
Location: Cologne, Germany
|
| Posted: Fri May 30, 2008 12:45 pm Post subject: |
|
|
| Heiko wrote: | | Quote: |
Heiko,
I could image that you want the amount of data in Bits. As you know RRDTool returns one measured value per time frame.
You have to multiply it with that step, so use "f_sum*8*step" instead.
If you choose a longer time frame it could be that RRDtool will change automatically to another archive to fulfill your request. This depends on the size your archives (e.g. a 5 min. granularity for 2 days, 30 min for 14 days and so on).
Remember that RRdtool is not a relational database, so the result has to be lower if you increase the reporting period and the report template uses the "Average" archive.
Best regards
-Andreas- |
Hello Andreas,
so when i say generate a report for the last month and the the timeframe is "Monthly (2 Hour Average)", i have to calculate how many 2 hours are in 30 days? Or can i use the daily (5 minutes) to calculate the whole traffic of one month?
Wait "step" is a variable inside cacti, sorry.
Now the reported values look more like they should, but 6.13TB looks still a bit much
cheers
Heiko |
Hi Heiko,
you don't have the possibility to choose a granularity, because this will be done by RRDtool automatically . ReportIt will calculate the difference of time between two measured values if RRDtool does not return this step.
This value is available during the calculation process, if you're using the variable called "step" in one of your calculation formulars.
Best regards
-Andreas- |
|
| Back to top |
|
|
chris.rolves
Cacti User
Joined: 01 Mar 2006
Posts: 52
|
| Posted: Fri May 30, 2008 5:04 pm Post subject: |
|
|
| GlueGuy wrote: | Just updated Reportit to v0.6.0. It seems to be working, but there are a couple of "new" things appearing under the Report Configuration after the daily scheduled report is run.
The daily report shows "*In process*", yet I think it completed a long time ago?
Also, the check box after Edit Data Items has a red "L" in the brackets ([L])
Here is a screen shot.
Not sure what is going on. Any suggestions? |
I am having this very same problem but it doesn't happen on all my reports and started happening when I moved my cacti installation to a different server. Both Machines are installed with CentOS |
|
| Back to top |
|
|
browniebraun
Cacti User
Joined: 13 Jun 2006
Posts: 306
Location: Cologne, Germany
|
| Posted: Sat May 31, 2008 12:44 am Post subject: |
|
|
| chris.rolves wrote: | | GlueGuy wrote: | Just updated Reportit to v0.6.0. It seems to be working, but there are a couple of "new" things appearing under the Report Configuration after the daily scheduled report is run.
The daily report shows "*In process*", yet I think it completed a long time ago?
Also, the check box after Edit Data Items has a red "L" in the brackets ([L])
Here is a screen shot.
Not sure what is going on. Any suggestions? |
I am having this very same problem but it doesn't happen on all my reports and started happening when I moved my cacti installation to a different server. Both Machines are installed with CentOS |
Hi Chris,
I need more information about your system environments!
To say "I've an issue with CentOS" is too little.
But principally it's important to know which version of MySQL your're using.
Please compare your two systems, so that we can see where you have differences in your software versions.
Best regards
-Andreas- |
|
| Back to top |
|
|
browniebraun
Cacti User
Joined: 13 Jun 2006
Posts: 306
Location: Cologne, Germany
|
| Posted: Mon Jun 02, 2008 4:28 am Post subject: |
|
|
| Heiko wrote: |
Hello Andreas,
so when i say generate a report for the last month and the the timeframe is "Monthly (2 Hour Average)", i have to calculate how many 2 hours are in 30 days? Or can i use the daily (5 minutes) to calculate the whole traffic of one month?
Wait "step" is a variable inside cacti, sorry.
Now the reported values look more like they should, but 6.13TB looks still a bit much
cheers
Heiko |
Please check if you've choosen the wrong base for rounding.
After changing it you don't have to rerun your report.
Best regards
-Andreas- |
|
| Back to top |
|
|
Heiko
Joined: 23 Apr 2008
Posts: 23
|
| Posted: Mon Jun 02, 2008 6:38 am Post subject: |
|
|
can it be that I found a bug?
I have on ereport running fine, now I added some more report and when I do "Run Report" i get the following errors:
# Number of warnings (4): REPORTIT WARNING: No values available. Report[5] Data Item[365]
# REPORTIT WARNING: No values available. Report[5] Data Item[246]
# REPORTIT WARNING: RRDfetch notified: Report[5] Data Item[210]
# REPORTIT WARNING: RRDfetch notified: Report[5] Data Item[423]
When I do a "Edit Data Items" after that, all of my graphs(all that exist inside cacti) are listed there, not only the two I added before.
I can reproduce this.
thx
.H |
|
| Back to top |
|
|
chris.rolves
Cacti User
Joined: 01 Mar 2006
Posts: 52
|
| Posted: Mon Jun 02, 2008 8:47 am Post subject: |
|
|
| browniebraun wrote: | | chris.rolves wrote: | | GlueGuy wrote: | Just updated Reportit to v0.6.0. It seems to be working, but there are a couple of "new" things appearing under the Report Configuration after the daily scheduled report is run.
The daily report shows "*In process*", yet I think it completed a long time ago?
Also, the check box after Edit Data Items has a red "L" in the brackets ([L])
Here is a screen shot.
Not sure what is going on. Any suggestions? |
I am having this very same problem but it doesn't happen on all my reports and started happening when I moved my cacti installation to a different server. Both Machines are installed with CentOS |
Hi Chris,
I need more information about your system environments!
To say "I've an issue with CentOS" is too little.
But principally it's important to know which version of MySQL your're using.
Please compare your two systems, so that we can see where you have differences in your software versions.
Best regards
-Andreas- |
ok, here is the info from my new cacti box....
| Quote: | Cacti Version - 0.8.7b
Plugin Architecture - 2.1
Poller Type - Cactid v
Server Info - Linux 2.6.18-53.el5
Web Server - Apache/2.2.3 (CentOS)
PHP - 5.1.6
PHP Extensions - libxml, xml, wddx, tokenizer, sysvshm, sysvsem, sysvmsg, standard, SimpleXML, sockets, SPL, shmop, session, Reflection, pspell, posix, mime_magic, iconv, hash, gmp, gettext, ftp, exif, date, curl, ctype, calendar, bz2, zlib, pcre, openssl, apache2handler, ldap, mysql, mysqli, PDO, pdo_mysql, pdo_sqlite, snmp
MySQL - 5.0.22
RRDTool - 1.2.27
SNMP - 5.3.1
PluginsHost Info (hostinfo - v0.2)
Realtime for Cacti (realtime - v0.32)
Global Plugin Settings (settings - v0.5)
Network Tools (tools - v0.3)
ReportIt (ReportIt - v0.5.1)
RRD Cleaner (rrdclean - v1.1)
Update Checker (update - v0.4) |
and here is the info from my old cacti box...
| Quote: | Cacti Version - 0.8.7b
Plugin Architecture - 2.1
Poller Type - Cactid v
Server Info - Linux 2.6.18-53.1.14.el5
Web Server - Apache/2.2.3 (CentOS)
PHP - 5.1.6
PHP Extensions - libxml, xml, wddx, tokenizer, sysvshm, sysvsem, sysvmsg, standard, SimpleXML, sockets, SPL, shmop, session, Reflection, pspell, posix, mime_magic, iconv, hash, gmp, gettext, ftp, exif, date, curl, ctype, calendar, bz2, zlib, pcre, openssl, apache2handler, gd, ldap, mysql, mysqli, PDO, pdo_mysql, pdo_sqlite, snmp
MySQL - 5.0.22
RRDTool - 1.2.27
SNMP - 5.3.1
PluginsHost Info (hostinfo - v0.2)
Realtime for Cacti (realtime - v0.32)
Global Plugin Settings (settings - v0.5)
Network Tools (tools - v0.3)
ReportIt (ReportIt - v0.5.1)
RRD Cleaner (rrdclean - v1.1)
Update Checker (update - v0.4) |
Some other info on the move was that I moved from a machine that was running dual dualcore Xeon 2Ghz processors with 2Gb of ram, to a machine running a 1.8Ghz Celeron with 2Gb of ram. I'm not sure if it makes a difference moving from a more powerful machine to a lesser machine or not but this is all the info I have so far. |
|
| Back to top |
|
|
|
Powered by phpBB © 2001, 2005 phpBB Group
|
|
FAQ
Search
Memberlist
Register
Profile
Log in to check your private messages
Log in
