Re: [Perfparse-users] db insert problem

[Yves M. <yme...@li...>]

An idea: is mysql launched with networking enabled ?
For example, there is an option "skip-networking" in my configuration fil=
e that I have
disabled. Is it enabled in your mysql config file ?

Yves

> Hi All,
>
> I've compiled and installed the latest release of perfparse (0.99.08) i=
n
> 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 =3D 0%, RTA =3D 0=
.38 ms
> 1092831063      info_1175/u21   PING    PING OK - Packet loss =3D 0%, R=
TA
> =3D 116.02 ms
> 1092831083      info_1175/u5    PING    PING OK - Packet loss =3D 0%, R=
TA
> =3D 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
>
>


--=20
- Homepage    - http://ymettier.free.fr - http://www.logicacmg.com -
- GPG key     - http://ymettier.free.fr/gpg.txt                    -
- Maitretarot - http://www.nongnu.org/maitretarot/                 -
- GTKtalog    - http://www.nongnu.org/gtktalog/                    -