|
|
| Author |
Message |
thomasw
Joined: 10 Nov 2005
Posts: 25
|
 Posted: Fri May 02, 2008 4:00 am Post subject: Thank you very much! |
 |
|
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
|
|
| Back to top |
|
 |
browniebraun
Cacti User
Joined: 13 Jun 2006
Posts: 329
Location: Cologne, Germany
|
| Posted: Fri May 02, 2008 7:52 am Post subject: Re: Archives Problem |
|
|
| 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-
|
|
| Back to top |
|
|
browniebraun
Cacti User
Joined: 13 Jun 2006
Posts: 329
Location: Cologne, Germany
|
| Posted: Fri May 02, 2008 8:58 am Post subject: Re: Archives Problem |
|
|
| 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  ). 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-
|
|
| Back to top |
|
|
ccng
Joined: 08 Aug 2007
Posts: 3
|
| Posted: Fri May 02, 2008 11:51 pm Post subject: error......anyone can help me? |
|
|
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!
|
|
| Back to top |
|
|
browniebraun
Cacti User
Joined: 13 Jun 2006
Posts: 329
Location: Cologne, Germany
|
| Posted: Sat May 03, 2008 2:32 am Post subject: Re: error......anyone can help me? |
|
|
| 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-
|
|
| Back to top |
|
|
dantzorn
Joined: 02 May 2008
Posts: 3
|
| Posted: Sat May 03, 2008 9:06 am Post subject: Re: Archives Problem |
|
|
| 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 ). 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.
|
|
| Back to top |
|
|
tephra
Joined: 09 Dec 2007
Posts: 24
|
| Posted: Sun May 04, 2008 11:14 pm Post subject: |
|
|
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.
|
|
| Back to top |
|
|
GlueGuy
Cacti User
Joined: 04 Nov 2005
Posts: 68
Location: Ca US
|
| Posted: Mon May 05, 2008 9:46 am Post subject: |
|
|
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?
| Description: |
|
| Filesize: |
17.91 KB |
| Viewed: |
1217 Time(s) |
|
|
|
| Back to top |
|
|
browniebraun
Cacti User
Joined: 13 Jun 2006
Posts: 329
Location: Cologne, Germany
|
| Posted: Mon May 05, 2008 12:27 pm Post subject: Re: error......anyone can help me? |
|
|
| 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-
| Description: |
| Cacti 0.8.6.x (also compatible with 0.8.7) |
|
Download |
| Filename: |
cc_templates.zip |
| Filesize: |
5.68 KB |
| Downloaded: |
44 Time(s) |
| Description: |
| Cacti 0.8.6.x (also compatible with 0.8.7) |
|
Download |
| Filename: |
cc_templates.tar.gz |
| Filesize: |
5.64 KB |
| Downloaded: |
47 Time(s) |
|
|
| Back to top |
|
|
browniebraun
Cacti User
Joined: 13 Jun 2006
Posts: 329
Location: Cologne, Germany
|
| Posted: Mon May 05, 2008 12:46 pm Post subject: |
|
|
| 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-
|
|
| Back to top |
|
|
browniebraun
Cacti User
Joined: 13 Jun 2006
Posts: 329
Location: Cologne, Germany
|
| Posted: Mon May 05, 2008 1:05 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? |
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-
|
|
| Back to top |
|
|
tephra
Joined: 09 Dec 2007
Posts: 24
|
| Posted: Tue May 06, 2008 1:01 am Post subject: |
|
|
| 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.
|
|
| Back to top |
|
|
GlueGuy
Cacti User
Joined: 04 Nov 2005
Posts: 68
Location: Ca US
|
| Posted: Tue May 06, 2008 1:40 am Post subject: |
|
|
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!
|
|
| Back to top |
|
|
browniebraun
Cacti User
Joined: 13 Jun 2006
Posts: 329
Location: Cologne, Germany
|
| Posted: Tue May 06, 2008 2:09 am Post subject: |
|
|
| 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-
|
|
| Back to top |
|
|
browniebraun
Cacti User
Joined: 13 Jun 2006
Posts: 329
Location: Cologne, Germany
|
| Posted: Tue May 06, 2008 2:16 am Post subject: |
|
|
| 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-
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Register
Profile
Log in to check your private messages
Log in
