用户工具

站点工具


18530927615

差别

这里会显示出您选择的修订版和当前版本之间的差别。

到此差别页面的链接

两侧同时换到之前的修订记录 前一修订版
后一修订版
前一修订版
18530927615 [2022/06/10 16:31]
amos
18530927615 [2022/06/16 15:57] (当前版本)
amos
行 1: 行 1:
 <sxh bash> <sxh bash>
-update oneapm_host_info set sys_guid="default"; +INSERT INTO  `oneapm_ctnr_cfg_info` (`BelongXiaQuCode`, `OperateUserName`, `OperateDate`, `Row_ID`, `YearFlag`, `RowGuid`, `content`, `vars`, `description`, `visible_name`, `sys_guid`, `content_sha`, `type`, `binary_content`) 
- +SELECT  `BelongXiaQuCode`, `OperateUserName`, `OperateDate`, `Row_ID`, `YearFlag`, UUID() AS RowGuid, `content`, `vars`, `description`, CONCAT('test-',visible_nameAS visible_name, `sys_guid`, `content_sha`, `type`, `binary_content`  FROM oneapm_ctnr_cfg_info WHERE visible_name not REGEXP "^test-";
-update epointoneapm.frame_user set password='{SM3#:null:null}AB9639BC1EC5281C6161578159719C726C766FE461A5E5C5A20299CAA5489567' where  loginid like 'admin'; +
- +
- +
-INSERT INTO `frame_userVALUES ('63952ad1-995c-4c10-8dbe-a1e7d40ffb7e','manager','{SM3#:null:null}AB9639BC1EC5281C6161578159719C726C766FE461A5E5C5A20299CAA5489567','9579bbf9-31d0-4548-b78f-ea4392bf68f9','manager',1,'','',0,'','13922222222','','','','',NULL,'男',NULL,NULL,NULL,'','','','','','','2021-10-13 15:38:40',NULL,0,NULL,NULL,NULL),('93b3923b-b504-4b4e-a78c-7f5726804798','operator','{SM3#:null:null}AB9639BC1EC5281C6161578159719C726C766FE461A5E5C5A20299CAA5489567','9579bbf9-31d0-4548-b78f-ea4392bf68f9','operator',1,'','',0,'','13911111111','','','','',NULL,'男',NULL,'2021-10-13 15:39:02',NULL,'','','','','zh_CN','','2021-10-13 11:27:53',NULL,0,NULL,NULL,NULL); +
- +
- +
- +
- +
-# 各1条 +
-INSERT INTO `frame_user_extendinfoVALUES (0,'63952ad1-995c-4c10-8dbe-a1e7d40ffb7e','',NULL,'',NULL,NULL,NULL,'','','',0,'','',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL),(0,'93b3923b-b504-4b4e-a78c-7f5726804798','',NULL,'',NULL,NULL,NULL,'','','',0,'','',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL); +
- +
- +
-# 各1条 +
- +
- +
-INSERT INTO `frame_userconfigVALUES ('0ec30b95-08b6-4321-b6d4-632bffef25a6','93b3923b-b504-4b4e-a78c-7f5726804798','PublicShowMobile','0',NULL,'2021-10-13 11:27:53'),('49c6f371-bd6b-47f9-99de-810b18bc6dc5','63952ad1-995c-4c10-8dbe-a1e7d40ffb7e','PublicShowMobile','0',NULL,'2021-10-13 15:38:40'); +
- +
- +
-# 各4条 +
-INSERT INTO `frame_userrolerelationVALUES ('0424432c-c873-4672-b6cb-bddb1930114d',NULL,'93b3923b-b504-4b4e-a78c-7f5726804798','9ea2c145-2e09-40f3-810d-819121dbb143','2021-10-13 15:39:02',NULL,NULL),('0ff975ae-6d91-4a9f-ad07-03695b969e80',NULL,'93b3923b-b504-4b4e-a78c-7f5726804798','b1eb8b98-746a-410d-ac8d-15a8112f20cc','2021-10-13 15:39:02',NULL,NULL),('497828d0-08a5-4bd2-a790-6e9c6aa1fa39',NULL,'93b3923b-b504-4b4e-a78c-7f5726804798','2d784a07-e7c8-4d7f-bcc4-05ccbfc29d58','2021-10-13 15:39:02',NULL,NULL),('900a767c-0aa9-44d3-a7fc-a2f06d1bce7f',NULL,'63952ad1-995c-4c10-8dbe-a1e7d40ffb7e','b1eb8b98-746a-410d-ac8d-15a8112f20cc','2021-10-13 15:38:40',NULL,NULL),('cd65591e-6007-4340-8cd6-8a45140abf61',NULL,'63952ad1-995c-4c10-8dbe-a1e7d40ffb7e','9ea2c145-2e09-40f3-810d-819121dbb143','2021-10-13 15:38:40',NULL,NULL),('da40533f-fcec-4f04-b581-c8578adf3106',NULL,'93b3923b-b504-4b4e-a78c-7f5726804798','d379183b-29d1-4856-804b-9de68d65d398','2021-10-13 15:39:02',NULL,NULL),('f3873598-565d-4006-b101-6361ba7073cf',NULL,'63952ad1-995c-4c10-8dbe-a1e7d40ffb7e','2d784a07-e7c8-4d7f-bcc4-05ccbfc29d58','2021-10-13 15:38:40',NULL,NULL),('fd7ba700-607b-47e1-a054-668c15617c89',NULL,'63952ad1-995c-4c10-8dbe-a1e7d40ffb7e','d379183b-29d1-4856-804b-9de68d65d398','2021-10-13 15:38:40',NULL,NULL); +
- +
- +
- +
-### config +
- +
-INSERT INTO `epointoneapm`.`oneapm_configfile_ctnrpath`(`rowguid`, `ctnr_path`, `type`, `path_desc`, `isusedtotomcat`) VALUES ('fc8d4045-573d-11e8-9b7f-0050569012c1''/usr/local/tomcat/conf/catalina.properties', 'tomcat', 'catalina.properties', 1); +
-INSERT INTO `epointoneapm`.`oneapm_configfile_ctnrpath`(`rowguid`, `ctnr_path`, `type`, `path_desc`, `isusedtotomcat`) VALUES ('fc8d4055-573d-11e8-9b7f-0050569012c1', '/usr/local/tomcat/bin/wrapper.conf', 'tomcat', 'wrapper.conf', 1); +
-INSERT INTO `epointoneapm`.`oneapm_configfile_ctnrpath`(`rowguid`, `ctnr_path`, `type`, `path_desc`, `isusedtotomcat`) VALUES ('fc8d4046-573d-11e8-9b7f-0050569012c1', '/usr/local/nginx/conf/nginx.conf', 'nginx', 'nginx.conf', NULL); +
-INSERT INTO `epointoneapm`.`oneapm_configfile_ctnrpath`(`rowguid`, `ctnr_path`, `type`, `path_desc`, `isusedtotomcat`) VALUES ('fc8d4047-573d-11e8-9b7f-0050569012c1''/usr/local/nginx/conf/nginx_vhost.conf', 'nginx', 'vhost.conf', NULL); +
-INSERT INTO `epointoneapm`.`oneapm_configfile_ctnrpath`(`rowguid`, `ctnr_path`, `type`, `path_desc`, `isusedtotomcat`VALUES ('fc8d4048-573d-11e8-9b7f-0050569012c1''/usr/local/nginx/html/index.html', 'nginx', 'index.html', NULL); +
- +
- +
-INSERT INTO `epointoneapm`.`oneapm_configfile_ctnrpath`(`rowguid`, `ctnr_path`, `type`, `path_desc`, `isusedtotomcat`) VALUES ('fc8d4048-573d-11e8-9b7f-0050569012c2', '/usr/local/nginx/conf/nginx.ssl.pem.crt', 'nginx', 'nginx.ssl.pem.crt', NULL)+
-INSERT INTO `epointoneapm`.`oneapm_configfile_ctnrpath`(`rowguid`, `ctnr_path`, `type`, `path_desc`, `isusedtotomcat`) VALUES ('fc8d4048-573d-11e8-9b7f-0050569012c3', '/usr/local/nginx/conf/nginx.ssl.key', 'nginx', 'nginx.ssl.key', NULL); +
-INSERT INTO `epointoneapm`.`oneapm_configfile_ctnrpath`(`rowguid`, `ctnr_path`, `type`, `path_desc`, `isusedtotomcat`) VALUES ('fc8d4048-573d-11e8-9b7f-0050569012c4', '/usr/local/nginx/conf/dhparam.pem', 'nginx', 'dhparam.pem', NULL); +
- +
- +
-INSERT INTO `epointoneapm`.`oneapm_configfile_ctnrpath`(`rowguid`, `ctnr_path`, `type`, `path_desc`, `isusedtotomcat`) VALUES ('fc8d4049-573d-11e8-9b7f-0050569012c1', '/usr/local/redis/etc/redis.conf', 'redis', 'index.html', NULL); +
-INSERT INTO `epointoneapm`.`oneapm_configfile_ctnrpath`(`rowguid`, `ctnr_path`, `type`, `path_desc`, `isusedtotomcat`) VALUES ('fc8d4039-573d-11e8-9b7f-0050569012c1', '/usr/local/zookeeper/conf/zoo.cfg', 'zookeeper', 'zoo.cfg', NULL); +
-INSERT INTO `epointoneapm`.`oneapm_configfile_ctnrpath`(`rowguid`, `ctnr_path`, `type`, `path_desc`, `isusedtotomcat`) VALUES ('fc8d4038-573d-11e8-9b7f-0050569012c1', '/usr/local/zookeeper/config.cfg', 'zookeeper', 'config.cfg', NULL); +
-INSERT INTO `epointoneapm`.`oneapm_configfile_ctnrpath`(`rowguid`, `ctnr_path`, `type`, `path_desc`, `isusedtotomcat`) VALUES ('fc8d4038-573d-11e8-9b7f-0050569012c2', '/usr/local/solr/solrhome/solr.xml', 'solr', 'solr.xml', NULL); +
- +
- +
-# tomcat +
-INSERT INTO `epointoneapm`.`oneapm_configfile_ctnrpath`(`rowguid`, `ctnr_path`, `type`, `path_desc`, `isusedtotomcat`) VALUES ('fc8d4045-573d-13e8-9b7f-0050569012c1', '/usr/local/tomcat/webapps/${app}/WEB-INF/classes/spring/appcontext-rabbitmq.xml', 'tomcat', 'appcontext-rabbitmq.xml', 1); +
-INSERT INTO `epointoneapm`.`oneapm_configfile_ctnrpath`(`rowguid`, `ctnr_path`, `type`, `path_desc`, `isusedtotomcat`) VALUES ('fc8d4045-573d-14e8-9b7f-0050569012c1', '/usr/local/tomcat/webapps/${app}/WEB-INF/classes/rabbitmq.properties', 'tomcat', 'rabbitmq.properties', 1); +
-INSERT INTO `epointoneapm`.`oneapm_configfile_ctnrpath`(`rowguid`, `ctnr_path`, `type`, `path_desc`, `isusedtotomcat`) VALUES ('fc8d4045-573d-15e8-9b7f-0050569012c1', '/usr/local/tomcat/webapps/${app}/WEB-INF/classes/zwfwcheck.properties', 'tomcat', 'zwfwcheck.properties', 1); +
-INSERT INTO `epointoneapm`.`oneapm_configfile_ctnrpath`(`rowguid`, `ctnr_path`, `type`, `path_desc`, `isusedtotomcat`) VALUES ('fc8d4045-573d-16e8-9b7f-0050569012c1', '/usr/local/tomcat/webapps/${app}/WEB-INF/classes/application.properties', 'tomcat', 'application.properties', 1); +
-INSERT INTO `epointoneapm`.`oneapm_configfile_ctnrpath`(`rowguid`, `ctnr_path`, `type`, `path_desc`, `isusedtotomcat`) VALUES ('fc8d4045-573d-17e8-9b7f-0050569012c1', '/usr/local/tomcat/webapps/${app}/WEB-INF/classes/application.properties', 'tomcat', 'application.properties', 1); +
-INSERT INTO `epointoneapm`.`oneapm_configfile_ctnrpath`(`rowguid`, `ctnr_path`, `type`, `path_desc`, `isusedtotomcat`) VALUES ('fc8d4045-573d-18e8-9b7f-0050569012c1', '/usr/local/tomcat/webapps/${app}/WEB-INF/classes/inteligentsearch.properties', 'tomcat', 'inteligentsearch.properties', 1); +
- +
- +
- +
- +
- +
-mysql -uroot -pInfra5@Gep0int -e "update epointoneapm.frame_ui set title='PaaS Control Panel' where pageid='docker'"; +
-docker cp `docker ps -a --filter=name='ecloud-web*' --format {{.ID}}`:/usr/local/tomcat/config /opt/ecloud_server/ecloud-web/ +
-docker cp `docker ps -a --filter=name='ecloud-we*' --format {{.ID}}`:/usr/local/tomcat/webapps/eCloud/WEB-INF/classes/epointframe.properties  /opt/ecloud_server/ecloud-web/config/epointframe.properties_template +
-sed -i -e '/checkMultipleLogin/s/checkMultipleLogin.*$/checkMultipleLogin=0/g' /opt/ecloud_server/ecloud-web/config/epointframe.properties_template +
-sed -e "1afilepath: /usr/local/tomcat/webapps/eCloud/WEB-INF/classes/epointframe.properties-e '1a\ \ params:' /opt/ecloud_server/ecloud-web/config/config.yaml +
-sed -i -e "1a- filepath: /usr/local/tomcat/webapps/eCloud/WEB-INF/classes/epointframe.properties" -e '1a\ \ params:' /opt/ecloud_server/ecloud-web/config/config.yaml +
- +
- +
-docker cp `docker ps -a --filter=name='ecloud-we*' --format {{.ID}}`:/usr/local/tomcat/webapps/eCloud/WEB-INF/classes/EpointSSOClient.properties  /opt/ecloud_server/ecloud-web/config/EpointSSOClient.properties_template +
-sed -i -e '/loginFailedLock/s/loginFailedLock.*$/loginFailedLock=15'$';1''/g' /opt/ecloud_server/ecloud-web/config/EpointSSOClient.properties_template +
-sed -i -e '/loginFrequency/s/loginFrequency.*$/loginFrequency=1mm30/g' /opt/ecloud_server/ecloud-web/config/EpointSSOClient.properties_template +
-sed -e "1a- filepath: /usr/local/tomcat/webapps/eCloud/WEB-INF/classes/EpointSSOClient.properties" -e '1a\ \ params:' /opt/ecloud_server/ecloud-web/config/config.yaml +
-sed -i -e "1a- filepath: /usr/local/tomcat/webapps/eCloud/WEB-INF/classes/EpointSSOClient.properties" -e '1a\ \ params:' /opt/ecloud_server/ecloud-web/config/config.yaml +
- +
-docker cp `docker ps -a --filter=name='ecloud-we*' --format {{.ID}}`:/usr/local/tomcat/webapps/eCloud/WEB-INF/classes/EpointSecurityConfig.properties  /opt/ecloud_server/ecloud-web/config/EpointSecurityConfig.properties_template +
-sed -i -e '/isOpenRobotDefense/s/isOpenRobotDefense.*$/isOpenRobotDefense=0/g' /opt/ecloud_server/ecloud-web/config/EpointSecurityConfig.properties_template +
-sed -e "1a- filepath: /usr/local/tomcat/webapps/eCloud/WEB-INF/classes/EpointSecurityConfig.properties" -e '1a\ \ params:' /opt/ecloud_server/ecloud-web/config/config.yaml +
-sed -i -e "1a- filepath: /usr/local/tomcat/webapps/eCloud/WEB-INF/classes/EpointSecurityConfig.properties" -e '1a\ \ params:' /opt/ecloud_server/ecloud-web/config/config.yaml +
- +
- +
- +
-sed -i -e '/${APP_NAME}\/logs/p;s/logs/config/g' /etc/init.d/ecloud-web +
-#sed -i -e '\=/${APP_NAME}/logs=p;s=logs=config=g' /etc/init.d/ecloud-web +
-/etc/init.d/ecloud-web rm_container +
-/etc/init.d/ecloud-web start +
-history -r +
- +
- +
- +
- +
- +
- +
- +
- +
 </sxh> </sxh>
18530927615.1654849904.txt.gz · 最后更改: 2022/06/10 16:31 由 amos