MYSQL - XYMon - Ubuntu - Simple Select Check

sudo nano /usr/lib/xymon/client/ext/mysql_select_check.sh

#!/bin/sh

COLUMN=mysql				# THIS IS WHERE XYMON GETS COLUMN NAME
COLOR=green				# By default, everything is OK
MSG="SELECT * FROM [TABLENAME] LIMIT 1;" # The comamnd from var

#In this test, if var = empty = RED
var="$(mysql --defaults-extra-file=/etc/xymon/.sqlpwd -e "SELECT * FROM [TABLENAME] LIMIT 1;")"
cmd="$(service mysql status)"

if [ -z "$var" ]

then

COLOR=red
MSG="${MSG}
FAILED
"${cmd}"
"
else

MSG="${MSG}
SUCCESS
"${cmd}"
"
fi

# Leave the rest of script alone
# Tell Xymon about it
$XYMON $XYMSRV "status $MACHINE.$COLUMN $COLOR `date`

${MSG}
"

exit 0

sudo chown xymon:xymon /usr/lib/xymon/client/ext/mysql_select_check.sh
sudo chmod 777 /usr/lib/xymon/client/ext/mysql_select_check.sh
sudo nano /etc/xymon/clientlaunch.d/mysql_select_check.cfg

[mysql_select_check]
	ENVFILE $XYMONCLIENTHOME/etc/xymonclient.cfg
	CMD $XYMONCLIENTHOME/ext/mysql_select_check.sh
	LOGFILE $XYMONCLIENTHOME/logs/mysql_select_check.log
	INTERVAL 15m

sudo nano /etc/xymon/.sqlpwd

[mysql]                     
user=[username]
password=[passwd]

/usr/lib/xymon/client/bin/xymoncmd /usr/lib/xymon/client/ext/mysql_select_check.sh

sudo chmod 600 /etc/xymon/.sqlpwd
sudo chown xymon:xymon /etc/xymon/.sqlpwd

sudo service xymon-client restart

sudo service xymon restart && sudo service apache2 restart