# 正式环境部署文档

## 部署位置

jar: 192.168.70.125/data1/acl

web: 192.168.70.125/data1/acl_web

url: https://133.96.94.108:12041/#/home?token=test_token_hebei&fromSystem=test

## v1.10部署

20220815完成部署,仅更新jar包,不需更新数据库

## v1.9部署

1. 老版本下线

    ```sh
    # 部署路径 192.168.70.125:/data1/acl
    sh stop.sh
    # 备份旧版本
    mv aclTousu.jar aclTousu.jar.bk
    ```

2. 备份数据库文件

    ```sql
    -- 备份
    create table sqmdb_rpt.acl_area_bak as select * from sqmdb_rpt.acl_area;
    create table sqmdb_rpt.acl_client_bak as select * from sqmdb_rpt.acl_client;
    create table sqmdb_rpt.acl_function_bak as select * from sqmdb_rpt.acl_function;
    create table sqmdb_rpt.acl_operation_log_bak as select * from sqmdb_rpt.acl_operation_log;
    create table sqmdb_rpt.acl_org_bak as select * from sqmdb_rpt.acl_org;
    create table sqmdb_rpt.acl_role_bak as select * from sqmdb_rpt.acl_role;
    create table sqmdb_rpt.acl_system_bak as select * from sqmdb_rpt.acl_system;
    create table sqmdb_rpt.acl_top_user_bak as select * from sqmdb_rpt.acl_top_user;
    create table sqmdb_rpt.acl_user_bak as select * from sqmdb_rpt.acl_user;
    create table sqmdb_rpt.acl_user_function_bak as select * from sqmdb_rpt.acl_user_function;
    create table sqmdb_rpt.acl_user_role_city_bak as select * from sqmdb_rpt.acl_user_role_city;
    create table sqmdb_rpt.acl_verification_log_bak as select * from sqmdb_rpt.acl_verification_log;

    -- 如需回退操作（将正式表命名为back结尾的，然后将备份表改为正式表名）执行如下
    alter table sqmdb_rpt.acl_area rename to acl_area_back;
    alter table sqmdb_rpt.acl_client rename to acl_client_back;
    alter table sqmdb_rpt.acl_function rename to acl_function_back;
    alter table sqmdb_rpt.acl_operation_log rename to acl_operation_log_back;
    alter table sqmdb_rpt.acl_org rename to acl_org_back;
    alter table sqmdb_rpt.acl_role rename to acl_role_back;
    alter table sqmdb_rpt.acl_system rename to acl_system_back;
    alter table sqmdb_rpt.acl_top_user rename to acl_top_user_back;
    alter table sqmdb_rpt.acl_user rename to acl_user_back;
    alter table sqmdb_rpt.acl_user_function rename to acl_user_function_back;
    alter table sqmdb_rpt.acl_user_role_city rename to acl_user_role_city_back;
    alter table sqmdb_rpt.acl_verification_log rename to acl_verification_log_back;

    alter table sqmdb_rpt.acl_area_bak rename to acl_area;
    alter table sqmdb_rpt.acl_client_bak rename to acl_client;
    alter table sqmdb_rpt.acl_function_bak rename to acl_function;
    alter table sqmdb_rpt.acl_operation_log_bak rename to acl_operation_log;
    alter table sqmdb_rpt.acl_org_bak rename to acl_org;
    alter table sqmdb_rpt.acl_role_bak rename to acl_role;
    alter table sqmdb_rpt.acl_system_bak rename to acl_system;
    alter table sqmdb_rpt.acl_top_user_bak rename to acl_top_user;
    alter table sqmdb_rpt.acl_user_bak rename to acl_user;
    alter table sqmdb_rpt.acl_user_function_bak rename to acl_user_function;
    alter table sqmdb_rpt.acl_user_role_city_bak rename to acl_user_role_city;
    alter table sqmdb_rpt.acl_verification_log_bak rename to acl_verification_log;
    ```

3. 更新数据库文件

4. 上传并启动新的jar包和配置文件（注意检查配置文件环境配置）

    ```sh
    # 启动
    sh run.sh
    ```

5. 完成测试

## 入口测试

[大屏界面-DCN访问](http://133.96.94.108:12011?token=test_token_abc&fromSystem=test)

[中屏--河北联通智慧网络运营平台](https://133.96.90.208/index)
[大屏--网络数据运营平台](http://133.96.90.210:8089/login)

wangyl5740 / Yunwang@2022