RE: [Perfparse-users] db insert problem

[Sz Z <zsz...@pr...>]

Hi Ben,

Thank you for the fast reply. You're right.I'm dud. I made a mistake in
the nagios.conf. I corrected that to 
xpdfile_service_perfdata_template=$TIMET$\t$HOSTNAME$\t$SERVICEDESC$\t$OUTPUT$\t$SERVICESTATE$\t$PERFDATA$
and it seems resolved the problem. I've new records in the tables.

Thanks,
Zoli

> -----Original Message-----
> From: Ben Clewett [mailto:Be...@cl...]
> Sent: Wednesday, August 18, 2004 3:15 PM
> To: Sz Z
> Subject: Re: [Perfparse-users] db insert problem
> 
> 
> Sz Z,
> 
> My second email on the subject.
> 
> You are using Ping, which I believe currently does not provide any
> performance data.  (Garry may be able to confirm this for latest
> plugins.)  You will be unable to get any graphs for this data.
> 
> You should be able to get raw data reports.  However the data lines
> should include the state (WARN,CRITICAL,OK,UNKNOWN) as the 
> last field of
> the line (where no performance data).  If this is not present, then
> PerfParse will ignore or drop (?) this line.
> 
> Can you check the format macro in nagios.cfg to ensure it matched that
> of the HOWTO:
> 
> xpdfile_service_perfdata_template=$TIMET$\t$HOSTNAME$\t$SERVIC
> EDESC$\t$OUTPUT$\t$SERVICESTATE$\t$PERFDATA$
> 
> If you want latency reports from a server which ping should provide,
> then the check_http plugin gives this, and produces good 
> performance data.
> 
> Ben
> 
> 
> 
> > Hi All,
> >
> > I've compiled and installed the latest release of perfparse 
> (0.99.08) in
> > a gentoo box. I've created the table structure by mysql_create.sql.
> > Nagios generate performace log into serviceperf.log and 
> hostperf.log.
> >
> > gentoo bin # cat /var/nagios/serviceperf.log
> > 1092831013      fs      PING    PING OK - Packet loss = 0%, 
> RTA = 0.38 ms
> > 1092831063      info_1175/u21   PING    PING OK - Packet 
> loss = 0%, RTA
> > = 116.02 ms
> > 1092831083      info_1175/u5    PING    PING OK - Packet 
> loss = 0%, RTA
> > = 69.46 ms
> >
> >
> > My problem is the follow:
> > Perfparse insert nothing to mysql database.
> >
> > gentoo bin # ./perfparse -r
> > Filename: /var/nagios/serviceperf.log
> > File open at line 0 and ready to parse:
> >
> > +---------------------------+   +---------------------------+
> > | Time:            00:00:00 |   | New Hosts:              0 |
> > | Line in file:           0 |   | New Services:           0 |
> > | Lines Read:             0 |   | New Metrics:            0 |
> > | Rate: (line/sec)     0.00 |   | Values Recorded:        0 |
> > | Metric/line:         0.00 |   | Lines Dropped:          0 |
> > | SQL Queries:           30 |   | Deleted Records:        0 |
> > +---------------------------+   +---------------------------+
> >
> > I've read the FAQ and mailing list archive too, but unfourtunately I
> > wasn't able to find the solution.
> > Can anybody help me?
> >
> > Thanks,
> > Zoli
> >
> >
> >
> > -------------------------------------------------------
> > SF.Net email is sponsored by Shop4tech.com-Lowest price on 
> Blank Media
> > 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
> > Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
> > http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
> > _______________________________________________
> > Perfparse-users mailing list
> > Per...@li...
> > https://lists.sourceforge.net/lists/listinfo/perfparse-users
> >
> 
> 
> 
> 
> 
>