notes/work/移动杭研/问题处理/2025-05/0528-移动云域名配置修正.md

日期, 来源

日期	来源
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'  
    );

总结

清空配置，从新下发。