meta_check.sh 397 B
#!/bin/bash
#Logovatko poctu prenesenych zprav na Warden server a vytizeni serveru
USER=root
PASS=
DB=warden
INT=1
QUERY="SELECT NOW(), COUNT( id ), COUNT(DISTINCT(note)) FROM events WHERE received > DATE_SUB(UTC_TIMESTAMP(), INTERVAL $INT MINUTE) AND service='test';"
M_OUT=`echo $QUERY | mysql -s -u$USER -p"$PASS" $DB`
U_OUT=`uptime | awk '{print $11}'`
RET="${M_OUT} ${U_OUT%?}"
echo $RET