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

[guigzmorez]

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

[Heiko]

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

[browniebraun]

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-

[John77]

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

[browniebraun]

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-

[browniebraun]

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: Select all

---------------------------------------------------------------------------------------------------------------
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: Select all

                        #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

[Heiko]

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

[John77]

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

[browniebraun]

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-

[browniebraun]

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-

[chris.rolves]

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

[browniebraun]

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-

[browniebraun]

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-

[Heiko]

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

[chris.rolves]

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....

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
Plugins

• Host 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...

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
Plugins

• Host 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.