#!/bin/bash
source /etc/profile
#public ip
ip=$(ifconfig eth0 |grep Mask |awk -F: '{print $2}' |awk '{print $1}')
#hostname
hostname=$(hostname)
#system_type
system=$(cat /etc/issue |grep -e "Server")
#kernel
kernel=$(uname -r)
#order_set
order_set=$(uname -m)
#insert data into mysql
mysqy -h localhost -uroot -pmysql -D lzy -e "insert into system_monitor (IP,host,system_type,kernel,order_set) values($ip,$hostname,$system,$kernel,$order_set);"
exit;
是不是不能插入变量的直到表中啊?
source /etc/profile
#public ip
ip=$(ifconfig eth0 |grep Mask |awk -F: '{print $2}' |awk '{print $1}')
#hostname
hostname=$(hostname)
#system_type
system=$(cat /etc/issue |grep -e "Server")
#kernel
kernel=$(uname -r)
#order_set
order_set=$(uname -m)
#insert data into mysql
mysqy -h localhost -uroot -pmysql -D lzy -e "insert into system_monitor (IP,host,system_type,kernel,order_set) values($ip,$hostname,$system,$kernel,$order_set);"
exit;
是不是不能插入变量的直到表中啊?