Re: [Perfparse-users] perfparse.cgi

[Ben C. <bcl...@pe...>]

Dear Krzemiński

This is an interesting one, and I don't know how it happened.

You version in your database is '0,15'.  It should be '0.15'. 
Internally this is converted to a double:

double version = atof(version)

So '0.15' -> 0.15  but '0,15' -> 0.00

Can please enter:

mysql> UPDATE perfdata_registry SET rvalue = '0.15' WHERE rkey = 
'pp/database/version';

Would you have any idea how this got like this to begin with?  Any 
information you have would be very useful.

The code which sets this is:

void setVersion(double version)
{
	char s[10];
	sprintf(s, "%.2lf", version);


Can you write a test program on your local UNIX box and let me know what 
this does on your system?

int main() { double d = 0.15; printf("%.2lf", d); return 1 }

I note this is using the 'lf' GNU extension.  Which GNU takes to mean 
'long float'.  Could your system take this to mean 'local float'?  If 
you change this to "%.2f" does this fix the problem?

Regards,

Ben


Krzemiński Krzysztof wrote:

> Hello,
> 
> I've problem with using perfparse.cgi.
> When I open this address: http://host/nagios/cgi-bin/perfparse.cgi, I 
> got following information:
> 
> Database Schema version is incorrect.
>  Current Version: 0.00, Required Version: 0.15.
>  Consider upgrading with:
>  perfparse-db-tool --update
> 
> I used this comman few times, but more importently in mysql logs, there 
> is information about requested query to database about perfparse version:
> 
> 041216 13:45:58  102457 Connect     perfparse@localhost on perfparse
> 102457 Query       SELECT rvalue,ctime from perfdata_registry WHERE host 
> = 'dummy' AND rkey = 'pp/database/version'
> 
> This log information are correct (user and database name) and when I use 
> above query to database I got this:
> 
> rvalue  ctime
> 0,15    2004-12-14 13:00:38
> 
> so it's look like database schema version is correct.
> 
> Anyone have such problem? How can I solve this problem or pass over this 
> version checking?
> 
> 
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real users.
> Discover which products truly live up to the hype. Start reading now. 
> http://productguide.itmanagersjournal.com/
> _______________________________________________
> Perfparse-users mailing list
> Per...@li...
> https://lists.sourceforge.net/lists/listinfo/perfparse-users
> 


-- 
Ben Clewett  bcl...@pe...
PerfParse    http://www.perfparse.org
PP FAQ       http://wiki.perfparse.org/tiki-list_faqs.php