Page 1 of 2
SNMP - MySQL
Posted: Fri Feb 01, 2013 10:16 am
by jcmanous
Greetings,
I'm utilizing SNMP to keep track of the up/down status of our MySQL instances and I keep getting the following error:
Status - Unknown
Status Information - Numerical values for warning and critical
I've only set the threshold to be warned of a critical event with the values of 0,2. I have modified these settings to no avail.
Any ideas?
Re: SNMP - MySQL
Posted: Fri Feb 01, 2013 10:19 am
by slansing
Can you show us which check/plugin you are using? Has this been verified as the same output you get when running it from the command line? Also, do you have other SNMP checks running to the same system from your Nagios box.
Re: SNMP - MySQL
Posted: Fri Feb 01, 2013 10:29 am
by jcmanous
That, I'm not 100% sure of. I configured this as a default setting using the "Linux SNMP" Wizard.
I've not been able to verify this from the command line as of yet because I'm having issues finding the 'check_xi_service_snmp_linux_process script that checks is. Or, which is what I expect, that merely a variable for another script to parse in order to do the check?
Sorry for the neophyte questions. This is my first real foray with Nagios.
Thanks!
Re: SNMP - MySQL
Posted: Fri Feb 01, 2013 10:43 am
by lmiltchev
Go to: Core Config Manager->Services->click on the service in question->Test Check Command
and show us the command and the output of it. (Hide sensitive info).
Re: SNMP - MySQL
Posted: Fri Feb 01, 2013 10:47 am
by jcmanous
I'll happily do that but I did do the following from the CLI to verify that it works from there:
./check_snmp_process_wizard.pl -H xxx.xxx.xxx.xxx -C public -n /usr/libexec/mysqld -f -c 0,2
Output: 1 process matching /usr/libexec/mysqld (> 0)
So, there's that. I'll check the other bit and post it here momentarily.
Re: SNMP - MySQL
Posted: Fri Feb 01, 2013 10:52 am
by abrist
jcmanous wrote:
./check_snmp_process_wizard.pl -H xxx.xxx.xxx.xxx -C public -n /usr/libexec/mysqld -f -c 0,2
Output: 1 process matching /usr/libexec/mysqld (> 0)
Well, if find the process just fine. Let us know how the actual service check shakes out in XI.
Re: SNMP - MySQL
Posted: Fri Feb 01, 2013 10:53 am
by jcmanous
There doesn't appear to be a function to test the command. At least not in my version 2011R1.3
Re: SNMP - MySQL
Posted: Fri Feb 01, 2013 3:15 pm
by abrist
No problem. Have you tried creating the full blown check in XI as it tested working on the cli?
Re: SNMP - MySQL
Posted: Fri Feb 01, 2013 3:36 pm
by jcmanous
It was decided to rebuild this machine, whole cloth, on RHEL 6.x. I'm considering this "closed" for now since I'm having major dependency issues with regards to running the 0-yum, 1-prerequisite scripts under RHEL6.
Thanks for all your responses. I'll let you know what happens.
Re: SNMP - MySQL
Posted: Fri Feb 01, 2013 4:35 pm
by slansing
Sounds good I'll mark the thread as resolved but keep it unlocked for the future. Look forward to hearing back.