docker 安裝 datax和datax-web 之 datax-web登錄時(shí)提示賬號(hào)或密碼錯(cuò)誤

這篇具有很好參考價(jià)值的文章主要介紹了docker 安裝 datax和datax-web 之 datax-web登錄時(shí)提示賬號(hào)或密碼錯(cuò)誤。希望對(duì)大家有所幫助。如果存在錯(cuò)誤或未考慮完全的地方，請(qǐng)大家不吝賜教，您也可以點(diǎn)擊"舉報(bào)違法"按鈕提交疑問。
docker 安裝docker 安裝 datax和datax-web 安裝教程地址：

https://www.cnblogs.com/leihongnu/p/16612273.html
根據(jù)該博客的教程安裝成功后，登錄頁面能打開，但是所提供的賬戶密碼一直報(bào)錯(cuò)，這個(gè)就需要根據(jù)日志一步步去尋找原因了。
該鏡像包含三個(gè)模塊：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
docker 安裝 datax和datax-web 之 datax-web登錄時(shí)提示賬號(hào)或密碼錯(cuò)誤
1、根據(jù)啟動(dòng)的id 進(jìn)入容器內(nèi)部，查看日志，
docker 安裝 datax和datax-web 之 datax-web登錄時(shí)提示賬號(hào)或密碼錯(cuò)誤
2、根據(jù)日志報(bào)錯(cuò)信息進(jìn)行相關(guān)處理
? （1）如果是連接數(shù)據(jù)庫的賬號(hào)密碼有問題，修正對(duì)應(yīng)的賬號(hào)密碼
? ?（2）如果使用的是mysql8 可能會(huì)報(bào) Public Key Retrieval is not allowed,解決方法就是在容器內(nèi)的配置文件路徑中/home/datax/datax-web-2.1.2/modules/datax-admin/conf
修改application。yml文件，在數(shù)據(jù)源的url后面追加allowPublicKeyRetrieval=true&useSSL=false
（3）如果提示 select 查詢語句 t_user.id，說明你的數(shù)據(jù)庫腳本不全,下面是我運(yùn)行成功的sql文章來源地址http://www.zghlxwxcb.cn/news/detail-496105.html
-- MySQL dump 10.13  Distrib 8.0.29, for Win64 (x86_64)
--
-- Host: 47.100.71.23    Database: datax_web
-- ------------------------------------------------------
-- Server version	8.0.26

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `job_group`
--

DROP TABLE IF EXISTS `job_group`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `job_group` (
  `id` int NOT NULL AUTO_INCREMENT,
  `app_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '執(zhí)行器AppName',
  `title` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '執(zhí)行器名稱',
  `order` int NOT NULL DEFAULT '0' COMMENT '排序',
  `address_type` tinyint NOT NULL DEFAULT '0' COMMENT '執(zhí)行器地址類型：0=自動(dòng)注冊(cè)、1=手動(dòng)錄入',
  `address_list` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '執(zhí)行器地址列表，多地址逗號(hào)分隔',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `job_group`
--

LOCK TABLES `job_group` WRITE;
/*!40000 ALTER TABLE `job_group` DISABLE KEYS */;
INSERT INTO `job_group` VALUES (1,'datax-executor','datax執(zhí)行器',1,0,'10.68.12.104:9999,172.17.0.10:9999');
/*!40000 ALTER TABLE `job_group` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `job_info`
--

DROP TABLE IF EXISTS `job_info`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `job_info` (
  `id` int NOT NULL AUTO_INCREMENT,
  `job_group` int NOT NULL COMMENT '執(zhí)行器主鍵ID',
  `job_cron` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任務(wù)執(zhí)行CRON',
  `job_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `project_id` int DEFAULT NULL COMMENT '所屬項(xiàng)目id',
  `add_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `user_id` int NOT NULL COMMENT '修改用戶',
  `alarm_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '報(bào)警郵件',
  `executor_route_strategy` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '執(zhí)行器路由策略',
  `executor_handler` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '執(zhí)行器任務(wù)handler',
  `executor_param` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '執(zhí)行器任務(wù)參數(shù)',
  `executor_block_strategy` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '阻塞處理策略',
  `executor_timeout` int NOT NULL DEFAULT '0' COMMENT '任務(wù)執(zhí)行超時(shí)時(shí)間，單位分鐘',
  `executor_fail_retry_count` int NOT NULL DEFAULT '0' COMMENT '失敗重試次數(shù)',
  `glue_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'GLUE類型',
  `glue_source` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'GLUE源代碼',
  `glue_remark` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'GLUE備注',
  `glue_updatetime` datetime DEFAULT NULL COMMENT 'GLUE更新時(shí)間',
  `child_jobid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '子任務(wù)ID，多個(gè)逗號(hào)分隔',
  `trigger_status` tinyint NOT NULL DEFAULT '0' COMMENT '調(diào)度狀態(tài)：0-停止，1-運(yùn)行',
  `trigger_last_time` bigint NOT NULL DEFAULT '0' COMMENT '上次調(diào)度時(shí)間',
  `trigger_next_time` bigint NOT NULL DEFAULT '0' COMMENT '下次調(diào)度時(shí)間',
  `job_json` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT 'datax運(yùn)行腳本',
  `replace_param` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '動(dòng)態(tài)參數(shù)',
  `jvm_param` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'jvm參數(shù)',
  `inc_start_time` datetime DEFAULT NULL COMMENT '增量初始時(shí)間',
  `partition_info` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '分區(qū)信息',
  `last_handle_code` int DEFAULT '0' COMMENT '最近一次執(zhí)行狀態(tài)',
  `replace_param_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '增量時(shí)間格式',
  `reader_table` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'reader表名稱',
  `primary_key` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '增量表主鍵',
  `inc_start_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '增量初始id',
  `increment_type` tinyint DEFAULT '0' COMMENT '增量類型',
  `datasource_id` bigint DEFAULT NULL COMMENT '數(shù)據(jù)源id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `job_info`
--

LOCK TABLES `job_info` WRITE;
/*!40000 ALTER TABLE `job_info` DISABLE KEYS */;
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);
/*!40000 ALTER TABLE `job_info` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `job_jdbc_datasource`
--

DROP TABLE IF EXISTS `job_jdbc_datasource`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `job_jdbc_datasource` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增主鍵',
  `datasource_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '數(shù)據(jù)源名稱',
  `datasource` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '數(shù)據(jù)源',
  `datasource_group` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'Default' COMMENT '數(shù)據(jù)源分組',
  `database_name` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '數(shù)據(jù)庫名',
  `jdbc_username` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '用戶名',
  `jdbc_password` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '密碼',
  `jdbc_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'jdbc url',
  `jdbc_driver_class` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'jdbc驅(qū)動(dòng)類',
  `zk_adress` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '狀態(tài)：0刪除 1啟用 2禁用',
  `create_by` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '創(chuàng)建人',
  `create_date` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
  `update_by` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '更新人',
  `update_date` datetime DEFAULT NULL COMMENT '更新時(shí)間',
  `comments` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '備注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='jdbc數(shù)據(jù)源配置';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `job_jdbc_datasource`
--

LOCK TABLES `job_jdbc_datasource` WRITE;
/*!40000 ALTER TABLE `job_jdbc_datasource` DISABLE KEYS */;
INSERT INTO `job_jdbc_datasource` VALUES (6,'產(chǎn)品數(shù)據(jù)系統(tǒng)生產(chǎn)庫','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,'產(chǎn)品數(shù)據(jù)測(cè)試庫','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,'產(chǎn)品數(shù)據(jù)生產(chǎn)庫（只讀賬號(hào)）','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,'銷管測(cè)試庫','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','');
/*!40000 ALTER TABLE `job_jdbc_datasource` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `job_lock`
--

DROP TABLE IF EXISTS `job_lock`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `job_lock` (
  `lock_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '鎖名稱',
  PRIMARY KEY (`lock_name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `job_lock`
--

LOCK TABLES `job_lock` WRITE;
/*!40000 ALTER TABLE `job_lock` DISABLE KEYS */;
INSERT INTO `job_lock` VALUES ('schedule_lock');
/*!40000 ALTER TABLE `job_lock` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `job_log`
--

DROP TABLE IF EXISTS `job_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `job_log` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `job_group` int NOT NULL COMMENT '執(zhí)行器主鍵ID',
  `job_id` int NOT NULL COMMENT '任務(wù)，主鍵ID',
  `job_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `executor_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '執(zhí)行器地址，本次執(zhí)行的地址',
  `executor_handler` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '執(zhí)行器任務(wù)handler',
  `executor_param` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '執(zhí)行器任務(wù)參數(shù)',
  `executor_sharding_param` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '執(zhí)行器任務(wù)分片參數(shù)，格式如 1/2',
  `executor_fail_retry_count` int DEFAULT '0' COMMENT '失敗重試次數(shù)',
  `trigger_time` datetime DEFAULT NULL COMMENT '調(diào)度-時(shí)間',
  `trigger_code` int NOT NULL COMMENT '調(diào)度-結(jié)果',
  `trigger_msg` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '調(diào)度-日志',
  `handle_time` datetime DEFAULT NULL COMMENT '執(zhí)行-時(shí)間',
  `handle_code` int NOT NULL COMMENT '執(zhí)行-狀態(tài)',
  `handle_msg` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '執(zhí)行-日志',
  `alarm_status` tinyint NOT NULL DEFAULT '0' COMMENT '告警狀態(tài)：0-默認(rèn)、1-無需告警、2-告警成功、3-告警失敗',
  `process_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'datax進(jìn)程Id',
  `max_id` bigint DEFAULT NULL COMMENT '增量表max id',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `I_trigger_time` (`trigger_time`) USING BTREE,
  KEY `I_handle_code` (`handle_code`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=130 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `job_log`
--

LOCK TABLES `job_log` WRITE;
/*!40000 ALTER TABLE `job_log` DISABLE KEYS */;
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,'任務(wù)觸發(fā)類型：手動(dòng)觸發(fā)<br>調(diào)度機(jī)器：10.68.12.104<br>執(zhí)行器-注冊(cè)方式：自動(dòng)注冊(cè)<br>執(zhí)行器-地址列表：[10.68.12.104:9999]<br>路由策略：隨機(jī)<br>阻塞處理策略：丟棄后續(xù)調(diào)度<br>任務(wù)超時(shí)時(shí)間：0<br>失敗重試次數(shù)：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>觸發(fā)調(diào)度<<<<<<<<<<< </span><br>觸發(fā)調(diào)度：<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,'任務(wù)觸發(fā)類型：手動(dòng)觸發(fā)<br>調(diào)度機(jī)器：10.68.12.104<br>執(zhí)行器-注冊(cè)方式：自動(dòng)注冊(cè)<br>執(zhí)行器-地址列表：[10.68.12.104:9999]<br>路由策略：隨機(jī)<br>阻塞處理策略：丟棄后續(xù)調(diào)度<br>任務(wù)超時(shí)時(shí)間：0<br>失敗重試次數(shù)：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>觸發(fā)調(diào)度<<<<<<<<<<< </span><br>觸發(fā)調(diào)度：<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,'任務(wù)觸發(fā)類型：手動(dòng)觸發(fā)<br>調(diào)度機(jī)器：10.68.12.104<br>執(zhí)行器-注冊(cè)方式：自動(dòng)注冊(cè)<br>執(zhí)行器-地址列表：[10.68.12.104:9999]<br>路由策略：隨機(jī)<br>阻塞處理策略：丟棄后續(xù)調(diào)度<br>任務(wù)超時(shí)時(shí)間：0<br>失敗重試次數(shù)：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>觸發(fā)調(diào)度<<<<<<<<<<< </span><br>觸發(fā)調(diào)度：<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,'任務(wù)觸發(fā)類型：手動(dòng)觸發(fā)<br>調(diào)度機(jī)器：172.17.0.11<br>執(zhí)行器-注冊(cè)方式：自動(dòng)注冊(cè)<br>執(zhí)行器-地址列表：[10.68.12.104:9999, 172.17.0.11:9999]<br>路由策略：隨機(jī)<br>阻塞處理策略：丟棄后續(xù)調(diào)度<br>任務(wù)超時(shí)時(shí)間：0<br>失敗重試次數(shù)：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>觸發(fā)調(diào)度<<<<<<<<<<< </span><br>觸發(fā)調(diào)度：<br>address：10.68.12.104:9999<br>code：500<br>msg：glueType[DATAX] is not valid.',NULL,0,NULL,1,NULL,NULL);
/*!40000 ALTER TABLE `job_log` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `job_log_report`
--

DROP TABLE IF EXISTS `job_log_report`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `job_log_report` (
  `id` int NOT NULL AUTO_INCREMENT,
  `trigger_day` datetime DEFAULT NULL COMMENT '調(diào)度-時(shí)間',
  `running_count` int NOT NULL DEFAULT '0' COMMENT '運(yùn)行中-日志數(shù)量',
  `suc_count` int NOT NULL DEFAULT '0' COMMENT '執(zhí)行成功-日志數(shù)量',
  `fail_count` int NOT NULL DEFAULT '0' COMMENT '執(zhí)行失敗-日志數(shù)量',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `i_trigger_day` (`trigger_day`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `job_log_report`
--

LOCK TABLES `job_log_report` WRITE;
/*!40000 ALTER TABLE `job_log_report` DISABLE KEYS */;
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);
/*!40000 ALTER TABLE `job_log_report` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `job_logglue`
--

DROP TABLE IF EXISTS `job_logglue`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `job_logglue` (
  `id` int NOT NULL AUTO_INCREMENT,
  `job_id` int NOT NULL COMMENT '任務(wù)，主鍵ID',
  `glue_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'GLUE類型',
  `glue_source` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'GLUE源代碼',
  `glue_remark` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'GLUE備注',
  `add_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `job_logglue`
--

LOCK TABLES `job_logglue` WRITE;
/*!40000 ALTER TABLE `job_logglue` DISABLE KEYS */;
/*!40000 ALTER TABLE `job_logglue` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `job_permission`
--

DROP TABLE IF EXISTS `job_permission`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `job_permission` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '主鍵',
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '權(quán)限名',
  `description` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '權(quán)限描述',
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pid` int DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `job_permission`
--

LOCK TABLES `job_permission` WRITE;
/*!40000 ALTER TABLE `job_permission` DISABLE KEYS */;
/*!40000 ALTER TABLE `job_permission` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `job_project`
--

DROP TABLE IF EXISTS `job_project`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `job_project` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'key',
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'project name',
  `description` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `user_id` int DEFAULT NULL COMMENT 'creator id',
  `flag` tinyint DEFAULT '1' COMMENT '0 not available, 1 available',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT 'create time',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT 'update time',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `job_project`
--

LOCK TABLES `job_project` WRITE;
/*!40000 ALTER TABLE `job_project` DISABLE KEYS */;
INSERT INTO `job_project` VALUES (1,'study','hahhh',1,1,'2023-04-26 10:41:06','2023-04-26 10:41:06');
/*!40000 ALTER TABLE `job_project` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `job_registry`
--

DROP TABLE IF EXISTS `job_registry`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `job_registry` (
  `id` int NOT NULL AUTO_INCREMENT,
  `registry_group` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `registry_key` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `registry_value` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `cpu_usage` double DEFAULT NULL,
  `memory_usage` double DEFAULT NULL,
  `load_average` double DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `i_g_k_v` (`registry_group`,`registry_key`,`registry_value`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `job_registry`
--

LOCK TABLES `job_registry` WRITE;
/*!40000 ALTER TABLE `job_registry` DISABLE KEYS */;
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');
/*!40000 ALTER TABLE `job_registry` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `job_template`
--

DROP TABLE IF EXISTS `job_template`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `job_template` (
  `id` int NOT NULL AUTO_INCREMENT,
  `job_group` int NOT NULL COMMENT '執(zhí)行器主鍵ID',
  `job_cron` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任務(wù)執(zhí)行CRON',
  `job_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `add_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `user_id` int NOT NULL COMMENT '修改用戶',
  `alarm_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '報(bào)警郵件',
  `executor_route_strategy` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '執(zhí)行器路由策略',
  `executor_handler` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '執(zhí)行器任務(wù)handler',
  `executor_param` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '執(zhí)行器參數(shù)',
  `executor_block_strategy` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '阻塞處理策略',
  `executor_timeout` int NOT NULL DEFAULT '0' COMMENT '任務(wù)執(zhí)行超時(shí)時(shí)間，單位秒',
  `executor_fail_retry_count` int NOT NULL DEFAULT '0' COMMENT '失敗重試次數(shù)',
  `glue_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'GLUE類型',
  `glue_source` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'GLUE源代碼',
  `glue_remark` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'GLUE備注',
  `glue_updatetime` datetime DEFAULT NULL COMMENT 'GLUE更新時(shí)間',
  `child_jobid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '子任務(wù)ID，多個(gè)逗號(hào)分隔',
  `trigger_last_time` bigint NOT NULL DEFAULT '0' COMMENT '上次調(diào)度時(shí)間',
  `trigger_next_time` bigint NOT NULL DEFAULT '0' COMMENT '下次調(diào)度時(shí)間',
  `job_json` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT 'datax運(yùn)行腳本',
  `jvm_param` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'jvm參數(shù)',
  `project_id` int DEFAULT NULL COMMENT '所屬項(xiàng)目Id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `job_template`
--

LOCK TABLES `job_template` WRITE;
/*!40000 ALTER TABLE `job_template` DISABLE KEYS */;
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);
/*!40000 ALTER TABLE `job_template` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `job_user`
--

DROP TABLE IF EXISTS `job_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `job_user` (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '賬號(hào)',
  `password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '密碼',
  `role` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '角色：0-普通用戶、1-管理員',
  `permission` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '權(quán)限：執(zhí)行器ID列表，多個(gè)逗號(hào)分割',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `i_username` (`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `job_user`
--

LOCK TABLES `job_user` WRITE;
/*!40000 ALTER TABLE `job_user` DISABLE KEYS */;
INSERT INTO `job_user` VALUES (1,'admin','$2a$10$2KCqRbra0Yn2TwvkZxtfLuWuUP5KyCWsljO/ci5pLD27pqR3TV1vy','ROLE_ADMIN',NULL);
/*!40000 ALTER TABLE `job_user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping routines for database 'datax_web'
--
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2023-04-27 11:46:58
到了這里，關(guān)于docker 安裝 datax和datax-web 之 datax-web登錄時(shí)提示賬號(hào)或密碼錯(cuò)誤的文章就介紹完了。如果您還想了解更多內(nèi)容，請(qǐng)?jiān)谟疑辖撬阉鱐OY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！