Date

2022-11-01

Applicant

lizz

Risk Level

1-Low

Business Sponsor

R&D

Start Time

2022-11-01 14:30

Expected Time

1 hour

Business description

• 1. custom domain project controlpanelpage release.
• 2. Migration tools release
• 3. Migrate test site from livehelp100 to private

Functionality testing description (code changes required)

Has functionality testing been performed to this change? Yes

Do the testing items include but not limited to certain vulnerabilities, such as Injection flaws, Buffer overflows, Insecure cryptographic storage, Insecure communications, Improper error handling, Cross-site scripting, Improper access control, Cross-site request forgery, Broken authentication and session management, etc.? No need

Were evidences of security scan/testing provided? No need

Data removal and migration applications description

Have made the expired data/accounts removal and data migration applications up-to-date?

• No need

List all the new non-recycling applications

None

Detailed implementation process

• 1.   Release application controlpanelpage on comm100 & livehelp100
• comm100-release --action update --platform all-platform --applications controlpanelpage --image 289075008031.dkr.ecr.ap-northeast-1.amazonaws.com/x2/controlpanelpage/master:2022-11-01-02-48-1d0d8979-release
• 
  
• 2. Migrate the test account
• Migration process: livehelp_privateMigrationPorcess.docx
• · Register new site database.

Select * from [private1.general].[system].[t_Global_SiteDatabase]

UPDATE [private1.General].[system].[T_Global_SiteDatabase] SET [SiteAmount]= 500

• · Exe script on private1.general. create migration sites. 5000377,5000378, 5000379

DBCC CHECKIDENT('[site].[T_Global_Site]',RESEED, 5000376)

• Register 3 sites on private1 ---lizz
• · Exe script on private1.general. create 4 testing sites on new sitedatabase.

DBCC CHECKIDENT('[site].[T_Global_Site]',RESEED,65000475)

Register 4 sites on private1 ---lizz (65000476, 65000477, 65000478, 65000479)

Exe script on private1.general. Restore the site seed. The reserved sites.

DBCC CHECKIDENT('[site].[T_Global_Site]',RESEED, 10201000)

Register 10 sites on private1 ---lizz (10201001, 10201002, 10201003,10201004, 10201005..)

• · Exe script on private1.general. Register new site database 800002.
• Site800000 to Letou ; Site800001 to 5000379

UPDATE [private1.General].[system].[T_Global_SiteDatabase] SET [SiteAmount]= 500

• Select * from [private1.general].[system].[t_Global_SiteDatabase]
• Register 1 site on private1 ---lizz (10201011)
• · Use the migration tools to migrate the test sites 65000476, 65000477, 65000478, 65000479
• Change the appsettings.json to online config.
• Click ‘创建迁移数据表’
  Click ‘清空目标表数据’
• Click ‘开始第一次迁移’
• Exe script on private1.general with 65000476_livechat_update_test.sql
• When all the data has consumed done.
• Click ‘开始第二次迁移’
• Exe script on private1.general with 65000476_livechat_update_test.sql
• · Exe script on private.general, change the partnerid
• update [site].[T_Global_Site] set [PartnerId] = 800001 where Id in(65000476,65000477,65000478,65000479)
• · Export the [private.general].t_sitemigration_table65000476 ,65000477,65000478, 65000479 to tester
• · Check the migration result. ---lizz
• [5664FFF7BBBD4977BD62394F34999553.png]
• 
  
• · Create AWS ACM to them.

Base domain: livesupportbs.com, live24chat7.com

• vue.livesupportbs.com CNAME vue1proxy.livehelp100private.com
• route.livesupportbs.com CNAME router1proxy.livehelp100private.com
• dash.livesupportbs.com CNAME app1proxy.livehelp100private.com
• api.livesupportbs.com CNAME api1proxy.livehelp100private.com
• chatserver.livesupportbs.com CNAME chatserver1proxy.livehelp100private.com
• file.livesupportbs.com CNAME file1proxy.livehelp100private.com
• apiv.livesupportbs.com CNAME api1proxy-v.livehelp100private.com
• filev.livesupportbs.com CNAME file1proxy-v.livehelp100private.com
• chatserverv.livesupportbs.com CNAME chatserver1proxy-v.livehelp100private.com

• vue.live24chat7.com CNAME vue1proxy.livehelp100private.com
• 
  

No bad impact

Implementer

Summer/Elei/Gabe

Rollback steps

Restore the backup apps to the website