DDWiki/运维/安装/2020淮安替换模块.md

1700C替换成242FC

• 寻找新模块： ifconfig sudo arp-scan -I enp3s0 --localnet
• 修改模块的新的服务器指向 root abc123 mandun_url 192.168.8.1:8080/ebx-bishop/data/carry
• 查看242FC是否已经到达服务器
• 删除局域网旧模块 ``` 查找模块的所有开关： select * from KaiGuan where Mac=‘187ED531700C’

记录开关编号： 97，98，99，100，101

记录开关位置： select * from DianXiang where Id=7 6层西箱

确认并删除SceneItem select * from SceneItem where KaiGuanId in (‘97’,‘98’,‘99’,‘100’,‘101’) delete from SceneItem where KaiGuanId in (‘97’,‘98’,‘99’,‘100’,‘101’)

确认并删除SceneDetails select * from sceneDetails where mac=‘187ed531700c’ delete from sceneDetails where mac=‘187ed531700c’

确认并删除warningHistories select * from warningHistories where KaiGuanId in (‘97’,‘98’,‘99’,‘100’,‘101’) delete from warningHistories where KaiGuanId in (‘97’,‘98’,‘99’,‘100’,‘101’)

确认并删除kaiguanwarning select * from KaiGuanWarning where KaiGuanId in (‘97’,‘98’,‘99’,‘100’,‘101’) delete from KaiGuanWarning where KaiGuanId in (‘97’,‘98’,‘99’,‘100’,‘101’)

删除开关： delete from KaiGuan where Mac=‘187ed531700c’

删除缓存中的该模块： 界面中删除模块：13800000000 TecheFwd2018 TaiHe187ED531700C,macss TaiHeQuYuKSH187ED531700C

- 删除云端旧模块

查看和删除 select * from realtimedatas where mac=‘187ED531700C’ select * from warninghistories where mac=‘187ED531700C’ select * from realwarnings where mac=‘187ED531700C’ select * from notis where KaiGuanId in (‘65’,‘66’,‘67’,‘68’,‘69’) delete from realtimedatas where mac=‘187ED531700C’ delete from warninghistories where mac=‘187ED531700C’ delete from realwarnings where mac=‘187ED531700C’ delete from notis where KaiGuanId in (‘65’,‘66’,‘67’,‘68’,‘69’)

- 添加局域网新模块和开关

选择电箱：6层西箱 242FC 查看是否有区域可视化缓存，如果有并且为空就删除 来到可视化界面查看

- 添加时序确认查询局域网时序数据库

192.168.18.54 dingding teche123 187ED53242FC use rlq_huaian_7_10; 确认电量 describe dl_187ed53242fc_0_m; describe dl_187ed53242fc_5_m; describe dl_187ed53242fc_0_h; describe dl_187ed53242fc_5_h; describe dl_187ed53242fc_0_d; describe dl_187ed53242fc_5_d; select * from dl_187ed53242fc_0_m;没有数据 select * from dl_187ed53242fc_0_h; select * from dl_187ed53242fc_1_h; 确认实时 describe real_187ed53242fc; select * from real_187ed53242fc; 确认统计 describe tj_187ed53242fc_m; describe tj_187ed53242fc_h; describe tj_187ed53242fc_d; select * from tj_187ed53242fc_m; 有

-- 确认局域网关系数据库是否有数据

select * from devicedls where mac=‘187ED53242FC’

- 添加时序确认查询云端时序数据库

187ED53242FC 47.102.145.164 root Teche7208 taos show databases; use rlq_huaian_7_10; 确认统计 describe tj_187ed53242fc_m; describe tj_187ed53242fc_h; describe tj_187ed53242fc_d; 确认实时 describe real_187ed53242fc; ```