Re: [Perfparse-users] No data in MySQL database

[Yves <yme...@pe...>]

Hello,

Could you read this : http://wiki.perfparse.org/tiki-view_faq.php?faqId=3D=
7#q12 ?
I think you are just missing that you have to enable the mysql storage mo=
dule.
If it not enough, there is also this :
http://wiki.perfparse.org/tiki-view_faq.php?faqId=3D6#q7 ?
http://wiki.perfparse.org/tiki-view_faq.php?faqId=3D5#q8 ?

And if you need more, ask us again and run "perfparsed <your usual option=
s here>
--show_config" that will print something compatible with your config file=
, with all the
options.

I'm interested in your results with nagios-2.02b : are you using the pipe=
 output in
Nagios ?
Yves

> Hi all,
>
> I've installed Perfparse 0.105.6 with MySQL 4.1.7 and Nagios 2.02b. Nag=
ios
> is running perfectly, but perfparse don't write data in my MySQL databa=
se.
> I see some data in the perfdata-service.log file and nothing in the
> perfdata-host.log.
>
> Can anyone help me to configure correctly perfparse, please ?
>
> I join my several config files with this message :
>
> perfparse.cfg
>
> # Server managment (perfparsed only) :
> # =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> Server_Port =3D                1976
>
> # Parser managment :
> # =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> # Performance Data Log Files ("-" for stdin) :
> #Service_Log =3D                "/usr/local/nagios/var/serviceperf.log"
> Service_Log =3D                "|/usr/local/nagios/var/perfdata-service=
.log"
> Service_Log_Position_Mark_Path =3D    "/usr/local/nagios/var"
> Service_Log_Save_Position =3D "yes"
>
> # Error handling :
> Error_Log =3D                  "/usr/local/nagios/var/perfparse.log"
> Error_Log_Rotate =3D           "Yes"
> Error_Log_Keep_N_Days =3D      "7"
> Drop_File =3D                  "/usr/local/nagios/var/perfparse.drop"
> Drop_File_Rotate =3D           "Yes"
> Drop_File_Keep_N_Days =3D      "7"
>
> # Lock file for only one perfparse running at the same time
> Lock_File =3D "/usr/local/nagios/var/perfparse.lock"
>
> # Reporting options :
> # =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
>
> # Do not display completion status of perfparse:
> Show_Status_Bar =3D "yes"
>
> # Display a report on exit of perfparse:
> Do_Report =3D      "yes"
>
> # CGI managment :
> # =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> # Default user permissions in the CGI. Accepted values are (ro|rw|hide)
> Default_user_permissions_Policy =3D "rw"
> Default_user_permissions_Host_groups =3D "rw"
> Default_user_permissions_Summary =3D "rw"
>
> # Output logger :
> # =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> # set Output_Log_File to "yes" to enable it
> Output_Log_File =3D                "yes"
> Output_Log_Filename =3D "/usr/local/nagios/var/perfparse_output_log"
> Output_Log_Rotate =3D              "yes"
> Output_Log_Keep_N_Days =3D         "7"
>
>
> # Database managment :
> # =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> Use_Storage_Mysql =3D              "yes"
> No_Raw_Data =3D                    "yes"
> No_Bin_Data =3D                    "yes"
>
> # Database Authentication
> DB_User =3D                    "nagios"
> DB_Name =3D                    "perfparse_nagios"
> DB_Pass =3D                    "xxxxxxx"
> DB_Host =3D                    "localhost"
>
> # misc
> Dummy_Hostname =3D             "venus"
> Storage_Modules_Load =3D "mysql"
>
> nagios_perfparse.cfg (loaded with nagios.cfg)
> define command {
>         command_name    process-service-perfdata
>         command_line    $USER2$/bin/perfparse_nagios_pipe_command.pl
> $USER2$/var/perfdata-service.log "$TIMET$" "$HOSTNAME$" "$SERVICEDESC$"
> "$OUTPUT$" "$SERVICESTATE$" "$SERVICEPERFDATA$"
> }
>
> define command {
>         command_name    process-host-perfdata
>         command_line    $USER2$/bin/perfparse_nagios_pipe_command.pl
> $USER2$/var/perfdata-host.log "$TIMET$" "$HOSTNAME$" "$SERVICEDESC$"
> "$OUTPUT$" "$SERVICESTATE$" "$HOSTPERFDATA$"
> }
>
> nagios.cfg
>
> cfg_file=3D/usr/local/nagios/etc/nagios_perfparse.cfg
> process_performance_data=3D1
> host_perfdata_command=3Dprocess-host-perfdata
> service_perfdata_command=3Dprocess-service-perfdata
>
> Thanks in advance for your help !!
> Frank
>
>
> fra...@dg...


--=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://www.perfparse.org/                          -