<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:w = "urn:schemas-microsoft-com:office:word" xmlns:o = "urn:schemas-microsoft-com:office:office" xmlns:v = "urn:schemas-microsoft-com:vml"><HEAD> <STYLE>@font-face { font-family: Tahoma; } @page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in 1.25in; } P.MsoNormal { FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman" } LI.MsoNormal { FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman" } DIV.MsoNormal { FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman" } A:link { COLOR: blue; TEXT-DECORATION: underline } SPAN.MsoHyperlink { COLOR: blue; TEXT-DECORATION: underline } A:visited { COLOR: blue; TEXT-DECORATION: underline } SPAN.MsoHyperlinkFollowed { COLOR: blue; TEXT-DECORATION: underline } P { FONT-SIZE: 12pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; FONT-FAMILY: "Times New Roman"; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto } SPAN.EmailStyle18 { COLOR: navy; FONT-FAMILY: Arial; mso-style-type: personal-reply } DIV.Section1 { page: Section1 } </STYLE> <META content="MSHTML 6.00.2900.3268" name=GENERATOR></HEAD> <BODY lang=EN-US vLink=blue link=blue> <DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN class=515445119-24032008>Hi Justin,</SPAN></FONT></DIV> <DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN class=515445119-24032008> 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.</SPAN></FONT></DIV> <DIV> </DIV> <DIV align=left><FONT size=2> <P>Jason Brunk<BR>WTHosting.com<BR>1-866-268-7725 ext 707<BR>jbrunk@wthosting.com</P> <P></P> <P>** For any hosting related technical issues, email <A href="mailto:support@wthosting.com">support@wthosting.com</A> and one of our technicians will assist you.</P></FONT></DIV> <DIV> </DIV><BR> <DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left> <HR tabIndex=-1> <FONT face=Tahoma size=2><B>From:</B> Justin Maloney [mailto:justinm@honeycomb.net] <BR><B>Sent:</B> Monday, March 24, 2008 3:34 PM<BR><B>To:</B> Jason Brunk; nagiosplug-help@lists.sourceforge.net<BR><B>Subject:</B> RE: [Nagiosplug-help] check_mysql returns null<BR></FONT><BR></DIV> <DIV></DIV> <DIV class=Section1> <P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">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.<o:p></o:p></SPAN></FONT></P> <P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P> <DIV> <P class=MsoNormal style="mso-margin-top-alt: auto; mso-margin-bottom-alt: auto"><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Thank you,<BR>Justin Maloney<BR>Systems Administrator<BR>Honeycomb Internet Services<BR>612.617.0007</SPAN></FONT><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p></o:p></SPAN></FONT></P></DIV> <DIV> <DIV class=MsoNormal style="TEXT-ALIGN: center" align=center><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"> <HR tabIndex=-1 align=center width="100%" SIZE=2> </SPAN></FONT></DIV> <P class=MsoNormal><B><FONT face=Tahoma size=2><SPAN style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">From:</SPAN></FONT></B><FONT face=Tahoma size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"> nagiosplug-help-bounces@lists.sourceforge.net [mailto:nagiosplug-help-bounces@lists.sourceforge.net] <B><SPAN style="FONT-WEIGHT: bold">On Behalf Of </SPAN></B>Jason Brunk<BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Sunday, March 23, 2008 8:53 PM<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> nagiosplug-help@lists.sourceforge.net<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> [Nagiosplug-help] check_mysql returns null</SPAN></FONT><o:p></o:p></P></DIV> <P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P> <DIV> <P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">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</SPAN></FONT><o:p></o:p></P></DIV> <DIV> <P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P></DIV> <DIV> <P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> ./check_mysql -H mysql.wthosting.com -uUSER -pPASS<BR>Uptime: 7630478 Threads: 4 Questions: 341247089 Slow queries: 1278 Opens: 1050510 Flush tables: 1 Open tables: 3290 Queries per second avg: 44.722</SPAN></FONT><o:p></o:p></P></DIV> <DIV> <P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P></DIV> <DIV> <P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">however, when its setup as a command in nagios. It returns warning because the status information says </SPAN></FONT>(null) <o:p></o:p></P></DIV> <DIV> <P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P></DIV> <DIV> <P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Has anyone seen this? Know how to fix it?</SPAN></FONT> <FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p></o:p></SPAN></FONT></P></DIV> <DIV> <P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P></DIV> <DIV> <P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P></DIV> <P><FONT face="Times New Roman" size=2><SPAN style="FONT-SIZE: 10pt">Jason Brunk<BR>WTHosting.com<BR>1-866-268-7725 ext 707<BR>jbrunk@wthosting.com<o:p></o:p></SPAN></FONT></P> <P><FONT face="Times New Roman" size=2><SPAN style="FONT-SIZE: 10pt">** For any hosting related technical issues, email <A href="mailto:support@wthosting.com">support@wthosting.com</A> and one of our technicians will assist you.<o:p></o:p></SPAN></FONT></P> <DIV> <P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P></DIV></DIV></BODY></HTML>