^-^
docker环境部署工智道
  1. 前期准备
  2. 正式部署
    1. 数据库服务器操作
      1. 还原数据库
      2. 更改数据库
    2. web服务器操作
      1. 安装docker和docker-compose
      2. 启动服务
      3. docker-compose文件
      4. 配置文件
        1. inroad
        2. pointer
        3. oaa
        4. timejob
        5. lowcode
        6. nginx
        7. todo

前期准备

要在docker环境中部署工智道，首先要明确一些事情，工智道部署的版本，是否需要积木(lowcode)，系统的客户用量。

有哪些机器?

部署机器分为web服务器和数据库服务器，web服务器的规格是2核4G，系统盘60G；数据库服务器的规格是4核8G，系统盘60G，数据盘100G。

客户用量为100人以下：一台web服务器，一台数据库服务器，两家客户共用一套。

客户用量为100~300人：一台web服务器，一台数据库服务器，独用一套。

客户用量为300人以上：两台web服务器，一台数据库服务器，独用一套。

需要什么文件？

  1. docker-compose的yaml文件
  2. inroad，pointer，oaa，timejob，nginx，todo的配置文件，以及lowcode的配置文件（如果需要部署的话）

上面的文件准备好之后，打包放到同步服务器的共享目录中（C盘的UpdateFiles目录），其他公网机器可以通过http://103.229.212.76:81/文件名来下载，比格云内网机器可以通过http://10.100.14.2:81/文件名来下载。

需要提前进行什么准备？

需要确定客户的名称、客户代码以及网站域名。

服务器列表中搜索通用服务，下面的BJ1和BJ2两台服务器是负责客户代码返回服务的，连接两台服务器，找到网站中的service站点，浏览站点文件，其中的url.config文件就是维护客户代码的xml文件，新增一行，添加key(客户名称)，code(客户代码)，url(客户站点)。两台服务器都要修改，修改之后重新启动服务。

正式部署

数据库服务器操作

还原数据库

原生工智道需要搭建好 inroad数据库 和 todo数据库 基础环境，我们的数据库服务器的镜像是已经安装好了sql server和sql server 管理工具的，我们首先打开sql server 管理工具，使用windows身份验证进行登录，然后可以开始搭建数据库基础环境了，这里有两种方式：手动搭建和自动搭建。

手动搭建

  1. 连接到DB-OA_CUSTOM-张家港-天然气管网这台服务器，拉取Inroad-Base的数据库备份文件和InroadTodoService-Base的数据库备份文件（可以去数据库里找到最新版本的数据库备份一个，也可以去备份目录里面找一个指定版本的备份文件），总之拿到Inroad-Base版本号.bak和InroadTodoService-Base版本号.bak两个文件

  2. 把这两个文件复制到我们要部署的数据库服务器上，在服务器的D盘中，新建DB和DBBAK两个目录，在sql server管理工具中，右键数据库，点击还原数据库，然后进入还原选项。

    这里要注意的地方是目标数据库名称，格式应该是Inroad-客户名称缩写。

    image-20240507233642098

    这里按照图中的规范来就行了，要注意的地方是图比较糊，设置好之后点击确定就可以还原了。

    image-20240507233713182

    image-20240507233903621

  3. 还原成功了之后，在这个数据库中新建查询，有一个sql脚本，把其中的语句粘贴进去执行，脚本内容太长就不把代码贴在这里了，主要的作用是创建一些作业。执行成功之后进到图中这里刷新一下看看作业是否生成。

    image-20240507234745476

  4. 设置备份计划。这一步看图就行

    管理——维护计划——维护计划向导，跳过起始页

    IMG_256

    IMG_256

    IMG_256

    IMG_256

    这个图箭头标错了，确认任务顺序没问题就选择下一步

    IMG_256

    IMG_256

    IMG_256

    IMG_256

    IMG_256

    IMG_256

    IMG_256

    IMG_256

    IMG_256

    选择报告选项，默认即可，点击下一步

    IMG_256

    完成向导，点击完成

    IMG_256

    等待维护计划向导完成，关闭即可

    IMG_256

    查看维护计划是否创建成功。作业需要刷新

    IMG_256

  5. 新建一个todo数据库，命名为InroadTodoService-客户名称简写，在todo数据库中新建一个查询，粘贴SQL语句，SQL语句太长就不贴了，执行的目的是初始化数据库结构。

自动搭建

执行一个auto_install.bat，这是一个Windows脚本，我还没试过，试过了再写。

更改数据库

  1. 进入Inroad数据库，执行select * from CommonConstConfig where consttitle='CommonFileServer'，查到下面的数据

img

其中CommonFileServer是指公共服务：文件服务的地址 https://uploadfilenew.in-road.com/FileUploadHandle.ashx，这个是默认参数。如果是客户内网部署公共服务，就需要修改这个地址，改为客户内网文件服务的地址。

  1. 进入Inroad数据库，执行select * from CommonConstConfig where consttitle = 'autoupdateurl'，如果查到的constvalue的域名是客户自己的，那就不用更改，如果查到的是filesnew.in-road.com域名，就要执行下面的语句

    1
    2
    3
    4
    -- 其中把版本号和apk的版本号都换成客户安装的版本
    update  CommonConstConfig
    set constvalue='https://filesnew.in-road.com/InroadAppFiles/20240508/inroad_release_202405083.apk'
    where consttitle =  'autoupdateurl'

  2. 执行select * from CommonConstConfig where constvalue='工智道基础x'，如果出现这些数据，就按图中操作。

img

另外补充一点，执行select * from CommonMobileSms order by c_cretaetime，可以查看登录时接收的验证码。

web服务器操作

安装docker和docker-compose

在ubuntu环境中部署

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
# 更新
apt update && apt upgrade
# 安装必要的证书并允许 apt 包管理器使用以下命令通过 HTTPS 使用存储库
apt install apt-transport-https ca-certificates curl software-properties-common gnupg lsb-release
# 添加 Docker 的官方 GPG 密钥
curl -fsSL https://download.docker.com/linux/ubuntu/gpg | gpg --dearmor -o /usr/share/keyrings/docker-archive-keyring.gpg
# 添加 Docker 官方库
echo "deb [arch=$(dpkg --print-architecture) signed-by=/usr/share/keyrings/docker-archive-keyring.gpg] https://download.docker.com/linux/ubuntu $(lsb_release -cs) stable" | tee /etc/apt/sources.list.d/docker.list > /dev/null
# 更新 Ubuntu 源列表
apt update
# 安装最新 Docker CE
apt install docker-ce docker-ce-cli containerd.io docker-compose-plugin
# 验证 Docker 服务是否在运行
systemctl status docker
systemctl enable docker

# 安装docker-compose
curl -L "https://github.com/docker/compose/releases/download/1.29.2/docker-compose-$(uname -s)-$(uname -m)" -o /usr/local/bin/docker-compose && \
chmod +x /usr/local/bin/docker-compose  && \
ln -s /usr/local/bin/docker-compose /usr/bin/docker-compose

启动服务

把配置文件下载到web服务器，登陆镜像仓库

1
2
3
4
# 上传操作的用户名和密码
docker login -u road-1664368754995 -p fc70890e6980e2263e668f6bef02634cc40b537e in-road-docker.pkg.coding.net
# 拉取操作的用户名和密码
docker login -u road-1661826238505 -p 4678a3ca6f3ba64013eed03b6e9e94be0f639fa9 in-road-docker.pkg.coding.net

docker-compose文件

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
version: '3'
networks:
  inroad_network:
    driver: bridge
    ipam:
      driver: default
      config:
        - subnet: 172.88.0.0/24
          gateway: 172.88.0.1
services:
  inroad:
    image: in-road-docker.pkg.coding.net/in/road/inroad:v240329 # 此处需要修改镜像版本号
    restart: unless-stopped
    environment:
      TZ: 'Asia/Shanghai'
    networks:
      inroad_network:
        ipv4_address: 172.88.0.2 #工智道默认IP为x.x.x.2
    expose:
      - 85
    volumes:
      - "./config/inroad/appsettings.json:/usr/local/inroad/appsettings.json"
      - "./config/inroad/Properties:/usr/local/inroad/Properties"
  timejob:
    image: in-road-docker.pkg.coding.net/in/road/timejob:v220930 # 此处需要修改镜像版本号
    restart: unless-stopped
    environment:
      TZ: 'Asia/Shanghai'
    networks:
      inroad_network:
        ipv4_address: 172.88.0.3 #timejob默认IP为x.x.x.3
    expose:
      - 5001
    volumes:
      - "./config/timejob/appsettings.json:/usr/local/timejob/appsettings.json"    
  oaa:
    image: in-road-docker.pkg.coding.net/in/road/oaa:v240329 # 此处需要修改镜像版本号
    restart: unless-stopped
    environment:
      TZ: 'Asia/Shanghai'
    networks:
      inroad_network:
        ipv4_address: 172.88.0.4 #oaa默认IP为x.x.x.4
    expose:
      - 82
    volumes:
      - "./config/oaa/appsettings.json:/usr/local/oaa/appsettings.json" 
      - "./config/oaa/SubsidiaryInfo.json:/usr/local/oaa/SubsidiaryInfo.json" 
  pointer:
    image: in-road-docker.pkg.coding.net/in/road/pointer:v220930 # 此处需要修改镜像版本号
    restart: unless-stopped
    environment:
      TZ: 'Asia/Shanghai'
    networks:
      inroad_network:
        ipv4_address: 172.88.0.5 #poinetr默认IP为x.x.x.5
    expose:
      - 18
    volumes:
      - "./config/pointer/appsettings.json:/usr/local/pointer/appsettings.json"      
  nginx:
    image: in-road-docker.pkg.coding.net/in/road/nginx:v240206_1 # 此处需要修改镜像版本号
    restart: unless-stopped
    environment:
      TZ: 'Asia/Shanghai'
    networks:
      inroad_network:
        ipv4_address: 172.88.0.6 #nginx默认IP为x.x.x.6
    ports:
      - "80:80" 
    volumes:   
      - "./config/nginx/nginx.conf:/etc/nginx/nginx.conf"  
  lowcode:
    image: in-road-docker.pkg.coding.net/in/road/lowcode:v2.3.4 # 此处需要修改镜像版本号
    restart: unless-stopped
    environment:
      TZ: 'Asia/Shanghai'
    networks:
      inroad_network:
        ipv4_address: 172.88.0.7 #lowcode默认IP为x.x.x.7
    expose:
      - 8088
    volumes:
      - "./config/lowcode/appsettings.json:/usr/local/lowcode/appsettings.json" 
  todo:
    image: in-road-docker.pkg.coding.net/in/road/todo:v240329 # 此处需要修改镜像版本号
    restart: unless-stopped
    environment:
      TZ: 'Asia/Shanghai'
    networks:
      inroad_network:
        ipv4_address: 172.88.0.8 #lowcode默认IP为x.x.x.8
    expose:
      - 88
    volumes:
      - "./config/todo/appsettings.json:/usr/local/todo/appsettings.json"

配置文件

inroad

appsettings.json

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
{
  "ConnectionStrings": {
      //此处需要修改MS SQL数据库的IP，用户名和密码
    "Default": "Data Source=10.100.14.150;Initial Catalog=Inroad-Base;Persist Security Info=True;User ID=sa;Password=First_Deploy_GZD_0507;Pooling=true;Max Pool Size=200;Min Pool Size=5;"
  },
  "Logging": {
    "IncludeScopes": false,
    "LogLevel": {
      "Default": "Information",
      "System": "Error",
      "Microsoft": "Error"
    }
  },
"InroadOaaAuth": {
     //如果需要使用OAA方式登录，则需要将OAA服务的IP放入AuthWhiteList中
    "AuthWhiteList": [
      "http://172.88.0.4:82"
    ]
  },
  "inroad": {
        "LoggerSubscribers": {
            //将日志信息输出到何处，建议优先ES，如果都为false会输出到控制台
          "OutPut": {
            "SQLSERVER": false,
            "ES": true,
            "LocalFile": false,
            "MQ": false
          }
        },
        "LogFitering": {
          "ResponseFilter": {
            "UrlPaths": [
              {
                "Path": "/UAPI/Demo/Index",
                "Method": "GET"
              }
            ]
          }
        },
       //租户ID，格式为`客户简称_客户代码_production`
        "TenantID": "GZKYCD_2356_production",
      //客户名称
        "TenantName": "贵州开阳川东",
      //ES的地址，华为云地址119.3.59.53:8200，比格云地址：10.100.10.17:8200
        "EsConfig": {
          "ConnectionStrings": [ "http://10.100.10.17:8200" ],
          "UseName": "elastic",
          "PassWord": "Inroad18121225109"
        },
        "MQConfig": {
          "Host": "119.3.49.204",
          "Port": 5672,
          "Username": "inroad",
          "Password": "InroadMq20191107",
          "VirtualHost": "/",
          "ConnectionTimeOut": 15000,
          "Name": "InroadLogger"
        },
    "openLogFlag":"1",
    "HTTPRedirection": "false",
    "APIVersion": "2020123101",
    "CountPerPage": "50",
    "DefaultWorkTypeWhenCreate": "普工",
    "pushservertype": "jiguang",
    "IsDebug": "false",
    "IsLimitUserid": "IsLimitUserid",
    "IsApiDebug": "IsApiDebug",
    "isDeleteImportHistory": "true",
    "calltoken": "3979189c96de598a7c2e10433bb1885a",
      //公共服务-上传服务的地址，如果是客户本地部署公共服务，需要修改此地址
    "uploadserver": "https://uploadfilenew.in-road.com/FileUploadHandle.ashx",
    "serviceserver": "http://service.in-road.com/Getserverlist.ashx",
    "smsserver": "http://sms.in-road.com/SMSHandle.ashx",
    "LogCenterType": "1",
    "LogCenterUrl": "http://log.in-road.com/Log/AddLog",
    "TempLogLevel": "4",
    "fileContentInvokeUrl": "http://192.168.31.99/log/FileContent",
    "fileContentUrl": "http://192.168.31.99:9031/GetFilesContent.ashx",
    "permition_permanent": "http://182.254.156.49/savevideo",
    "permition_delete": "http://182.254.156.49/removevideo",
    "computing_test": "http://10.21.1.30:8888",
    "ExportDocUrl": "http://readdoc.in-road.com/",
    "RedirectAddress": "",
    "WxOpenToken": "4A4B98ED0F66ECC3720543C2AD681624",
    "OpenLinkToken": "4A4B98ED0F66ECC3720543C2AD681624",
      //实时数据地址，下面两行需要修改
    "prGetDataCurrValueURL": "http://43.247.90.165:81/SVGDataValue/SVGPointPosition",
    "prSaveDataCurrValueURL": "http://43.247.90.165:81/DataPushToPR/ReceivedIRData",
    "ShzhHost": "http://10.141.45.128:9045",
    "CustomComputing": "0",
    "LocalTest": "1",
    "SDHFComputing": "0",
    "SDHFHost": "http://172.16.100.45",
    "IsMsgPush": "1",
      //数据中心地址，需要修改
    "DataCenterAddress": "http://43.247.90.165:81",
    "DataCenterdataGap": "",
    "is_use_translate": "0",
	"useDataBase":"SQLServer",
    "enginMouldPath": "C:\\Users\\hhchen\\source\\repos\\InroadWorkFlowEngin\\InroadWorkFlowEngin\\Template\\",
    "enginFunctionSavePath": "C:\\Users\\hhchen\\source\\repos\\InroadWorkFlowEngin\\InroadWorkFlowEngin\\BusinessLibrary\\",
    "CmdPath": "C:\\Windows\\System32\\cmd.exe",
    "enginCmd": "C:&cd C:\\Users\\hhchen\\source\\repos\\InroadWorkFlowEngin&dotnet publish -c release -o C:\\Users\\hhchen\\publish",
    "enginDll": "C:\\InroadWebCoredDemo\\Engin\\InroadWorkFlowEngin.dll",
    "emailserver": "http://43.247.89.168:81/EmailHandle.ashx",
      //todo代办服务的地址
	"TodoListAddress": "http://172.88.0.8:88/",
    "pointer": "http://172.88.0.5:18/"
  },
  "ES": {
   "ESAPIUrl": "http://platform.in-road.com"
  },
  "IdentityServer": {
      //OAA服务的地址
    "Authority": "http://172.88.0.4:82",
    "Scope": "OaaScope",
    "InUse": true,
    "ClaimRelationDic": {
      "uid": "c_id",
      "deptId": "DeptId",
      "commonFunctionPostId": "functionpostid",
      "regionIds": "regionids",
      "isNeedChangePassword": "isNeedChangePassword",
      "givenname": "Name"
    }
  }
}

./Properties/appsettings.json

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
{
  "ConnectionStrings": [
    {
      "ConnectionName": "DefaultConnection",
        //修改数据库服务器的地址，用户名和密码
      "ConnectionString": "Data Source=10.100.14.150;Initial Catalog=Inroad-Base;Persist Security Info=True;User ID=sa;Password=First_Deploy_GZD_0507;Pooling=true;Max Pool Size=200;Min Pool Size=5;",
      "ProviderName": "System.Data.SqlClient",
      "DatabaseType": "SqlServer" //Database type can be SqlServer\Oracle\OfficialOracle\MySql\PostgreSql
    }
  ],
  "InroadSettings": {
      //修改数据库服务器的地址，用户名和密码
    "ConnectionString": "Data Source=10.100.14.150;Initial Catalog=Inroad-Base;Persist Security Info=True;User ID=sa;Password=First_Deploy_GZD_0507;Pooling=true;Max Pool Size=200;Min Pool Size=5;",
    "ProviderName": "System.Data.SqlClient",
    "DatabaseType": "SqlServer", //Database type can be SqlServer\Oracle\OfficialOracle\MySql\PostgreSql
    "DefaultIdentityUsed": false, //specify if current system is using default identity system
    "FoundationConfigFile": ""
  }
}

数据库修改

select * from CommonConstConfig

把consttitle字段的值为CommonFileServer的所在行的constvalue字段的值改为上传服务的地址，如果公共服务不采取客户内网部署的话，默认应该是https://uploadfilenew.in-road.com/FileUploadHandle.ashx

把consttitle字段的值为”工智道基础”的，都改为”客户名称”

pointer

appsettings.json

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
{
  "Logging": {
    "LogLevel": {
      "Default": "Information",
      "Microsoft": "Warning",
      "Microsoft.Hosting.Lifetime": "Information"
    }
  },
  "AllowedHosts": "*",
    //修改数据库地址，账号和密码
  "ConnectionSql": "Data Source=10.100.14.150;Initial Catalog=Inroad-Base;Persist Security Info=True;User ID=sa;Password=First_Deploy_GZD_0507;Pooling=true;Max Pool Size=200;Min Pool Size=3;MultipleActiveResultSets=true;",
  "Redis": {
    "ConnectionRedis": "122.112.221.122:6379,password=inroad18121225109"
  },
  "Jwt": {
    "JwtOptions": {
      "Audience": "InroadPointer",
      "Issuer": "InroadPointer",
      "AccessTokenExpiration": 30,
      "RefreshTokenExpiration": 60
    },
    "JwtKey": "MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDI2a2EJ7m872v0afyoSDJT2o1+SitIeJSWtLJU8/Wz2m7gStexajkeD+Lka6DSTy8gt9UwfgVQo6uKjVLG5Ex7PiGOODVqAEghBuS7JzIYU5RvI543nNDAPfnJsas96mSA7L/mD7RTE2drj6hf3oZjJpMPZUQI/B1Qjb5H3K3PNwIDAQAB"
  },
  "Global": {
    "IsUseCache": 1,
      //修改为客户代码
    "FactoryCode": "2356"
  }
}

oaa

appsettings.json

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
{
  "Logging": {
    "LogLevel": {
      "Default": "Information"
    }
  },
  "AllowedHosts": "*",
  "ConnectionStrings": {
      //修改数据库地址，账号和密码，下面两项Default和UAA都要修改
    "Default": "Data Source=10.100.14.150;Initial Catalog=Inroad-Base;Persist Security Info=True;User ID=sa;Password=First_Deploy_GZD_0507;Pooling=true;Max Pool Size=200;Min Pool Size=5;", 
    "UAA": "Data Source=10.100.14.150;Initial Catalog=Inroad-Base;Persist Security Info=True;User ID=sa;Password=First_Deploy_GZD_0507;Pooling=true;Max Pool Size=200;Min Pool Size=5;"
  },
  "Sms": {
      //没太理解，好像是双因素认证服务的地址
    "TwoFactorSmsUrl": "http://sms.in-road.com/SMSHandle.ashx"
  }, 
  "ApiVersion": "v2",
  "IdentityServer": {
        //oaa站点的地址
    "Authority": "http://172.88.0.4:82",
    "Scope": "OaaScope",
    "InUse": true,
    "ClaimRelationDic": {
      "uid": "c_id",
      "deptId": "DeptId",
      "commonFunctionPostId": "functionpostid",
      "regionIds": "regionids",
      "isNeedChangePassword": "isNeedChangePassword"
    }
  }
}

SubsidiaryInfo.json

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
{
  "DefaultLogo": "http://files.in-road.com/inroadfiles/nbwh/attachfiles/20180831/6358648602061006666673563.png",   //数据中心登陆logo
  "FileAddress": "https://uploadfilenew.in-road.com/FileUploadHandle.ashx", //上传，数据中心使用站点
  "CurrentSubsidiaryId": "1",
  "InroadAuthInfo": {
    "Md5Key": "jZae727K08KaOmKSgOaGzwwXVqGrPKEgIMkjrcbJI",
    "ExpTick": 20
  }, 
  "SubsidiaryList": [
  
    {
      "SubsidiaryId": "1",
      "Name": "工智道",
      "Logo": "http://files.in-road.com/inroadfiles/nbwh/attachfiles/20180831/6358648602061006666673563.png", //数据中心登陆logo
        //修改为oaa站点地址
      "BaseUrl": "http://172.88.0.4:82",
         //修改为工智道站点地址，非集团用户无需更改
      "InroadUrl": "http://172.88.0.2:85",
      "ClientId": "OaaClient",
      "ClientSecret": "665CAF62CCF42FD945B690DC830DD8"
    }
  ]
}

timejob

appsettings.json

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
{
  "ConnectionStrings": {
      //修改数据库IP地址，用户和密码
    "Default": "Data Source=10.100.14.150;Initial Catalog=Inroad-Base;Persist Security Info=True;User ID=sa;Password=First_Deploy_GZD_0507;Pooling=true;Max Pool Size=200;Min Pool Size=5;"
  },
  "Logging": {
    "LogLevel": {
      "Default": "Information",
      "Microsoft": "Warning",
      "Microsoft.Hosting.Lifetime": "Information"
    }
  },
  "inroad": {
    "IsOpen": "1",
    "useDataBase": "SQLServer",
      //指定为1
    "IsOpenInroadRabbitMq": "1",
    "emailserver": "http://43.247.89.168:81/EmailHandle.ashx",
    "smsserver": "http://sms.in-road.com/SMSHandle.ashx",
    "OpenLinkToken": "4A4B98ED0F66ECC3720543C2AD681624",
    "PrReportCalculation": "http://43.247.90.165/Report/ReportCalculation"
  },
  "BackgroundJobs": {
    "IsOpen": "1",
      //指定为1
    "IsAuto": "1",
      //修改为工智道的地址
    "InroadWebUrl": "http://kycd.in-road.com",
      //修改为timejob的地址
    "HeartBeatUrl": "http://172.88.0.3:5001",
    "OpenLinkToken": "4A4B98ED0F66ECC3720543C2AD681624",
    "SyncCoreDataItem2DataCenterUrl": "http://43.247.90.165:81/Pretreat/ReceivePretreatConfig",
    "PlatFormUrl": "http://localhost:2218"
  },
  "ES": {
      //这个地方应该也需要修改吧
    "IsOpen": "1",
    "ESUrls": "http://10.100.10.17:8200",
    "TenantID": "GZKYCD_2356_production",
    "UserName": "elastic",
    "Password": "Inroad18121225109"
  },
  "RabbitMq": {
      //指定为0
    "IsOpen": "0",
    "HostName": "119.3.49.204",
    "UserName": "inroad",
    "Password": "InroadMq20191107",
    "Port": 5672
  },
  "AllowedHosts": "*",
  "EmailConfig": {
    "Account": "df_notice@in-road.com",
    "PassWord": "Gzd123456",
    "EmailServer": "smtp.exmail.qq.com",
    "ServerPort": "25",
    "UseSSL": "1"
  }
}

lowcode

appsettings.json

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
{
  "Z.Expressions.Eval": {
    "LicenseName": "4061;500-sagena.hr",
    "LicenseKey": "08X8X386-X0X2-7X8X-4EXX-23XXC2XXB6XX"
  },
  "App": {
    "CorsOrigins": "https://*.FormEngine.com,http://localhost:4200,http://localhost:44307,https://localhost:44307"
  },
  "ConnectionStrings": {
      //积木的数据库连接
    "FormEngine": "Data Source=10.100.14.150;Initial Catalog=InroadLowCode2-Base;Persist Security Info=True;User ID=sa;Password=First_Deploy_GZD_0507;Pooling=true;Max Pool Size=200;Min Pool Size=5;",
      //工智道的数据库连接
    "Common": "Data Source=10.100.14.150;Initial Catalog=Inroad-Base;Persist Security Info=True;User ID=sa;Password=First_Deploy_GZD_0507;Pooling=true;Max Pool Size=200;Min Pool Size=5;"
  },
  "Redis": {
    "Configuration": "127.0.0.1"
  },
  "AuthServer": {
      //oaa地址
    "Authority": "http://172.88.0.4:82/",
    "RequireHttpsMetadata": "false",
    "SwaggerClientId": "FormEngine_Swagger",
    "SwaggerClientSecret": "1q2w3e*"
  },
  "RemoteServices": {//远程服务
  	"Todo": {
  		"BaseUrl": "http://172.88.0.8:88" //待办服务的远程地址
  	}
  },  
  "Settings": {
    "MemoryCacheSlidingExpiration": 86400,
    "Abp.Localization.DefaultLanguage": "zh-CN",
      //工智道的地址，好像是域名吧
    "InroadDomain": "kycd.in-road.com",
    "EmailNotify": false,
    "JGPushNotify": false,
    "JGPushIOSIsProduction": true,
      //修改为nginx地址或者客户域名
    "RecordLink": "kycd.in-road.com/low-code-platform/list-view-record?modelId={0}&recordId={1}&name={2}&viewType=FlowView",
    "InroadDomainRecordLink": "kycd.in-road.com/vweb/#/low-code-platform/list-view-record?modelId={0}&recordId={1}&viewType=FlowView",
    "Abp.Mailing.Smtp.Host": "smtp.exmail.qq.com",
    "Abp.Mailing.Smtp.Port": "25",
    "Abp.Mailing.Smtp.UserName": "df_notice@in-road.com",
    "Abp.Mailing.Smtp.Password": "YuYXTjKUTYbR+4Cs0FquCw==",
    "Abp.Mailing.Smtp.Domain": "",
    "Abp.Mailing.Smtp.EnableSsl": "true",
    "Abp.Mailing.Smtp.UseDefaultCredentials": "false",
    "Abp.Mailing.DefaultFromAddress": "df_notice@in-road.com",
    "Abp.Mailing.DefaultFromDisplayName": "Inroad",
    "EmailServiceUrl":"https://mailserver.in-road.com",
    "EmailServiceApiKey":"3979189c96de598a7c2e10433bb1885a",	
    "JiGuang": {
      "AppKey": "90eb727b6de30bb58e76ef21",
      "MasterSecret": "46d039d1f5920db61478028f"
    },
	"StreamingPlatformConfig": {
		"Url": "http://103.229.212.44:9000",
		"SecretKey": "KJmCTKIS2En+Ly0vBSBy20Bc2XSkPsK4X/IszHpGJ0xhyze2ErLqokbUqmPk/r9RmzbuPcLl7UBtFRLI6cGkj+T2IQVRY4MKRHh7phr878jEvBZgxJgwkhMNNaRGE5PoTZm82/zqRvaUOH5obGqYbmTZkfHR68lqfxxiIW+/XWI=",
		"Codes": ["LowCode"]
	},	
    "ResourceUpload": {
        //客户上传服务接口，对应修改为nginx地址或者域名
        "Url": "kycd.in-road.com/lowcode/prod-upload",
        "Calltoken": "3979189c96de598a7c2e10433bb1885a",
        //客户代码
        "Customercode": "2356",
        "Action": "uploadfile"
    }	
  }
}

nginx

nginx.conf

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
user  root;
worker_processes  2;
#error_log  logs/error.log;
#error_log  logs/error.log  notice;
#error_log  logs/error.log  info;
#pid        logs/nginx.pid;
events {
    worker_connections  1024;
}
http {
    include       mime.types;
    default_type  application/octet-stream;
    log_format  main  '$remote_addr - $remote_user [$time_local] "$request" '
                      '$status $body_bytes_sent "$http_referer" '
                      '"$http_user_agent" "$http_x_forwarded_for" '
                      '"$upstream_addr" "$upstream_status" "$upstream_response_time" "$request_time"';
    access_log  /var/log/nginx/access.log  main;	
    client_max_body_size 500M;
	client_body_timeout 600s;
	underscores_in_headers on;
    sendfile        on;
    keepalive_timeout  120;	
    proxy_connect_timeout 600;
    proxy_send_timeout 600;
    proxy_read_timeout 600;	
	gzip  on;
	gzip_min_length 1k;	#设置允许压缩的页面最小字节数，建议设置成大于1k的字节数，小于1k可能会越压越大
	gzip_buffers 4 32k; #设置系统获取几个单位的缓存用于存储gzip的压缩结果数据流，比如4 32K表示申请了4块内存，每块32K。
	gzip_comp_level 6; #压缩比，1~9，数值越大压缩比例越高，压缩比例越高越消耗CPU
	# 对哪些类型的文件压缩， 默认text/html, 还可以指定对js，css,txt,xml,json等类型文件压缩
	gzip_types text/plain text/css application/javascript application/xml application/json image/png;	
	gzip_vary on; # 是否显示gzip压缩标志
	gzip_static on; #静态压缩
	gzip_http_version 1.0; #压缩支持http1.0协议
    # Oaa 集团版 工智道
    server {
        listen       80; # nginx监听的端口1
        location /oaa/ {
            rewrite ^/oaa/(.*) /$1 break;
            proxy_pass  http://172.88.0.4:82/oaa;
        }
		
		# 工智道系统
        location / {
            root   /usr/local/inroad/wwwroot/;
            index  index.html index.htm;
			absolute_redirect off; # 注意，可能有坑
            if ( $request_uri = "/" ) {
                return 302  /vweb/;
            }
        }

        #低代码平台
        location /low-code-platform{
            absolute_redirect off;
            add_header Cache-Control no-cache;
            add_header Access-Control-Allow-Origin *;
            add_header Access-Control-Allow-Methods 'GET, POST, OPTIONS';
            add_header Access-Control-Allow-Headers 'DNT,X-Mx-ReqToken,Keep-Alive,User-Agent,X-Requested-With,If-Modified-Since,Cache-Control,Content-Type,Authorization';

            if ($request_method = 'OPTIONS') {
                return 204;
            }
            root   /usr/local/inroad/wwwroot/;
            try_files $uri $uri/ /low-code-platform/index.html; # vue路由模式为history        
        }

	
		location ~ .*\.(js|css|ico|jpg|png|ttf|woff|woff2)$ {
             root   /usr/local/inroad/wwwroot/;
             index  index.html;
        }

        # 代理工智道接口
		location ~^/(UAPI|uapi|API|api|www|Web|web) {
			proxy_pass http://172.88.0.2:85;
			
		}
		
        location /low-code-platform/API {
			proxy_pass http://172.88.0.2:85/API;
        }		
		
        location /low-code-platform/UAPI {
			proxy_pass http://172.88.0.2:85/UAPI;
        }		

		location /vweb/API {
			proxy_pass http://172.88.0.2:85/API;
		}
		
		location /vweb/UAPI {
			proxy_pass http://172.88.0.2:85/UAPI;
		}
		
        location /lowcode/api {
			proxy_pass http://172.88.0.7:8088/api;
        }	

        location /lowcode/v2 {
            proxy_pass http://172.88.0.7:8088/api/inroad/formEngine;
        }		

        location /lowcode-platform {
			proxy_pass http://172.88.0.7:8088/api;
        }

		location /lowcode/prod-upload {
            proxy_pass  https://uploadfilenew.in-road.com/FileUploadHandle.ashx;
        }
		
		location /prod-upload {
            proxy_pass  https://uploadfilenew.in-road.com/FileUploadHandle.ashx;
        }
		
        location /prod-api-login {
            rewrite ^/prod-api-login/(.*) /$1 break;
            proxy_pass   http://172.88.0.4:82;
        }
		
        location /todo/api {
            proxy_pass http://172.88.0.8:88/api/app;
        }		
    }
		
    # 工智道https
    server {
        listen       443 ssl; # nginx监听的端口2
		
		ssl_certificate      cert/1_in-road.com_bundle.crt;
		ssl_certificate_key  cert/2_in-road.com.key;
		
		ssl_session_cache    shared:SSL:1m;
		ssl_session_timeout  5m;
		
		ssl_ciphers  HIGH:!aNULL:!MD5;
		ssl_prefer_server_ciphers  on;		

        location /oaa/ {
            rewrite ^/oaa/(.*) /$1 break;
            proxy_pass  http://172.88.0.4:82/oaa;
        }
		
		# 工智道系统
        location / {
            root   /usr/local/inroad/wwwroot/;
            index  index.html index.htm;
			absolute_redirect off;
            #默认重定向
            if ( $request_uri = "/" ) {
                return 302 /vweb/;
            }
        }

        #低代码平台
        location /low-code-platform{
            #absolute_redirect off;
            add_header Cache-Control no-cache;
            add_header Access-Control-Allow-Origin *;
            add_header Access-Control-Allow-Methods 'GET, POST, OPTIONS';
            add_header Access-Control-Allow-Headers 'DNT,X-Mx-ReqToken,Keep-Alive,User-Agent,X-Requested-With,If-Modified-Since,Cache-Control,Content-Type,Authorization';

            if ($request_method = 'OPTIONS') {
                return 204;
            }
            root   /usr/local/inroad/wwwroot/;
            try_files $uri $uri/ /low-code-platform/index.html; # vue路由模式为history        
        }

	
		location ~ .*\.(js|css|ico|jpg|png|ttf|woff|woff2)$ {
             root   /usr/local/inroad/wwwroot/;
             index  index.html;
        }

        # 代理工智道接口
		location ~^/(UAPI|uapi|API|api|www|Web|web) {
			proxy_pass http://172.88.0.2:85;
			
		}
		
        location /low-code-platform/API {
			proxy_pass http://172.88.0.2:85/API;
        }		
		
        location /low-code-platform/UAPI {
			proxy_pass http://172.88.0.2:85/UAPI;
        }		

		location /vweb/API {
			proxy_pass http://172.88.0.2:85/API;
		}
		
		location /vweb/UAPI {
			proxy_pass http://172.88.0.2:85/UAPI;
		}
		
        location /lowcode/api {
			proxy_pass http://172.88.0.7:8088/api;
        }	

        location /lowcode/v2 {
            proxy_pass http://172.88.0.7:8088/api/inroad/formEngine;
        }		

        location /lowcode-platform {
			proxy_pass http://172.88.0.7:8088/api;
        }

		location /lowcode/prod-upload {
            # 上传服务的地址
            proxy_pass  https://uploadfilenew.in-road.com/FileUploadHandle.ashx;
        }
		
		location /prod-upload {
            # 上传服务的地址
            proxy_pass  https://uploadfilenew.in-road.com/FileUploadHandle.ashx;
        }		
		
        location /prod-api-login {
            rewrite ^/prod-api-login/(.*) /$1 break;
            proxy_pass   http://172.88.0.4:82;
        }	
		
        location /todo/api {
            proxy_pass http://172.88.0.8:88/api/app;
        }		
    }
}

todo

有点麻烦，涉及到数据库，最后再说

appsettings.json

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
{
  "App": {
    "CorsOrigins": "https://*.TodoService.com"
  },
  "ConnectionStrings": {
      //修改
    "TodoService": "Server=10.100.14.150;Database=InroadTodoService_GZKYCD;User Id=sa;Password=First_Deploy_GZD_0507;"
  },
  "Redis": {
    "Configuration": "127.0.0.1"
  },
  "AuthServer": {
      //oaa地址
    "Authority": "http://172.88.0.4:82",
    "RequireHttpsMetadata": "false",
    "SwaggerClientId": "TodoService_Swagger"
  },
  "StringEncryption": {
    "DefaultPassPhrase": "w7pdVMj0twGVeaOi"
  }
}
2024-05-07 该篇文章被 邓胖胖 打上标签: 操作流程 归为分类: 工作笔记