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

General discussion about Plugins for Cacti

Moderators: Developers, Moderators

Post Reply
thomasw
Posts: 33
Joined: Thu Nov 10, 2005 6:11 am

Thank you very much!

Post by thomasw »

Hi Andreas,

thank you very much for your great piece of work! I just upgraded from 0.51 on my production system and everything worked for me out-of-the box! Perfect work!

best regards,

tom
User avatar
browniebraun
Developer
Posts: 791
Joined: Tue Jun 13, 2006 1:17 am
Location: Cologne, Germany

Re: Archives Problem

Post by browniebraun »

dantzorn wrote:Hi,

You made a very good works.

But I h'ave a problem with archives.
when I select Current all is right, but when I select an archive, I have no data.

Best regards.
Please send me an email or pm and attach your archive, so that I can take a look at it.

Best regards
-Andreas-
Hat das Blümchen einen Knick, war der Schmetterling zu dick! ;)
reportit v0.7.5a
SNMPAgent v0.2.3
Download ReportIt | Download SNMPAgent | ReportIt SVN | ReportIt Templates | Wish list
User avatar
browniebraun
Developer
Posts: 791
Joined: Tue Jun 13, 2006 1:17 am
Location: Cologne, Germany

Re: Archives Problem

Post by browniebraun »

dantzorn wrote:Hi,

You made a very good works.

But I h'ave a problem with archives.
when I select Current all is right, but when I select an archive, I have no data.

Best regards.
Thank you for sending me your archive!
It seems to me that you've tested one of the latest svn releases, because your reports contain a field called "email_compression" (and the archive has been created at the 28th of April :wink: ). The compression of email attachments is not part of the official release v0.6.0.
The svn release you've installed contains a bug, because it does not create the necessary field in the tables "reportit_cache_reports" and "reportit_reports".
So If you don't want to loose your existing reports then you've to edit the definition of these tables. Add a field called "email_compression" as type "binary" default "0".
The easiest way is to download the official release v0.6.0 and to clean up your database with the uninstall procedure contained in the main folder of ReportIt. Then you'll loose your report settings.

Best regards
-Andreas-
Hat das Blümchen einen Knick, war der Schmetterling zu dick! ;)
reportit v0.7.5a
SNMPAgent v0.2.3
Download ReportIt | Download SNMPAgent | ReportIt SVN | ReportIt Templates | Wish list
ccng
Posts: 3
Joined: Wed Aug 08, 2007 3:27 am

error......anyone can help me?

Post by ccng »

when I create a new report template. an error shows as :

"Notice: unserialize(): Error at offset 23 of 53 bytes in /var/www/html/plugins/reportit/lib_int/funct_html.php on line 335
"

what can I do...

Thanks!
User avatar
browniebraun
Developer
Posts: 791
Joined: Tue Jun 13, 2006 1:17 am
Location: Cologne, Germany

Re: error......anyone can help me?

Post by browniebraun »

ccng wrote:when I create a new report template. an error shows as :

"Notice: unserialize(): Error at offset 23 of 53 bytes in /var/www/html/plugins/reportit/lib_int/funct_html.php on line 335
"

what can I do...

Thanks!
Please give me some more information: Version of Cacti, PIA, PHP and the data source alias you want to add.

Best regards
-Andreas-
Hat das Blümchen einen Knick, war der Schmetterling zu dick! ;)
reportit v0.7.5a
SNMPAgent v0.2.3
Download ReportIt | Download SNMPAgent | ReportIt SVN | ReportIt Templates | Wish list
dantzorn
Posts: 3
Joined: Fri May 02, 2008 1:38 am

Re: Archives Problem

Post by dantzorn »

browniebraun wrote:
dantzorn wrote:Hi,

You made a very good works.

But I h'ave a problem with archives.
when I select Current all is right, but when I select an archive, I have no data.

Best regards.
Thank you for sending me your archive!
It seems to me that you've tested one of the latest svn releases, because your reports contain a field called "email_compression" (and the archive has been created at the 28th of April :wink: ). The compression of email attachments is not part of the official release v0.6.0.
The svn release you've installed contains a bug, because it does not create the necessary field in the tables "reportit_cache_reports" and "reportit_reports".
So If you don't want to loose your existing reports then you've to edit the definition of these tables. Add a field called "email_compression" as type "binary" default "0".
The easiest way is to download the official release v0.6.0 and to clean up your database with the uninstall procedure contained in the main folder of ReportIt. Then you'll loose your report settings.

Best regards
-Andreas-
Hi, thanks for your reply. I have try the first solutions without success. And I have re-installed the new version. And now all are right.

Best regards.
tephra
Posts: 26
Joined: Sun Dec 09, 2007 8:11 pm

Post by tephra »

Andreas,

I have a problem (with .51 as well as .60):

my RRA has MAX and AVERAGE CF's, I have created a report template using the AVERAGE CF and f_min as the measurand.

However my report just shows 0 for all dataitems.

I am trying to create a report which shows the minimum recorded result over the time period.

Any ideas?

Cheers
D.
User avatar
GlueGuy
Cacti User
Posts: 255
Joined: Fri Nov 04, 2005 3:37 pm
Location: Ca US
Contact:

Post by GlueGuy »

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?
Attachments
Reportit_v6_cfg.gif
Reportit_v6_cfg.gif (17.91 KiB) Viewed 6385 times
---------
The Glue Guy
User avatar
browniebraun
Developer
Posts: 791
Joined: Tue Jun 13, 2006 1:17 am
Location: Cologne, Germany

Re: error......anyone can help me?

Post by browniebraun »

ccng wrote:when I create a new report template. an error shows as :

"Notice: unserialize(): Error at offset 23 of 53 bytes in /var/www/html/plugins/reportit/lib_int/funct_html.php on line 335
"

what can I do...

Thanks!

Hi Cacti Community!

There was a change with 0.8.7 in one of Cacti's core functions to sanitize sql strings (database.php , function "sql_sanitize").
In older versions of Cacti (0.8.6x) this function removes semicolons instead of escaping them. That's the reason why PHP's storable representation becomes invalid on systems with 0.8.6x.
I wrote a little workaround to support this versions as well, because I'm not one of Cacti's main developers and so I can not advise to modify that core function without having the full sureness that nothing else will be affected.

So, everybody who wants to use ReportIt v0.6.0 with Cacti 0.8.6x has to replace the file called "cc_templates.php" by that one I've attached.
After saving your report template again the error message will disappear.

Please notice that Cacti 0.8.7x is not affected! There's no change necessary on these systems.

Best regards
-Andreas-
Attachments
cc_templates.tar.gz
Cacti 0.8.6.x (also compatible with 0.8.7)
(5.64 KiB) Downloaded 301 times
cc_templates.zip
Cacti 0.8.6.x (also compatible with 0.8.7)
(5.68 KiB) Downloaded 331 times
Hat das Blümchen einen Knick, war der Schmetterling zu dick! ;)
reportit v0.7.5a
SNMPAgent v0.2.3
Download ReportIt | Download SNMPAgent | ReportIt SVN | ReportIt Templates | Wish list
User avatar
browniebraun
Developer
Posts: 791
Joined: Tue Jun 13, 2006 1:17 am
Location: Cologne, Germany

Post by browniebraun »

tephra wrote:Andreas,

I have a problem (with .51 as well as .60):

my RRA has MAX and AVERAGE CF's, I have created a report template using the AVERAGE CF and f_min as the measurand.

However my report just shows 0 for all dataitems.

I am trying to create a report which shows the minimum recorded result over the time period.

Any ideas?

Cheers
D.
Hi tephra!
In relation to one of your previous posting I've to say that ReportIt automatically excludes all values which are declared as "nan" before the calculation starts.
The function "f_min()" returns the lowest of these filtered values. If you reporting period contains a measured value which is zero then it returns zero.
I'll try to implement a debugging mode in 0.6.1, because I wrote one for a debugging session with 0.5.1. 3 weeks ago. This allows to display most parts of the calculation process including the cache statuses.
Till now I can only suggest to use RRDtool dump or fetch to display your measured values. :(

Best regards
-Andreas-
Hat das Blümchen einen Knick, war der Schmetterling zu dick! ;)
reportit v0.7.5a
SNMPAgent v0.2.3
Download ReportIt | Download SNMPAgent | ReportIt SVN | ReportIt Templates | Wish list
User avatar
browniebraun
Developer
Posts: 791
Joined: Tue Jun 13, 2006 1:17 am
Location: Cologne, Germany

Post by browniebraun »

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?
This occurs if the calculation process has been interrupted or if it got out of time. (Or through a loop :cry: ).
The calculation process is not as simple as it seems to be. That's one reason more why I've to implement the debugging mode as soon as possible to make issues visible. I've also to implement a function to reset the report and to generate a log message if the calculation aborts.

You can reset your report by using the MySQL's CLI or PHPmyAdmin. Go to table reportit_reports and set the value of field "in_process" to zero.

Best regards
-Andreas-
Hat das Blümchen einen Knick, war der Schmetterling zu dick! ;)
reportit v0.7.5a
SNMPAgent v0.2.3
Download ReportIt | Download SNMPAgent | ReportIt SVN | ReportIt Templates | Wish list
tephra
Posts: 26
Joined: Sun Dec 09, 2007 8:11 pm

Post by tephra »

browniebraun wrote: Till now I can only suggest to use RRDtool dump or fetch to display your measured values. :(
Hrmm I have been through my rra file and there are no zero's.

Is there anything else you can suggest?

Cheers
D.
User avatar
GlueGuy
Cacti User
Posts: 255
Joined: Fri Nov 04, 2005 3:37 pm
Location: Ca US
Contact:

Post by GlueGuy »

Thanks again Andreas,

Resetting the in_process column for that report put it back to "normal".

BTW - There was nothing to indicate that the report had not completed. The report seemed complete, and there was nothing in the log file.

I presume the "2008/05/05 05:00:21 / 20" under the last run time column indicated that the report took 20 seconds to complete?

I did have a muck-up in the email settings, which I've fixed. Hopefully, that is what caused the problem.

As usual, great plugin!
---------
The Glue Guy
User avatar
browniebraun
Developer
Posts: 791
Joined: Tue Jun 13, 2006 1:17 am
Location: Cologne, Germany

Post by browniebraun »

GlueGuy wrote:Thanks again Andreas,

Resetting the in_process column for that report put it back to "normal".

BTW - There was nothing to indicate that the report had not completed. The report seemed complete, and there was nothing in the log file.

I presume the "2008/05/05 05:00:21 / 20" under the last run time column indicated that the report took 20 seconds to complete?

I did have a muck-up in the email settings, which I've fixed. Hopefully, that is what caused the problem.

As usual, great plugin!
You're absolutely right - "/20" means 20 seconds.
It could be that this issue has been caused by sending the email, but generally ReportIt logs error messages returned by the Settings plugin.

Best regards
-Andreas-
Hat das Blümchen einen Knick, war der Schmetterling zu dick! ;)
reportit v0.7.5a
SNMPAgent v0.2.3
Download ReportIt | Download SNMPAgent | ReportIt SVN | ReportIt Templates | Wish list
User avatar
browniebraun
Developer
Posts: 791
Joined: Tue Jun 13, 2006 1:17 am
Location: Cologne, Germany

Post by browniebraun »

tephra wrote:
browniebraun wrote: Till now I can only suggest to use RRDtool dump or fetch to display your measured values. :(
Hrmm I have been through my rra file and there are no zero's.

Is there anything else you can suggest?

Cheers
D.
If everything else is working we've to wait until the debugger is implemented to show the values ReportIt receives. (and also the results)
I'll try to find some time to implement it next weekend and then you'll receive a PM from me with that modified version.

Best regards
-Andreas-
Hat das Blümchen einen Knick, war der Schmetterling zu dick! ;)
reportit v0.7.5a
SNMPAgent v0.2.3
Download ReportIt | Download SNMPAgent | ReportIt SVN | ReportIt Templates | Wish list
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest