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;
```