Shell自动化部署应用

    wget -b -O mysql.rpm https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
    
    rpm -ivh mysql.rpm  #将mysql下载的源安装在 /etc/yum.repos.d/ 目录下
    
    linea=$(grep -n "mysql56-community" /etc/yum.repos.d/mysql-community.repo | awk -F : '{print $1}')
    
    ((linea+=3))
    
    sed -i "${linea}c enabled=1" /etc/yum.repos.d/mysql-community.repo
    
    lineb=$(grep -n "mysql80-community" /etc/yum.repos.d/mysql-community.repo | awk -F : '{print $1}')
    
    ((lineb+=3))
    
    sed -i "${lineb}c enabled=0" /etc/yum.repos.d/mysql-community.repo
    
    yum install mysql-server -y
    
    systemctl start mysqld

    #因mysql5.6默认root用户无密码，故使用 mysql -uroot -e " " ，引号内执行语句即可
    mysql -uroot -e "use mysql;"
    mysql -uroot -e "create database woniusales character set utf8 collate utf8_general_ci;"
    mysql -uroot -e "create user remote@'%' identified by 'p-0p-0p-0';"
    mysql -uroot -e "grant all priveleges on woniusales.* to remote@'%';"
    mysql -uroot -e "source woniusales.sql"

    #下载java，注意版本
    #配置java环境变量，每次开启都生效
    #下载tomcat，并配置
    #使用curl来测试网站是否正常

    先判断tomcat是否启动成功
    mv /opt/woniusales.war /opt/tomcat/webapps/
    /opt/tomcat/bin/startup.sh
    rm -f /opt/tomcat/webapps/woniusales/WEB_INF/classes/db.profiles
    vi /opt/tomcat/webapps/woniusales/WEB_INF/classes/db.profiles
    输入：
    db_url=jdbc:mysql://localhost:3306/woniusales?useUnicode=true&characterEncoding=utf8 
    db_username=root
    db_password=p-0p-0p-0
    db_driver=com.mysql.jdbc.Driver
    保存退出,重启 tomcat
    /opt/tomcat/bin/shutdown.sh
    /opt/tomcat/bin/startup.sh

    curl -d "username=admin&password=admin123&verifycode=0000" http://192.168.230.147:8083/woniusales/user/login

    rpm -qa | grep mysql-community-server 1> /dev/null 2> /dev/null
    if [ $? -eq 0 ]; then
    	echo "MySQL数据库已经安装" | tee -a /opt/mysqlinstall.log
    else
    	echo "MySQL数据库没有安装，准备安装" | tee -a /opt/mysqlinstall.log
    
    	yum install wget -y 1> /dev/null
    	slepp 7
    	
    	wget -b -O mysql.rpm https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm 1> /dev/null
    	slepp 7
    	
    	rpm -ivh mysql.rpm 1> /dev/null
    	slepp 3
    	
    	linea=$(grep -n "mysql56-community" /etc/yum.repos.d/mysql-community.repo | awk -F : '{print $1}')
    	((linea+=3))
    	sed -i "${linea}c enabled=1" /etc/yum.repos.d/mysql-community.repo
    
    	lineb=$(grep -n "mysql80-community" /etc/yum.repos.d/mysql-community.repo | awk -F : '{print $1}')
    	((lineb+=3))
    	sed -i "${lineb}c enabled=0" /etc/yum.repos.d/mysql-community.repo
    	echo "MySQL数据库源配置完成，开始安装" | tee -a /opt/mysqlinstall.log
    
    	yum install mysql-server -y 1> /dev/null
    	slepp 30
    	systemctl list-unit-files | grep mysqld
    	if [ $? -eq 0 ]; then 
    		echo "MySQL数据库安装成功" | tee -a /opt/mysqlinstall.log
    		systemctl start mysqld 1> /dev/null
    		echo "MySQL数据库打开成功" | tee -a /opt/mysqlinstall.log
    	else
    		echo "MySQL数据库安装失败" | tee -a /opt/mysqlinstall.log
    		exit 1
    	fi
    	
    fi
    
    systemctl list-unit-files | grep mysqld
    if [$? -eq 0]; then
    	mysql -uroot -e "use mysql;" 1> /dev/null 2> /dev/null
    	mysql -uroot -e "create database woniusales character set utf8 collate utf8_general_ci;" 1> /dev/null 2> /dev/null
    	echo "woniusales数据库创建完成" | tee -a /opt/woniusalesinstall.log 
    	
    	mysql -uroot -e "create user remote@'%' identified by 'p-0p-0p-0';" 1> /dev/null 2> /dev/null
    	mysql -uroot -e "grant all priveleges on woniusales.* to remote@'%';" 1> /dev/null 2> /dev/null
    	echo "woniusales远程用户创建完成" | tee -a /opt/woniusalesinstall.log 
    	
    	mysql -uroot -e "source woniusales.sql" 1> /dev/null 2> /dev/null
    	echo "woniusales数据库数据插入成功" | tee -a /opt/woniusalesinstall.log 
    else
    	echo "MySQL数据库安装失败" | tee -a /opt/mysqlinstall.log
    	exit 1;