No output!

Ashley Dawkins adawkins at skynet.co.uk
Wed Sep 6 12:16:00 CEST 2006


Problem Solved! 
The query it should be running is 
"select count(ProductName) from Products where ProductID=1;"
however, nagios does not seem to like the ";" at the end of
the mysql query, so when I look at the config I see the
following: 
$USER1$/check_mysql_query -q 'select count(ProductName) from Products where ProductID=1
instead of the full check command which is : 
$USER1$/check_mysql_query -q 'select count(ProductName) from Products where ProductID=1;' -w 1 -d skynet -H web02.skynet.co.uk -u skynet -p tail3dog
By simply omitting the ";" from the query, the check seems
to work and return the correct result. 


====================================================================
Ashley Dawkins (Technical Support Engineer)
-=
Skynet Internet Services

a: 8 Premier Court
    Boarden Close
    Moulton Park
    Northampton
    NN3 6LF
-=
t: 0845 1 20 65 90 (General)
t: 0845 1 24 44 00 (Sales)
f: 0845 1 20 65 91
e: jhammond at sky.net.uk
w: http://www.sky.net.uk/
-=
D I S C L A I M E R
Statements and opinions expressed in this e-mail may not represent those
of the company.

The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you
received this in error, please contact the sender immediately and delete
the material from any computer.  
====================================================================


-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Nagios-users mailing list
Nagios-users at 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





More information about the Users mailing list