From: Richard D. <de...@ya...> - 2005-06-29 01:10:57
|
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 |
From: abo <ab...@br...> - 2005-06-29 07:03:11
|
is your error log complaining about something? /usr/local/nagios/var/perfparse.log i had problems setting up mysql permissions and didn't notice it until i saw that file. see you El dt, 28-06-2005 a las 18:10 -0700, Richard DeWath escribi=F3: > 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 =3D 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: >=20 > 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? =20 >=20 > 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. =20 > Anyone's input is welcome about how I can get the > MySQL issue resolved and how to best complete which > setup. =20 >=20 > I am including below my current setup for review and > comment/suggestions. >=20 > Cheers, >=20 > Richard >=20 >=20 > perfparsed -c ../etc/perfparse.cfg --show_config > # >=20 > Perfparsed [options] >=20 > # File where Perfparse logs messages > # Error_Log =3D "string" > Error_Log =3D "/usr/local/nagios/var/perfparse.log" >=20 > # Rotate Perfparse log files > # Error_Log_Rotate =3D "Y/N" > Error_Log_Rotate =3D "Yes" >=20 > # Keep N days of error log. Compress recent logs and > remove too old ones > # Error_Log_Keep_N_Days =3D "value" > Error_Log_Keep_N_Days =3D "7" >=20 > # When perfparse cannot parse a line, it drops it to > that file > # Drop_File =3D "string" > Drop_File =3D "/tmp/perfparse.drop" >=20 > #=20 > # Drop_File_Rotate =3D "Y/N" > Drop_File_Rotate =3D "Yes" >=20 > # Keep N days of drop file log. Compress recent logs > and remove too old ones > # Drop_File_Keep_N_Days =3D "value" > Drop_File_Keep_N_Days =3D "7" >=20 > # Port for perfparsed server > # Put 0 or "" to disable the server > # Server_Port =3D "value" > Server_Port =3D "1976" >=20 > # 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 =3D "string" > Service_Log =3D "/usr/local/nagios/var/serviceperf.log" >=20 > # 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 =3D "Y/N" > Service_Log_Save_Position =3D "yes" >=20 > # Path for files containing the read position for > nagios log files > # Service_Log_Position_Mark_Path =3D "string" > Service_Log_Position_Mark_Path =3D > "/usr/local/nagios/var" >=20 > # Lock file for perfparsed > # Daemon_Lock =3D "string" > Daemon_Lock =3D "/usr/local/nagios/var/perfparsed.lock" >=20 > # Run perfparsed as a daemon > # Daemonize =3D "Y/N" > Daemonize =3D "no" >=20 > # Perform some periodic cleanup every day > # Periodic_Cleanup =3D "Y/N" > Periodic_Cleanup =3D "yes" >=20 > # Lock file for perfparsed periodic cleanup process > # Periodic_Cleanup_Lock =3D "string" > Periodic_Cleanup_Lock =3D > "/usr/local/nagios/var/perfparsed_periodic_cleanup.lock" >=20 > # Perform some periodic cleanup every day at HHMM > # Periodic_Cleanup_Hour =3D "value" > Periodic_Cleanup_Hour =3D "0230" >=20 > # Dummy hostname if gethostname() does not work > # Dummy_Hostname =3D "string" > Dummy_Hostname =3D "dummy" >=20 > # Don't store raw data > # No_Raw_Data =3D "Y/N" > No_Raw_Data =3D "no" >=20 > # Don't store bin data > # No_Bin_Data =3D "Y/N" > No_Bin_Data =3D "no" >=20 > # Path where storage modules are > # Storage_Modules_Dir =3D "string" > Storage_Modules_Dir =3D "/usr/local/nagios/lib" >=20 > # Modules to load (Coma separated values) > # Storage_Modules_Load =3D "string" > Storage_Modules_Load =3D "mysql" >=20 > # File to contain Storage Modules Status > # Storage_Modules_Status_File =3D "string" > Storage_Modules_Status_File =3D > "/usr/local/nagios/var/storage_modules.status" >=20 >=20 >=20 > # Storage Module : mysql > # =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 >=20 > # Database user > # DB_User =3D "string" > DB_User =3D "perfparse" >=20 > # Database password > # DB_Pass =3D "string" > DB_Pass =3D "******" >=20 > # Database name > # DB_Name =3D "string" > DB_Name =3D "perfparse" >=20 > # Database hostname > # DB_Host =3D "string" > DB_Host =3D "127.0.0.1" >=20 >=20 >=20 > [root@pa-monitor-qa etc]# cat /tmp/perfparsed.config=20 > Perfparsed [options] >=20 > # File where Perfparse logs messages > # Error_Log =3D "string" > Error_Log =3D "/usr/local/nagios/var/perfparse.log" >=20 > # Rotate Perfparse log files > # Error_Log_Rotate =3D "Y/N" > Error_Log_Rotate =3D "Yes" >=20 > # Keep N days of error log. Compress recent logs and > remove too old ones > # Error_Log_Keep_N_Days =3D "value" > Error_Log_Keep_N_Days =3D "7" >=20 > # When perfparse cannot parse a line, it drops it to > that file > # Drop_File =3D "string" > Drop_File =3D "/tmp/perfparse.drop" >=20 > #=20 > # Drop_File_Rotate =3D "Y/N" > Drop_File_Rotate =3D "Yes" >=20 > # Keep N days of drop file log. Compress recent logs > and remove too old ones > # Drop_File_Keep_N_Days =3D "value" > Drop_File_Keep_N_Days =3D "7" >=20 > # Port for perfparsed server > # Put 0 or "" to disable the server > # Server_Port =3D "value" > Server_Port =3D "1976" >=20 > # 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 =3D "string" > Service_Log =3D "/usr/local/nagios/var/serviceperf.log" >=20 > # 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 =3D "Y/N" > Service_Log_Save_Position =3D "yes" >=20 > # Path for files containing the read position for > nagios log files > # Service_Log_Position_Mark_Path =3D "string" > Service_Log_Position_Mark_Path =3D > "/usr/local/nagios/var" >=20 > # Lock file for perfparsed > # Daemon_Lock =3D "string" > Daemon_Lock =3D "/usr/local/nagios/var/perfparsed.lock" >=20 > # Run perfparsed as a daemon > # Daemonize =3D "Y/N" > Daemonize =3D "no" >=20 > # Perform some periodic cleanup every day > # Periodic_Cleanup =3D "Y/N" > Periodic_Cleanup =3D "yes" >=20 > # Lock file for perfparsed periodic cleanup process > # Periodic_Cleanup_Lock =3D "string" > Periodic_Cleanup_Lock =3D > "/usr/local/nagios/var/perfparsed_periodic_cleanup.lock" >=20 > # Perform some periodic cleanup every day at HHMM > # Periodic_Cleanup_Hour =3D "value" > Periodic_Cleanup_Hour =3D "0230" >=20 > # Dummy hostname if gethostname() does not work > # Dummy_Hostname =3D "string" > Dummy_Hostname =3D "dummy" >=20 > # Don't store raw data > # No_Raw_Data =3D "Y/N" > No_Raw_Data =3D "no" >=20 > # Don't store bin data > # No_Bin_Data =3D "Y/N" > No_Bin_Data =3D "no" >=20 > # Path where storage modules are > # Storage_Modules_Dir =3D "string" > Storage_Modules_Dir =3D "/usr/local/nagios/lib" >=20 > # Modules to load (Coma separated values) > # Storage_Modules_Load =3D "string" > Storage_Modules_Load =3D "mysql" >=20 > # File to contain Storage Modules Status > # Storage_Modules_Status_File =3D "string" > Storage_Modules_Status_File =3D > "/usr/local/nagios/var/storage_modules.status" >=20 >=20 >=20 > # Storage Module : mysql > # =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 >=20 > # Database user > # DB_User =3D "string" > DB_User =3D "perfparse" >=20 > # Database password > # DB_Pass =3D "string" > DB_Pass =3D "dummy" >=20 > # Database name > # DB_Name =3D "string" > DB_Name =3D "perfparse" >=20 > # Database hostname > # DB_Host =3D "string" > DB_Host =3D "127.0.0.1" >=20 >=20 > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D >=20 > # 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=3D 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 >=20 >=20 > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D >=20 >=20 > MySQL: >=20 > mysql Ver 14.7 Distrib 4.1.7, for redhat-linux-gnu (i386) >=20 > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around=20 > http://mail.yahoo.com=20 >=20 >=20 > ------------------------------------------------------- > SF.Net email is sponsored by: Discover Easy Linux Migration Strategies > from IBM. Find simple to follow Roadmaps, straightforward articles, > informative Webcasts and more! Get everything you need to get up to > speed, fast. http://ads.osdn.com/?ad_id=3D7477&alloc_id=3D16492&op=3Dcl= ick > _______________________________________________ > Perfparse-users mailing list > Per...@li... > https://lists.sourceforge.net/lists/listinfo/perfparse-users --=20 =E0ngel bosch ab...@br... |