[Nagios-users] Newbie Question
Hey everyone, I am still a newbie to nagios, so please bear with me. I am trying to find a plugin that will monitor the contents of a particular DB table. If certain status codes show up, then generate an alert. Is there something available off the shelf that can do this? Or will I have to write something myself? I already have a skeleton of a python script together to do the test, but I'd hate to completely implement it if there's a plugin out there that's fully fleshed out. Any help would be appreciated -Matthew -- Achieve unprecedented app performance and reliability What every C/C++ and Fortran developer should know. Learn how Intel has extended the reach of its next-generation tools to help boost performance applications - inlcuding clusters. http://p.sf.net/sfu/intel-dev2devmay ___ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null
Re: [Nagios-users] Newbie Question
This is for mysql. I saw a plugin called check_mysql_query but it doesn't seem to be included in the plugins package I downloaded. I'm going to try reinstalling the plugins in case something got borked. I can't find it on exchange either. I may have one other possibility after some more searching: check_mysql_count Any further suggestions would really be appreciated though. -Matty On Mon, May 16, 2011 at 9:34 AM, Terry Carmen te...@cnysupport.com wrote: Quoting Matty Sarro msa...@gmail.com: Hey everyone, I am still a newbie to nagios, so please bear with me. I am trying to find a plugin that will monitor the contents of a particular DB table. If certain status codes show up, then generate an alert. Is there something available off the shelf that can do this? What database server? Terry -- Achieve unprecedented app performance and reliability What every C/C++ and Fortran developer should know. Learn how Intel has extended the reach of its next-generation tools to help boost performance applications - inlcuding clusters. http://p.sf.net/sfu/intel-dev2devmay ___ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null -- Achieve unprecedented app performance and reliability What every C/C++ and Fortran developer should know. Learn how Intel has extended the reach of its next-generation tools to help boost performance applications - inlcuding clusters. http://p.sf.net/sfu/intel-dev2devmay ___ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null
Re: [Nagios-users] Newbie Question
On 16 May 2011 14:47, Matty Sarro msa...@gmail.com wrote: This is for mysql. I saw a plugin called check_mysql_query but it doesn't seem to be included in the plugins package I downloaded. I'm going to try reinstalling the plugins in case something got borked. I can't find it on exchange either. I may have one other possibility after some more searching: check_mysql_count Any further suggestions would really be appreciated though. If you can't find anything suitable 'off the shelf' then there is a plugin check_snmptraps.pl included with the NagTrap addon which is supposed to be for checking the number of traps in the nagtrap database but I expect it would be easy to rewrite it to query whatever MySQL database you like. -- Achieve unprecedented app performance and reliability What every C/C++ and Fortran developer should know. Learn how Intel has extended the reach of its next-generation tools to help boost performance applications - inlcuding clusters. http://p.sf.net/sfu/intel-dev2devmay ___ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null
Re: [Nagios-users] Newbie Question
Weird, I just reinstalled the plugins and I still don't see check_mysql_query or check_mysql. This is installing from source following the quickstart guide. On Mon, May 16, 2011 at 9:47 AM, Matty Sarro msa...@gmail.com wrote: This is for mysql. I saw a plugin called check_mysql_query but it doesn't seem to be included in the plugins package I downloaded. I'm going to try reinstalling the plugins in case something got borked. I can't find it on exchange either. I may have one other possibility after some more searching: check_mysql_count Any further suggestions would really be appreciated though. -Matty On Mon, May 16, 2011 at 9:34 AM, Terry Carmen te...@cnysupport.com wrote: Quoting Matty Sarro msa...@gmail.com: Hey everyone, I am still a newbie to nagios, so please bear with me. I am trying to find a plugin that will monitor the contents of a particular DB table. If certain status codes show up, then generate an alert. Is there something available off the shelf that can do this? What database server? Terry -- Achieve unprecedented app performance and reliability What every C/C++ and Fortran developer should know. Learn how Intel has extended the reach of its next-generation tools to help boost performance applications - inlcuding clusters. http://p.sf.net/sfu/intel-dev2devmay ___ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null -- Achieve unprecedented app performance and reliability What every C/C++ and Fortran developer should know. Learn how Intel has extended the reach of its next-generation tools to help boost performance applications - inlcuding clusters. http://p.sf.net/sfu/intel-dev2devmay ___ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null
Re: [Nagios-users] Newbie Question
Thanks everyone! It turns out there is a dependency for check_mysql_query to compile correctly. I installed the dep, recompiled, and now have access to it. This looks like it will return exactly what I need. Thanks again! On Mon, May 16, 2011 at 10:00 AM, Jim Avery j...@jimavery.me.uk wrote: On 16 May 2011 14:47, Matty Sarro msa...@gmail.com wrote: This is for mysql. I saw a plugin called check_mysql_query but it doesn't seem to be included in the plugins package I downloaded. I'm going to try reinstalling the plugins in case something got borked. I can't find it on exchange either. I may have one other possibility after some more searching: check_mysql_count Any further suggestions would really be appreciated though. If you can't find anything suitable 'off the shelf' then there is a plugin check_snmptraps.pl included with the NagTrap addon which is supposed to be for checking the number of traps in the nagtrap database but I expect it would be easy to rewrite it to query whatever MySQL database you like. -- Achieve unprecedented app performance and reliability What every C/C++ and Fortran developer should know. Learn how Intel has extended the reach of its next-generation tools to help boost performance applications - inlcuding clusters. http://p.sf.net/sfu/intel-dev2devmay ___ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null -- Achieve unprecedented app performance and reliability What every C/C++ and Fortran developer should know. Learn how Intel has extended the reach of its next-generation tools to help boost performance applications - inlcuding clusters. http://p.sf.net/sfu/intel-dev2devmay ___ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null
Re: [Nagios-users] Newbie Question
On Mon, May 16, 2011 16:01, Matty Sarro wrote: Weird, I just reinstalled the plugins and I still don't see check_mysql_query or check_mysql. This is installing from source following the quickstart guide. You may need some mysql devel packages on your system? -- Achieve unprecedented app performance and reliability What every C/C++ and Fortran developer should know. Learn how Intel has extended the reach of its next-generation tools to help boost performance applications - inlcuding clusters. http://p.sf.net/sfu/intel-dev2devmay ___ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null
Re: [Nagios-users] Newbie Question
Hi, did you install the plugins from source? You have to install libmysqlclient and reinstall the plugins again. configure checks the libraries on your system. Regards Axel Am Montag, 16. Mai. 11, 16:01:22 schrieb Matty Sarro: Weird, I just reinstalled the plugins and I still don't see check_mysql_query or check_mysql. This is installing from source following the quickstart guide. On Mon, May 16, 2011 at 9:47 AM, Matty Sarro msa...@gmail.com wrote: This is for mysql. I saw a plugin called check_mysql_query but it doesn't seem to be included in the plugins package I downloaded. I'm going to try reinstalling the plugins in case something got borked. I can't find it on exchange either. I may have one other possibility after some more searching: check_mysql_count Any further suggestions would really be appreciated though. -Matty On Mon, May 16, 2011 at 9:34 AM, Terry Carmen te...@cnysupport.com wrote: Quoting Matty Sarro msa...@gmail.com: Hey everyone, I am still a newbie to nagios, so please bear with me. I am trying to find a plugin that will monitor the contents of a particular DB table. If certain status codes show up, then generate an alert. Is there something available off the shelf that can do this? What database server? Terry -- Achieve unprecedented app performance and reliability What every C/C++ and Fortran developer should know. Learn how Intel has extended the reach of its next-generation tools to help boost performance applications - inlcuding clusters. http://p.sf.net/sfu/intel-dev2devmay ___ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when ::: reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null --- --- Achieve unprecedented app performance and reliability What every C/C++ and Fortran developer should know. Learn how Intel has extended the reach of its next-generation tools to help boost performance applications - inlcuding clusters. http://p.sf.net/sfu/intel-dev2devmay ___ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when ::: reporting any issue. Messages without supporting info will risk being ::: sent to /dev/null -- Axel Rosenski - Administration - __ Wave Computersysteme GmbH Philipp-Reis-Str. 1-3 / 9 35440 Linden Geschäftsführer: Carsten Kellmann Registergericht Gießen HRB 1823 Tel.: +49 (0)6403 / 9050 8317 Fax: +49 (0)6403 / 9050 5089 mailto:rosen...@wave-computer.de http://www.wave-computer.de -- Achieve unprecedented app performance and reliability What every C/C++ and Fortran developer should know. Learn how Intel has extended the reach of its next-generation tools to help boost performance applications - inlcuding clusters. http://p.sf.net/sfu/intel-dev2devmay ___ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null
Re: [Nagios-users] Newbie Question
That fixed it :) Thanks all! On Mon, May 16, 2011 at 10:25 AM, Axel Rosenski rosen...@wave-computer.de wrote: Hi, did you install the plugins from source? You have to install libmysqlclient and reinstall the plugins again. configure checks the libraries on your system. Regards Axel Am Montag, 16. Mai. 11, 16:01:22 schrieb Matty Sarro: Weird, I just reinstalled the plugins and I still don't see check_mysql_query or check_mysql. This is installing from source following the quickstart guide. On Mon, May 16, 2011 at 9:47 AM, Matty Sarro msa...@gmail.com wrote: This is for mysql. I saw a plugin called check_mysql_query but it doesn't seem to be included in the plugins package I downloaded. I'm going to try reinstalling the plugins in case something got borked. I can't find it on exchange either. I may have one other possibility after some more searching: check_mysql_count Any further suggestions would really be appreciated though. -Matty On Mon, May 16, 2011 at 9:34 AM, Terry Carmen te...@cnysupport.com wrote: Quoting Matty Sarro msa...@gmail.com: Hey everyone, I am still a newbie to nagios, so please bear with me. I am trying to find a plugin that will monitor the contents of a particular DB table. If certain status codes show up, then generate an alert. Is there something available off the shelf that can do this? What database server? Terry -- Achieve unprecedented app performance and reliability What every C/C++ and Fortran developer should know. Learn how Intel has extended the reach of its next-generation tools to help boost performance applications - inlcuding clusters. http://p.sf.net/sfu/intel-dev2devmay ___ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when ::: reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null --- --- Achieve unprecedented app performance and reliability What every C/C++ and Fortran developer should know. Learn how Intel has extended the reach of its next-generation tools to help boost performance applications - inlcuding clusters. http://p.sf.net/sfu/intel-dev2devmay ___ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when ::: reporting any issue. Messages without supporting info will risk being ::: sent to /dev/null -- Axel Rosenski - Administration - __ Wave Computersysteme GmbH Philipp-Reis-Str. 1-3 / 9 35440 Linden Geschäftsführer: Carsten Kellmann Registergericht Gießen HRB 1823 Tel.: +49 (0)6403 / 9050 8317 Fax: +49 (0)6403 / 9050 5089 mailto:rosen...@wave-computer.de http://www.wave-computer.de -- Achieve unprecedented app performance and reliability What every C/C++ and Fortran developer should know. Learn how Intel has extended the reach of its next-generation tools to help boost performance applications - inlcuding clusters. http://p.sf.net/sfu/intel-dev2devmay ___ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null -- Achieve unprecedented app performance and reliability What every C/C++ and Fortran developer should know. Learn how Intel has extended the reach of its next-generation tools to help boost performance applications - inlcuding clusters. http://p.sf.net/sfu/intel-dev2devmay ___ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null
[Nagios-users] Flap Detection: Why do only HARD state changes count?
This isn't explicitly stated in the documentation, but it seems that flap detection state changes only apply to HARD states. So it's possible that a service check and toggle back and forth indefinitely between OK and not OK (unless max_check_attempts is set to 1) and flapping will not be detected. I tested this with a service that does this and verified the behavior. The Last State Change time gets updated with each SOFT state change, but the % state change for flap detection remains at 0% until I set max_check_attempts to 1 and let it toggle between hard state changes. Is this a bug or is it by design? Is there a way to include SOFT state transitions in flap detection? I'm using Nagios Core 3.2.3. -- Achieve unprecedented app performance and reliability What every C/C++ and Fortran developer should know. Learn how Intel has extended the reach of its next-generation tools to help boost performance applications - inlcuding clusters. http://p.sf.net/sfu/intel-dev2devmay ___ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null
[Nagios-users] Error: Could not read object configuration data!
Running nagios-3.2.3-8.fc14.x86_64 rpm, clicking most links in the leftnav result in the Error: Could not read object configuration data! First things first, from every FAQ I've read: # nagios -v /etc/nagios/nagios.cfg Total Warnings: 0 Total Errors: 0 # /etc/init.d/nagios status nagios (pid 17797) is running... # tail /var/log/nagios/nagios.log [1305566224] Nagios 3.2.3 starting... (PID=17796) [1305566224] Local time is Mon May 16 17:17:04 UTC 2011 [1305566224] LOG VERSION: 2.0 [1305566225] Finished daemonizing... (New PID=17797) [1305566585] SERVICE ALERT: localhost;HTTP;CRITICAL;SOFT;1;HTTP CRITICAL - Invalid HTTP response received from host: !DOCTYPE HTML PUBLIC -//IETF//DTD HTML 2.0//EN So it's running check_http no problem with a nominal failure (nothing at /, so 403). Same behavior when I run check_http from the command line, so all that appears to be working as expected. Reading http://www.mail-archive.com/nagios-users@lists.sourceforge.net/msg19610.html makes me wonder if I have some sort of file permissions issue such that nagios is running fine, but apache is unable to read certain files when it executes CGI. I haven't figured out how to turn up the log level for CGI. Turning Apache's LogLevel up to debug hasn't shown me anything interesting. Any ideas? -- Achieve unprecedented app performance and reliability What every C/C++ and Fortran developer should know. Learn how Intel has extended the reach of its next-generation tools to help boost performance applications - inlcuding clusters. http://p.sf.net/sfu/intel-dev2devmay ___ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null
Re: [Nagios-users] Flap Detection: Why do only HARD state changes count?
This is by design. As you have mentioned you can tweak the Max check attention to trigger hard state change soon after a soft state transition On May 17, 2011 12:20 AM, Paul M. Dubuc w...@paul.dubuc.org wrote: This isn't explicitly stated in the documentation, but it seems that flap detection state changes only apply to HARD states. So it's possible that a service check and toggle back and forth indefinitely between OK and not OK (unless max_check_attempts is set to 1) and flapping will not be detected. I tested this with a service that does this and verified the behavior. The Last State Change time gets updated with each SOFT state change, but the % state change for flap detection remains at 0% until I set max_check_attempts to 1 and let it toggle between hard state changes. Is this a bug or is it by design? Is there a way to include SOFT state transitions in flap detection? I'm using Nagios Core 3.2.3. -- Achieve unprecedented app performance and reliability What every C/C++ and Fortran developer should know. Learn how Intel has extended the reach of its next-generation tools to help boost performance applications - inlcuding clusters. http://p.sf.net/sfu/intel-dev2devmay ___ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null -- Achieve unprecedented app performance and reliability What every C/C++ and Fortran developer should know. Learn how Intel has extended the reach of its next-generation tools to help boost performance applications - inlcuding clusters. http://p.sf.net/sfu/intel-dev2devmay___ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null
Re: [Nagios-users] Newbie Question
Quoting Matty Sarro msa...@gmail.com: Hey everyone, I am still a newbie to nagios, so please bear with me. I am trying to find a plugin that will monitor the contents of a particular DB table. If certain status codes show up, then generate an alert. Is there something available off the shelf that can do this? FWIW, you might be looking at the wrong end of the problem. Instead of having Nagios constantly query the database for your status codes, why don't you add a trigger on the table to do what you want when the record is updated. This could include generating a trap or notifying Nagios though another method. It's much more efficient to work with the actual data at the source, than to keep watching from the outside. http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html Terry -- Achieve unprecedented app performance and reliability What every C/C++ and Fortran developer should know. Learn how Intel has extended the reach of its next-generation tools to help boost performance applications - inlcuding clusters. http://p.sf.net/sfu/intel-dev2devmay___ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null
