搭建个人web监控系统 - 黑帽联盟

create table servers (
id int not null primary key auto_increment,
hostname varchar(20),
ip varchar(64),
rootpartion varchar(64),
loadaverage varchar(64),
uptime varchar(64),
memory varchar(64),
Process varchar(64),
time timestamp
)

复制代码

#!/bin/bash
#Server status monitor
#初始化变量及设置阀值
MYSQL="mysql -udbmonitor -p123456 monitor -e" #数据库连接语句
DIR="/tmp"
NOW=$(date "+%F %T")
>${DIR}/messages.txt
ADMIN="admin@cnblackhat.com" #你的邮箱地址
HOSTNAME=$(hostname) #这里也可以手动指定服务器名如：HOSTNAME="Server1"
IP=$(ifconfig eth0|grep 'inet addr'|sed 's/.*addr:$.*$ Bcast:.*/\1/')
loadaverage_MAX=3 #系统负载
DISK_MAX=90 #磁盘使用率
#系统负载
loadaverage=$(uptime|sed 's/^.*age: $.*$$/\1/')
loadaverage_NOW=$(echo $loadaverage|awk -F. '{print $1}')
if [ $loadaverage_NOW -ge $loadaverage_MAX ];then
echo "loadaverage: $loadaverage" >>${DIR}/messages.txt
fi
#服务器存活时间
UPTIME=$(uptime|awk '{print $3}')
#内存使用率
memory=$(free -m | grep - | awk '{print $3}')
#memory_total=$(free -m |grep Mem |awk '{print $2}')
#[ "$memory" -ge "$memory_total" ] && $(echo "memory: $memory" >> ${DIR}/messages.txt)
MemTotal=`free -m | grep Mem | awk -F: '{print $2}' | awk '{print $1}'`
MemFree=`free -m | grep cache | awk NR==2 | awk '{print $4}'`
MemFreeB=`awk 'BEGIN{printf "%.2f%\n",'$MemFree/$MemTotal\*100'}'`
MemFreeS=`awk 'BEGIN{printf "%.f",'$MemFree/$MemTotal\*100'}'`
if [ $MemFreeS -lt 20 ]
then
echo "系统可用内存小于20%，实际可用内存为：$MemFreeB ，请查看。">>${DIR}/messages.txt
else
echo "Mem OK" >/dev/null
fi
#总进程
Process=$(ps -ef |wc -l)
if [ $Process -gt 200 ]
then
echo "系统总进程已经超过200,目前进程数位: $Process ,请查看.">>${DIR}/messages.txt
else
echo "Process is ok!">/dev/null
fi
#根分区
#DISK=$(df -h|grep /$|awk '{print $5,$2,$4}')
#DISK=$(df -h|grep /$|awk '{print $4,$2}')
#DISK_USAGE=$(echo $DISK|awk '{print $1}'|tr -d '%')
DISK=$(df -hP|grep /$|awk '{print $5,$2,$4}')
DISK_USAGE=$(echo $DISK|awk '{print $1}'|tr -d '%')
[ "$DISK_USAGE" -ge "$DISK_MAX" ] && $(echo "DISK: $DISK" >> ${DIR}/messages.txt)
#如果messages.txt文件不为空则发送警报信
if [ -s ${DIR}/messages.txt ];then
mutt -s "system monitor: $NOW $IP $HOSTNAME" "$ADMIN" < ${DIR}/messages.txt
fi
#将服务器运行状态数据入到mysql数据库中
#第一次执行插入一条新记录，后续则更新记录
if [ -n "$1" ];then
$MYSQL "insert into servers(hostname,ip,rootpartion,loadaverage,uptime,memory,Process,time) values('$HOSTNAME','$IP','$DISK','$loadaverage','$UPTIME','$memory','$Process',now())"
else
$MYSQL "update servers set rootpartion='$DISK',loadaverage='$loadaverage',uptime='$UPTIME',memory='$memory',Process='$Process',time=now() where hostname='$HOSTNAME'"
fi

复制代码

<html>
<head>
<meta http-equiv='Content-Type' content='text/html; charset=utf-8' />
<meta http-equiv="refresh" content="60">
<title>my servers</title>
</head>
<body>
<h2>My servers</h2>
<table border='1'>
<tr>
<th>id</th>
<th>hostname</th>
<th>ip</th>
<th>rootpartion</th>
<th>loadaverage</th>
<th>uptime</th>
<th>memory</th>
<th>Process</th>
<th>time</th>
</tr>
<?php
//1、连接并选择数据库
$link=@mysql_connect("127.0.0.1","dbmonitor","123456") or die("连接数据库失败");
mysql_select_db("monitor",$link);
//2、构造sql语句并执行，返回结果集
$sql="select * from servers";
$res=mysql_query($sql,$link);
//3、遍历解析结果集
while($rows=mysql_fetch_assoc($res)){
echo "<tr>";
echo "<td>${rows['id']}</td>";
echo "<td>${rows['hostname']}</td>";
echo "<td>${rows['ip']}</td>";
echo "<td>${rows['rootpartion']}</td>";
echo "<td>${rows['loadaverage']}</td>";
echo "<td>${rows['uptime']}</td>";
echo "<td>${rows['memory']}</td>";
echo "<td>${rows['Process']}</td>";
echo "<td>${rows['time']}</td>";
echo "";
}
?>
</table>
</body>
</html>

复制代码