Docker7530
134 lines
5.6 KiB
Markdown
134 lines
5.6 KiB
Markdown
---
|
||
日期: 2025-05-28 11:25
|
||
来源:
|
||
---
|
||
|
||
# 问题详情
|
||
|
||
# 处理过程
|
||
|
||
```
|
||
|
||
|
||
PUSHDOMAIN
|
||
(0, "推流域名", "push")
|
||
,
|
||
PULLDOMAIN(1, "播流域名", "pull");
|
||
|
||
|
||
select *
|
||
from live_stream_domain_config
|
||
where domain in (
|
||
'pull.lychexe.com', 'pull.jycshi.com', 'hsdyorg.douyucdn2.cn'
|
||
);
|
||
|
||
|
||
select *
|
||
from live_stream_domain_config
|
||
where domain in (
|
||
'pull.lychexe.com', 'pull.jycshi.com', 'hsdyorg.douyucdn2.cn'
|
||
);
|
||
|
||
给我更新这三个域名的sql: state 均为 4
|
||
pull.lychexe.com 的 c_name pull.lychexe.com.c.cdnhwc3.com
|
||
pull.jycshi.com 的 c_name pull.jycshi.com.c.cdnhwc3.com
|
||
hsdyorg.douyucdn2.cn 的 c_name hsdyorg.douyucdn2.cn.cdnhwczba04.com
|
||
|
||
|
||
给我更新这三个域名的sql:
|
||
pull.lychexe.com 的 live_stream_type 为 0 type 为 1 has_processed 为 1 configuration 为 1
|
||
pull.jycshi.com 的 live_stream_type 为 0 type 为 1 has_processed 为 1 configuration 为 1
|
||
hsdyorg.douyucdn2.cn 的 live_stream_type 为 1 type 为 1 has_processed 为 1 configuration 为 1
|
||
|
||
1790,hsdyorg.douyucdn2.cn
|
||
1815,pull.jycshi.com
|
||
1816,pull.lychexe.com
|
||
|
||
select *
|
||
from live_stream_domain_config_plain_info
|
||
where live_stream_domain_config_id in (1790, 1815, 1816);
|
||
|
||
|
||
pull.lychexe.com，推流，定制化域名，适配平面：华为平面，cname：pull.lychexe.com.c.cdnhwc3.com
|
||
|
||
pull.jycshi.com，推流，定制化域名，适配平面：华为平面，cname：pull.jycshi.com.c.cdnhwc3.com
|
||
|
||
hsdyorg.douyucdn2.cn，拉流，定制化域名，适配平面：华为平面，cname：hsdyorg.douyucdn2.cn.cdnhwczba04.com
|
||
|
||
live_stream_domain_config:liveStreamType、type
|
||
live_stream_plain_info：cname（plain：新）state
|
||
live_app_name
|
||
|
||
self_service_domain_config:state、cName、domainPlain
|
||
|
||
|
||
|
||
has_processed、configuration
|
||
|
||
|
||
-- -------------------
|
||
|
||
UPDATE live_stream_domain_config SET live_stream_type = 0, type = 1, has_processed = 1, configuration = 1 WHERE domain = 'pull.lychexe.com';
|
||
|
||
UPDATE live_stream_domain_config SET live_stream_type = 0, type = 1, has_processed = 1, configuration = 1 WHERE domain = 'pull.jycshi.com';
|
||
|
||
UPDATE live_stream_domain_config SET live_stream_type = 1, type = 1, has_processed = 1, configuration = 1 WHERE domain = 'hsdyorg.douyucdn2.cn';
|
||
|
||
UPDATE self_service_domain_config SET state = 4, c_name = 'pull.lychexe.com.c.cdnhwc3.com' WHERE domain = 'pull.lychexe.com';
|
||
|
||
UPDATE self_service_domain_config SET state = 4, c_name = 'pull.jycshi.com.c.cdnhwc3.com' WHERE domain = 'pull.jycshi.com';
|
||
|
||
UPDATE self_service_domain_config SET state = 4, c_name = 'hsdyorg.douyucdn2.cn.cdnhwczba04.com' WHERE domain = 'hsdyorg.douyucdn2.cn';
|
||
|
||
-- -------------------
|
||
|
||
INSERT INTO live_app_name (created_time, deleted, updated_time, app_name, code , code_flag, delay_flag, delay_time, high_low_code, template_code_ids , live_stream_plain_id) VALUES (NOW(), 0, NULL, 'live', NULL , NULL, NULL, NULL, NULL, 'null' , 1001);
|
||
|
||
INSERT INTO live_app_name (created_time, deleted, updated_time, app_name, code , code_flag, delay_flag, delay_time, high_low_code, template_code_ids , live_stream_plain_id) VALUES (NOW(), 0, NULL, 'live', NULL , NULL, NULL, NULL, NULL, 'null' , 1001);
|
||
|
||
INSERT INTO live_app_name (created_time, deleted, updated_time, app_name, code , code_flag, delay_flag, delay_time, high_low_code, template_code_ids , live_stream_plain_id) VALUES (NOW(), 0, NULL, 'live', NULL , NULL, NULL, NULL, NULL, 'null' , 1001);
|
||
|
||
INSERT INTO live_stream_plain_info (created_time, deleted, cname, plain, state) VALUES (NOW(), 0, 'pull.lychexe.com.c.cdnhwc3.com', 1, 4);
|
||
|
||
INSERT INTO live_stream_plain_info (created_time, deleted, cname, plain, state) VALUES (NOW(), 0, 'pull.jycshi.com.c.cdnhwc3.com', 1, 4);
|
||
|
||
INSERT INTO live_stream_plain_info (created_time, deleted, cname, plain, state) VALUES (NOW(), 0, 'hsdyorg.douyucdn2.cn.cdnhwczba04.com', 1, 4);
|
||
|
||
INSERT INTO live_stream_domain_config_plain_info (live_stream_domain_config_id, live_stream_plain_info_id) VALUES (1790,);
|
||
|
||
INSERT INTO live_stream_domain_config_plain_info (live_stream_domain_config_id, live_stream_plain_info_id) VALUES (1815,);
|
||
|
||
INSERT INTO live_stream_domain_config_plain_info (live_stream_domain_config_id, live_stream_plain_info_id) VALUES (1816,);
|
||
|
||
|
||
---
|
||
|
||
live_stream_domain_config type live_stream_type
|
||
|
||
self_service_domain_config state
|
||
|
||
|
||
UPDATE live_stream_domain_config SET live_stream_type = null, type = null WHERE domain = 'pull.lychexe.com' and live_stream_type = 0 and type = 0;
|
||
|
||
UPDATE live_stream_domain_config SET live_stream_type = null, type = null WHERE domain = 'pull.jycshi.com' and live_stream_type = 0 and type = 0;
|
||
|
||
UPDATE live_stream_domain_config SET live_stream_type = null, type = null WHERE domain = 'hsdyorg.douyucdn2.cn' and live_stream_type = 0 and type = 0;
|
||
|
||
UPDATE self_service_domain_config SET state = null, c_name = null, domain_plain = null WHERE domain = 'pull.lychexe.com' and state = 5 and c_name = 'cdnn' and domain_plain = '[1]';
|
||
|
||
UPDATE self_service_domain_config SET state = null, c_name = null, domain_plain = null WHERE domain = 'pull.jycshi.com' and state = 5 and c_name = 'cdnn' and domain_plain = '[1]';
|
||
|
||
UPDATE self_service_domain_config SET state = null, c_name = null, domain_plain = null WHERE domain = 'hsdyorg.douyucdn2.cn' and state = 5 and c_name = 'cdnn' and domain_plain = '[1]';
|
||
|
||
|
||
select state,c_name,domain_plain
|
||
from self_service_domain_config
|
||
where domain in (
|
||
'pull.lychexe.com', 'pull.jycshi.com', 'hsdyorg.douyucdn2.cn'
|
||
);
|
||
```
|
||
|
||
# 总结
|
||
|
||
清空配置，从新下发。
|