[Perfparse-users] No data in MySQL database

[<Fra...@dg...>]

Hi all,

I've installed Perfparse 0.105.6 with MySQL 4.1.7 and Nagios 2.02b. Nagios 
is running perfectly, but perfparse don't write data in my MySQL database. 
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) :
# ====================================
Server_Port =                1976

# Parser managment :
# ==================
# Performance Data Log Files ("-" for stdin) :
#Service_Log =                "/usr/local/nagios/var/serviceperf.log"
Service_Log =                "|/usr/local/nagios/var/perfdata-service.log"
Service_Log_Position_Mark_Path =    "/usr/local/nagios/var"
Service_Log_Save_Position = "yes"

# Error handling :
Error_Log =                  "/usr/local/nagios/var/perfparse.log"
Error_Log_Rotate =           "Yes"
Error_Log_Keep_N_Days =      "7"
Drop_File =                  "/usr/local/nagios/var/perfparse.drop"
Drop_File_Rotate =           "Yes"
Drop_File_Keep_N_Days =      "7"

# Lock file for only one perfparse running at the same time
Lock_File = "/usr/local/nagios/var/perfparse.lock"

# Reporting options :
# ===================

# Do not display completion status of perfparse:
Show_Status_Bar = "yes"

# Display a report on exit of perfparse:
Do_Report =      "yes"

# CGI managment :
# ===============
# Default user permissions in the CGI. Accepted values are (ro|rw|hide)
Default_user_permissions_Policy = "rw"
Default_user_permissions_Host_groups = "rw"
Default_user_permissions_Summary = "rw"

# Output logger :
# ===============
# set Output_Log_File to "yes" to enable it
Output_Log_File =                "yes"
Output_Log_Filename = "/usr/local/nagios/var/perfparse_output_log"
Output_Log_Rotate =              "yes"
Output_Log_Keep_N_Days =         "7"


# Database managment :
# ====================
Use_Storage_Mysql =              "yes"
No_Raw_Data =                    "yes"
No_Bin_Data =                    "yes"

# Database Authentication
DB_User =                    "nagios"
DB_Name =                    "perfparse_nagios"
DB_Pass =                    "xxxxxxx"
DB_Host =                    "localhost"

# misc
Dummy_Hostname =             "venus"
Storage_Modules_Load = "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=/usr/local/nagios/etc/nagios_perfparse.cfg
process_performance_data=1
host_perfdata_command=process-host-perfdata
service_perfdata_command=process-service-perfdata

Thanks in advance for your help !!
Frank


fra...@dg...