perfparse-users — Problems using PerfParse

[Perfparse-users] Re: [Nagios-users] PerfParse Help?

[Ben C. <Be...@cl...>]

Jon,

This is odd.  If perfparse sees the performance metric, it will index it.

Can you reply with three bits of information.  Can you let me know what 
the raw output of 'check_ifstatus' looks like:

$ /..../nagios/libexec/check_ifstatus

Secondly, can you stop 'perfparse' running, and show me a sample of the 
serviceperf.log file showing how this plugin reports it's self in this log?

Lastly, can you see if there is anything in the 'drop' file, and show me?

Regards Ben.

PS, I don't really mind, but officially this mailing list is to discuss 
programming issues of PerfParse.  There is another mailing list, 
'perfparse-users' for these problems.  This mailing list has far more 
subscribes, some of whom may know straight away what your problem is. :)


Jon Lyons wrote:
> Yep, 99% of my checks are with the check_ping plugin,
> allthough check_ifstatus does reports the performance
> numbers, but doesn't show up in the graphs...
> 
> Just spent the entire day trying to fix my MYsql
> client so I can try this and none of my checks are
> supported yet....ARGH!
> 
> 
> --- "Cook, Garry" <GW...@ma...> wrote:
> 
>>Jon Lyons wrote:
>>
>>>Ok, I finally got PerfParse installed and running,
>>
>>but
>>
>>>only 6 hosts out of 200 are being displayed with
> 
> 
> 
> 
> 		
> __________________________________
> Do you Yahoo!?
> Yahoo! Mail is new and improved - Check it out!
> http://promotions.yahoo.com/new_mail
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by The 2004 JavaOne(SM) Conference
> Learn from the experts at JavaOne(SM), Sun's Worldwide Java Developer
> Conference, June 28 - July 1 at the Moscone Center in San Francisco, CA
> REGISTER AND SAVE! http://java.sun.com/javaone/sf Priority Code NWMGYKND
> _______________________________________________
> Nagios-users mailing list
> Nag...@li...
> https://lists.sourceforge.net/lists/listinfo/nagios-users
> ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
> ::: Messages without supporting info will risk being sent to /dev/null
> 

[Perfparse-users] Re: Antwort: Re: Antwort: Re: Perfparse 0.08

[Ben C. <Be...@cl...>]

Norbert,

Sorry about this, I have had people complain about this problem.  I am 
glad you found this without any problems.

The program will use the current perfchart/perfgraph in all future 
versions.  I will amend the documentation for the next version to help 
other users.

Ii hope you have got perfparse to work for you.

Regards, Ben.


Norbert Wiedeke/GIS wrote:

> Hallo,
> 
> make -install (0.08) installs in .../sbin perfchart/perfgraph
> but not perfchart.cgi/perfgraph.cgi
> 
> 
> 
> Norbert.
> 
> 
> 
> 
> 
>                                                                                                             
>                       Ben Clewett                                                                           
>                       <Be...@cl...         An:      Norbert Wiedeke/GIS <nor...@gi...> 
>                       .uk>                     Kopie:                                                       
>                                                Thema:   Re: Antwort: Re: Perfparse 0.08                     
>                       15.06.04 14:29                                                                        
>                                                                                                             
>                                                                                                             
> 
> 
> 
> Norbert,
> 
> Do you have the latest version, 0.08?
> 
> If so, can you enter:
> 
> $ perfparse --show_config
> 
> Can you confirm that the data is correct?
> 
> If you try:
> 
> mysql -u user -ppass -h host -D database
> 
> Does this connect with *exactly* the same values?
> 
> Regards, Ben.
> 
> 
> 
> Norbert Wiedeke/GIS wrote:
> 
> 
>>Hallo Ben,
>>
>>now I have another error.
>>
>>When i started perfparse.cgi in the Browser:
>>
>>"Cannot connect to database. Please supply the correct details to connect
>>to database.
>>Please adjust the config file: //usr/local/nagios/etc/perfparse.cfg"
>>
>>
>>Perfparse.cfg is correct!!!
>>
>>
>>Norbert.
>>
>>
>>
>>
>>
>>
>>
>>
> 
> 
> 
> 
> 
> 

[Perfparse-users] Re: Make error

[Ben C. <Be...@cl...>]

Phillipp,

Great to hear you have installed MySQL 4.  This will make a difference.

I think perfparse has experienced a format of log file it can't=20
understand.  Can you look in nagios.cfg and find these lines:

process_performance_data=3D1
xpdfile_service_perfdata_file=3D/usr/local/nagios/var/serviceperf.log
xpdfile_service_perfdata_template=3D$TIMET$\t$HOSTNAME$\t$SERVICEDESC$\t$=
OUTPUT$\t$PERFDATA$

These have to be exactly as above in this version of PerfParse.

If you really need a different format, I can show you how to change the=20
source code to accommodate your changes.

Regards, Ben.


Sand Philipp wrote:

> Hi,
>=20
> I installed mysql 4 now and recompiled the perparse binaries. Now it se=
ems ok concering the compiling stuff.
> Now I get an error when running perfparse, that i got unknown colums in=
 my service-perfdata file.
>=20
> Here's the Error Message:
> #./perfparse -l /usr/local/nagios/var/service-perfdata.out
> Filename: /usr/local/nagios/var/service-perfdata.out
> "INSERT INTO perfdata_service_raw (host_name, service_description, ctim=
e, txt_data) VALUES ('users=3D1;75;150;01083050695','pcadm76',FROM_UNIXTI=
ME(n),'Current Users')" failed:
> Unknown column 'n' in 'field list'
> 00:00:00 l 1 read 0 @ 0.0 l/sec.  Met 0 @ nan Met/l.  Drop 0. =20
>=20
> What's next? :)
>=20
> Thanks in advance!
> Philipp
>=20
>=20
>>-----Original Message-----
>>From: Ben Clewett [mailto:Be...@cl...]=20
>>Sent: Monday, June 14, 2004 2:36 PM
>>To: Sand Philipp; 'per...@li...'
>>Subject: Re: Make error
>>
>>Phillipp,
>>
>>You are never waiting my time, if I can do anything to help=20
>>PerfParse users I always will.
>>
>>You problems is the version of SQL you are using.  Only the=20
>>latest version 4 supports transactions.
>>
>>I would advise you to upgrade to the latest version. =20
>>Alternatively, you can edit the source code in the directory=20
>>'src'.  Look for any lines like:
>>
>>now_query("START TRANSACTION");
>>
>>or
>>
>>now_query("COMMIT");
>>
>>And delete them.
>>
>>
>>Regards, Ben.
>>
>>
>>
>>
>>Sand Philipp wrote:
>>
>>
>>>Ah great now it works...thanks for that!
>>>Now i got another failure :( I just created the Database=20
>>
>>and the tables with the mysql_create.sh skript contributed.
>>
>>>Now i want to run perfparse and get the following:
>>>[root@nagios1 bin]# ./perfparse
>>>"START TRANSACTION" failed:
>>>You have an error in your SQL syntax near 'START=20
>>
>>TRANSACTION' at line=20
>>
>>>1
>>>
>>>My mysql.log shows the following:
>>>
>>>040614 13:50:48     201 Connect    =20
>>
>>ro...@na... on nagios
>>
>>>                    201 Query       SELECT file_name,=20
>>
>>line_in_file, last_line_hash, pid, file_name FROM=20
>>perfdata_state WHERE domain =3D '008DC5B5'
>>
>>>                    201 Query       UPDATE perfdata_state=20
>>
>>SET pid =3D 10227, line_in_file =3D 0, last_line_hash =3D '',=20
>>file_name =3D '/usr/local/nagios/var/serviceperf.log' WHERE=20
>>domain =3D '008DC5B5'
>>
>>>                    201 Query       SET AUTOCOMMIT=3D0
>>>                    201 Query       START TRANSACTION
>>>                    201 Quit
>>>
>>>Sorry for wasting your time :)
>>>
>>>Philipp
>>>
>>>
>>>
>>>>-----Original Message-----
>>>>From: Ben Clewett [mailto:Ben...@ro...]
>>>>Sent: Monday, June 14, 2004 12:41 PM
>>>>To: Sand Philipp
>>>>Cc: 'per...@li...'
>>>>Subject: Re: Make error
>>>>
>>>>Hi Philipp,
>>>>
>>>>I am glad you have found PerfParse, and hope you will enjoy=20
>>
>>using it.
>>
>>>>Your error messages seem to indicate you do not have the=20
>>
>>MySQL client=20
>>
>>>>development libs on your system.  These will include the=20
>>
>>missing files=20
>>
>>>>'mysql.h' and 'errmsg.h'.
>>>>
>>>>If you don't think this is the case, (errors in the make are=20
>>>>possible), enter the following and let me know if it replys with=20
>>>>anything:
>>>>
>>>>$ find / -name "mysql.h" -ls 2> /dev/null
>>>>
>>>>I do not know 'Fedora Core 1', so I am not sure how they distribute=20
>>>>the Mysql-devel package.  You can however obtain this from MySQL by=20
>>>>getting and installing the source package from mysql.com. =20
>>
>>It is the=20
>>
>>>>client development libs you need, or the full package :)
>>>>
>>>>I also notice you are on MySQL version 3.  This does not support=20
>>>>transactions.  I strongly advice you upgrade to the full version of=20
>>>>MySQL 4, in what ever their latest release version it,=20
>>
>>including the=20
>>
>>>>'InnoDB', or 'max', release.
>>>>Transactions ensure that bad data cannot accidentally be=20
>>
>>added to the=20
>>
>>>>system, which will ensure a far better quality database in the long=20
>>>>run.  This also offers referential integrity, so that your database=20
>>>>cannot be accidentally corrupted by a bad program/user! :)
>>>>
>>>>May I ask in future that you might want to address support=20
>>
>>requests to=20
>>
>>>>the mailing list per...@li.... =20
>>
>>You can sign=20
>>
>>>>up for this from the bottom of PerfParse project page:
>>>>
>>>>http://sourceforge.net/projects/perfparse
>>>>
>>>>This will help other users with similar errors to fix their own=20
>>>>problems, and you may get a reply from another user who offers an=20
>>>>alternate fix.
>>>>
>>>>Kind regards,
>>>>
>>>>Ben Clewett.
>>>>
>>>>
>>>>Sand Philipp wrote:
>>>>
>>>>
>>>>
>>>>>Hi Ben,
>>>>>
>>>>>I just wanted to try out your perparse Plugin for Nagios,=20
>>
>>and got a=20
>>
>>>>>few problems in compiling the package...
>>>>>My OS: Fedora Core 1
>>>>>Nagios 1.2 (without MySQL)
>>>>>Mysql server version: 3.23.58
>>>>>
>>>>>When I run configure everything looks fine.
>>>>>When I run make (as root) the following messages are displayed:
>>>>>[root@nagios1 perfparse-0.08]# make
>>>>>make  all-recursive
>>>>>make[1]: Entering directory `/root/perfparse-0.08'
>>>>>Making all in src
>>>>>make[2]: Entering directory `/root/perfparse-0.08/src'
>>>>>if gcc -DHAVE_CONFIG_H -I. -I. -I.. -I'/usr/include'     =20
>>>>
>>>>-g -O2 -Wall
>>>>
>>>>
>>>>>-MT perfparse.o -MD -MP -MF ".deps/perfparse.Tpo" -c -o=20
>>
>>perfparse.o=20
>>
>>>>>perfparse.c; \
>>>>>
>>>>>then mv -f ".deps/perfparse.Tpo" ".deps/perfparse.Po"; else rm -f=20
>>>>>".deps/perfparse.Tpo"; exit 1; fi In file included from
>>>>>perfparse.c:35:
>>>>>common.h:29:19: mysql.h: No such file or directory
>>>>>common.h:30:20: errmsg.h: No such file or directory In file
>>>>
>>>>included
>>>>
>>>>>from perfparse.c:35:
>>>>
>>>>>common.h:41: error: syntax error before "db_mysql"
>>>>>common.h:41: warning: type defaults to `int' in declaration
>>>>
>>>>of `db_mysql'
>>>>
>>>>
>>>>>common.h:41: warning: data definition has no type or storage class
>>>>>common.h:42: error: syntax error before '*' token
>>>>>common.h:42: warning: type defaults to `int' in declaration of=20
>>>>>`query_result'
>>>>>common.h:42: warning: data definition has no type or storage class
>>>>>common.h:43: error: syntax error before "result_row"
>>>>>common.h:43: warning: type defaults to `int' in declaration
>>>>
>>>>of `result_row'
>>>>
>>>>
>>>>>common.h:43: warning: data definition has no type or storage class
>>>>>perfparse.c: In function `my_on_exit':
>>>>>perfparse.c:198: warning: implicit declaration of function
>>>>
>>>>`mysql_close'
>>>>
>>>>
>>>>>perfparse.c: In function `save_raw_data':
>>>>>perfparse.c:672: warning: implicit declaration of function=20
>>>>>`mysql_fetch_row'
>>>>>perfparse.c: In function `saveBinAllowed':
>>>>>perfparse.c:702: error: subscripted value is neither array
>>>>
>>>>nor pointer
>>>>
>>>>
>>>>>perfparse.c: In function `now_get_state':
>>>>>perfparse.c:1183: error: subscripted value is neither array nor=20
>>>>>pointer
>>>>>perfparse.c: In function `sql_fail':
>>>>>perfparse.c:1386: warning: implicit declaration of function
>>>>
>>>>`mysql_error'
>>>>
>>>>
>>>>>perfparse.c:1386: warning: format argument is not a pointer (arg 4)
>>>>>make[2]: *** [perfparse.o] Error 1
>>>>>make[2]: Leaving directory `/root/perfparse-0.08/src'
>>>>>make[1]: *** [all-recursive] Error 1
>>>>>make[1]: Leaving directory `/root/perfparse-0.08'
>>>>>make: *** [all] Error 2
>>>>>
>>>>>When i run ./make install then, the following is displayed:
>>>>>
>>>>>[root@nagios1 perfparse-0.08]# make install Making install in src
>>>>>make[1]: Entering directory `/root/perfparse-0.08/src'
>>>>>if gcc -DHAVE_CONFIG_H -I. -I. -I.. -I'/usr/include'     =20
>>>>
>>>>-g -O2 -Wall
>>>>
>>>>
>>>>>-MT perfparse.o -MD -MP -MF ".deps/perfparse.Tpo" -c -o=20
>>
>>perfparse.o=20
>>
>>>>>perfparse.c; \
>>>>>
>>>>>then mv -f ".deps/perfparse.Tpo" ".deps/perfparse.Po"; else rm -f=20
>>>>>".deps/perfparse.Tpo"; exit 1; fi In file included from
>>>>>perfparse.c:35:
>>>>>common.h:29:19: mysql.h: No such file or directory
>>>>>common.h:30:20: errmsg.h: No such file or directory In file
>>>>
>>>>included
>>>>
>>>>>from perfparse.c:35:
>>>>
>>>>>common.h:41: error: syntax error before "db_mysql"
>>>>>common.h:41: warning: type defaults to `int' in declaration
>>>>
>>>>of `db_mysql'
>>>>
>>>>
>>>>>common.h:41: warning: data definition has no type or storage class
>>>>>common.h:42: error: syntax error before '*' token
>>>>>common.h:42: warning: type defaults to `int' in declaration of=20
>>>>>`query_result'
>>>>>common.h:42: warning: data definition has no type or storage class
>>>>>common.h:43: error: syntax error before "result_row"
>>>>>common.h:43: warning: type defaults to `int' in declaration
>>>>
>>>>of `result_row'
>>>>
>>>>
>>>>>common.h:43: warning: data definition has no type or storage class
>>>>>perfparse.c: In function `my_on_exit':
>>>>>perfparse.c:198: warning: implicit declaration of function
>>>>
>>>>`mysql_close'
>>>>
>>>>
>>>>>perfparse.c: In function `save_raw_data':
>>>>>perfparse.c:672: warning: implicit declaration of function=20
>>>>>`mysql_fetch_row'
>>>>>perfparse.c: In function `saveBinAllowed':
>>>>>perfparse.c:702: error: subscripted value is neither array
>>>>
>>>>nor pointer
>>>>
>>>>
>>>>>perfparse.c: In function `now_get_state':
>>>>>perfparse.c:1183: error: subscripted value is neither array nor=20
>>>>>pointer
>>>>>perfparse.c: In function `sql_fail':
>>>>>perfparse.c:1386: warning: implicit declaration of function
>>>>
>>>>`mysql_error'
>>>>
>>>>
>>>>>perfparse.c:1386: warning: format argument is not a pointer (arg 4)
>>>>>make[1]: *** [perfparse.o] Error 1
>>>>>make[1]: Leaving directory `/root/perfparse-0.08/src'
>>>>>make: *** [install-recursive] Error 1
>>>>>
>>>>>
>>>>>Any suggestions?
>>>>>Thanks in advance!
>>>>>Philipp
>>>>>
>>>>>
>>>>>
>>>>>_____________________________
>>>>>
>>>>>*Philipp Sand*
>>>>>OC-CC-TEC-SYS
>>>>>
>>>>>*SYCOR GmbH*
>>>>>Heinrich-von-Stephan-Stra=DFe 1-5
>>>>>D - 37073 G=F6ttingen
>>>>>
>>>>>Telefon +49 (0) 551 / 490 - 0
>>>>>Telefax +49 (0) 551 / 490 - 2000
>>>>>
>>>>>_ph...@sy..._
>>>>>___www.sycor.de___ <file://www.sycor.de>__
>>>>>------------------------------------------------
>>>>>
>>>>
>>>>
>>>>
>>
>>
>=20

[Perfparse-users] Re: Antwort: Re: Antwort: Re: Perfparse 0.08 Compile-Error

[Ben C. <Be...@cl...>]

Thanks for the info on the links.

Worrying that PerfParse does not stop.  You can safely CRTL-C at any time.

Try killing perfparse.sh and perfparse, and running from the command 
line.  This will tell you what's going on:

$ perfparse --report
00:00:32 l 1739 read 938 @ 14.1 l/sec.  Met 496 @ 0.53 Met/l.  Drop 0.

This should end when all data had been added to the database.  You may 
have a very large amount of waiting data:

$ wc -l serviceperf.log

If this is the case, then it will take a while.  To enable Nagios to 
work better, you can use 'nice':

$ nice perfparse --report

This should allow Nagios to work without problem.  Obviously the next 
time it runs there will be a lot less data.

Ben



Norbert Wiedeke/GIS wrote:

> Hallo Ben,
> 
> now it seems, there a new Error !!!!
> 
> 
> For the compile-error I set two links
> 
> in /lib
> 
> ln   -s  libnss_files.so.2  libnss_files.so
> ln   -s  libdns_files.so.2  libdns_files.so
> 
> 
> 
> I started ./perfparse.sh. The Script runs and runs .......
> Nagios is now performing an Error for Zombies on all hosts.
> 
> Norbert.
> 
> 
> 
> 
> 
> 
> 
> Norbert.
> 
> 
> 
> 
> 
> 
>                                                                                                            
>                       Ben Clewett                                                                          
>                       <Be...@cl...         An:      Norbert Wiedeke/GIS                                
>                       .uk>                     <nor...@gi...>,                            
>                                                "'per...@li...'"                   
>                       14.06.04 14:31           <per...@li...>                     
>                                                Kopie:                                                      
>                                                Thema:   Re: Antwort: Re: Perfparse 0.08 Compile-Error      
>                                                                                                            
> 
> 
> 
> Norbert,
> 
> You have two empty lines at the top of your serviceperf.log.  If you
> remove these, PerfParse will work.  Please let me know.
> 
> Can you also tell me how you got it to compile, so that any other users
> with the same error can be helped?
> 
> Regards, Ben
> 
> Norbert Wiedeke/GIS wrote:
> 
>>Hallo,
>>
>>so, now I compiled and installed version 0.08.
>>
>>
>>perfparse.sh:
>>
>>Errors at the Start /usr/local/nagios/bin/perfparse.sh
>>
>>"INSERT INTO perfdata_service_raw (host_name, service_description, ctime,
>>txt_data) VALUES ('','',FROM_UNIXTIME(
>>),'')" failed:
>>You have an error in your SQL syntax.  Check the manual that corresponds
> 
> to
> 
>>your MySQL server version for the right syntax to use near '),'')' at
> 
> line
> 
>>2
>>
>>
>>
>>(See attached file: serviceperf.zip)
>>
>>
>>Norbert.
> 
> 
> 
> 
> 
> 

[Perfparse-users] Perfparse 0.08 Compile-Error

[Norbert Wiedeke/G. <nor...@gi...>]

Hallo,


for the new version Perfparse
now the Compiler ends in Errors:



 # make
make  all-recursive
make[1]: Entering directory `/space/perf4/perfparse-0.08'
Making all in src
make[2]: Entering directory `/space/perf4/perfparse-0.08/src'
if gcc -DHAVE_CONFIG_H -I. -I. -I..
-I/usr/local/mysql-standard-4.0.20-pc-linux-i686/include -mcpu=pentiumpro
-g -O2 -Wall -MT perfparse.o -MD -MP -MF ".deps/perfparse.Tpo" -c -o
perfparse.o perfparse.c; \
then mv -f ".deps/perfparse.Tpo" ".deps/perfparse.Po"; else rm -f
".deps/perfparse.Tpo"; exit 1; fi
perfparse.c: In function `get_metrics':
perfparse.c:398: warning: comparison between signed and unsigned
if gcc -DHAVE_CONFIG_H -I. -I. -I..
-I/usr/local/mysql-standard-4.0.20-pc-linux-i686/include -mcpu=pentiumpro
-g -O2 -Wall -MT config_file.o -MD -MP -MF ".deps/config_file.Tpo" -c -o
config_file.o config_file.c; \
then mv -f ".deps/config_file.Tpo" ".deps/config_file.Po"; else rm -f
".deps/config_file.Tpo"; exit 1; fi
if gcc -DHAVE_CONFIG_H -I. -I. -I..
-I/usr/local/mysql-standard-4.0.20-pc-linux-i686/include -mcpu=pentiumpro
-g -O2 -Wall -MT common.o -MD -MP -MF ".deps/common.Tpo" -c -o common.o
common.c; \
then mv -f ".deps/common.Tpo" ".deps/common.Po"; else rm -f
".deps/common.Tpo"; exit 1; fi
common.c: In function `hash':
common.c:223: warning: suggest parentheses around assignment used as truth
value
common.c: In function `strip':
common.c:267: warning: comparison between signed and unsigned
common.c:268: warning: comparison between signed and unsigned
common.c: In function `lcase':
common.c:280: warning: comparison between signed and unsigned
common.c: In function `ucase':
Gcommon.c:291: warning: comparison between signed and unsigned
if gcc -DHAVE_CONFIG_H -I. -I. -I..
-I/usr/local/mysql-standard-4.0.20-pc-linux-i686/include -mcpu=pentiumpro
-g -O2 -Wall -MT convert.o -MD -MP -MF ".deps/convert.Tpo" -c -o convert.o
convert.c; \
then mv -f ".deps/convert.Tpo" ".deps/convert.Po"; else rm -f
".deps/convert.Tpo"; exit 1; fi
/bin/sh ../libtool --mode=link gcc  -g -O2 -Wall   -o perfparse
perfparse.o config_file.o common.o convert.o
-L/usr/local/mysql-standard-4.0.20-pc-linux-i686/lib -lmysqlclient -lz
-lcrypt -lnsl -lm -lc -lnss_files -lnss_dns -lresolv -lc -lnss_files
-lnss_dns -lresolv
mkdir .libs
gcc -g -O2 -Wall -o perfparse perfparse.o config_file.o common.o convert.o
-L/usr/local/mysql-standard-4.0.20-pc-linux-i686/lib -lmysqlclient -lz
-lcrypt -lnsl -lm -lc -lnss_files -lnss_dns -lresolv -lc -lnss_files
-lnss_dns -lresolv
/usr/lib/gcc-lib/i486-suse-linux/3.3/../../../../i486-suse-linux/bin/ld:
cannot find -lnss_files
collect2: ld returned 1 exit status
make[2]: *** [perfparse] Error 1
make[2]: Leaving directory `/space/perf4/perfparse-0.08/src'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/space/perf4/perfparse-0.08'
make: *** [all] Error 2




Gruss  Norbert

[Perfparse-users] Re: Make error

[Ben C. <Be...@cl...>]

Phillipp,

You are never waiting my time, if I can do anything to help PerfParse=20
users I always will.

You problems is the version of SQL you are using.  Only the latest=20
version 4 supports transactions.

I would advise you to upgrade to the latest version.  Alternatively, you=20
can edit the source code in the directory 'src'.  Look for any lines like=
:

now_query("START TRANSACTION");

or

now_query("COMMIT");

And delete them.


Regards, Ben.




Sand Philipp wrote:

> Ah great now it works...thanks for that!
> Now i got another failure :( I just created the Database and the tables=
 with the mysql_create.sh skript contributed.
> Now i want to run perfparse and get the following:
> [root@nagios1 bin]# ./perfparse
> "START TRANSACTION" failed:
> You have an error in your SQL syntax near 'START TRANSACTION' at line 1
>=20
> My mysql.log shows the following:
>=20
> 040614 13:50:48     201 Connect     ro...@na... on nagios
>                     201 Query       SELECT file_name, line_in_file, las=
t_line_hash, pid, file_name FROM perfdata_state WHERE domain =3D '008DC5B=
5'
>                     201 Query       UPDATE perfdata_state SET pid =3D 1=
0227, line_in_file =3D 0, last_line_hash =3D '', file_name =3D '/usr/loca=
l/nagios/var/serviceperf.log' WHERE domain =3D '008DC5B5'
>                     201 Query       SET AUTOCOMMIT=3D0
>                     201 Query       START TRANSACTION
>                     201 Quit
>=20
> Sorry for wasting your time :)
>=20
> Philipp
>=20
>=20
>>-----Original Message-----
>>From: Ben Clewett [mailto:Ben...@ro...]=20
>>Sent: Monday, June 14, 2004 12:41 PM
>>To: Sand Philipp
>>Cc: 'per...@li...'
>>Subject: Re: Make error
>>
>>Hi Philipp,
>>
>>I am glad you have found PerfParse, and hope you will enjoy using it.
>>
>>Your error messages seem to indicate you do not have the=20
>>MySQL client development libs on your system.  These will=20
>>include the missing files 'mysql.h' and 'errmsg.h'.
>>
>>If you don't think this is the case, (errors in the make are=20
>>possible), enter the following and let me know if it replys=20
>>with anything:
>>
>>$ find / -name "mysql.h" -ls 2> /dev/null
>>
>>I do not know 'Fedora Core 1', so I am not sure how they=20
>>distribute the Mysql-devel package.  You can however obtain=20
>>this from MySQL by getting and installing the source package=20
>>from mysql.com.  It is the client development libs you need,=20
>>or the full package :)
>>
>>I also notice you are on MySQL version 3.  This does not=20
>>support transactions.  I strongly advice you upgrade to the=20
>>full version of MySQL 4, in what ever their latest release=20
>>version it, including the 'InnoDB', or 'max', release. =20
>>Transactions ensure that bad data cannot accidentally be=20
>>added to the system, which will ensure a far better quality=20
>>database in the long run.  This also offers referential=20
>>integrity, so that your database cannot be accidentally=20
>>corrupted by a bad program/user! :)
>>
>>May I ask in future that you might want to address support=20
>>requests to the mailing list=20
>>per...@li....  You can sign up for=20
>>this from the bottom of PerfParse project page:
>>
>>http://sourceforge.net/projects/perfparse
>>
>>This will help other users with similar errors to fix their=20
>>own problems, and you may get a reply from another user who=20
>>offers an alternate fix.
>>
>>Kind regards,
>>
>>Ben Clewett.
>>
>>
>>Sand Philipp wrote:
>>
>>
>>>Hi Ben,
>>>
>>>I just wanted to try out your perparse Plugin for Nagios, and got a=20
>>>few problems in compiling the package...
>>>My OS: Fedora Core 1
>>>Nagios 1.2 (without MySQL)
>>>Mysql server version: 3.23.58
>>>
>>>When I run configure everything looks fine.
>>>When I run make (as root) the following messages are displayed:
>>>[root@nagios1 perfparse-0.08]# make
>>>make  all-recursive
>>>make[1]: Entering directory `/root/perfparse-0.08'
>>>Making all in src
>>>make[2]: Entering directory `/root/perfparse-0.08/src'
>>>if gcc -DHAVE_CONFIG_H -I. -I. -I.. -I'/usr/include'     =20
>>
>>-g -O2 -Wall=20
>>
>>>-MT perfparse.o -MD -MP -MF ".deps/perfparse.Tpo" -c -o perfparse.o=20
>>>perfparse.c; \
>>>
>>>then mv -f ".deps/perfparse.Tpo" ".deps/perfparse.Po"; else rm -f=20
>>>".deps/perfparse.Tpo"; exit 1; fi In file included from=20
>>>perfparse.c:35:
>>>common.h:29:19: mysql.h: No such file or directory
>>>common.h:30:20: errmsg.h: No such file or directory In file=20
>>
>>included=20
>>
>>>from perfparse.c:35:
>>>common.h:41: error: syntax error before "db_mysql"
>>>common.h:41: warning: type defaults to `int' in declaration=20
>>
>>of `db_mysql'
>>
>>>common.h:41: warning: data definition has no type or storage class
>>>common.h:42: error: syntax error before '*' token
>>>common.h:42: warning: type defaults to `int' in declaration of=20
>>>`query_result'
>>>common.h:42: warning: data definition has no type or storage class
>>>common.h:43: error: syntax error before "result_row"
>>>common.h:43: warning: type defaults to `int' in declaration=20
>>
>>of `result_row'
>>
>>>common.h:43: warning: data definition has no type or storage class
>>>perfparse.c: In function `my_on_exit':
>>>perfparse.c:198: warning: implicit declaration of function=20
>>
>>`mysql_close'
>>
>>>perfparse.c: In function `save_raw_data':
>>>perfparse.c:672: warning: implicit declaration of function=20
>>>`mysql_fetch_row'
>>>perfparse.c: In function `saveBinAllowed':
>>>perfparse.c:702: error: subscripted value is neither array=20
>>
>>nor pointer
>>
>>>perfparse.c: In function `now_get_state':
>>>perfparse.c:1183: error: subscripted value is neither array nor=20
>>>pointer
>>>perfparse.c: In function `sql_fail':
>>>perfparse.c:1386: warning: implicit declaration of function=20
>>
>>`mysql_error'
>>
>>>perfparse.c:1386: warning: format argument is not a pointer (arg 4)
>>>make[2]: *** [perfparse.o] Error 1
>>>make[2]: Leaving directory `/root/perfparse-0.08/src'
>>>make[1]: *** [all-recursive] Error 1
>>>make[1]: Leaving directory `/root/perfparse-0.08'
>>>make: *** [all] Error 2
>>>
>>>When i run ./make install then, the following is displayed:
>>>
>>>[root@nagios1 perfparse-0.08]# make install Making install in src
>>>make[1]: Entering directory `/root/perfparse-0.08/src'
>>>if gcc -DHAVE_CONFIG_H -I. -I. -I.. -I'/usr/include'     =20
>>
>>-g -O2 -Wall=20
>>
>>>-MT perfparse.o -MD -MP -MF ".deps/perfparse.Tpo" -c -o perfparse.o=20
>>>perfparse.c; \
>>>
>>>then mv -f ".deps/perfparse.Tpo" ".deps/perfparse.Po"; else rm -f=20
>>>".deps/perfparse.Tpo"; exit 1; fi In file included from=20
>>>perfparse.c:35:
>>>common.h:29:19: mysql.h: No such file or directory
>>>common.h:30:20: errmsg.h: No such file or directory In file=20
>>
>>included=20
>>
>>>from perfparse.c:35:
>>>common.h:41: error: syntax error before "db_mysql"
>>>common.h:41: warning: type defaults to `int' in declaration=20
>>
>>of `db_mysql'
>>
>>>common.h:41: warning: data definition has no type or storage class
>>>common.h:42: error: syntax error before '*' token
>>>common.h:42: warning: type defaults to `int' in declaration of=20
>>>`query_result'
>>>common.h:42: warning: data definition has no type or storage class
>>>common.h:43: error: syntax error before "result_row"
>>>common.h:43: warning: type defaults to `int' in declaration=20
>>
>>of `result_row'
>>
>>>common.h:43: warning: data definition has no type or storage class
>>>perfparse.c: In function `my_on_exit':
>>>perfparse.c:198: warning: implicit declaration of function=20
>>
>>`mysql_close'
>>
>>>perfparse.c: In function `save_raw_data':
>>>perfparse.c:672: warning: implicit declaration of function=20
>>>`mysql_fetch_row'
>>>perfparse.c: In function `saveBinAllowed':
>>>perfparse.c:702: error: subscripted value is neither array=20
>>
>>nor pointer
>>
>>>perfparse.c: In function `now_get_state':
>>>perfparse.c:1183: error: subscripted value is neither array nor=20
>>>pointer
>>>perfparse.c: In function `sql_fail':
>>>perfparse.c:1386: warning: implicit declaration of function=20
>>
>>`mysql_error'
>>
>>>perfparse.c:1386: warning: format argument is not a pointer (arg 4)
>>>make[1]: *** [perfparse.o] Error 1
>>>make[1]: Leaving directory `/root/perfparse-0.08/src'
>>>make: *** [install-recursive] Error 1
>>>
>>>
>>>Any suggestions?
>>>Thanks in advance!
>>>Philipp
>>>
>>>
>>>
>>>_____________________________
>>>
>>>*Philipp Sand*
>>>OC-CC-TEC-SYS
>>>
>>>*SYCOR GmbH*
>>>Heinrich-von-Stephan-Stra=DFe 1-5
>>>D - 37073 G=F6ttingen
>>>
>>>Telefon +49 (0) 551 / 490 - 0
>>>Telefax +49 (0) 551 / 490 - 2000
>>>
>>>_ph...@sy..._
>>>___www.sycor.de___ <file://www.sycor.de>__
>>>------------------------------------------------
>>>
>>
>>
>>
>=20

[Perfparse-users] Re: Antwort: Re: Perfparse 0.08 Compile-Error

[Ben C. <Be...@cl...>]

Norbert,

You have two empty lines at the top of your serviceperf.log.  If you 
remove these, PerfParse will work.  Please let me know.

Can you also tell me how you got it to compile, so that any other users 
with the same error can be helped?

Regards, Ben

Norbert Wiedeke/GIS wrote:
> Hallo,
> 
> so, now I compiled and installed version 0.08.
> 
> 
> perfparse.sh:
> 
> Errors at the Start /usr/local/nagios/bin/perfparse.sh
> 
> "INSERT INTO perfdata_service_raw (host_name, service_description, ctime,
> txt_data) VALUES ('','',FROM_UNIXTIME(
> ),'')" failed:
> You have an error in your SQL syntax.  Check the manual that corresponds to
> your MySQL server version for the right syntax to use near '),'')' at line
> 2
> 
> 
> 
> (See attached file: serviceperf.zip)
> 
> 
> Norbert.

[Perfparse-users] Re: Make error

[Ben C. <Ben...@ro...>]

Hi Philipp,

I am glad you have found PerfParse, and hope you will enjoy using it.

Your error messages seem to indicate you do not have the MySQL client=20
development libs on your system.  These will include the missing files=20
'mysql.h' and 'errmsg.h'.

If you don't think this is the case, (errors in the make are possible),=20
enter the following and let me know if it replys with anything:

$ find / -name "mysql.h" -ls 2> /dev/null

I do not know 'Fedora Core 1', so I am not sure how they distribute the=20
Mysql-devel package.  You can however obtain this from MySQL by getting=20
and installing the source package from mysql.com.  It is the client=20
development libs you need, or the full package :)

I also notice you are on MySQL version 3.  This does not support=20
transactions.  I strongly advice you upgrade to the full version of=20
MySQL 4, in what ever their latest release version it, including the=20
'InnoDB', or 'max', release.  Transactions ensure that bad data cannot=20
accidentally be added to the system, which will ensure a far better=20
quality database in the long run.  This also offers referential=20
integrity, so that your database cannot be accidentally corrupted by a=20
bad program/user! :)

May I ask in future that you might want to address support requests to=20
the mailing list per...@li....  You can sign up=20
for this from the bottom of PerfParse project page:

http://sourceforge.net/projects/perfparse

This will help other users with similar errors to fix their own=20
problems, and you may get a reply from another user who offers an=20
alternate fix.

Kind regards,

Ben Clewett.


Sand Philipp wrote:

> Hi Ben,
>=20
> I just wanted to try out your perparse Plugin for Nagios, and got a few=
=20
> problems in compiling the package...
> My OS: Fedora Core 1
> Nagios 1.2 (without MySQL)
> Mysql server version: 3.23.58
>=20
> When I run configure everything looks fine.
> When I run make (as root) the following messages are displayed:
> [root@nagios1 perfparse-0.08]# make
> make  all-recursive
> make[1]: Entering directory `/root/perfparse-0.08'
> Making all in src
> make[2]: Entering directory `/root/perfparse-0.08/src'
> if gcc -DHAVE_CONFIG_H -I. -I. -I.. -I'/usr/include'      -g -O2 -Wall=20
> -MT perfparse.o -MD -MP -MF ".deps/perfparse.Tpo" -c -o perfparse.o=20
> perfparse.c; \
>=20
> then mv -f ".deps/perfparse.Tpo" ".deps/perfparse.Po"; else rm -f=20
> ".deps/perfparse.Tpo"; exit 1; fi
> In file included from perfparse.c:35:
> common.h:29:19: mysql.h: No such file or directory
> common.h:30:20: errmsg.h: No such file or directory
> In file included from perfparse.c:35:
> common.h:41: error: syntax error before "db_mysql"
> common.h:41: warning: type defaults to `int' in declaration of `db_mysq=
l'
> common.h:41: warning: data definition has no type or storage class
> common.h:42: error: syntax error before '*' token
> common.h:42: warning: type defaults to `int' in declaration of=20
> `query_result'
> common.h:42: warning: data definition has no type or storage class
> common.h:43: error: syntax error before "result_row"
> common.h:43: warning: type defaults to `int' in declaration of `result_=
row'
> common.h:43: warning: data definition has no type or storage class
> perfparse.c: In function `my_on_exit':
> perfparse.c:198: warning: implicit declaration of function `mysql_close=
'
> perfparse.c: In function `save_raw_data':
> perfparse.c:672: warning: implicit declaration of function=20
> `mysql_fetch_row'
> perfparse.c: In function `saveBinAllowed':
> perfparse.c:702: error: subscripted value is neither array nor pointer
> perfparse.c: In function `now_get_state':
> perfparse.c:1183: error: subscripted value is neither array nor pointer
> perfparse.c: In function `sql_fail':
> perfparse.c:1386: warning: implicit declaration of function `mysql_erro=
r'
> perfparse.c:1386: warning: format argument is not a pointer (arg 4)
> make[2]: *** [perfparse.o] Error 1
> make[2]: Leaving directory `/root/perfparse-0.08/src'
> make[1]: *** [all-recursive] Error 1
> make[1]: Leaving directory `/root/perfparse-0.08'
> make: *** [all] Error 2
>=20
> When i run ./make install then, the following is displayed:
>=20
> [root@nagios1 perfparse-0.08]# make install
> Making install in src
> make[1]: Entering directory `/root/perfparse-0.08/src'
> if gcc -DHAVE_CONFIG_H -I. -I. -I.. -I'/usr/include'      -g -O2 -Wall=20
> -MT perfparse.o -MD -MP -MF ".deps/perfparse.Tpo" -c -o perfparse.o=20
> perfparse.c; \
>=20
> then mv -f ".deps/perfparse.Tpo" ".deps/perfparse.Po"; else rm -f=20
> ".deps/perfparse.Tpo"; exit 1; fi
> In file included from perfparse.c:35:
> common.h:29:19: mysql.h: No such file or directory
> common.h:30:20: errmsg.h: No such file or directory
> In file included from perfparse.c:35:
> common.h:41: error: syntax error before "db_mysql"
> common.h:41: warning: type defaults to `int' in declaration of `db_mysq=
l'
> common.h:41: warning: data definition has no type or storage class
> common.h:42: error: syntax error before '*' token
> common.h:42: warning: type defaults to `int' in declaration of=20
> `query_result'
> common.h:42: warning: data definition has no type or storage class
> common.h:43: error: syntax error before "result_row"
> common.h:43: warning: type defaults to `int' in declaration of `result_=
row'
> common.h:43: warning: data definition has no type or storage class
> perfparse.c: In function `my_on_exit':
> perfparse.c:198: warning: implicit declaration of function `mysql_close=
'
> perfparse.c: In function `save_raw_data':
> perfparse.c:672: warning: implicit declaration of function=20
> `mysql_fetch_row'
> perfparse.c: In function `saveBinAllowed':
> perfparse.c:702: error: subscripted value is neither array nor pointer
> perfparse.c: In function `now_get_state':
> perfparse.c:1183: error: subscripted value is neither array nor pointer
> perfparse.c: In function `sql_fail':
> perfparse.c:1386: warning: implicit declaration of function `mysql_erro=
r'
> perfparse.c:1386: warning: format argument is not a pointer (arg 4)
> make[1]: *** [perfparse.o] Error 1
> make[1]: Leaving directory `/root/perfparse-0.08/src'
> make: *** [install-recursive] Error 1
>=20
>=20
> Any suggestions?
> Thanks in advance!
> Philipp
>=20
>=20
>=20
> _____________________________
>=20
> *Philipp Sand*
> OC-CC-TEC-SYS
>=20
> *SYCOR GmbH*
> Heinrich-von-Stephan-Stra=DFe 1-5
> D - 37073 G=F6ttingen
>=20
> Telefon +49 (0) 551 / 490 - 0
> Telefax +49 (0) 551 / 490 - 2000
>=20
> _ph...@sy..._
> ___www.sycor.de___ <file://www.sycor.de>__
> ------------------------------------------------
>=20

[Perfparse-users] Error from PerfParse

[Ben C. <Ben...@ro...>]

Norbert,

I am glad you have got further with PerfParse.  May I ask what version 
you are using?

The error you have got is likely to mean that there is nothing, or an 
error in the first like of nagios/var/serviceperf.log

Can you please send me the first few lines of this file?

This will report a better error in later versions.

May I ask in future that you might want to address support requests to 
the mailing list per...@li....  You can sign up 
for this from the bottom of PerfParse project page:

http://sourceforge.net/projects/perfparse

This will help other users with similar errors to fix their own 
problems, and you may get a reply from another user who offers an 
alternate fix.

Kind regards,

Ben Clewett.


Norbert Wiedeke/GIS wrote:
> Hallo Ben,
> 
> now I have compiled and installed Nagios 1.2 with (./configure
> --with-file-perfdata)
> , the newest plugin's and so on.
> 
> 'check_disk' replies:
> 
> DISK OK - free space: / 484 MB (24%); /space 11154 MB (52%); /dev/shm 251
> MB (100%);| /=483MB;1700;1900;0;2000 /space=11153MB;18270;20420;0;21495
> /dev/shm=251MB;213;238;0;251
> 
> 
> Errors at the Start /usr/local/nagios/bin/perfparse.sh
> 
> "INSERT INTO perfdata_service_raw (host_name, service_description, ctime,
> txt_data) VALUES ('','',FROM_UNIXTIME(
> ),'')" failed:
> You have an error in your SQL syntax.  Check the manual that corresponds to
> your MySQL server version for the right syntax to use near '),'')' at line
> 2
> 
> 
> In Process Info:
> 
> "Performance Data Being Processed?    Yes"
> 
> 
> 
> Norbert.
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
>                                                                                                                  
>                       Ben Clewett                                                                                
>                       <Ben.Clewett@roadrun         An:      Norbert Wiedeke/GIS <nor...@gi...>  
>                       ner.uk.com>                  Kopie:                                                        
>                                                    Thema:   Re: Antwort: Re: Antwort: Re: Antwort: Re:           
>                       08.06.04 15:11               perfparse-0.07                                                
>                                                                                                                  
>                                                                                                                  
> 
> 
> 
> Norbert,
> 
> Sorry I got your name wrong :)
> 
> I think your nagios is not producing the performance data you need.  I
> have a check-list here which you might find helpful:
> 
> 
> 1. You are using the latest Nagios, 1.2.
> 
> 2. You are using the latest nagios plugins.  Only these produce
> performance data.  You can check this by running one, like 'check_disk'.
>   If you have performance data, this should reply:
> 
> DISK OK - free space: / 8089 MB (22%); /boot 35 MB (76%) |
> /=8089MB;33312;35163;0;37014 /boot=34MB;40;42;0;45
> 
> You can see the performance data beyond the '|'.
> 
> Download from:
> 
> http://nagiosplug.sourceforge.net/snapshot
> http://nagiosplug.sourceforge.net/snapshot/nagios-plugins-HEAD-200406080514.tar.gz
> 
> 
> 3. You have compiled nagios with the option to produce performance data.
>   Using the '--with-file-perfdata'.  Ie:
> 
> ./configure --with-file-perfdata
> 
> 4. Set the permissions on the servicelog file as:
>      -rw-rw-r-- nagios nagios
> ie:
> $ chmod 664 serviceperf.log
> $ chown nagios.nagios serviceperf.log
> 
> 5. Check 'nagios.cfg', ensure you have these lines somewhere:
> 
> process_performance_data=1
> xpdfile_host_perfdata_file=/usr/local/nagios/var/hostperf.log
> xpdfile_host_perfdata_template=$TIMET$\t$HOSTNAME$\t$OUTPUT$\t$PERFDATA$
> xpdfile_service_perfdata_file=/usr/local/nagios/var/serviceperf.log
> xpdfile_service_perfdata_template=$TIMET$\t$HOSTNAME$\t$SERVICEDESC
> $\t$OUTPUT$\t$PERFDATA$
> 
> 6. In services.cfg, ensure this line is in all services you want to
> monitor:  (Or the generic parent table.)
> 
> process_perf_data 1
> 
> 7. In Nagios 'Process Info' page. At the bottom of the Process
> Information box, ensure you have:
> 
> "Performance Data Being Processed?    Yes"
> 
> 
> Regards, Ben.
> 
> 
> 
> 
> 
> 

Re: [Perfparse-users] Great Potential

[Ben C. <Be...@cl...>]

Thanks for the complement.  I hope you go on enjoying the product.

To get perfparse working for all plugins, you must use the latest 
snapshot data on all hosts.  These can be obtained from:

http://nagiosplug.sourceforge.net/snapshot/nagios-plugins-HEAD-200406080514.tar.gz

These will eventually be available in the standard release.

I am very interested in your alterations to the MySQL schema.  I want to 
ensure that later versions are compatible with your changes.  But I also 
want to make sure that there is nothing missing from the current schema. 
If you could let me know of your changes, I'll ensure that the product 
remains compatible, and any extra benefits are available to all users, 
with your permission.

Kind regards, Ben.

Tony Hart wrote:

> Well, what a surprise. I have been looking for this type of functionality
> for some time. Even given the early stages of development it has shown great
> potential.
> 
> For your information - I have installed ( albeit with some modifications to
> the database schema to match our requirements ) onto two Nagios systems, and
> found that while most plug-ins do not return performance metrics the NRPE
> components do ( running on Solaris ). I have some ugly procedures to
> generate our own for ping RTA's and the like, as well as some other critical
> components but the reliability of the software and the display mechanisms
> are first-rate.
> 
> Well done.
> 
> Regards,
> Tony Hart
> 
> Chief Technical Architect
> ASX
> 
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: GNOME Foundation
> Hackers Unite!  GUADEC: The world's #1 Open Source Desktop Event.
> GNOME Users and Developers European Conference, 28-30th June in Norway
> http://2004/guadec.org
> _______________________________________________
> Perfparse-users mailing list
> Per...@li...
> https://lists.sourceforge.net/lists/listinfo/perfparse-users
> 

[Perfparse-users] Great Potential

[Tony H. <Ton...@as...>]

Well, what a surprise. I have been looking for this type of functionality
for some time. Even given the early stages of development it has shown great
potential.

For your information - I have installed ( albeit with some modifications to
the database schema to match our requirements ) onto two Nagios systems, and
found that while most plug-ins do not return performance metrics the NRPE
components do ( running on Solaris ). I have some ugly procedures to
generate our own for ping RTA's and the like, as well as some other critical
components but the reliability of the software and the display mechanisms
are first-rate.

Well done.

Regards,
Tony Hart

Chief Technical Architect
ASX

[Perfparse-users] Re: [perfparse - Help] RE: Missing metrics?

[Ben C. <Be...@cl...>]

Jason,

1.  You will have to check the metrics and see what they give.  I 
believe they are trying to get 100% coverage of the plugins.  So even if 
not now, definitely soon.  Any missing ones, drop them an email to their 
mailing list, I am sure they will give you a polite reply.  Certainly I 
have found all the UNIX ones for checking the basics are all working.

2.  Yes, you can use them.  But might be a good idea to compile in 
parallel with stable ones.  Any which don't work, copy over from stable 
release.  But I would be surprised if you have to.

Thanks greatly for the complement!

Regards, Ben.

SourceForge.net wrote:

> Read and respond to this message at: 
> https://sourceforge.net/forum/message.php?msg_id=2605701
> By: jasonashworth
> 
> Had a feeling that might be it...
> 
> So, last two questions - 
> 1. What performance data will I be able to extract from this snapshot of the
> plugins (doesn't detail much in the changelog) - what I really need to be able
> to graph is things like CPU use, and disk space usage on NT and NW boxes...
> 2. Do you reckon these plugins are stable enough for production use?
> 
> Thanks for the help, and once again, keep up the good work on a great
> project...!
> 
> ______________________________________________________________________
> You are receiving this email because you elected to monitor this forum.
> To stop monitoring this forum, login to SourceForge.net and visit: 
> https://sourceforge.net/forum/unmonitor.php?forum_id=375250
> 

[Perfparse-users] Re: [perfparse - Help] Missing metrics?

[Ben C. <Be...@cl...>]

Jason,

You problem is unfortunately common.  The nagios plugin's which support 
performance data are so new that even the alpha-release does not contain 
them.  PerfParse does not contain an entry until it finds the first 
metric for a service.  Then it will be created automatically.

You need to get the latest snapshot, which is available from a link on 
the plugin web site:

http://nagiosplug.sourceforge.net

At time of writing, this is:

http://nagiosplug.sourceforge.net/snapshot/nagios-plugins-HEAD-200406070514.tar.gz

I have CC'd this message to the nagios plugin developers page, as I my 
self are very interested to know when these will be released.

Please continue to enjoy PerfParse!

Ben

http://sourceforge.net/projects/perfparse/
PerfParse. Storage and analysis of binary performance data produced by 
Nagios. High quality accurate graphs of live data from standard Nagios 
plugins. Permanent history of plugin results with advanced analysis tools




SourceForge.net wrote:

> Read and respond to this message at: 
> https://sourceforge.net/forum/message.php?msg_id=2602758
> By: jasonashworth
> 
> Just about got PerfParse running now - just got to get the shell script scheduled
> in cron (maybe this should be in the docs soon?)
> 
> Only problem is, the only metrics I seem to get is any based on the check_tcp
> plugin.  None of the rest are selectable, or even in the perfdata_service_bin
> table, although they're all in the perfdata_service table.
> 
> Why is this?  Is it because I'm using Plugins v1.3.1?  If so, is the new 1.4x
> stable enough for production use?
> 
> P.S.  Looks like it's going to be a great product - just what Nagios has needed
> for a long time!!

[Perfparse-users] New version, 0.06

[Ben C. <Be...@cl...>]

Dear Users,

Some of you have been rightly concerned with the amount of database 
space PerfParse takes up.  For me this is about 1GB/week!  To address 
these concerns, there is a new version (0.06) with some extras.

The main parsing program 'perfparse' now has two options:

--no-raw

This flag tells PerfParse not to store the raw data.  This is the 
textual output from the plugins, and takes up the most room in the 
database.  Current versions do nothing with this data anyway :)

--del-old n

This will delete *all* data older than n days.  Use with care!

Secondly, within the cgi application there is a new tool to define a 
policy for storage of data for each Binary Metric.  Ie, the data used to 
draw the graphs.  There are three options:

Never Delete		Permanently store data, unless deletes as above.
Always Delete		Store no data for this metric.
Keep for n days.	Store data for n days, then delete.

These policies will be executed on each run of PerfParse.

Please address any comment to this mailing group where I will be glad to 
answer you privately, on in a reply.

Regards, Ben.



Ben Clewett wrote:

> Getting performance data out of Nagios seems so far to be the part which 
> most bothers people.  Any help in this direction would I am sure be very 
> well received by many people.
> 
> I look forward to getting the document,
> 
> Ben
> 
> Cook, Garry wrote:
> 
>> Yes. I have not spent much time yet actually installing perfparse. I
>> took a quick look at it last Thursday before taking a little vacation. I
>> hope to download the new version and continue working with it this week,
>> as well as continue work on the HOW-TO. At this point, the HOW-TO is
>> current up to the point where I needed to turn on Performance Data
>> processing via the Nagios web page. So, it's really more of a 'Nagios
>> Performance Data HOW-TO'. So, I'll see if I can clean this up a bit and
>> send it over to you later today.
>>
>> Garry W. Cook, CCNA
>> Network Infrastructure Manager
>> MACTEC, Inc. - http://www.mactec.com/
>> 303.308.6228 (Office) - 720.220.1862 (Mobile)
>>
>> Ben Clewett wrote:
>>
>>> Garry, I am very glad to hear that it works for you.  It does sound a
>>> bit odd.  I never had to turn it on here.  Can you remember
>>> ever turning
>>> it off?
>>>
>>> You you be able to put together a check-list of all the
>>> things which you
>>> had to do to get the data.  Which we can put live on the site
>>> and link
>>> from the web page?  I dread to think from the 130+ people who have
>>> downloaded perfparse, how many have also given up because of
>>> this problem.
>>>
>>> Well, enjoy using the product,
>>>
>>> Ben
>>>
>>> Cook, Garry wrote:
>>>
>>>
>>>> No, that wasn't the issue. However, I did finally find the solution!
>>>> I opened my Nagios web page, and went to the 'Process Info' page. At
>>>> the bottom of the Process Information box I saw:
>>>>
>>>> "Performance Data Being Processed?     No"
>>>>
>>>> So, in the 'Process Commands' box I clicked on "Enable performance
>>>> data". This solved the problem.
>>>>
>>>> Did I miss something somewhere? Shouldn't the changes to the config
>>>> files make performance data active? In other words, is this a bug
>>>> that I've found or do you think it was Ethan's intention to have us
>>>> enable it in the configs and then have to manually turn it on via
>>>> the web page? If it was intentional, then the docs should be updated.
>>>>
>>>> I've copied Ethan directly on this message, rather than clutter up
>>>> the Nagios list any further.
>>>> -g
>>
>>
>>
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: Oracle 10g
> Get certified on the hottest thing ever to hit the market... Oracle 10g. 
> Take an Oracle 10g class now, and we'll give you the exam FREE.
> http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click
> _______________________________________________
> Perfparse-users mailing list
> Per...@li...
> https://lists.sourceforge.net/lists/listinfo/perfparse-users
> 

Re: [Perfparse-users] No data in serviceperf.log file.

[Ben C. <Be...@cl...>]

Getting performance data out of Nagios seems so far to be the part which 
most bothers people.  Any help in this direction would I am sure be very 
well received by many people.

I look forward to getting the document,

Ben

Cook, Garry wrote:

> Yes. I have not spent much time yet actually installing perfparse. I
> took a quick look at it last Thursday before taking a little vacation. I
> hope to download the new version and continue working with it this week,
> as well as continue work on the HOW-TO. At this point, the HOW-TO is
> current up to the point where I needed to turn on Performance Data
> processing via the Nagios web page. So, it's really more of a 'Nagios
> Performance Data HOW-TO'. So, I'll see if I can clean this up a bit and
> send it over to you later today.
> 
> Garry W. Cook, CCNA
> Network Infrastructure Manager
> MACTEC, Inc. - http://www.mactec.com/
> 303.308.6228 (Office) - 720.220.1862 (Mobile)
> 
> Ben Clewett wrote:
> 
>>Garry, I am very glad to hear that it works for you.  It does sound a
>>bit odd.  I never had to turn it on here.  Can you remember
>>ever turning
>>it off?
>>
>>You you be able to put together a check-list of all the
>>things which you
>>had to do to get the data.  Which we can put live on the site
>>and link
>>from the web page?  I dread to think from the 130+ people who have
>>downloaded perfparse, how many have also given up because of
>>this problem.
>>
>>Well, enjoy using the product,
>>
>>Ben
>>
>>Cook, Garry wrote:
>>
>>
>>>No, that wasn't the issue. However, I did finally find the solution!
>>>I opened my Nagios web page, and went to the 'Process Info' page. At
>>>the bottom of the Process Information box I saw:
>>>
>>>"Performance Data Being Processed?     No"
>>>
>>>So, in the 'Process Commands' box I clicked on "Enable performance
>>>data". This solved the problem.
>>>
>>>Did I miss something somewhere? Shouldn't the changes to the config
>>>files make performance data active? In other words, is this a bug
>>>that I've found or do you think it was Ethan's intention to have us
>>>enable it in the configs and then have to manually turn it on via
>>>the web page? If it was intentional, then the docs should be updated.
>>>
>>>I've copied Ethan directly on this message, rather than clutter up
>>>the Nagios list any further. 
>>>
>>>-g
> 
> 

RE: [Perfparse-users] No data in serviceperf.log file.

[Cook, G. <GW...@ma...>]

Yes. I have not spent much time yet actually installing perfparse. I
took a quick look at it last Thursday before taking a little vacation. I
hope to download the new version and continue working with it this week,
as well as continue work on the HOW-TO. At this point, the HOW-TO is
current up to the point where I needed to turn on Performance Data
processing via the Nagios web page. So, it's really more of a 'Nagios
Performance Data HOW-TO'. So, I'll see if I can clean this up a bit and
send it over to you later today.

Garry W. Cook, CCNA
Network Infrastructure Manager
MACTEC, Inc. - http://www.mactec.com/
303.308.6228 (Office) - 720.220.1862 (Mobile)

Ben Clewett wrote:
> Garry, I am very glad to hear that it works for you.  It does sound a
> bit odd.  I never had to turn it on here.  Can you remember
> ever turning
> it off?
>=20
> You you be able to put together a check-list of all the
> things which you
> had to do to get the data.  Which we can put live on the site
> and link
> from the web page?  I dread to think from the 130+ people who have
> downloaded perfparse, how many have also given up because of
> this problem.
>=20
> Well, enjoy using the product,
>=20
> Ben
>=20
> Cook, Garry wrote:
>=20
>> No, that wasn't the issue. However, I did finally find the solution!
>> I opened my Nagios web page, and went to the 'Process Info' page. At
>> the bottom of the Process Information box I saw:
>>=20
>> "Performance Data Being Processed?     No"
>>=20
>> So, in the 'Process Commands' box I clicked on "Enable performance
>> data". This solved the problem.
>>=20
>> Did I miss something somewhere? Shouldn't the changes to the config
>> files make performance data active? In other words, is this a bug
>> that I've found or do you think it was Ethan's intention to have us
>> enable it in the configs and then have to manually turn it on via
>> the web page? If it was intentional, then the docs should be updated.
>>=20
>> I've copied Ethan directly on this message, rather than clutter up
>> the Nagios list any further.=20
>>=20
>> -g

[Perfparse-users] Re: PerfParse Query

[Ben C. <Be...@cl...>]

Swarup,

I am glad you have it working.

It will add hosts as and when it finds data for them.  The reasons it=20
has not added all hosts can only be that there is not yet any data for th=
em.

You will want to run 'perfparse' frequently.  I find that once every ten=20
minutes is good.  You will find a file 'perfparse.sh' which should have=20
been moved into nagios/bin.  Run this from the cron every ten minutes.

This will add lost of data.  The main reason for perfparse is to have a=20
permanent record of your network.  My database of about one months has=20
3.6 million records in the perfdata_service_bin file, and the whole=20
database is about 4.5 Gb in size.  My best advise is to allow lots of=20
room, or store data for just a few hosts, or use a long check frequency=20
within Nagios.  Also use Nagios to check on the size of this disk.  You=20
also may want to control the MySQL logs, they grow much faster than the=20
data they log.

At least disks are cheep at the moment.  A 120Gb disk capable of holding=20
two years of our data is less than $100. (=A375 here in UK.)

There is not yet any method of deleting from this database.  If you wish=20
to delete, then you will have to manually.  Using 'mysql', enter=20
something like:

DELETE FROM perfdata_service_bin WHERE ctime < NOW() - INTERVAL 30 DAYS;
DELETE FROM perfdata_service_raw WHERE ctime < NOW() - INTERVAL 30 DAYS;

If you don't use the 'raw' data, which is not used by any of PerfParse,=20
then simply enter:

DELETE FROM perfdata_service_raw;

Or, if you just want to delete data from a specific host, enter:

DELETE FROM perfdata_service_bin WHERE host =3D 'host_name' AND ctime <=20
NOW() - INTERVAL 30 DAYS;

You can add any of these commands into perfparse.sh.  Eg:

echo "DELETE FROM perfdata_service_raw;" | mysql -u user -ppass -D=20
database -h hostname

Deleting the MySQL logs is simple.  Find the data or log directory and=20
enter:

# rm database-bin.0*
# rm access.log

Where 'database' is the name of your host, which may be changed in my.cfg.

DO NOT EVER delete database-bin.index !!!!

These features will be added to the product at some time in the (near)=20
future.

Regards, Ben.

PS, I have posted this reply to perfparse-users mailing list for the=20
interest of other users.

[Perfparse-users] Re: PerfParse Query

[Ben C. <Ben...@ro...>]

Swarup,

Sorry but you do need to compile with --with-file-perfdata.  There is no 
other method to get Nagios to produce the data.

The following is a check-sheet of other Nagios related problems:

1. You are using the latest Nagios, 1.2.

2. You are using the latest nagios plugins.  Only these produce 
performance data.  You can check this by running one, like 'check_disk'. 
  If you have performance data, this should reply:

DISK OK - free space: / 8089 MB (22%); /boot 35 MB (76%) | 
/=8089MB;33312;35163;0;37014 /boot=34MB;40;42;0;45

You can see the performance data beyond the '|'.

3. You have compiled nagios with the option to produce performance data. 
  Using the '--with-file-perfdata'.  Ie:

./configure --with-file-perfdata

4. Set the permissions on the servicelog file as:
	-rw-rw-r-- nagios nagios
ie:
$ chmod 664 serviceperf.log
$ chown nagios.nagios serviceperf.log

5. Check 'nagios.cfg', ensure you have these lines somewhere:

process_performance_data=1
xpdfile_host_perfdata_file=/usr/local/nagios/var/hostperf.log
xpdfile_host_perfdata_template=$TIMET$\t$HOSTNAME$\t$OUTPUT$\t$PERFDATA$
xpdfile_service_perfdata_file=/usr/local/nagios/var/serviceperf.log
xpdfile_service_perfdata_template=$TIMET$\t$HOSTNAME$\t$SERVICEDESC$\t$OUTPUT$\t$PERFDATA$

6. In services.cfg, ensure this line is in all services you want to 
monitor:  (Or the generic parent table.)

process_perf_data 1

7. In Nagios 'Process Info' page. At the bottom of the Process 
Information box, ensure you have:

"Performance Data Being Processed?    Yes"


Regard, Ben

[Perfparse-users] Re: PerfParse Query

[Ben C. <Be...@cl...>]

Swarup,

I believe you do not have the library 'libmysqlclient', or this is in 
the wrong directory.  Can you please try and locate this lib:

# find / -name "libmysqlclient*"

When you have the location, please edit the Makefile:

LDFLAGS= -L/usr/local/lib/mysql -lmysqlclient -lm

Adjust the '-L' Linkage path for that which is correct for your setup.

Please let me know if this solves your problem.

Regards, Ben.

PS, I will would like to copy this email to the mailing list 
'perfparse-users' so that other users can see these comments.




Swarup Kumar wrote:

> Sir, 
>      I am trying to install perfparse on redhat enterprise. I have installed 
> nagios 1.2 in /usr/local/nms directory. Before compiling the perfparse, i 
> made the necessary PATH changes in config.h,Makefile and perfparse.cfg.
> I am already using mysql and have created a database named nms with the 
> command supplied by u in README.txt.
> I have installed Mysql 4.0.18 and running fine.
> 
> Now when i run perfparse command to start it, gives me the following error:
> 
> 
> [root@cruxonline bin]# ./perfparse
> ./perfparse: error while loading shared libraries: libmysqlclient.so.10: 
> cannot open shared object file: No such file or directory
> [root@cruxonline bin]#
> 
> 
> Please help
> 
> Thanks
> 
> Swarup Kumar
> INDIA
> 

Re: [Perfparse-users] No data in serviceperf.log file.

[Ben C. <Be...@cl...>]

Garry, I am very glad to hear that it works for you.  It does sound a 
bit odd.  I never had to turn it on here.  Can you remember ever turning 
it off?

You you be able to put together a check-list of all the things which you 
had to do to get the data.  Which we can put live on the site and link 
from the web page?  I dread to think from the 130+ people who have 
downloaded perfparse, how many have also given up because of this problem.

Well, enjoy using the product,

Ben

Cook, Garry wrote:

> No, that wasn't the issue. However, I did finally find the solution!
> I opened my Nagios web page, and went to the 'Process Info' page. At the 
> bottom of the Process Information box I saw:
>  
> "Performance Data Being Processed?     No"
>  
> So, in the 'Process Commands' box I clicked on "Enable performance 
> data". This solved the problem.
>  
> Did I miss something somewhere? Shouldn't the changes to the config 
> files make performance data active? In other words, is this a bug that 
> I've found or do you think it was Ethan's intention to have us enable it 
> in the configs and then have to manually turn it on via the web page? If 
> it was intentional, then the docs should be updated.
>  
> I've copied Ethan directly on this message, rather than clutter up the 
> Nagios list any further.
>  
> -g

RE: [Perfparse-users] No data in serviceperf.log file.

[Cook, G. <GW...@ma...>]

Tm8sIHRoYXQgd2Fzbid0IHRoZSBpc3N1ZS4gSG93ZXZlciwgSSBkaWQgZmluYWxseSBmaW5kIHRo
ZSBzb2x1dGlvbiENCkkgb3BlbmVkIG15IE5hZ2lvcyB3ZWIgcGFnZSwgYW5kIHdlbnQgdG8gdGhl
ICdQcm9jZXNzIEluZm8nIHBhZ2UuIEF0IHRoZSBib3R0b20gb2YgdGhlIFByb2Nlc3MgSW5mb3Jt
YXRpb24gYm94IEkgc2F3Og0KIA0KIlBlcmZvcm1hbmNlIERhdGEgQmVpbmcgUHJvY2Vzc2VkPyAg
ICAgTm8iDQogDQpTbywgaW4gdGhlICdQcm9jZXNzIENvbW1hbmRzJyBib3ggSSBjbGlja2VkIG9u
ICJFbmFibGUgcGVyZm9ybWFuY2UgZGF0YSIuIFRoaXMgc29sdmVkIHRoZSBwcm9ibGVtLg0KIA0K
RGlkIEkgbWlzcyBzb21ldGhpbmcgc29tZXdoZXJlPyBTaG91bGRuJ3QgdGhlIGNoYW5nZXMgdG8g
dGhlIGNvbmZpZyBmaWxlcyBtYWtlIHBlcmZvcm1hbmNlIGRhdGEgYWN0aXZlPyBJbiBvdGhlciB3
b3JkcywgaXMgdGhpcyBhIGJ1ZyB0aGF0IEkndmUgZm91bmQgb3IgZG8geW91IHRoaW5rIGl0IHdh
cyBFdGhhbidzIGludGVudGlvbiB0byBoYXZlIHVzIGVuYWJsZSBpdCBpbiB0aGUgY29uZmlncyBh
bmQgdGhlbiBoYXZlIHRvIG1hbnVhbGx5IHR1cm4gaXQgb24gdmlhIHRoZSB3ZWIgcGFnZT8gSWYg
aXQgd2FzIGludGVudGlvbmFsLCB0aGVuIHRoZSBkb2NzIHNob3VsZCBiZSB1cGRhdGVkLg0KIA0K
SSd2ZSBjb3BpZWQgRXRoYW4gZGlyZWN0bHkgb24gdGhpcyBtZXNzYWdlLCByYXRoZXIgdGhhbiBj
bHV0dGVyIHVwIHRoZSBOYWdpb3MgbGlzdCBhbnkgZnVydGhlci4NCiANCi1nDQoNCgktLS0tLU9y
aWdpbmFsIE1lc3NhZ2UtLS0tLSANCglGcm9tOiBCZW4gQ2xld2V0dCBbbWFpbHRvOkJlbkBjbGV3
ZXR0Lm9yZy51a10gDQoJU2VudDogVGh1IDUvMjcvMjAwNCAxMDoxOSBBTSANCglUbzogQ29vaywg
R2FycnkgDQoJQ2M6IHBlcmZwYXJzZS11c2Vyc0BsaXN0cy5zb3VyY2Vmb3JnZS5uZXQgDQoJU3Vi
amVjdDogUmU6IFtQZXJmcGFyc2UtdXNlcnNdIE5vIGRhdGEgaW4gc2VydmljZXBlcmYubG9nIGZp
bGUuDQoJDQoJDQoNCglDb3VsZCBiZSB0aGUgb25lIQ0KCQ0KCVllcywgdGhpcyBpcyBzZXQgdG8g
JzEnIGluIG15IHBhcmVudCB0YWJsZS4NCgkNCglCZXN0IG9mIGx1Y2suLi4uDQoJDQoJQmVuDQoJ
DQoJQ29vaywgR2Fycnkgd3JvdGU6DQoJPiBNYXJjZWxvLA0KCT4gQXMgQmVuIGlzIGF3YXJlLCBJ
J20gY3VycmVudGx5IHNlZWluZyB0aGUgc2FtZSBwcm9ibGVtIHRoYXQgSSB0aGluayB5b3UNCgk+
IGFyZSBoYXZpbmcuIEknbSBub3Qgc3VyZSwgYXMgSSBoYXZlIG5vdCBzZWVuIHlvdXIgb3JpZ2lu
YWwgbWVzc2FnZS4NCgk+IFRoZSBnb29kIG5ld3MgaXMsIEkgdGhpbmsgSSd2ZSBmaW5hbGx5IHN0
dW1ibGVkIHVwb24gdGhlIHNvbHV0aW9uIQ0KCT4gVW5mb3J0dW5hdGVseSwgSSBkb24ndCBoYXZl
IHRpbWUgdG8gdGVzdCBpdCByaWdodCBub3csIGJ1dCBoZXJlIGlzIHdoYXQNCgk+IEkndmUgZm91
bmQ6DQoJPiANCgk+IEluIHRoZSBzZXJ2aWNlcy5jZmcsIHRoZXJlIGlzIGEgZGlyZWN0aXZlIGlu
IHRoZSBzZXJ2aWNlIGRlZmluaXRpb25zDQoJPiBjYWxsZWQgJ3Byb2Nlc3NfcGVyZl9kYXRhJy4g
SSBmb3VuZCB0aGlzIGluIHRoZSBtYWluICdnZW5lcmljLXNlcnZpY2UnDQoJPiB0ZW1wbGF0ZS4g
VW5mb3J0dW5hdGVseSwgSSd2ZSBjcmVhdGVkIG15IG93biB0ZW1wbGF0ZSBzZXJ2aWNlcyBhbmQg
ZGlkDQoJPiBub3QgaW5jbHVkZSB0aGlzIGluIHNvbWUgb2YgdGhlbSwgd2hpY2ggaXMgcHJvYmFi
bHkgdGhlIHNvdXJjZSBvZiBteQ0KCT4gaXNzdWUuIEknbSBnb2luZyB0byB0ZXN0IGl0IG5vdywg
YnV0IHdhcyBzbyBleGNpdGVkIGFib3V0IHRoZSBwcm9zcGVjdA0KCT4gb2YgZmluYWxseSBmaW5k
aW5nIGEgc29sdXRpb24sIEkgZmlndXJlZCBJIHdvdWxkIHRlbGwgeW91IGd1eXMgcmlnaHQgYXdh
eS4NCgk+IA0KCT4gR29vZCBMdWNrIQ0KCT4gLWcNCgk+DQoJPiAgICAgLS0tLS1PcmlnaW5hbCBN
ZXNzYWdlLS0tLS0NCgk+ICAgICAqRnJvbToqIHBlcmZwYXJzZS11c2Vycy1hZG1pbkBsaXN0cy5z
b3VyY2Vmb3JnZS5uZXQgb24gYmVoYWxmIG9mIEJlbg0KCT4gICAgIENsZXdldHQNCgk+ICAgICAq
U2VudDoqIFRodSA1LzI3LzIwMDQgMjowOSBBTQ0KCT4gICAgICpUbzoqIHBlcmZwYXJzZS11c2Vy
c0BsaXN0cy5zb3VyY2Vmb3JnZS5uZXQNCgk+ICAgICAqQ2M6Kg0KCT4gICAgICpTdWJqZWN0Oiog
W1BlcmZwYXJzZS11c2Vyc10gTm8gZGF0YSBpbiBzZXJ2aWNlcGVyZi5sb2cgZmlsZS4NCgk+DQoJ
PiAgICAgTWFyY2VsbywNCgk+DQoJPiAgICAgVGhhbmtzIGZvciB0aGUgaW5mb3JtYXRpb24uDQoJ
Pg0KCT4gICAgIEZpcnN0LCBjYW4gSSBzdWdnZXN0IHlvdSB1cGdyYWRlIHBlcmZwYXJzZSB0byB0
aGUgbGF0ZXN0IHZlcnNpb24sICAwLjA1Lg0KCT4gICAgICAgVGhlIHZlcnNpb24geW91IGhhdmUg
aGFzIGEgbWVtb3J5IHByb2JsZW1zLg0KCT4NCgk+ICAgICBNb3JlIGltcG9ydGFudGx5LCB5b3Vy
IG5hZ2lvcyBpcyBub3QgcHJvZHVjaW5nIHBlcmZvcm1hbmNlIGRhdGEuICBDYW4NCgk+ICAgICB5
b3UgcGxlYXNlIGNoZWNrIGZvciBtZToNCgk+DQoJPiAgICAgMS4gWW91IGFyZSB1c2luZyB0aGUg
bGF0ZXN0IE5hZ2lvcywgMS4yLg0KCT4NCgk+ICAgICAyLiBZb3UgYXJlIHVzaW5nIHRoZSBsYXRl
c3QgbmFnaW9zIHBsdWdpbnMuICBPbmx5IHRoZXNlIHByb2R1Y2UNCgk+ICAgICBwZXJmb3JtYW5j
ZSBkYXRhLiAgWW91IGNhbiBjaGVjayB0aGlzIGJ5IHJ1bm5pbmcgb25lLCBsaWtlICdjaGVja19k
aXNrJy4NCgk+ICAgICAgIElmIHlvdSBoYXZlIHBlcmZvcm1hbmNlIGRhdGEsIHRoaXMgc2hvdWxk
IHJlcGx5Og0KCT4NCgk+ICAgICBESVNLIE9LIC0gZnJlZSBzcGFjZTogLyA4MDg5IE1CICgyMiUp
OyAvYm9vdCAzNSBNQiAoNzYlKSB8DQoJPiAgICAgLz04MDg5TUI7MzMzMTI7MzUxNjM7MDszNzAx
NCAvYm9vdD0zNE1COzQwOzQyOzA7NDUNCgk+DQoJPiAgICAgWW91IGNhbiBzZWUgdGhlIHBlcmZv
cm1hbmNlIGRhdGEgYmV5b25kIHRoZSAnfCcuDQoJPg0KCT4gICAgIDMuIFlvdSBoYXZlIGNvbXBp
bGVkIG5hZ2lvcyB3aXRoIHRoZSBvcHRpb24gdG8gcHJvZHVjZSBwZXJmb3JtYW5jZSBkYXRhLg0K
CT4gICAgICAgVXNpbmcgdGhlICctLXdpdGgtZmlsZS1wZXJmZGF0YScuICBJZToNCgk+DQoJPiAg
ICAgLi9jb25maWd1cmUgLS13aXRoLWZpbGUtcGVyZmRhdGENCgk+DQoJPiAgICAgNC4gU2V0IHRo
ZSBwZXJtaXNzaW9ucyBvbiB0aGUgc2VydmljZWxvZyBmaWxlIGFzIC1ydy1ydy1yLS0gaWU6DQoJ
PiAgICAgJCBjaG1vZCA2NjQgc2VydmljZXBlcmYubG9nDQoJPg0KCT4gICAgIDUuIENoZWNrICdu
YWdpb3MuY2ZnJywgZW5zdXJlIHlvdSBoYXZlIHRoZXNlIGxpbmVzIHNvbWV3aGVyZToNCgk+DQoJ
PiAgICAgcHJvY2Vzc19wZXJmb3JtYW5jZV9kYXRhPTENCgk+ICAgICB4cGRmaWxlX2hvc3RfcGVy
ZmRhdGFfZmlsZT0vdXNyL2xvY2FsL25hZ2lvcy92YXIvaG9zdHBlcmYubG9nDQoJPiAgICAgeHBk
ZmlsZV9ob3N0X3BlcmZkYXRhX3RlbXBsYXRlPSRUSU1FVCRcdCRIT1NUTkFNRSRcdCRPVVRQVVQk
XHQkUEVSRkRBVEEkDQoJPiAgICAgeHBkZmlsZV9zZXJ2aWNlX3BlcmZkYXRhX2ZpbGU9L3Vzci9s
b2NhbC9uYWdpb3MvdmFyL3NlcnZpY2VwZXJmLmxvZw0KCT4gICAgIHhwZGZpbGVfc2VydmljZV9w
ZXJmZGF0YV90ZW1wbGF0ZT0kVElNRVQkXHQkSE9TVE5BTUUkXHQkU0VSVklDRURFU0MkXHQkT1VU
UFVUJFx0JFBFUkZEQVRBJA0KCT4NCgk+ICAgICBSZWdhcmQsIEJlbg0KCT4NCgk+DQoJPg0KCT4g
ICAgIC0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0NCgk+ICAgICBUaGlzIFNGLk5ldCBlbWFpbCBpcyBzcG9uc29yZWQgYnk6IE9yYWNsZSAxMGcN
Cgk+ICAgICBHZXQgY2VydGlmaWVkIG9uIHRoZSBob3R0ZXN0IHRoaW5nIGV2ZXIgdG8gaGl0IHRo
ZSBtYXJrZXQuLi4gT3JhY2xlIDEwZy4NCgk+ICAgICBUYWtlIGFuIE9yYWNsZSAxMGcgY2xhc3Mg
bm93LCBhbmQgd2UnbGwgZ2l2ZSB5b3UgdGhlIGV4YW0gRlJFRS4NCgk+ICAgICBodHRwOi8vYWRz
Lm9zZG4uY29tLz9hZF9pZD0zMTQ5JmFsbG9jX2lkPTgxNjYmb3A9Y2xpY2sNCgk+ICAgICA8aHR0
cDovL2Fkcy5vc2RuLmNvbS8/YWRfaWQ9MzE0OSZhbGxvY19pZD04MTY2Jm9wPWNsaWNrPg0KCT4g
ICAgIF9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fDQoJPiAg
ICAgUGVyZnBhcnNlLXVzZXJzIG1haWxpbmcgbGlzdA0KCT4gICAgIFBlcmZwYXJzZS11c2Vyc0Bs
aXN0cy5zb3VyY2Vmb3JnZS5uZXQNCgk+ICAgICBodHRwczovL2xpc3RzLnNvdXJjZWZvcmdlLm5l
dC9saXN0cy9saXN0aW5mby9wZXJmcGFyc2UtdXNlcnMNCgk+DQoJDQoJDQoNCg==

Re: [Perfparse-users] No data in serviceperf.log file.

[Ben C. <Be...@cl...>]

Could be the one!

Yes, this is set to '1' in my parent table.

Best of luck....

Ben

Cook, Garry wrote:
> Marcelo,
> As Ben is aware, I'm currently seeing the same problem that I think you 
> are having. I'm not sure, as I have not seen your original message.
> The good news is, I think I've finally stumbled upon the solution! 
> Unfortunately, I don't have time to test it right now, but here is what 
> I've found:
>  
> In the services.cfg, there is a directive in the service definitions 
> called 'process_perf_data'. I found this in the main 'generic-service' 
> template. Unfortunately, I've created my own template services and did 
> not include this in some of them, which is probably the source of my 
> issue. I'm going to test it now, but was so excited about the prospect 
> of finally finding a solution, I figured I would tell you guys right away.
>  
> Good Luck!
> -g
> 
>     -----Original Message-----
>     *From:* per...@li... on behalf of Ben
>     Clewett
>     *Sent:* Thu 5/27/2004 2:09 AM
>     *To:* per...@li...
>     *Cc:*
>     *Subject:* [Perfparse-users] No data in serviceperf.log file.
> 
>     Marcelo,
> 
>     Thanks for the information.
> 
>     First, can I suggest you upgrade perfparse to the latest version,  0.05.
>       The version you have has a memory problems.
> 
>     More importantly, your nagios is not producing performance data.  Can
>     you please check for me:
> 
>     1. You are using the latest Nagios, 1.2.
> 
>     2. You are using the latest nagios plugins.  Only these produce
>     performance data.  You can check this by running one, like 'check_disk'.
>       If you have performance data, this should reply:
> 
>     DISK OK - free space: / 8089 MB (22%); /boot 35 MB (76%) |
>     /=8089MB;33312;35163;0;37014 /boot=34MB;40;42;0;45
> 
>     You can see the performance data beyond the '|'.
> 
>     3. You have compiled nagios with the option to produce performance data.
>       Using the '--with-file-perfdata'.  Ie:
> 
>     ./configure --with-file-perfdata
> 
>     4. Set the permissions on the servicelog file as -rw-rw-r-- ie:
>     $ chmod 664 serviceperf.log
> 
>     5. Check 'nagios.cfg', ensure you have these lines somewhere:
> 
>     process_performance_data=1
>     xpdfile_host_perfdata_file=/usr/local/nagios/var/hostperf.log
>     xpdfile_host_perfdata_template=$TIMET$\t$HOSTNAME$\t$OUTPUT$\t$PERFDATA$
>     xpdfile_service_perfdata_file=/usr/local/nagios/var/serviceperf.log
>     xpdfile_service_perfdata_template=$TIMET$\t$HOSTNAME$\t$SERVICEDESC$\t$OUTPUT$\t$PERFDATA$
> 
>     Regard, Ben
> 
> 
> 
>     -------------------------------------------------------
>     This SF.Net email is sponsored by: Oracle 10g
>     Get certified on the hottest thing ever to hit the market... Oracle 10g.
>     Take an Oracle 10g class now, and we'll give you the exam FREE.
>     http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click
>     <http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click>
>     _______________________________________________
>     Perfparse-users mailing list
>     Per...@li...
>     https://lists.sourceforge.net/lists/listinfo/perfparse-users
> 

RE: [Perfparse-users] No data in serviceperf.log file.

[Cook, G. <GW...@ma...>]

TWFyY2VsbywNCkFzIEJlbiBpcyBhd2FyZSwgSSdtIGN1cnJlbnRseSBzZWVpbmcgdGhlIHNhbWUg
cHJvYmxlbSB0aGF0IEkgdGhpbmsgeW91IGFyZSBoYXZpbmcuIEknbSBub3Qgc3VyZSwgYXMgSSBo
YXZlIG5vdCBzZWVuIHlvdXIgb3JpZ2luYWwgbWVzc2FnZS4gDQpUaGUgZ29vZCBuZXdzIGlzLCBJ
IHRoaW5rIEkndmUgZmluYWxseSBzdHVtYmxlZCB1cG9uIHRoZSBzb2x1dGlvbiEgVW5mb3J0dW5h
dGVseSwgSSBkb24ndCBoYXZlIHRpbWUgdG8gdGVzdCBpdCByaWdodCBub3csIGJ1dCBoZXJlIGlz
IHdoYXQgSSd2ZSBmb3VuZDoNCiANCkluIHRoZSBzZXJ2aWNlcy5jZmcsIHRoZXJlIGlzIGEgZGly
ZWN0aXZlIGluIHRoZSBzZXJ2aWNlIGRlZmluaXRpb25zIGNhbGxlZCAncHJvY2Vzc19wZXJmX2Rh
dGEnLiBJIGZvdW5kIHRoaXMgaW4gdGhlIG1haW4gJ2dlbmVyaWMtc2VydmljZScgdGVtcGxhdGUu
IFVuZm9ydHVuYXRlbHksIEkndmUgY3JlYXRlZCBteSBvd24gdGVtcGxhdGUgc2VydmljZXMgYW5k
IGRpZCBub3QgaW5jbHVkZSB0aGlzIGluIHNvbWUgb2YgdGhlbSwgd2hpY2ggaXMgcHJvYmFibHkg
dGhlIHNvdXJjZSBvZiBteSBpc3N1ZS4gSSdtIGdvaW5nIHRvIHRlc3QgaXQgbm93LCBidXQgd2Fz
IHNvIGV4Y2l0ZWQgYWJvdXQgdGhlIHByb3NwZWN0IG9mIGZpbmFsbHkgZmluZGluZyBhIHNvbHV0
aW9uLCBJIGZpZ3VyZWQgSSB3b3VsZCB0ZWxsIHlvdSBndXlzIHJpZ2h0IGF3YXkuDQogDQpHb29k
IEx1Y2shDQotZw0KDQoJLS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0tLS0gDQoJRnJvbTogcGVyZnBh
cnNlLXVzZXJzLWFkbWluQGxpc3RzLnNvdXJjZWZvcmdlLm5ldCBvbiBiZWhhbGYgb2YgQmVuIENs
ZXdldHQgDQoJU2VudDogVGh1IDUvMjcvMjAwNCAyOjA5IEFNIA0KCVRvOiBwZXJmcGFyc2UtdXNl
cnNAbGlzdHMuc291cmNlZm9yZ2UubmV0IA0KCUNjOiANCglTdWJqZWN0OiBbUGVyZnBhcnNlLXVz
ZXJzXSBObyBkYXRhIGluIHNlcnZpY2VwZXJmLmxvZyBmaWxlLg0KCQ0KCQ0KDQoJTWFyY2VsbywN
CgkNCglUaGFua3MgZm9yIHRoZSBpbmZvcm1hdGlvbi4NCgkNCglGaXJzdCwgY2FuIEkgc3VnZ2Vz
dCB5b3UgdXBncmFkZSBwZXJmcGFyc2UgdG8gdGhlIGxhdGVzdCB2ZXJzaW9uLCAgMC4wNS4NCgkg
IFRoZSB2ZXJzaW9uIHlvdSBoYXZlIGhhcyBhIG1lbW9yeSBwcm9ibGVtcy4NCgkNCglNb3JlIGlt
cG9ydGFudGx5LCB5b3VyIG5hZ2lvcyBpcyBub3QgcHJvZHVjaW5nIHBlcmZvcm1hbmNlIGRhdGEu
ICBDYW4NCgl5b3UgcGxlYXNlIGNoZWNrIGZvciBtZToNCgkNCgkxLiBZb3UgYXJlIHVzaW5nIHRo
ZSBsYXRlc3QgTmFnaW9zLCAxLjIuDQoJDQoJMi4gWW91IGFyZSB1c2luZyB0aGUgbGF0ZXN0IG5h
Z2lvcyBwbHVnaW5zLiAgT25seSB0aGVzZSBwcm9kdWNlDQoJcGVyZm9ybWFuY2UgZGF0YS4gIFlv
dSBjYW4gY2hlY2sgdGhpcyBieSBydW5uaW5nIG9uZSwgbGlrZSAnY2hlY2tfZGlzaycuDQoJICBJ
ZiB5b3UgaGF2ZSBwZXJmb3JtYW5jZSBkYXRhLCB0aGlzIHNob3VsZCByZXBseToNCgkNCglESVNL
IE9LIC0gZnJlZSBzcGFjZTogLyA4MDg5IE1CICgyMiUpOyAvYm9vdCAzNSBNQiAoNzYlKSB8DQoJ
Lz04MDg5TUI7MzMzMTI7MzUxNjM7MDszNzAxNCAvYm9vdD0zNE1COzQwOzQyOzA7NDUNCgkNCglZ
b3UgY2FuIHNlZSB0aGUgcGVyZm9ybWFuY2UgZGF0YSBiZXlvbmQgdGhlICd8Jy4NCgkNCgkzLiBZ
b3UgaGF2ZSBjb21waWxlZCBuYWdpb3Mgd2l0aCB0aGUgb3B0aW9uIHRvIHByb2R1Y2UgcGVyZm9y
bWFuY2UgZGF0YS4NCgkgIFVzaW5nIHRoZSAnLS13aXRoLWZpbGUtcGVyZmRhdGEnLiAgSWU6DQoJ
DQoJLi9jb25maWd1cmUgLS13aXRoLWZpbGUtcGVyZmRhdGENCgkNCgk0LiBTZXQgdGhlIHBlcm1p
c3Npb25zIG9uIHRoZSBzZXJ2aWNlbG9nIGZpbGUgYXMgLXJ3LXJ3LXItLSBpZToNCgkkIGNobW9k
IDY2NCBzZXJ2aWNlcGVyZi5sb2cNCgkNCgk1LiBDaGVjayAnbmFnaW9zLmNmZycsIGVuc3VyZSB5
b3UgaGF2ZSB0aGVzZSBsaW5lcyBzb21ld2hlcmU6DQoJDQoJcHJvY2Vzc19wZXJmb3JtYW5jZV9k
YXRhPTENCgl4cGRmaWxlX2hvc3RfcGVyZmRhdGFfZmlsZT0vdXNyL2xvY2FsL25hZ2lvcy92YXIv
aG9zdHBlcmYubG9nDQoJeHBkZmlsZV9ob3N0X3BlcmZkYXRhX3RlbXBsYXRlPSRUSU1FVCRcdCRI
T1NUTkFNRSRcdCRPVVRQVVQkXHQkUEVSRkRBVEEkDQoJeHBkZmlsZV9zZXJ2aWNlX3BlcmZkYXRh
X2ZpbGU9L3Vzci9sb2NhbC9uYWdpb3MvdmFyL3NlcnZpY2VwZXJmLmxvZw0KCXhwZGZpbGVfc2Vy
dmljZV9wZXJmZGF0YV90ZW1wbGF0ZT0kVElNRVQkXHQkSE9TVE5BTUUkXHQkU0VSVklDRURFU0Mk
XHQkT1VUUFVUJFx0JFBFUkZEQVRBJA0KCQ0KCVJlZ2FyZCwgQmVuDQoJDQoJDQoJDQoJLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KCVRoaXMg
U0YuTmV0IGVtYWlsIGlzIHNwb25zb3JlZCBieTogT3JhY2xlIDEwZw0KCUdldCBjZXJ0aWZpZWQg
b24gdGhlIGhvdHRlc3QgdGhpbmcgZXZlciB0byBoaXQgdGhlIG1hcmtldC4uLiBPcmFjbGUgMTBn
Lg0KCVRha2UgYW4gT3JhY2xlIDEwZyBjbGFzcyBub3csIGFuZCB3ZSdsbCBnaXZlIHlvdSB0aGUg
ZXhhbSBGUkVFLg0KCWh0dHA6Ly9hZHMub3Nkbi5jb20vP2FkX2lkPTMxNDkmYWxsb2NfaWQ9ODE2
NiZvcD1jbGljaw0KCV9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f
X19fDQoJUGVyZnBhcnNlLXVzZXJzIG1haWxpbmcgbGlzdA0KCVBlcmZwYXJzZS11c2Vyc0BsaXN0
cy5zb3VyY2Vmb3JnZS5uZXQNCglodHRwczovL2xpc3RzLnNvdXJjZWZvcmdlLm5ldC9saXN0cy9s
aXN0aW5mby9wZXJmcGFyc2UtdXNlcnMNCgkNCg0K

[Perfparse-users] No data in serviceperf.log file.

[Ben C. <Be...@cl...>]

Marcelo,

Thanks for the information.

First, can I suggest you upgrade perfparse to the latest version,  0.05. 
  The version you have has a memory problems.

More importantly, your nagios is not producing performance data.  Can 
you please check for me:

1. You are using the latest Nagios, 1.2.

2. You are using the latest nagios plugins.  Only these produce 
performance data.  You can check this by running one, like 'check_disk'. 
  If you have performance data, this should reply:

DISK OK - free space: / 8089 MB (22%); /boot 35 MB (76%) | 
/=8089MB;33312;35163;0;37014 /boot=34MB;40;42;0;45

You can see the performance data beyond the '|'.

3. You have compiled nagios with the option to produce performance data. 
  Using the '--with-file-perfdata'.  Ie:

./configure --with-file-perfdata

4. Set the permissions on the servicelog file as -rw-rw-r-- ie:
$ chmod 664 serviceperf.log

5. Check 'nagios.cfg', ensure you have these lines somewhere:

process_performance_data=1
xpdfile_host_perfdata_file=/usr/local/nagios/var/hostperf.log
xpdfile_host_perfdata_template=$TIMET$\t$HOSTNAME$\t$OUTPUT$\t$PERFDATA$
xpdfile_service_perfdata_file=/usr/local/nagios/var/serviceperf.log
xpdfile_service_perfdata_template=$TIMET$\t$HOSTNAME$\t$SERVICEDESC$\t$OUTPUT$\t$PERFDATA$

Regard, Ben

[Perfparse-users] Problems compiling

[Ben C. <Be...@cl...>]

Marcelo,

I am very glad to hear you are working with PerfParse.  This was 
designed exactly to overcome the problems of the performance data being 
so inaccessible.

Looking at the error, I believe the compiler cannot find the MySQL 
libraries.  These are defined in the 'Makefile' as:

CFLAGS= -I/usr/local/include/mysql
LDFLAGS= -L/usr/local/lib/mysql

(These lines do include more information.  Do not adjust any other parts.)

Therefore we looking for the libraries in /usr/local/include/mysql.

Can you please locate the file 'mysql.h', then adjust the Makefile to suit.

To help with this, please look at the Makefile in the Nagios directory. 
  If you have compiled Nagios with support for MySQL, There will be a 
similar line to above.  You can copy this directly if you so choose.

Please let me know if this solution works, as other users may be greatly 
interested.

Sorry about this, later versions will not have this problem.

Regards,

Ben.


Marcos & Marcelo wrote:

 > [cut] I'm interesting to use your solution, but I have some problems 
to install it, although, the README file explain everything. I received 
some error messages as you can see in the document attached.
 > Thanks,
 > Marcelo



 > [root@dhcp-brasil-xxx-xxx-xxx-xxx perfparse]# make
 > gcc -g -O2 -I -DHAVE_CONFIG_H -DNSCORE -L -lmysqlclient  perfparse.c 
  common.o -o perfparse
 > /tmp/ccuiITWZ.o(.text+0xc8): In function `my_on_exit':
 > /tmp/projeto/plugins/perfparse/perfparse.c:138: undefined reference 
to `mysql_close'
 > /tmp/ccuiITWZ.o(.text+0xc26): In function `save_raw_data':
 > /tmp/projeto/plugins/perfparse/perfparse.c:594: undefined reference 
to `mysql_fetch_row'
 > 
/tmp/ccuiITWZ.o(.text+0xc45):/tmp/projeto/plugins/perfparse/perfparse.c:596: 
undefined reference to `mysql_free_result'
 > /tmp/ccuiITWZ.o(.text+0xe0b): In function `save_bin_data':
 > /tmp/projeto/plugins/perfparse/perfparse.c:649: undefined reference 
to `mysql_fetch_row'
 > 
/tmp/ccuiITWZ.o(.text+0xe2a):/tmp/projeto/plugins/perfparse/perfparse.c:651: 
undefined reference to `mysql_free_result'
 > /tmp/ccuiITWZ.o(.text+0x110c): In function `validate_service':
 > /tmp/projeto/plugins/perfparse/perfparse.c:767: undefined reference 
to `mysql_fetch_row'
 > 
/tmp/ccuiITWZ.o(.text+0x112e):/tmp/projeto/plugins/perfparse/perfparse.c:771: 
undefined reference to `mysql_free_result'
 > /tmp/ccuiITWZ.o(.text+0x11d7): In function `validate_host':
 > /tmp/projeto/plugins/perfparse/perfparse.c:798: undefined reference 
to `mysql_fetch_row'
 > 
/tmp/ccuiITWZ.o(.text+0x11f9):/tmp/projeto/plugins/perfparse/perfparse.c:802: 
undefined reference to `mysql_free_result'
 > /tmp/ccuiITWZ.o(.text+0x12c4): In function `validate_metric':
 > /tmp/projeto/plugins/perfparse/perfparse.c:834: undefined reference 
to `mysql_fetch_row'
 > 
/tmp/ccuiITWZ.o(.text+0x12e3):/tmp/projeto/plugins/perfparse/perfparse.c:836: 
undefined reference to `mysql_free_result'
 > /tmp/ccuiITWZ.o(.text+0x13db): In function `now_get_state':
 > /tmp/projeto/plugins/perfparse/perfparse.c:888: undefined reference 
to `mysql_fetch_row'
 > 
/tmp/ccuiITWZ.o(.text+0x1448):/tmp/projeto/plugins/perfparse/perfparse.c:917: 
undefined reference to `mysql_free_result'
 > 
/tmp/ccuiITWZ.o(.text+0x14ba):/tmp/projeto/plugins/perfparse/perfparse.c:876: 
undefined reference to `mysql_free_result'
 > 
/tmp/ccuiITWZ.o(.text+0x1503):/tmp/projeto/plugins/perfparse/perfparse.c:896: 
undefined reference to `mysql_free_result'
 > /tmp/ccuiITWZ.o(.text+0x1a54): In function `sql_fail':
 > /tmp/projeto/plugins/perfparse/perfparse.c:1085: undefined reference 
to `mysql_error'
 > common.o(.text+0xce): In function `now_query':
 > : undefined reference to `mysql_free_result'
 > common.o(.text+0xeb): In function `now_query':
 > : undefined reference to `mysql_query'
 > common.o(.text+0x10d): In function `now_query':
 > : undefined reference to `mysql_store_result'
 > common.o(.text+0x13a): In function `rows':
 > : undefined reference to `mysql_num_rows'
 > common.o(.text+0x161): In function `now_connect':
 > : undefined reference to `mysql_init'
 > common.o(.text+0x192): In function `now_connect':
 > : undefined reference to `mysql_options'
 > common.o(.text+0x1c1): In function `now_connect':
 > : undefined reference to `mysql_real_connect'
 > common.o(.text+0x1ef): In function `now_connect':
 > : undefined reference to `mysql_error'
 > common.o(.text+0x22a): In function `now_connect':
 > : undefined reference to `mysql_close'
 > collect2: ld returned 1 exit status
 > make: *** [perfparse] Error 1