顏色變量腳本展示
| 123456789101112131415161718192021222324252627282930313233343536 | [root@localhost opt]#!/bin/bash BLACK="/033[30m" RED="/033[31m" GREEN="/033[32m" YELLOW="/033[33m" BLUE="/033[34m" PURPLE="/033[35m" SKY_GREEN="/033[36m " WHITE="/033[37m" BLACK_WHITE="/033[40;37m" RED_WHITE="/033[41;37m" GREEN_WHITE="/033[42;37m" YELLOW_WHITE="/033[43;37m" BLUE_WHITE="/033[44;37m" PURPLE_WHITE="/033[45;37m" WHITE_BLACK="/033[47;30m" SKY_BLUE_WHITE="/033[46;37m" FLICKER="/033[05m" OUTPUT="echo -e" TAILS="/033[0m" |
把文件里的sql文件按從高到下的順序導進數據庫
############# 需求 #############
依序從上到下把文件里面的每行sql文件導進數據庫
############# 執(zhí)行方法 #############
sh import_ku.sh 變量1 變量2 變量3
變量1：存儲數據庫腳本文件名的文件
變量2：數據庫用戶名
變量3: 數據庫密碼
代碼展示
| 1234567891011121314151617181920 | #!/bin/bashOUTPUT="echo -e"TAILS="/033[0m"GREEN="/033[32m"RED="/033[31m"FLICKER="/033[05m"DATA=`cat $1 | wc -l`for((i=1;i<=$DATA;i++))do SQL=`head -$i $1 | tail -1` MySQL -u$2 -p$3 < $SQL NU=$? if [ $NU -eq 0 ];then $OUTPUT $GREEN "$SQL exculde success" $TAILS echo else $OUTPUT $RED$FLICKER "$SQL exculde eroor!" $TAILS echo fidone |
MySQL主從同步監(jiān)控
#此腳本為監(jiān)控MySQL主從IO和SQL的兩個YES，NO代表為不同步
#Zabbix一分鐘采集一次數據
#觸為器為大于1則報警
#!/bin/bash
mysql="/usr/bin/mysql"
user="root"
passWord="123456"
IO=`$mysql -u$user -p$password -e "show slave status/G" | grep 'Slave_IO_Running:' | awk '{PRint $2}'`
SQL=`$mysql -u$user -p$password -e "show slave status/G" | grep 'Slave_SQL_Running:' | awk '{print $2}'`
#[ "$IO" == "Yes" -a "$SQL" == "Yes" ] && echo "1" || echo "2"
[ "$IO" == "Yes" -o "$IO" == "Connecting" ] && [ "$SQL" == "Yes" -o "$SQL" == "Connecting" ] && echo "1" || echo "2"
#此腳本為監(jiān)控MySQL主從同步的中繼日志點，不變化代表不同步，
#Zabbix三分鐘采集一次數據
#觸為器為日志點數字不變化則報警
#!/bin/bash
mysql="/usr/bin/mysql"
user="root"
password="123456"
Relay=`$mysql -u$user -p$password -e "show slave status/G" | grep 'Relay_Log_Pos:' | awk '{print $2}'`
echo $Relay
#此腳本為監(jiān)控MySQL主從同步延遲時間
#Zabbix一分鐘采集一次數據
#觸為器為超過3600秒延遲時間則報警
#!/bin/bash
mysql="/usr/bin/mysql"
user="root"
password="123456"
Seconds=`$mysql -u$user -p$password -e "show slave status/G" | grep 'Seconds_Behind_Master:' | awk '{print $2}'`
echo $Seconds
上述三個監(jiān)控腳本寫后，在Slave的機器上相應位置放置三個腳本，
再去Zabbix Web界面添加監(jiān)控，設置好Item和Key即可
#telnet放到子shell執(zhí)行退出
| 12345 | [root@localhost ~]Trying 127.0.0.1... Connected to 127.0.0.1.Escape character is '^]'.Connection closed by foreign host. |
#通過telnet監(jiān)控22端口
| 12345678 | [root@ryzc32 opt]#!/bin/bashJG=`echo -e "/n" | telnet 192.168.1.30 22 | grep Connected | wc -l`if [ "$JG" == 1 ];then echo "0" else echo "1" fi |
#通過nmap監(jiān)控22端口
| 12345678 | [root@localhost opt]#!/bin/bashnamp=`nmap 192.168.100.50 -p 22 | grep open | wc -l`if [ "$namp" == 1 ];then echo 0else echo 1fi |
#通過nc監(jiān)控22端口
| 123 | [root@localhost opt]#!/bin/bashnc -w 5 192.168.100.50 22 && echo 0 || echo 1 |
#通過wget判斷www.baidu.com狀態(tài)是否為200
| 12345678 | [root@mndg248 opt]#!/bin/bashwget -T 10 -c -q --spider www.baidu.com && RETVAL=$?if [ "$RETVAL" == 0 ];then echo "0"elsee cho "1"fi
|
一健安裝Zabbix
#!/bin/bash
#定義變量
Redh="/033[31m"
Blueh="/033[36m"
Yellow="/033[33m"
Tails="/033[0m"
Output="echo -e"
Document=`dirname $0;pwd`
dir=`echo $Document | sed s'/. //'`
#加載函數庫
. /etc/init.d/functions
#檢查網絡
$Output --------------------$Blueh【 正在檢查網絡,請稍候 】$Tails--------------------
echo
ping www.baidu.com -c 3 &> /dev/null
[ $? -eq 0 ] && action "網絡正常" /bin/true || {
action "你的網絡不通，請修復你的網絡，然后再進行安裝" /bin/false
exit 2
}
echo
$Output --------------------$Redh【 準備安裝Zabbix 】$Tails-------------------------
sleep 3
#下載yum
rm -rf /etc/yum.repos.d/other
mkdir /etc/yum.repos.d/other
mv /etc/yum.repos.d/*.repo /etc/yum.repos.d/other
wget -O /etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-6.repo
yum clean all
yum makecache
#關閉防火墻和selinux
service iptables stop
setenforce 0
chkconfig iptables off
sed -i 's/SELINUX=enforcing/SELINUX=disabled/g' /etc/sysconfig/selinux
#修改主機名
sed -i '2d' /etc/sysconfig/network
sed -i '1a HOSTNAME=zabbix' /etc/sysconfig/network
hostname zabbix
#服務端安裝LAMP環(huán)境
yum install -y gcc gcc-c++ autoconf httpd php mysql mysql-server php-mysql httpd-manual mod_ssl mod_perl mod_auth_mysql php-gd php-xml php-ldap php-pear php-xmlrpc mysql-connector-odbc mysql-devel libdbi-dbd-mysql net-snmp-devel curl-devel php-mbstring php-bcmath mail
#服務端配置LAMP使用環(huán)境
sed -i 's/;date.timezone =/date.timezone = Asia//Shanghai/g' /etc/php.ini
sed -i 's#max_execution_time = 30#max_execution_time = 300#g' /etc/php.ini
sed -i 's#post_max_size = 8M#post_max_size = 32M#g' /etc/php.ini
sed -i 's#max_input_time = 60#max_input_time = 300#g' /etc/php.ini
sed -i 's/;mbstring.func_overload = 0/mbstring.func_overload = 2/g' /etc/php.ini
service mysqld start;chkconfig mysqld on
service httpd start;chkconfig httpd on
#安裝Zabbix server服務端
groupadd -g 201 zabbix
useradd -g zabbix -u 201 zabbix
tar xf zabbix-2.2.2.tar.gz -C /usr/src/
cd /usr/src/zabbix-2.2.2/
./configure --prefix=/usr/local/zabbix --enable-server --enable-proxy --enable-agent --with-mysql=/usr/bin/mysql_config --with-net-snmp --with-libcurl
make
make install
#添加Zabbix到系統(tǒng)服務文件
sed -i '$a zabbix-agent 10050/tcp #Zabbix Agent' /etc/services
sed -i '$a zabbix-agent 10050/udp #Zabbix Agent' /etc/services
sed -i '$a zabbix-server 10051/tcp #zabbix Trapper' /etc/services
sed -i '$a zabbix-server 10051/udp #zabbix Trapper' /etc/services
#導入zabbix數據庫
mysqladmin -uroot password 'mysql_pass'
mysql -uroot -pmysql_pass -e "create database zabbix default character set utf8;"
mysql -uroot -pmysql_pass -e "grant all on zabbix.* to 'zabbix'@'localhost' identified by 'zabbix';"
mysql -uroot -pmysql_pass -e "flush privileges;"
cd /usr/src/zabbix-2.2.2/database/mysql/
mysql -uzabbix -pzabbix zabbix < schema.sql
mysql -uzabbix -pzabbix zabbix < images.sql
mysql -uzabbix -pzabbix zabbix < data.sql
#創(chuàng)建鏈接
mkdir /var/log/zabbix
chown zabbix.zabbix /var/log/zabbix
ln -s /usr/local/zabbix/etc /etc/zabbix
ln -s /usr/local/zabbix/bin/* /usr/bin/
ln -s /usr/local/zabbix/sbin/* /usr/sbin/
#拷貝service啟動腳本
cp /usr/src/zabbix-2.2.2/misc/init.d/fedora/core/zabbix_* /etc/init.d/
sed -i "s#BASEDIR=/usr/local#BASEDIR=/usr/local/zabbix#g" /etc/init.d/zabbix_server
sed -i "s#BASEDIR=/usr/local#BASEDIR=/usr/local/zabbix#g" /etc/init.d/zabbix_agentd
#配置zabbix_server.conf服務端文件
sed -i 's#LogFile=/tmp/zabbix_server.log#LogFile=/var/log/zabbix/zabbix_server.log#' /etc/zabbix/zabbix_server.conf
sed -i 's#DBUser=root#DBUser=zabbix#' /etc/zabbix/zabbix_server.conf
sed -i 's/# DBPassword=/DBPassword=zabbix/' /etc/zabbix/zabbix_server.conf
service zabbix_server start
#配置zabbix_agentd.conf文件 （監(jiān)控server本身，如對其他服務器進行監(jiān)控，配置文件相同）
IP=`ifconfig | head -2 | tail -1 | awk '{print $2}' | awk -F':' '{print $2}'`
sed -i 's#LogFile=/tmp/zabbix_agentd.log#LogFile=/var/log/zabbix/zabbix_agentd.log#' /etc/zabbix/zabbix_agentd.conf
sed -i "s/Server=127.0.0.1/Server=127.0.0.1,$IP/" /etc/zabbix/zabbix_agentd.conf
sed -i "s/ServerActive=127.0.0.1/ServerActive=$IP:10051/" /etc/zabbix/zabbix_agentd.conf
sed -i 's/# UnsafeUserParameters=0/UnsafeUserParameters=1/' /etc/zabbix/zabbix_agentd.conf
sed -i 's/Hostname=Zabbix server/Hostname=Zabbix/' /etc/zabbix/zabbix_agentd.conf
sed -i 's$# EnableRemoteCommands=0$EnableRemoteCommands=1$' /etc/zabbix/zabbix_agentd.conf
sed -i 's$# Include=/usr/local/etc/zabbix_agentd.conf.d/$Include=/usr/local/zabbix/etc/zabbix_agentd.conf.d/$' /etc/zabbix/zabbix_agentd.conf
service zabbix_agentd start
#拷貝網頁文件到apache目錄
cp /usr/src/zabbix-2.2.2/frontends/php/ /var/www/html/zabbix -r
chown -R apache.apache /var/www/html/zabbix
#設置zabbix開機啟動
chkconfig --add zabbix_server
chkconfig --add zabbix_agentd
chkconfig zabbix_agentd on
chkconfig zabbix_server on
#配置郵件發(fā)送
cat >> /etc/mail.rc <<EOF
set [email protected]
set smtp=smtp.139.com
set [email protected]
set smtp-auth-password=test
set smtp-auth=login
EOF
cat >> /etc/postfix/main.cf <<EOF
myhostname = zabbix.test.com
myorigin = zabbix.jenkins.com
mydomain = zabbix.jenkins.com
mynetworks = 127.0.0.0/8
EOF
#修改Hosts文件，做域名解析
sed -i '1a 127.0.0.1 localhost localhost.localdomain zabbix.test.com zabbix.wsyht.com' /etc/hosts
sed -i 1d /etc/hosts
#設置zabbix在web頁面的字體
cp $dir/msyhbd.ttf /var/www/html/zabbix/fonts/
sed -i "s/define('ZBX_FONT_NAME', 'DejaVuSans');/define('ZBX_FONT_NAME', 'msyhbd');/" /var/www/html/zabbix/include/defines.inc.php
sed -i "39a define('ZBX_GRAPH_FONT_NAME', 'msyhbd');" /var/www/html/zabbix/include/defines.inc.php
sed -i 39d /var/www/html/zabbix/include/defines.inc.php
#web登陸
$Output $Yellow"[腳本功能]" $Tails
$Output $Blueh"安裝Zabbix" $Tails
$Output $Blueh"安裝agentd" $Tails
$Output $Blueh"郵件服務配置" $Tails
$Output $Blueh"配置PHP支持中文字體" $Tails
$Output $Yellow"[瀏覽器登陸]" $Tails
$Output $Redh"http://$IP/zabbix" $Tails
$Output 用戶名: $Redh"admin" $Tails
$Output 密碼: $Redh"zabbix" $Tails
?
