SNMP - MySQL

[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?

[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.

[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!

[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).

[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.

[abrist]

./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.

[jcmanous]

There doesn't appear to be a function to test the command. At least not in my version 2011R1.3

[abrist]

No problem. Have you tried creating the full blown check in XI as it tested working on the cli?

[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.

[slansing]

Sounds good I'll mark the thread as resolved but keep it unlocked for the future. Look forward to hearing back.