From:
<krz...@at...> - 2004-12-16 13:11:46
|
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? |
From: Yves <yme...@pe...> - 2004-12-16 13:34:12
|
On the command line, run "perfparse.cgi --show_config" Do the parameters look good ? If not, check the config file location. No better idea for now. Yves > 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 versio= n: > > 041216 13:45:58 102457 Connect perfparse@localhost on perfparse > 102457 Query SELECT rvalue,ctime from perfdata_registry WHERE hos= t > =3D 'dummy' AND rkey =3D 'pp/database/version' > > This log information are correct (user and database name) and when I us= e > 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 thi= s > 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 > > --=20 - Homepage - http://ymettier.free.fr - http://www.logicacmg.com - - GPG key - http://ymettier.free.fr/gpg.txt - - Maitretarot - http://www.nongnu.org/maitretarot/ - - Perfparse - http://perfparse.sf.net/ - |
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 |