doa系统搭建教程

￡神魔★判官ぃ 2022-12-28 14:26 193阅读 0赞

### 文章目录 ###

*  环境安装
 *   *  关闭防火墙
     *  java安装
     *  zookeeper安装
     *  tomcat和dubbo安装
     *  数据库安装
     *  后端服务部署
     *  前端部署
     *  部署nginx发布前端资源

# 环境安装 #

## 关闭防火墙 ##

临时关闭  
systemctl stop firewalld.service  
永久关闭  
systemctl disable firewalld.service

注：关闭防火墙=开放所有端口

## java安装 ##

yum install java -y

--------------------

## zookeeper安装 ##

docker pull zookeeper  
docker images  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMDYzMTQx_size_16_color_FFFFFF_t_70]  
docker run -p 2181:2181 --name zookeeper -dit e1763fd3a0e3

--------------------

## tomcat和dubbo安装 ##

mkdir -p /opt/tomcat  
mkdir -p /opt/dubbo  
上传文件到tomcat和dubbo目录下，然后进入  
cd /opt/tomcat  
tar zxvf apache-tomcat-8.5.45.tar.gz  
vi /opt/tomcat/apache-tomcat-8.5.45/conf/server.xml

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMDYzMTQx_size_16_color_FFFFFF_t_70 1]

> 先按Esc键  
> 再按![在这里插入图片描述][20201221161242309.png]

yum install unzip -y  
unzip /opt/dubbo/dubbo-admin-2.5.4.war -d /opt/dubbo

启动tomcat  
sh /opt/tomcat/apache-tomcat-8.5.45/bin/startup.sh

浏览器访问  
http://192.168.153.139:8080/dubbo/  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMDYzMTQx_size_16_color_FFFFFF_t_70 2]

## 数据库安装 ##

docker pull mysql
    docker run -d -p 3306:3306 --name mymysql -e MYSQL_ROOT_PASSWORD=root docker.io/mysql:latest
    docker exec -it mymysql /bin/bash
    mysql -uroot -p (密码：root)
    alter user 'root'@'%' identified with mysql_native_password by 'root';（修改权限允许远程访问）

创建数据库

CREATE DATABASE  IF NOT EXISTS `d_oa`;
    USE `d_oa`;
    SET NAMES utf8 ;
    DROP TABLE IF EXISTS `apply`;
    SET character_set_client = utf8mb4 ;
    CREATE TABLE `apply` (
      `apply_id` int(11) NOT NULL,
      `apply_status` int(11) DEFAULT NULL,
      `apply_title` varchar(45) DEFAULT NULL,
      `apply_context` varchar(45) DEFAULT NULL,
      `apply_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
      `begin_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
      `end_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
      `apply_type` int(11) DEFAULT NULL,
      `apply_user` varchar(45) DEFAULT NULL,
      `feedback_info` varchar(45) DEFAULT NULL,
      `check_user` varchar(45) DEFAULT NULL,
      PRIMARY KEY (`apply_id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
    LOCK TABLES `apply` WRITE;
    UNLOCK TABLES;
    DROP TABLE IF EXISTS `attendence`;
    SET character_set_client = utf8mb4 ;
    CREATE TABLE `attendence` (
      `idattendence` int(11) NOT NULL,
      `user_no` varchar(45) DEFAULT NULL,
      `specified_on_duty_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
      `specified_off_duty_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
      `on_duty_time` timestamp NULL DEFAULT NULL,
      `off_duty_time` timestamp NULL DEFAULT NULL,
      `on_duty_time_status` int(11) DEFAULT NULL,
      `off_duty_time_status` int(11) DEFAULT NULL,
      PRIMARY KEY (`idattendence`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
    LOCK TABLES `attendence` WRITE;
    UNLOCK TABLES;
    DROP TABLE IF EXISTS `forum`;
    SET character_set_client = utf8mb4 ;
    CREATE TABLE `forum` (
      `forum_id` int(11) NOT NULL,
      `user_no` varchar(45) DEFAULT NULL,
      `title` varchar(45) DEFAULT NULL,
      `content` varchar(45) DEFAULT NULL,
      `send_date` timestamp NULL DEFAULT NULL,
      `reply_num` int(11) DEFAULT NULL,
      `view_num` int(11) DEFAULT NULL,
      PRIMARY KEY (`forum_id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
    LOCK TABLES `forum` WRITE;
    UNLOCK TABLES;
    DROP TABLE IF EXISTS `forum_reply`;
    SET character_set_client = utf8mb4 ;
    CREATE TABLE `forum_reply` (
      `reply_id` int(11) NOT NULL,
      `forum_id` int(11) DEFAULT NULL,
      `user_no` varchar(45) DEFAULT NULL,
      `reply_content` varchar(45) DEFAULT NULL,
      `reply_date` timestamp NULL DEFAULT NULL,
      PRIMARY KEY (`reply_id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
    LOCK TABLES `forum_reply` WRITE;
    UNLOCK TABLES;
    DROP TABLE IF EXISTS `netdisk`;
    SET character_set_client = utf8mb4 ;
    CREATE TABLE `netdisk` (
      `netdisk_id` int(11) NOT NULL,
      `netdisk_uploader` varchar(45) DEFAULT NULL,
      `netdisk_name` varchar(45) DEFAULT NULL,
      `netdisk_type` int(11) DEFAULT NULL,
      `netdisk_permission` int(11) DEFAULT NULL,
      `netdisk_parent` int(11) DEFAULT NULL,
      `netdisk_path` varchar(45) DEFAULT NULL,
      PRIMARY KEY (`netdisk_id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
    LOCK TABLES `netdisk` WRITE;
    UNLOCK TABLES;
    DROP TABLE IF EXISTS `on_time`;
    SET character_set_client = utf8mb4 ;
    CREATE TABLE `on_time` (
      `id` int(11) NOT NULL,
      `specified_on_duty_time` timestamp NULL DEFAULT NULL,
      `specified_off_duty_time` timestamp NULL DEFAULT NULL,
      `operator` varchar(45) DEFAULT NULL,
      `on_timecol` varchar(45) DEFAULT NULL,
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
    LOCK TABLES `on_time` WRITE;
    UNLOCK TABLES;
    DROP TABLE IF EXISTS `permission`;
    SET character_set_client = utf8mb4 ;
    CREATE TABLE `permission` (
      `permission_id` int(11) NOT NULL,
      `permission_name` varchar(45) DEFAULT NULL,
      `required_permission` int(11) DEFAULT NULL,
      `menu_name` varchar(45) DEFAULT NULL,
      `menu_code` varchar(45) DEFAULT NULL,
      `permission_code` varchar(45) DEFAULT NULL,
      PRIMARY KEY (`permission_id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
    LOCK TABLES `permission` WRITE;
    UNLOCK TABLES;
    DROP TABLE IF EXISTS `role`;
    SET character_set_client = utf8mb4 ;
    CREATE TABLE `role` (
      `role_id` int(11) NOT NULL,
      `role_name` varchar(45) DEFAULT NULL,
      PRIMARY KEY (`role_id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
    LOCK TABLES `role` WRITE;
    UNLOCK TABLES;
    
    
    DROP TABLE IF EXISTS `role_permission`;
    SET character_set_client = utf8mb4 ;
    CREATE TABLE `role_permission` (
      `role_id` int(11) NOT NULL,
      `permission_id` int(11) DEFAULT NULL,
      PRIMARY KEY (`role_id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
    LOCK TABLES `role_permission` WRITE;
    UNLOCK TABLES;
    DROP TABLE IF EXISTS `user`;
    SET character_set_client = utf8mb4 ;
    CREATE TABLE `user` (
      `user_no` int(11) NOT NULL,
      `user_name` varchar(45) DEFAULT NULL,
      `user_password` varchar(45) DEFAULT NULL,
      `user_job` varchar(45) DEFAULT NULL,
      `user_icon` varchar(45) DEFAULT NULL,
      `user_profile` varchar(45) DEFAULT NULL,
      `user_face` varchar(45) DEFAULT NULL,
      `role_id` int(11) DEFAULT NULL,
      `user_hire_date` timestamp NULL DEFAULT NULL,
      PRIMARY KEY (`user_no`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
    LOCK TABLES `user` WRITE;
    UNLOCK TABLES;

## 后端服务部署 ##

mkdir -p /opt/doa-package  
上传jar包到目录：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMDYzMTQx_size_16_color_FFFFFF_t_70 3]  
再改目录下编辑启动脚本文件  
start.sh

#! /bin/bash
    proc_id=`ps -ef |grep -w user-2.0.5.RELEASE.jar | grep -v grep | awk '{print $2}'`
    proc_msg=`ps -ef |grep -w user-2.0.5.RELEASE.jar | grep -v grep | awk '{print $8,$9,$10,$11,$12,$13}'`
    if [ -n "$proc_id" ];
    then
        ps -ef |grep -w user-2.0.5.RELEASE.jar | grep -v grep | awk '{print $2}' |xargs kill -9
        echo "kill ${proc_id} ${proc_msg}"
    fi
    echo "${proc_id}"
    
    
    proc_id=`ps -ef |grep -w web-2.0.5.RELEASE.jar | grep -v grep | awk '{print $2}'`
    proc_msg=`ps -ef |grep -w web-2.0.5.RELEASE.jar | grep -v grep | awk '{print $8,$9,$10,$11,$12,$13}'`
    if [ -n "$proc_id" ];
    then
        ps -ef |grep -w web-2.0.5.RELEASE.jar | grep -v grep | awk '{print $2}' |xargs kill -9
        echo "kill ${proc_id} ${proc_msg}"
    fi
    echo "${proc_id}"
    
    proc_id=`ps -ef |grep -w chat-1.0-SNAPSHOT.jar | grep -v grep | awk '{print $2}'`
    proc_msg=`ps -ef |grep -w chat-1.0-SNAPSHOT.jar | grep -v grep | awk '{print $8,$9,$10,$11,$12,$13}'`
    if [ -n "$proc_id" ];
    then
        ps -ef |grep -w chat-1.0-SNAPSHOT.jar | grep -v grep | awk '{print $2}' |xargs kill -9
        echo "kill ${proc_id} ${proc_msg}"
    fi
    echo "${proc_id}"
    
    
    nohup java -jar user-2.0.5.RELEASE.jar >user-module.log &
    nohup java -jar web-2.0.5.RELEASE.jar >web-module.log &
    nohup java -jar chat-1.0-SNAPSHOT.jar >chat-module.log &

./start.sh 即可启动服务

## 前端部署 ##

上传前端资源文件  
mkdir -p /opt/doa-package  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMDYzMTQx_size_16_color_FFFFFF_t_70 4]

## 部署nginx发布前端资源 ##

添加nginx 的 yum源

> rpm -Uvh http://nginx.org/packages/centos/7/noarch/RPMS/nginx-release-centos-7-0.el7.ngx.noarch.rpm

> yum install -y nginx  
> vi /etc/nginx/conf.d/default.conf  
> ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMDYzMTQx_size_16_color_FFFFFF_t_70 5]

location / { 
            root   /opt/doa-package/dist;
            index  index.html index.htm;
        }
    
        location /api { 
            proxy_pass  http://127.0.0.1:9999/api;
        }

> /etc/nginx/conf.d/default.conf的优先级高于/etc/nginx/nginx.conf

启动nginx  
find / -name nginx  
/usr/sbin/nginx -c /etc/nginx/nginx.conf

如果重启可以使用/usr/sbin/nginx -s reload -c /etc/nginx/nginx.conf

*  **浏览器访问前端服务**
 *  http:192.168.153.139/

这个地方需要注意

我访问nginx，nginx转发把静态资源给浏览器，此时虽然前端代码是放在服务器上的，但是通过nginx转发到浏览器这里，代码里的127.0.0.1就不是服务器上的192.168.153.139，而就是浏览器所处的本地ip，相当于前端资源不在服务端，而在客户端，它和你把前端资源放在springboot的resorce下面不一样（该种方式最终会生成servlet代码，本质资源在服务器，所以里面的127.0.0.1就是服务器的地址）

所以前后端分离的项目，前端的地址不能填127.0.0.1，应该写成服务器的地址192.168.153.139

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMDYzMTQx_size_16_color_FFFFFF_t_70]: /images/20221120/7744889c5a5240e4b0eb91081605b224.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMDYzMTQx_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20201221161038772.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMDYzMTQx,size_16,color_FFFFFF,t_70
[20201221161242309.png]: https://img-blog.csdnimg.cn/20201221161242309.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMDYzMTQx_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20201221173618159.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMDYzMTQx,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMDYzMTQx_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/20201221202627208.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMDYzMTQx,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMDYzMTQx_size_16_color_FFFFFF_t_70 4]: https://img-blog.csdnimg.cn/20201221203039282.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMDYzMTQx,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMDYzMTQx_size_16_color_FFFFFF_t_70 5]: https://img-blog.csdnimg.cn/20201221220611847.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMDYzMTQx,size_16,color_FFFFFF,t_70