Cacti (home)ForumsRepositoryDocumentation
Cacti: offical forums and support  

 FAQFAQ   SearchSearch   MemberlistMemberlist    RegisterRegister   ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in    


Report plugin ''ReportIt" - v0.6.1 (released 05/29/08)
Goto page Previous  1, 2, 3 ... 20, 21, 22 ... 28, 29, 30  Next
 
Post new topic   Reply to topic    Cacti Forum Index -> Plugin General
Author Message
thomasw



Joined: 10 Nov 2005
Posts: 25

PostPosted: Fri May 02, 2008 4:00 am    Post subject: Thank you very much! Reply with quote

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

PostPosted: Fri May 02, 2008 7:52 am    Post subject: Re: Archives Problem Reply with quote

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

PostPosted: Fri May 02, 2008 8:58 am    Post subject: Re: Archives Problem Reply with quote

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

PostPosted: Fri May 02, 2008 11:51 pm    Post subject: error......anyone can help me? Reply with quote

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

PostPosted: Sat May 03, 2008 2:32 am    Post subject: Re: error......anyone can help me? Reply with quote

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

PostPosted: Sat May 03, 2008 9:06 am    Post subject: Re: Archives Problem Reply with quote

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

PostPosted: Sun May 04, 2008 11:14 pm    Post subject: Reply with quote

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

PostPosted: Mon May 05, 2008 9:46 am    Post subject: Reply with quote

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?



Reportit_v6_cfg.gif
 Description:
 Filesize:  17.91 KB
 Viewed:  1216 Time(s)

Reportit_v6_cfg.gif


Back to top
browniebraun
Cacti User


Joined: 13 Jun 2006
Posts: 329
Location: Cologne, Germany

PostPosted: Mon May 05, 2008 12:27 pm    Post subject: Re: error......anyone can help me? Reply with quote

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-



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


cc_templates.tar.gz
 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

PostPosted: Mon May 05, 2008 12:46 pm    Post subject: Reply with quote

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

PostPosted: Mon May 05, 2008 1:05 pm    Post subject: Reply with quote

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

PostPosted: Tue May 06, 2008 1:01 am    Post subject: Reply with quote

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

PostPosted: Tue May 06, 2008 1:40 am    Post subject: Reply with quote

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

PostPosted: Tue May 06, 2008 2:09 am    Post subject: Reply with quote

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

PostPosted: Tue May 06, 2008 2:16 am    Post subject: Reply with quote

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
Display posts from previous:   
Post new topic   Reply to topic    Cacti Forum Index -> Plugin General All times are GMT - 5 Hours
Goto page Previous  1, 2, 3 ... 20, 21, 22 ... 28, 29, 30  Next
Page 21 of 30

 



Powered by phpBB © 2001, 2005 phpBB Group