用户工具

站点工具

您的足迹: • 18530927615

侧边栏123123

最近发布

随机推荐

18530927615

这是本文档旧的修订版！ 

update oneapm_host_info set sys_guid="default";

update epointoneapm.frame_user set password='{SM3#:null:null}AB9639BC1EC5281C6161578159719C726C766FE461A5E5C5A20299CAA5489567' where  loginid like 'admin';


INSERT INTO `frame_user` VALUES ('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_extendinfo` VALUES (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_userconfig` VALUES ('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_userrolerelation` VALUES ('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 "1a- filepath: /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

18530927615.1654849904.txt.gz · 最后更改: 2022/06/10 16:31 由 amos

页面工具

您的足迹: • 18530927615