[Perfparse-users] First time install - some questions on options

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

I have been running Nagios 1.2 and want to add
perfparse to get the stats it can provide.  I am
setting up a new host for better performance on RHES4,
with MySQL version 4.1.7.  I reconfigured and
installed a new Nagios with --with-file-perfdata and
attempted to install the first way I found "Periodic
Nagios Log Parse".   I had a few problems with needing
to touch the error log file the first time, and
setting up correctly in the config the
"Storage_Modules_Load = mysql" which it now seems to
recognize (initially it complained about no storage
modules until this was fixed).   I have a
/usr/local/nagios/var/serviceperf.log that Nagios is
updating.  So here are the problems and questions:

1.  The MySQL database does not update still.  How can
I debug this better - or any suggestions?
2.  I started with the install using the first listed
as the "default".  I read the list and see that others
seem to go with pipe and perfparsed options.  Anyone
set up on RHES and using any other option?  

I am intereseted in a long term use with perfparse and
am at a point that I can go forward with what I have
if it is the best, or rebuild this new host before it
goes into production with a different approach.  
Anyone's input is welcome about how I can get the
MySQL issue resolved and how to best complete which
setup.   

I am including below my current setup for review and
comment/suggestions.

Cheers,

Richard

perfparsed -c ../etc/perfparse.cfg --show_config
#

Perfparsed [options]

# File where Perfparse logs messages
# Error_Log = "string"
Error_Log = "/usr/local/nagios/var/perfparse.log"

# Rotate Perfparse log files
# Error_Log_Rotate = "Y/N"
Error_Log_Rotate = "Yes"

# Keep N days of error log. Compress recent logs and
remove too old ones
# Error_Log_Keep_N_Days = "value"
Error_Log_Keep_N_Days = "7"

# When perfparse cannot parse a line, it drops it to
that file
# Drop_File = "string"
Drop_File = "/tmp/perfparse.drop"

# 
# Drop_File_Rotate = "Y/N"
Drop_File_Rotate = "Yes"

# Keep N days of drop file log. Compress recent logs
and remove too old ones
# Drop_File_Keep_N_Days = "value"
Drop_File_Keep_N_Days = "7"

# Port for perfparsed server
# Put 0 or "" to disable the server
# Server_Port = "value"
Server_Port = "1976"

# Log source from nagios (or other tools) that
perfparse will scan
# Authorized values: a file name, '-' for stdin, '|'
for a fifo and '>' for a host:port socket
# For sockets, a command 'history' will be sent before
retreiving the data
# Service_Log = "string"
Service_Log = "/usr/local/nagios/var/serviceperf.log"

# Save the read position in the nagios log file ? If
yes, perfparse will start from that position instead
of from the beginning
# Service_Log_Save_Position = "Y/N"
Service_Log_Save_Position = "yes"

# Path for files containing the read position for
nagios log files
# Service_Log_Position_Mark_Path = "string"
Service_Log_Position_Mark_Path =
"/usr/local/nagios/var"

# Lock file for perfparsed
# Daemon_Lock = "string"
Daemon_Lock = "/usr/local/nagios/var/perfparsed.lock"

# Run perfparsed as a daemon
# Daemonize = "Y/N"
Daemonize = "no"

# Perform some periodic cleanup every day
# Periodic_Cleanup = "Y/N"
Periodic_Cleanup = "yes"

# Lock file for perfparsed periodic cleanup process
# Periodic_Cleanup_Lock = "string"
Periodic_Cleanup_Lock =
"/usr/local/nagios/var/perfparsed_periodic_cleanup.lock"

# Perform some periodic cleanup every day at HHMM
# Periodic_Cleanup_Hour = "value"
Periodic_Cleanup_Hour = "0230"

# Dummy hostname if gethostname() does not work
# Dummy_Hostname = "string"
Dummy_Hostname = "dummy"

# Don't store raw data
# No_Raw_Data = "Y/N"
No_Raw_Data = "no"

# Don't store bin data
# No_Bin_Data = "Y/N"
No_Bin_Data = "no"

# Path where storage modules are
# Storage_Modules_Dir = "string"
Storage_Modules_Dir = "/usr/local/nagios/lib"

# Modules to load (Coma separated values)
# Storage_Modules_Load = "string"
Storage_Modules_Load = "mysql"

# File to contain Storage Modules Status
# Storage_Modules_Status_File = "string"
Storage_Modules_Status_File =
"/usr/local/nagios/var/storage_modules.status"

# Storage Module : mysql
# ==============================

# Database user
# DB_User = "string"
DB_User = "perfparse"

# Database password
# DB_Pass = "string"
DB_Pass = "******"

# Database name
# DB_Name = "string"
DB_Name = "perfparse"

# Database hostname
# DB_Host = "string"
DB_Host = "127.0.0.1"

[root@pa-monitor-qa etc]# cat /tmp/perfparsed.config 
Perfparsed [options]

# File where Perfparse logs messages
# Error_Log = "string"
Error_Log = "/usr/local/nagios/var/perfparse.log"

# Rotate Perfparse log files
# Error_Log_Rotate = "Y/N"
Error_Log_Rotate = "Yes"

# Keep N days of error log. Compress recent logs and
remove too old ones
# Error_Log_Keep_N_Days = "value"
Error_Log_Keep_N_Days = "7"

# When perfparse cannot parse a line, it drops it to
that file
# Drop_File = "string"
Drop_File = "/tmp/perfparse.drop"

# 
# Drop_File_Rotate = "Y/N"
Drop_File_Rotate = "Yes"

# Keep N days of drop file log. Compress recent logs
and remove too old ones
# Drop_File_Keep_N_Days = "value"
Drop_File_Keep_N_Days = "7"

# Port for perfparsed server
# Put 0 or "" to disable the server
# Server_Port = "value"
Server_Port = "1976"

# Log source from nagios (or other tools) that
perfparse will scan
# Authorized values: a file name, '-' for stdin, '|'
for a fifo and '>' for a host:port socket
# For sockets, a command 'history' will be sent before
retreiving the data
# Service_Log = "string"
Service_Log = "/usr/local/nagios/var/serviceperf.log"

# Save the read position in the nagios log file ? If
yes, perfparse will start from that position instead
of from the beginning
# Service_Log_Save_Position = "Y/N"
Service_Log_Save_Position = "yes"

# Path for files containing the read position for
nagios log files
# Service_Log_Position_Mark_Path = "string"
Service_Log_Position_Mark_Path =
"/usr/local/nagios/var"

# Lock file for perfparsed
# Daemon_Lock = "string"
Daemon_Lock = "/usr/local/nagios/var/perfparsed.lock"

# Run perfparsed as a daemon
# Daemonize = "Y/N"
Daemonize = "no"

# Perform some periodic cleanup every day
# Periodic_Cleanup = "Y/N"
Periodic_Cleanup = "yes"

# Lock file for perfparsed periodic cleanup process
# Periodic_Cleanup_Lock = "string"
Periodic_Cleanup_Lock =
"/usr/local/nagios/var/perfparsed_periodic_cleanup.lock"

# Perform some periodic cleanup every day at HHMM
# Periodic_Cleanup_Hour = "value"
Periodic_Cleanup_Hour = "0230"

# Dummy hostname if gethostname() does not work
# Dummy_Hostname = "string"
Dummy_Hostname = "dummy"

# Don't store raw data
# No_Raw_Data = "Y/N"
No_Raw_Data = "no"

# Don't store bin data
# No_Bin_Data = "Y/N"
No_Bin_Data = "no"

# Path where storage modules are
# Storage_Modules_Dir = "string"
Storage_Modules_Dir = "/usr/local/nagios/lib"

# Modules to load (Coma separated values)
# Storage_Modules_Load = "string"
Storage_Modules_Load = "mysql"

# File to contain Storage Modules Status
# Storage_Modules_Status_File = "string"
Storage_Modules_Status_File =
"/usr/local/nagios/var/storage_modules.status"

# Storage Module : mysql
# ==============================

# Database user
# DB_User = "string"
DB_User = "perfparse"

# Database password
# DB_Pass = "string"
DB_Pass = "dummy"

# Database name
# DB_Name = "string"
DB_Name = "perfparse"

# Database hostname
# DB_Host = "string"
DB_Host = "127.0.0.1"

==================

# tail /usr/local/nagios/var/serviceperf.log
1119656630tPA-BACKUP3tCheck NT host disk space on F
drivetF: total: 279.40 Gb - used: 12.87 Gb (5%) - free
266.53 Gb (95%)tOK
1119656630tMAILOUT1tSMTPtSMTP OK - 5 second response
timetOK
1119656630tPA-BACKUP6tCheck NT host process state
NWREStAll processes are runningtOK
1119656630tPA-ADC1tPORT 139tTCP OK -   0.064 second
response time on port 139tOK        time=  0.064
1119656630tNS3tCheck remote host users warning gt 1
critical gt 5tCHECK_NRPE: Socket timeout after 10
seconds.tCRITICAL
1119656630tNS3tSSHtSocket timeout after 10
secondstCRITICAL
1119656630tNS4tCheck remote host users warning gt 1
critical gt 5tCHECK_NRPE: Socket timeout after 10
seconds.tCRITICAL
1119656630tNS4tSSHtSocket timeout after 10
secondstCRITICAL
1119656630tNS1tCheck remote host disk sda5tCHECK_NRPE:
Socket timeout after 15 seconds.tCRITICAL
1119656630tPA-BACKUP3tCheck Legato Backup status
dailytCHECK_NRPE: Socket timeout after 10
seconds.tCRITICAL

==================

MySQL:

mysql  Ver 14.7 Distrib 4.1.7, for redhat-linux-gnu (i386)

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 