监控mysql利用telnet发邮件

#!/bin/bash

 

pwd=

user=

cd /usr/script

for host in `grep -v -e '^#' -e '^$' mysqlhost`

do

        [[ `mysql -u$user -p"$pwd" -h"$host" --execute="repair table mysql.time_zone"` ]] &> /dev/null

if (( $? != 0 ))

then

        ( echo "HELO hi";

        sleep 1;

        echo "auth login";

        sleep 1;

        echo ""

        sleep 1;

        echo ""

        sleep 1;

        echo "mail from:<[e-mail]>";

        sleep 1;

        echo "rcpt to:<[e-mail]>";

        sleep 1;

        echo "data";

        sleep 1;

echo "From: <[e-mail]>";

        echo "Subject: $host mysql-error";

        echo  ;

        echo ".";

        sleep 1;

        echo "quit" ) | telnet smtp.139.com 25

 

        echo "`date +%b\ %d\ %T` -- $host -- mysql-error" >> /var/log/my.log

fi

done