从 Control Room 注销 IQ Bot
- Updated: 2022/11/08
从 Control Room 注销 IQ Bot
如果 IQ Bot URL 因 IQ Bot 的安装或卸载而更改,或者添加了负载均衡器,则必须从 Control Room 注销 IQ Bot。
过程
- 使用 sysadmin 角色,在不同的数据库中运行两个单独的 SQL 查询。
-
运行 Control Room 数据库中的第一组 SQL 语句以删除以下数据:
对版本 A2019.10 至 A2019.13 运行以下 SQL 语句:
DELETE FROM [AAE-Database].[dbo].[ACTIVEMQ_ACKS]
DELETE FROM [AAE-Database].[dbo].[ACTIVEMQ_MSGS]
DELETE FROM [AAE-Database].[dbo].[SERVICE_USER]
DELETE FROM [AAE-Database].[dbo].[USERS] where user_type='APP'
对版本 A2019.14 和更高版本运行以下 SQL 语句:- 运行以下查询:
USE [AAE-Database] SELECT T.uuid As TenantID,T.name AS TenantName,T.created_by,T.enabled,U.id AS IQBotAppUserId,U.user_type,S.url AS IQBotURL FROM [dbo].[TENANTS] T LEFT JOIN [dbo].[USERS] U ON T.uuid = U.tenant_uuid LEFT JOIN [dbo].[SERVICE_USER] S ON U.id = S.id WHERE (U.user_type='APP' AND S.type='IQBOT')
- 上述查询将为您提供一个‘IQBotAppUserId’编号。 替换 id = 'IQBotAppUserId'。
- 执行以下删除查询:
DELETE FROM [AAE-Database].[dbo].[SERVICE_USER] WHERE [type]='IQBOT'
-
DELETE FROM [AAE-Database].[dbo].[USERS] WHERE id = 'IQBotAppUserId'
- 运行以下查询:
-
在 IQ Bot 配置数据库中运行第二组 SQL 语句以删除以下数据:
-
DELETE FROM [IQBot].[dbo].[Configurations] where [key]='controlRoomVersion'
-
DELETE FROM [IQBot].[dbo].[Configurations] where [key]='appRegistered'
-
DELETE FROM [IQBot].[dbo].[Configurations] where [key]='controlRoomUrl'
-
DELETE FROM [IQBot].[dbo].[Configurations] where [key]='appId'
您已成功注销。 -