I have a query that says it returns 0.0000 and have a warning value of 2:6 and
critical value of 7 and am getting a warning.
This is from the debug file:
[1361472169.305131] [2048.1] [pid=2302] **** BEGIN MACRO PROCESSING ***********
[1361472169.305133] [2048.1] [pid=2302] Processing: '$USER1$/check_mysql_query
--hostname=$ARG1$ --port
=$ARG2$ --database=$ARG3$ --username=$ARG4$ --password=$ARG5$ --warning=$ARG6$
--critical=$ARG7$ --quer
y=$ARG8$'
[1361472169.305154] [2048.1] [pid=2302] Done. Final output:
'/export/nagios/libexec/check_mysql_quer
y --hostname=sd-mysql --port=3308 --database=it_administration
--username=ituser --password=########## -
-warning=2:6 --critical=7 --query="select
format(datediff(current_timestamp,UPDATE_TIME),0) from inform
ation_schema.tables where TABLE_SCHEMA = 'it_administration' and TABLE_NAME =
'SD_AD_USERS'"'
[1361472169.305157] [2048.1] [pid=2302] **** END MACRO PROCESSING *************
This is from the status:
QUERY WARNING: 'select format(datediff(current_timestamp,UPDATE_TIME),0) from
information_schema.tables where TABLE_SCHEMA = 'it_administration' and
TABLE_NAME = 'SD_AD_USERS'' returned 0.000000
What am I doing wrong?
Thanks,
Ken
------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb
_______________________________________________
Nagios-users mailing list
Nagios-users@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
