[Nagiosplug-help] check_mysql returns null

[Jason Brunk]

I ran it as the nagios user and it returns correctly.  It is running
locally.  
 
Jason Brunk
WTHosting.com
1-866-268-7725 ext 707
jbrunk at wthosting.com

** For any hosting related technical issues, email support at wthosting.com
and one of our technicians will assist you.

 

________________________________

From: Erik Cummings [mailto:ecummings at helpstream.biz] 
Sent: Monday, March 24, 2008 4:47 PM
To: Jason Brunk; nagiosplug-help at lists.sourceforge.net
Subject: RE: [Nagiosplug-help] check_mysql returns null



Basic question - did you execute the command line AS the nagios user?
Is the command line running locally and is the check running locally or
from a different host.

 

Erik

 

From: nagiosplug-help-bounces at lists.sourceforge.net
[mailto:nagiosplug-help-bounces at lists.sourceforge.net] On Behalf Of
Jason Brunk
Sent: Monday, March 24, 2008 1:42 PM
To: nagiosplug-help at lists.sourceforge.net
Subject: Re: [Nagiosplug-help] check_mysql returns null

 

Hi Justin,

    I compiled on the same machine.  When I ran it from the command line
and passed it the parameters it connected fine.  I did notice that
unlike most plugins it returned regular info instead of a warning, ok,
critical.   Not sure what the values are for setting warning or
critical.  the script is located in the libexec folder with the others.
Not sure what I did wrong.

 

Jason Brunk
WTHosting.com
1-866-268-7725 ext 707
jbrunk at wthosting.com

** For any hosting related technical issues, email support at wthosting.com
and one of our technicians will assist you.

 

 

________________________________

From: Justin Maloney [mailto:justinm at honeycomb.net] 
Sent: Monday, March 24, 2008 3:34 PM
To: Jason Brunk; nagiosplug-help at lists.sourceforge.net
Subject: RE: [Nagiosplug-help] check_mysql returns null

It could be if the check is set to return that if it can't find libs or
includes.  Did you compile the script on that server or move it from
another?  Try running it with the full path while you are in another
directory.  I had a similar issue with a perl script and that was the
test, the solution was to add the path to the include line.  Don't know
how you could do that with your script but you could add the path to the
user that is running it.

 

Thank you,
Justin Maloney
Systems Administrator
Honeycomb Internet Services
612.617.0007

________________________________

From: nagiosplug-help-bounces at lists.sourceforge.net
[mailto:nagiosplug-help-bounces at lists.sourceforge.net] On Behalf Of
Jason Brunk
Sent: Sunday, March 23, 2008 8:53 PM
To: nagiosplug-help at lists.sourceforge.net
Subject: [Nagiosplug-help] check_mysql returns null

 

I am having an issue with the check_mysql.  Hoping someone has run into
this before.  when i run this plugin from the command line i get this

 

 ./check_mysql -H mysql.wthosting.com -uUSER -pPASS
Uptime: 7630478  Threads: 4  Questions: 341247089  Slow queries: 1278
Opens: 1050510  Flush tables: 1  Open tables: 3290  Queries per second
avg: 44.722

 

however, when its setup as a command in nagios.  It returns warning
because the status information says (null) 

 

Has anyone seen this?  Know how to fix it?  

 

 

Jason Brunk
WTHosting.com
1-866-268-7725 ext 707
jbrunk at wthosting.com

** For any hosting related technical issues, email support at wthosting.com
and one of our technicians will assist you.

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-plugins.org/archive/help/attachments/20080324/4cea507b/attachment.html>