devbox
2023面试高手
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

docker 安装 datax和datax-web 之 datax-web登录时提示账号或密码错误_docker datax

作者：2023面试高手 | 2024-04-18 09:47:49

赞

踩

docker datax

docker 安装docker 安装 datax和datax-web 安装教程地址：

https://www.cnblogs.com/leihongnu/p/16612273.html

根据该博客的教程安装成功后，登录页面能打开，但是所提供的账户密码一直报错，这个就需要根据日志一步步去寻找原因了。

该镜像包含三个模块：datax, datax-web, datax-exector,日志路径分别为：
/home/datax/datax-web-2.1.2/bin/console.out
/home/datax/datax-web-2.1.2/modules/datax-admin/bin/console.out
/home/datax/datax-web-2.1.2/modules/datax-executor/bin/console.out


datax-web, datax-exector,配置路径为：/home/datax/datax-web-2.1.2/modules/datax-admin/conf

1、根据启动的id 进入容器内部，查看日志，


2、根据日志报错信息进行相关处理
  （1）如果是连接数据库的账号密码有问题，修正对应的账号密码
   （2）如果使用的是mysql8 可能会报 Public Key Retrieval is not allowed,解决方法就是在容器内的配置文件路径中/home/datax/datax-web-2.1.2/modules/datax-admin/conf

修改application。yml文件，在数据源的url后面追加allowPublicKeyRetrieval=true&useSSL=false

（3）如果提示 select 查询语句 t_user.id，说明你的数据库脚本不全,下面是我运行成功的sql

  1. -- MySQL dump 10.13  Distrib 8.0.29, for Win64 (x86_64)
  2. --
  3. -- Host: 47.100.71.23    Database: datax_web
  4. -- ------------------------------------------------------
  5. -- Server version	8.0.26
  6.  
  7. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  8. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  9. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  10. /*!50503 SET NAMES utf8mb4 */;
  11. /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  12. /*!40103 SET TIME_ZONE='+00:00' */;
  13. /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  14. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  15. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  16. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  17.  
  18. --
  19. -- Table structure for table `job_group`
  20. --
  21.  
  22. DROP TABLE IF EXISTS `job_group`;
  23. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  24. /*!50503 SET character_set_client = utf8mb4 */;
  25. CREATE TABLE `job_group` (
  26.   `id` int NOT NULL AUTO_INCREMENT,
  27.   `app_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '执行器AppName',
  28.   `title` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '执行器名称',
  29.   `order` int NOT NULL DEFAULT '0' COMMENT '排序',
  30.   `address_type` tinyint NOT NULL DEFAULT '0' COMMENT '执行器地址类型：0=自动注册、1=手动录入',
  31.   `address_list` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '执行器地址列表，多地址逗号分隔',
  32.   PRIMARY KEY (`id`) USING BTREE
  33. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
  34. /*!40101 SET character_set_client = @saved_cs_client */;
  35.  
  36. --
  37. -- Dumping data for table `job_group`
  38. --
  39.  
  40. LOCK TABLES `job_group` WRITE;
  41. /*!40000 ALTER TABLE `job_group` DISABLE KEYS */;
  42. INSERT INTO `job_group` VALUES (1,'datax-executor','datax执行器',1,0,'10.68.12.104:9999,172.17.0.10:9999');
  43. /*!40000 ALTER TABLE `job_group` ENABLE KEYS */;
  44. UNLOCK TABLES;
  45.  
  46. --
  47. -- Table structure for table `job_info`
  48. --
  49.  
  50. DROP TABLE IF EXISTS `job_info`;
  51. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  52. /*!50503 SET character_set_client = utf8mb4 */;
  53. CREATE TABLE `job_info` (
  54.   `id` int NOT NULL AUTO_INCREMENT,
  55.   `job_group` int NOT NULL COMMENT '执行器主键ID',
  56.   `job_cron` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务执行CRON',
  57.   `job_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  58.   `project_id` int DEFAULT NULL COMMENT '所属项目id',
  59.   `add_time` datetime DEFAULT NULL,
  60.   `update_time` datetime DEFAULT NULL,
  61.   `user_id` int NOT NULL COMMENT '修改用户',
  62.   `alarm_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '报警邮件',
  63.   `executor_route_strategy` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '执行器路由策略',
  64.   `executor_handler` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '执行器任务handler',
  65.   `executor_param` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '执行器任务参数',
  66.   `executor_block_strategy` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '阻塞处理策略',
  67.   `executor_timeout` int NOT NULL DEFAULT '0' COMMENT '任务执行超时时间，单位分钟',
  68.   `executor_fail_retry_count` int NOT NULL DEFAULT '0' COMMENT '失败重试次数',
  69.   `glue_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'GLUE类型',
  70.   `glue_source` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'GLUE源代码',
  71.   `glue_remark` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'GLUE备注',
  72.   `glue_updatetime` datetime DEFAULT NULL COMMENT 'GLUE更新时间',
  73.   `child_jobid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '子任务ID，多个逗号分隔',
  74.   `trigger_status` tinyint NOT NULL DEFAULT '0' COMMENT '调度状态：0-停止，1-运行',
  75.   `trigger_last_time` bigint NOT NULL DEFAULT '0' COMMENT '上次调度时间',
  76.   `trigger_next_time` bigint NOT NULL DEFAULT '0' COMMENT '下次调度时间',
  77.   `job_json` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT 'datax运行脚本',
  78.   `replace_param` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '动态参数',
  79.   `jvm_param` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'jvm参数',
  80.   `inc_start_time` datetime DEFAULT NULL COMMENT '增量初始时间',
  81.   `partition_info` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '分区信息',
  82.   `last_handle_code` int DEFAULT '0' COMMENT '最近一次执行状态',
  83.   `replace_param_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '增量时间格式',
  84.   `reader_table` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'reader表名称',
  85.   `primary_key` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '增量表主键',
  86.   `inc_start_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '增量初始id',
  87.   `increment_type` tinyint DEFAULT '0' COMMENT '增量类型',
  88.   `datasource_id` bigint DEFAULT NULL COMMENT '数据源id',
  89.   PRIMARY KEY (`id`) USING BTREE
  90. ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
  91. /*!40101 SET character_set_client = @saved_cs_client */;
  92.  
  93. --
  94. -- Dumping data for table `job_info`
  95. --
  96.  
  97. LOCK TABLES `job_info` WRITE;
  98. /*!40000 ALTER TABLE `job_info` DISABLE KEYS */;
  99. INSERT INTO `job_info` VALUES (7,1,'* 55 * ? * * *','rrer',1,'2023-04-26 10:44:29','2023-04-26 16:14:45',1,'','RANDOM','executorJobHandler','','DISCARD_LATER',0,0,'DATAX','',NULL,'2023-04-26 10:44:29','',0,0,0,'{\n    \"job\":{\n        \"setting\":{\n            \"speed\":{\n                \"channel\":1\n            }\n        },\n        \"content\":[\n            {\n                \"reader\":{\n                    \"name\":\"mysqlreader\",\n                    \"parameter\":{\n                        \"password\":\"risen_component_trace\",\n                        \"username\":\"risen\",\n                        \"connection\":[\n                            {\n                                \"querySql\":[\n                                \"select * from `component-trace`.sys_order_component where sys_create_time <\'2023-02-15 00:55:05\' and sys_create_time >\'2022-11-07 15:43:44\'\"\n                                ],\n                                \"jdbcUrl\":[\n                                    \"jdbc:mysql://10.10.11.159:3306/component-trace?useUnicode=true&amp;serverTimezone=UTC&amp;characterEncoding=utf8&amp;&amp;allowLoadLocalInfile=false&amp;autoDeserialize=false&amp;allowLocalInfile=false&amp;allowUrlInLocalInfile=false\"\n                                ]\n                            }\n                        ]\n                    }\n                },\n                \"writer\":{\n                    \"name\":\"postgresqlwriter\",\n                    \"parameter\":{\n                        \"username\":\"ywmxadmin\",\n                        \"password\":\"rsmatrixdb@2022\",\n                        \"column\":[\n                            \"id\",\n                            \"customer_name\",\n                            \"container_no\",\n                            \"cabinet_no\",\n                            \"license_plate_no\",\n                            \"support_num\",\n                            \"bar_code\",\n                            \"product_name\",\n                            \"order_num\",\n                            \"sale_order_num\",\n                            \"component_level\",\n                            \"brand_id\",\n                            \"factory_id\",\n                            \"workshop_name\",\n                            \"production_order_num\",\n                            \"for_batch_time\",\n                            \"iv_test_nameplate_model\",\n                            \"battery_piece_theory_power\",\n                            \"pack_num\",\n                            \"pack_sum\",\n                            \"pack_create_by\",\n                            \"pack_create_time\",\n                            \"ship_date\",\n                            \"in_storage_create_time\",\n                            \"pack_loss\",\n                            \"component_iv\",\n                            \"component_el\",\n                            \"component_box\",\n                            \"operate_no\",\n                            \"sys_create_time\",\n                            \"sys_update_time\",\n                            \"deleted\",\n                            \"other_info\"\n                        ],\n                        \"connection\":[\n                            {\n                                \"jdbcUrl\":\"jdbc:postgresql://10.80.1.70:5432/r_db\",\n                                \"table\":[\n                                    \"component.component_order_temp\"\n                                ]\n                            }\n                        ],\n                        \"preSql\":[\n\n                        ]\n                    }\n                }\n            }\n        ]\n    }\n}\n ','','',NULL,'',500,'Timestamp','','',NULL,0,0),(8,1,'* * * ? * * *','aoa_attachment_list',1,'2023-04-26 10:47:42','2023-04-26 10:47:42',1,'','RANDOM','executorJobHandler','','DISCARD_LATER',0,0,'DATAX',NULL,NULL,'2023-04-26 10:47:42','',0,0,0,'{\n  \"job\": {\n    \"setting\": {\n      \"speed\": {\n        \"channel\": 3,\n        \"byte\": 1048576\n      },\n      \"errorLimit\": {\n        \"record\": 0,\n        \"percentage\": 0.02\n      }\n    },\n    \"content\": [\n      {\n        \"reader\": {\n          \"name\": \"mysqlreader\",\n          \"parameter\": {\n            \"username\": \"yRjwDFuoPKlqya9h9H2Amg==\",\n            \"password\": \"xBW5e8rfLpcZmRQhwLd3xghlk6AUjANpWuRIndDVIGI=\",\n            \"column\": [\n              \"`attachment_id`\",\n              \"`attachment_name`\",\n              \"`attachment_path`\",\n              \"`attachment_shuffix`\",\n              \"`attachment_size`\",\n              \"`attachment_type`\",\n              \"`model`\",\n              \"`upload_time`\",\n              \"`user_id`\"\n            ],\n            \"splitPk\": \"\",\n            \"connection\": [\n              {\n                \"table\": [\n                  \"aoa_attachment_list\"\n                ],\n                \"jdbcUrl\": [\n                  \"jdbc:mysql://10.10.9.141:3306/study?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\"\n                ]\n              }\n            ]\n          }\n        },\n        \"writer\": {\n          \"name\": \"mysqlwriter\",\n          \"parameter\": {\n            \"username\": \"yRjwDFuoPKlqya9h9H2Amg==\",\n            \"password\": \"Nb4RyvWuxvF3S9oWYbCofDXNEqSt+DQlyF9GC1YtIsw=\",\n            \"column\": [\n              \"`attachment_id`\",\n              \"`attachment_name`\",\n              \"`attachment_path`\",\n              \"`attachment_shuffix`\",\n              \"`attachment_size`\",\n              \"`attachment_type`\",\n              \"`model`\",\n              \"`upload_time`\",\n              \"`user_id`\"\n            ],\n            \"connection\": [\n              {\n                \"table\": [\n                  \"aoa_attachment_list\"\n                ],\n                \"jdbcUrl\": \"jdbc:mysql://47.100.71.23:33306/study_temp?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8&rewriteBatchedStatements=true\\n\"\n              }\n            ]\n          }\n        }\n      }\n    ]\n  }\n}',NULL,'',NULL,NULL,0,'Timestamp',NULL,NULL,NULL,0,0);
  100. /*!40000 ALTER TABLE `job_info` ENABLE KEYS */;
  101. UNLOCK TABLES;
  102.  
  103. --
  104. -- Table structure for table `job_jdbc_datasource`
  105. --
  106.  
  107. DROP TABLE IF EXISTS `job_jdbc_datasource`;
  108. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  109. /*!50503 SET character_set_client = utf8mb4 */;
  110. CREATE TABLE `job_jdbc_datasource` (
  111.   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增主键',
  112.   `datasource_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '数据源名称',
  113.   `datasource` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '数据源',
  114.   `datasource_group` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'Default' COMMENT '数据源分组',
  115.   `database_name` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '数据库名',
  116.   `jdbc_username` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '用户名',
  117.   `jdbc_password` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '密码',
  118.   `jdbc_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'jdbc url',
  119.   `jdbc_driver_class` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'jdbc驱动类',
  120.   `zk_adress` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  121.   `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态：0删除 1启用 2禁用',
  122.   `create_by` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
  123.   `create_date` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  124.   `update_by` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '更新人',
  125.   `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  126.   `comments` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  127.   PRIMARY KEY (`id`) USING BTREE
  128. ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='jdbc数据源配置';
  129. /*!40101 SET character_set_client = @saved_cs_client */;
  130.  
  131. --
  132. -- Dumping data for table `job_jdbc_datasource`
  133. --
  134.  
  135. LOCK TABLES `job_jdbc_datasource` WRITE;
  136. /*!40000 ALTER TABLE `job_jdbc_datasource` DISABLE KEYS */;
  137. INSERT INTO `job_jdbc_datasource` VALUES (6,'产品数据系统生产库','mysql','Default',NULL,'fMaKElymbiVDjjwluBXyhA==','XCYVpFosvZBBWobFzmLWvA==','jdbc:mysql://10.10.11.159:3306/component-trace?useUnicode=true&amp;serverTimezone=UTC&amp;characterEncoding=utf8&amp;&amp;allowLoadLocalInfile=false&amp;autoDeserialize=false&amp;allowLocalInfile=false&amp;allowUrlInLocalInfile=false\"','com.mysql.cj.jdbc.Driver',NULL,0,'admin','2023-04-26 10:25:45',NULL,NULL,''),(7,'产品数据测试库','mysql','Default',NULL,'yRjwDFuoPKlqya9h9H2Amg==','xBW5e8rfLpcZmRQhwLd3xghlk6AUjANpWuRIndDVIGI=','jdbc:mysql://10.10.9.141:3306/study?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8','com.mysql.jdbc.Driver',NULL,1,'admin','2023-04-26 10:29:28','admin','2023-04-26 10:36:47',''),(8,'产品数据生产库（只读账号）','mysql','Default',NULL,'hB1OjGaijcKfRnwxQD8bWg==','xBW5e8rfLpcZmRQhwLd3xghlk6AUjANpWuRIndDVIGI=','jdbc:mysql://10.10.11.159:3306/component-trace?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8','com.mysql.jdbc.Driver',NULL,1,'admin','2023-04-26 10:33:09','admin','2023-04-26 10:34:12',''),(9,'销管测试库','mysql','Default',NULL,'yRjwDFuoPKlqya9h9H2Amg==','Nb4RyvWuxvF3S9oWYbCofDXNEqSt+DQlyF9GC1YtIsw=','jdbc:mysql://47.100.71.23:33306/study_temp?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8&rewriteBatchedStatements=true\n','com.mysql.jdbc.Driver',NULL,1,'admin','2023-04-26 10:35:38','admin','2023-04-26 10:37:24','');
  138. /*!40000 ALTER TABLE `job_jdbc_datasource` ENABLE KEYS */;
  139. UNLOCK TABLES;
  140.  
  141. --
  142. -- Table structure for table `job_lock`
  143. --
  144.  
  145. DROP TABLE IF EXISTS `job_lock`;
  146. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  147. /*!50503 SET character_set_client = utf8mb4 */;
  148. CREATE TABLE `job_lock` (
  149.   `lock_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '锁名称',
  150.   PRIMARY KEY (`lock_name`) USING BTREE
  151. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
  152. /*!40101 SET character_set_client = @saved_cs_client */;
  153.  
  154. --
  155. -- Dumping data for table `job_lock`
  156. --
  157.  
  158. LOCK TABLES `job_lock` WRITE;
  159. /*!40000 ALTER TABLE `job_lock` DISABLE KEYS */;
  160. INSERT INTO `job_lock` VALUES ('schedule_lock');
  161. /*!40000 ALTER TABLE `job_lock` ENABLE KEYS */;
  162. UNLOCK TABLES;
  163.  
  164. --
  165. -- Table structure for table `job_log`
  166. --
  167.  
  168. DROP TABLE IF EXISTS `job_log`;
  169. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  170. /*!50503 SET character_set_client = utf8mb4 */;
  171. CREATE TABLE `job_log` (
  172.   `id` bigint NOT NULL AUTO_INCREMENT,
  173.   `job_group` int NOT NULL COMMENT '执行器主键ID',
  174.   `job_id` int NOT NULL COMMENT '任务，主键ID',
  175.   `job_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  176.   `executor_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '执行器地址，本次执行的地址',
  177.   `executor_handler` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '执行器任务handler',
  178.   `executor_param` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '执行器任务参数',
  179.   `executor_sharding_param` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '执行器任务分片参数，格式如 1/2',
  180.   `executor_fail_retry_count` int DEFAULT '0' COMMENT '失败重试次数',
  181.   `trigger_time` datetime DEFAULT NULL COMMENT '调度-时间',
  182.   `trigger_code` int NOT NULL COMMENT '调度-结果',
  183.   `trigger_msg` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '调度-日志',
  184.   `handle_time` datetime DEFAULT NULL COMMENT '执行-时间',
  185.   `handle_code` int NOT NULL COMMENT '执行-状态',
  186.   `handle_msg` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '执行-日志',
  187.   `alarm_status` tinyint NOT NULL DEFAULT '0' COMMENT '告警状态：0-默认、1-无需告警、2-告警成功、3-告警失败',
  188.   `process_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'datax进程Id',
  189.   `max_id` bigint DEFAULT NULL COMMENT '增量表max id',
  190.   PRIMARY KEY (`id`) USING BTREE,
  191.   KEY `I_trigger_time` (`trigger_time`) USING BTREE,
  192.   KEY `I_handle_code` (`handle_code`) USING BTREE
  193. ) ENGINE=InnoDB AUTO_INCREMENT=130 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
  194. /*!40101 SET character_set_client = @saved_cs_client */;
  195.  
  196. --
  197. -- Dumping data for table `job_log`
  198. --
  199.  
  200. LOCK TABLES `job_log` WRITE;
  201. /*!40000 ALTER TABLE `job_log` DISABLE KEYS */;
  202. INSERT INTO `job_log` VALUES (126,1,8,'aoa_attachment_list','10.68.12.104:9999','executorJobHandler','',NULL,0,'2023-04-26 16:18:09',500,'任务触发类型：手动触发<br>调度机器：10.68.12.104<br>执行器-注册方式：自动注册<br>执行器-地址列表：[10.68.12.104:9999]<br>路由策略：随机<br>阻塞处理策略：丢弃后续调度<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：10.68.12.104:9999<br>code：500<br>msg：glueType[DATAX] is not valid.',NULL,0,NULL,1,NULL,NULL),(127,1,8,'aoa_attachment_list','10.68.12.104:9999','executorJobHandler','',NULL,0,'2023-04-27 09:22:14',500,'任务触发类型：手动触发<br>调度机器：10.68.12.104<br>执行器-注册方式：自动注册<br>执行器-地址列表：[10.68.12.104:9999]<br>路由策略：随机<br>阻塞处理策略：丢弃后续调度<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：10.68.12.104:9999<br>code：500<br>msg：glueType[DATAX] is not valid.',NULL,0,NULL,1,NULL,NULL),(128,1,8,'aoa_attachment_list','10.68.12.104:9999','executorJobHandler','',NULL,0,'2023-04-27 09:31:03',500,'任务触发类型：手动触发<br>调度机器：10.68.12.104<br>执行器-注册方式：自动注册<br>执行器-地址列表：[10.68.12.104:9999]<br>路由策略：随机<br>阻塞处理策略：丢弃后续调度<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：10.68.12.104:9999<br>code：500<br>msg：glueType[DATAX] is not valid.',NULL,0,NULL,1,NULL,NULL),(129,1,8,'aoa_attachment_list','10.68.12.104:9999','executorJobHandler','',NULL,0,'2023-04-27 10:53:44',500,'任务触发类型：手动触发<br>调度机器：172.17.0.11<br>执行器-注册方式：自动注册<br>执行器-地址列表：[10.68.12.104:9999, 172.17.0.11:9999]<br>路由策略：随机<br>阻塞处理策略：丢弃后续调度<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：10.68.12.104:9999<br>code：500<br>msg：glueType[DATAX] is not valid.',NULL,0,NULL,1,NULL,NULL);
  203. /*!40000 ALTER TABLE `job_log` ENABLE KEYS */;
  204. UNLOCK TABLES;
  205.  
  206. --
  207. -- Table structure for table `job_log_report`
  208. --
  209.  
  210. DROP TABLE IF EXISTS `job_log_report`;
  211. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  212. /*!50503 SET character_set_client = utf8mb4 */;
  213. CREATE TABLE `job_log_report` (
  214.   `id` int NOT NULL AUTO_INCREMENT,
  215.   `trigger_day` datetime DEFAULT NULL COMMENT '调度-时间',
  216.   `running_count` int NOT NULL DEFAULT '0' COMMENT '运行中-日志数量',
  217.   `suc_count` int NOT NULL DEFAULT '0' COMMENT '执行成功-日志数量',
  218.   `fail_count` int NOT NULL DEFAULT '0' COMMENT '执行失败-日志数量',
  219.   PRIMARY KEY (`id`) USING BTREE,
  220.   UNIQUE KEY `i_trigger_day` (`trigger_day`) USING BTREE
  221. ) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
  222. /*!40101 SET character_set_client = @saved_cs_client */;
  223.  
  224. --
  225. -- Dumping data for table `job_log_report`
  226. --
  227.  
  228. LOCK TABLES `job_log_report` WRITE;
  229. /*!40000 ALTER TABLE `job_log_report` DISABLE KEYS */;
  230. INSERT INTO `job_log_report` VALUES (20,'2019-12-07 00:00:00',0,0,0),(21,'2019-12-10 00:00:00',77,52,23),(22,'2019-12-11 00:00:00',9,2,11),(23,'2019-12-13 00:00:00',9,48,74),(24,'2019-12-12 00:00:00',10,8,30),(25,'2019-12-14 00:00:00',78,45,66),(26,'2019-12-15 00:00:00',24,76,9),(27,'2019-12-16 00:00:00',23,85,10),(28,'2023-04-26 00:00:00',0,0,1),(29,'2023-04-25 00:00:00',0,0,0),(30,'2023-04-24 00:00:00',0,0,0),(31,'2023-04-27 00:00:00',0,0,3);
  231. /*!40000 ALTER TABLE `job_log_report` ENABLE KEYS */;
  232. UNLOCK TABLES;
  233.  
  234. --
  235. -- Table structure for table `job_logglue`
  236. --
  237.  
  238. DROP TABLE IF EXISTS `job_logglue`;
  239. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  240. /*!50503 SET character_set_client = utf8mb4 */;
  241. CREATE TABLE `job_logglue` (
  242.   `id` int NOT NULL AUTO_INCREMENT,
  243.   `job_id` int NOT NULL COMMENT '任务，主键ID',
  244.   `glue_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'GLUE类型',
  245.   `glue_source` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'GLUE源代码',
  246.   `glue_remark` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'GLUE备注',
  247.   `add_time` datetime DEFAULT NULL,
  248.   `update_time` datetime DEFAULT NULL,
  249.   PRIMARY KEY (`id`) USING BTREE
  250. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
  251. /*!40101 SET character_set_client = @saved_cs_client */;
  252.  
  253. --
  254. -- Dumping data for table `job_logglue`
  255. --
  256.  
  257. LOCK TABLES `job_logglue` WRITE;
  258. /*!40000 ALTER TABLE `job_logglue` DISABLE KEYS */;
  259. /*!40000 ALTER TABLE `job_logglue` ENABLE KEYS */;
  260. UNLOCK TABLES;
  261.  
  262. --
  263. -- Table structure for table `job_permission`
  264. --
  265.  
  266. DROP TABLE IF EXISTS `job_permission`;
  267. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  268. /*!50503 SET character_set_client = utf8mb4 */;
  269. CREATE TABLE `job_permission` (
  270.   `id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
  271.   `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '权限名',
  272.   `description` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '权限描述',
  273.   `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  274.   `pid` int DEFAULT NULL,
  275.   PRIMARY KEY (`id`) USING BTREE
  276. ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
  277. /*!40101 SET character_set_client = @saved_cs_client */;
  278.  
  279. --
  280. -- Dumping data for table `job_permission`
  281. --
  282.  
  283. LOCK TABLES `job_permission` WRITE;
  284. /*!40000 ALTER TABLE `job_permission` DISABLE KEYS */;
  285. /*!40000 ALTER TABLE `job_permission` ENABLE KEYS */;
  286. UNLOCK TABLES;
  287.  
  288. --
  289. -- Table structure for table `job_project`
  290. --
  291.  
  292. DROP TABLE IF EXISTS `job_project`;
  293. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  294. /*!50503 SET character_set_client = utf8mb4 */;
  295. CREATE TABLE `job_project` (
  296.   `id` int NOT NULL AUTO_INCREMENT COMMENT 'key',
  297.   `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'project name',
  298.   `description` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  299.   `user_id` int DEFAULT NULL COMMENT 'creator id',
  300.   `flag` tinyint DEFAULT '1' COMMENT '0 not available, 1 available',
  301.   `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT 'create time',
  302.   `update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT 'update time',
  303.   PRIMARY KEY (`id`) USING BTREE
  304. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
  305. /*!40101 SET character_set_client = @saved_cs_client */;
  306.  
  307. --
  308. -- Dumping data for table `job_project`
  309. --
  310.  
  311. LOCK TABLES `job_project` WRITE;
  312. /*!40000 ALTER TABLE `job_project` DISABLE KEYS */;
  313. INSERT INTO `job_project` VALUES (1,'study','hahhh',1,1,'2023-04-26 10:41:06','2023-04-26 10:41:06');
  314. /*!40000 ALTER TABLE `job_project` ENABLE KEYS */;
  315. UNLOCK TABLES;
  316.  
  317. --
  318. -- Table structure for table `job_registry`
  319. --
  320.  
  321. DROP TABLE IF EXISTS `job_registry`;
  322. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  323. /*!50503 SET character_set_client = utf8mb4 */;
  324. CREATE TABLE `job_registry` (
  325.   `id` int NOT NULL AUTO_INCREMENT,
  326.   `registry_group` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  327.   `registry_key` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  328.   `registry_value` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  329.   `cpu_usage` double DEFAULT NULL,
  330.   `memory_usage` double DEFAULT NULL,
  331.   `load_average` double DEFAULT NULL,
  332.   `update_time` datetime DEFAULT NULL,
  333.   PRIMARY KEY (`id`) USING BTREE,
  334.   KEY `i_g_k_v` (`registry_group`,`registry_key`,`registry_value`) USING BTREE
  335. ) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
  336. /*!40101 SET character_set_client = @saved_cs_client */;
  337.  
  338. --
  339. -- Dumping data for table `job_registry`
  340. --
  341.  
  342. LOCK TABLES `job_registry` WRITE;
  343. /*!40000 ALTER TABLE `job_registry` DISABLE KEYS */;
  344. INSERT INTO `job_registry` VALUES (30,'EXECUTOR','datax-executor','10.68.12.104:9999',9.58,73.98,-1,'2023-04-27 11:46:43'),(32,'EXECUTOR','datax-executor','172.17.0.10:9999',1.12,89,0,'2023-04-27 11:46:51');
  345. /*!40000 ALTER TABLE `job_registry` ENABLE KEYS */;
  346. UNLOCK TABLES;
  347.  
  348. --
  349. -- Table structure for table `job_template`
  350. --
  351.  
  352. DROP TABLE IF EXISTS `job_template`;
  353. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  354. /*!50503 SET character_set_client = utf8mb4 */;
  355. CREATE TABLE `job_template` (
  356.   `id` int NOT NULL AUTO_INCREMENT,
  357.   `job_group` int NOT NULL COMMENT '执行器主键ID',
  358.   `job_cron` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务执行CRON',
  359.   `job_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  360.   `add_time` datetime DEFAULT NULL,
  361.   `update_time` datetime DEFAULT NULL,
  362.   `user_id` int NOT NULL COMMENT '修改用户',
  363.   `alarm_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '报警邮件',
  364.   `executor_route_strategy` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '执行器路由策略',
  365.   `executor_handler` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '执行器任务handler',
  366.   `executor_param` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '执行器参数',
  367.   `executor_block_strategy` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '阻塞处理策略',
  368.   `executor_timeout` int NOT NULL DEFAULT '0' COMMENT '任务执行超时时间，单位秒',
  369.   `executor_fail_retry_count` int NOT NULL DEFAULT '0' COMMENT '失败重试次数',
  370.   `glue_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'GLUE类型',
  371.   `glue_source` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'GLUE源代码',
  372.   `glue_remark` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'GLUE备注',
  373.   `glue_updatetime` datetime DEFAULT NULL COMMENT 'GLUE更新时间',
  374.   `child_jobid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '子任务ID，多个逗号分隔',
  375.   `trigger_last_time` bigint NOT NULL DEFAULT '0' COMMENT '上次调度时间',
  376.   `trigger_next_time` bigint NOT NULL DEFAULT '0' COMMENT '下次调度时间',
  377.   `job_json` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT 'datax运行脚本',
  378.   `jvm_param` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'jvm参数',
  379.   `project_id` int DEFAULT NULL COMMENT '所属项目Id',
  380.   PRIMARY KEY (`id`) USING BTREE
  381. ) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
  382. /*!40101 SET character_set_client = @saved_cs_client */;
  383.  
  384. --
  385. -- Dumping data for table `job_template`
  386. --
  387.  
  388. LOCK TABLES `job_template` WRITE;
  389. /*!40000 ALTER TABLE `job_template` DISABLE KEYS */;
  390. INSERT INTO `job_template` VALUES (22,1,'* * * ? * * *','ceshi','2023-04-26 10:45:36','2023-04-26 10:45:36',1,'','RANDOM','executorJobHandler','','DISCARD_LATER',0,0,'DATAX',NULL,NULL,'2023-04-26 10:45:36','',0,0,NULL,'',1);
  391. /*!40000 ALTER TABLE `job_template` ENABLE KEYS */;
  392. UNLOCK TABLES;
  393.  
  394. --
  395. -- Table structure for table `job_user`
  396. --
  397.  
  398. DROP TABLE IF EXISTS `job_user`;
  399. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  400. /*!50503 SET character_set_client = utf8mb4 */;
  401. CREATE TABLE `job_user` (
  402.   `id` int NOT NULL AUTO_INCREMENT,
  403.   `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '账号',
  404.   `password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '密码',
  405.   `role` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '角色：0-普通用户、1-管理员',
  406.   `permission` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '权限：执行器ID列表，多个逗号分割',
  407.   PRIMARY KEY (`id`) USING BTREE,
  408.   UNIQUE KEY `i_username` (`username`) USING BTREE
  409. ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
  410. /*!40101 SET character_set_client = @saved_cs_client */;
  411.  
  412. --
  413. -- Dumping data for table `job_user`
  414. --
  415.  
  416. LOCK TABLES `job_user` WRITE;
  417. /*!40000 ALTER TABLE `job_user` DISABLE KEYS */;
  418. INSERT INTO `job_user` VALUES (1,'admin','$2a$10$2KCqRbra0Yn2TwvkZxtfLuWuUP5KyCWsljO/ci5pLD27pqR3TV1vy','ROLE_ADMIN',NULL);
  419. /*!40000 ALTER TABLE `job_user` ENABLE KEYS */;
  420. UNLOCK TABLES;
  421.  
  422. --
  423. -- Dumping routines for database 'datax_web'
  424. --
  425. /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  426.  
  427. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  428. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  429. /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  430. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  431. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  432. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  433. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  434.  
  435. -- Dump completed on 2023-04-27 11:46:58

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/2023面试高手/article/detail/445273
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号