自动化安装脚本

#!/bin/bash
# This Script is to install oa system by Teacher Yan
# Author: Yan Feng
# Date: 20250308
# install java

echo "确保java已经安装"
yum -y install java-1.8.0-openjdk >& /dev/null
javacount=`find / |grep java$ |grep jvm | wc -l `
echo "$javacount java 安装好了。"
# Check if mysql is installed or not
installed=`rpm -qa |grep -ci mysql`

echo "删除数据库..."
~/bin/remove-mysql.sh

echo "开始安装数据库，请稍后..."
yum -y install mysql-server >& /dev/null
isready=`rpm -qa |grep -ci mysql`
echo "安装数据库已完成, mysql的rpm数量 $isready"

echo "启动数据库，并初始化密码，改成root/root"
systemctl enable mysqld --now 

sleep 15
echo "开始登陆服务器,首先获取临时密码"
initpass=$(cat /var/log/mysqld.log |grep password |head -1 | awk '{print $NF}')
echo "已经获取初始密码 $initpass"

mysql -uroot -p"$initpass" --connect-expired-password <<EOF
alter user root@localhost identified by '1qaz!QAZ';
flush privileges;
EOF
echo "初始化密码已经修改为" '1qaz!QAZ' 

mysql -uroot -p'1qaz!QAZ' <<EOF
set global validate_password_length=4;
set global validate_password_policy=LOW;
alter user root@localhost identified by 'root';
create database oasys charset utf8;
flush privileges;
EOF

OABASE=/opt/oasys
echo "开始导入数据库"
mysql -uroot -proot oasys<$OABASE/oasys.sql
count=`mysql -uroot -proot oasys -e " show tables ; " | wc -l ` 
echo "导入数据库成功，数据库oasys中有表 $count 个"

echo "配置防火墙"
systemctl start firewalld
firewall-cmd --add-port=8088/tcp --permanent
firewall-cmd --reload

echo "启动服务器,oa日志位于$OABASE/oa.log" 
nohup java -jar $OABASE/oasys.jar >& $OABASE/oa.log &

sleep 20

isready=`netstat -antp |grep LIST |grep -c 8088 `
echo "端口启用状态为 $isready"

echo "请访问服务器http://192.168.10.67:8088/,密码是soli/123456, ENJOY !!!"

删除数据库脚本

#!/bin/bash

yum -y remove mysql-server mysql >& /dev/null
rpm -e perl-DBD-MySQL-4.023-6.el7.x86_64
rpm -e postfix-2:2.10.1-9.el7.x86_64
rpm -qa |grep mysql | xargs rpm -e 

rm -fr /var/lib/mysql
rm -f /var/log/mysql*
rm -f /etc/my.cnf
rm -fr /etc/my.cnf.d