|
From: Ben C. <bcl...@pe...> - 2004-12-16 14:04:08
|
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
|