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

[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

[browniebraun]

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-

[browniebraun]

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

[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!

[browniebraun]

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-

[dantzorn]

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

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.

[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?

[browniebraun]

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-

[browniebraun]

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-

[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?

This occurs if the calculation process has been interrupted or if it got out of time. (Or through a loop ).
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-

[tephra]

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.

[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!

[browniebraun]

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-

[browniebraun]

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-