做网站完整过程,伊通县建设局网站,wordpress中文标题404,自贡权威发布CentOs7.x安装部署SeaTunnelWeb遇到的坑 文章目录 1. 环境2. SeaTunnel安装部署2.1下载安装包2.2 设置环境变量2.3 安装连接器插件2.4 拷贝jar包到lib下2.5 启动命令2.6 执行官方client提交任务demo 3. SeaTunnel-Web安装部署3.1 下载安装包3.2 初始化数据库脚本或修改配置appl…CentOs7.x安装部署SeaTunnelWeb遇到的坑 文章目录 1. 环境2. SeaTunnel安装部署2.1下载安装包2.2 设置环境变量2.3 安装连接器插件2.4 拷贝jar包到lib下2.5 启动命令2.6 执行官方client提交任务demo 3. SeaTunnel-Web安装部署3.1 下载安装包3.2 初始化数据库脚本或修改配置application.yml中的数据库连接信息3.2.1 不使用它的初始化脚本自动创建3.2.2 使用脚本初始化数据库 3.3 修改端口与数据源3.4 两个文件拷贝配置3.5 拷贝jar到lib下3.6 启动3.7 访问首页3.8 执行myslq-jdbc--mysl-jdbc的单表数据同步 4. 总结 1. 环境 采用的是虚拟机上安装CentOs7.x安装java15环境安装mysql8.0.28这两步骤省略之前的文章里面有讲属于基础环境配置也比较简单说明我用的是一台CentOs7.x的虚拟机实例都安装在一台上面需要开放8081、3306和5801的防火墙不然会网络访问不到。
2. SeaTunnel安装部署
2.1下载安装包
export version2.3.3
wget https://archive.apache.org/dist/seatunnel/${version}/apache-seatunnel-${version}-bin.tar.gz
tar -xzvf apache-seatunnel-${version}-bin.tar.gz2.2 设置环境变量
vi /etc/profile.d/seatunnel.sh
# 新增如下变量
export SEATUNNEL_HOME/root/apache-seatunnel-2.3.3 #这里设置的是seatunnel的解压目录即可
export PATH$PATH:$SEATUNNEL_HOME/bin然后执行source /etc/profile
2.3 安装连接器插件 进入/root/apache-seatunnel-2.3.3路径下执行安装连接器插件 sh bin/install-plugin.sh 2.3.3可以修改/root/apache-seatunnel-2.3.3/connectors下的plugin-mapping.properties文件根据需要加入连接器插件把不需要的连接器插件名称删除留下需要的即可然后执行上面的安装命令由于我没有修改这个文件默认安装的是全部的连接器插件所以需要一点时间下载速度取决于网速。
2.4 拷贝jar包到lib下 2.5 启动命令 进入/root/apache-seatunnel-2.3.3路径下执行启动命令
sh bin/seatunnel-cluster.sh -d -DJvmOption-Xms1G -Xmx1G
或者
nohup sh bin/seatunnel-cluster.sh 21 jps查看seatunnel的进程如下 查看logs下的日志均正常输出没有报错说明启动成功然后执行下面的官方demo没有报错说明seatunnel启动是正常的。
2.6 执行官方client提交任务demo 进入/root/apache-seatunnel-2.3.3路径下执行启动命令
$SEATUNNEL_HOME/bin/seatunnel.sh --config $SEATUNNEL_HOME/config/v2.batch.config.template该命令来自于官网执行结果如下
[rootes1 apache-seatunnel-2.3.3]# $SEATUNNEL_HOME/bin/seatunnel.sh --config $SEATUNNEL_HOME/config/v2.batch.config.template
WARNING: sun.reflect.Reflection.getCallerClass is not supported. This will impact performance.
12月 19, 2023 12:11:20 上午 com.hazelcast.internal.config.AbstractConfigLocator
信息: Loading configuration /root/apache-seatunnel-2.3.3/config/seatunnel.yaml from System property seatunnel.config
12月 19, 2023 12:11:20 上午 com.hazelcast.internal.config.AbstractConfigLocator
信息: Using configuration file at /root/apache-seatunnel-2.3.3/config/seatunnel.yaml
12月 19, 2023 12:11:20 上午 org.apache.seatunnel.engine.common.config.SeaTunnelConfig
信息: seatunnel.home is /root/apache-seatunnel-2.3.3
12月 19, 2023 12:11:20 上午 com.hazelcast.internal.config.AbstractConfigLocator
信息: Loading configuration /root/apache-seatunnel-2.3.3/config/hazelcast.yaml from System property hazelcast.config
12月 19, 2023 12:11:20 上午 com.hazelcast.internal.config.AbstractConfigLocator
信息: Using configuration file at /root/apache-seatunnel-2.3.3/config/hazelcast.yaml
12月 19, 2023 12:11:20 上午 com.hazelcast.internal.config.AbstractConfigLocator
信息: Loading configuration /root/apache-seatunnel-2.3.3/config/hazelcast-client.yaml from System property hazelcast.client.config
12月 19, 2023 12:11:20 上午 com.hazelcast.internal.config.AbstractConfigLocator
信息: Using configuration file at /root/apache-seatunnel-2.3.3/config/hazelcast-client.yaml
2023-12-19 00:11:21,149 INFO com.hazelcast.client.impl.spi.ClientInvocationService - hz.client_1 [seatunnel] [5.1] Running with 2 response threads, dynamictrue
2023-12-19 00:11:21,233 INFO com.hazelcast.core.LifecycleService - hz.client_1 [seatunnel] [5.1] HazelcastClient 5.1 (20220228 - 21f20e7) is STARTING
2023-12-19 00:11:21,234 INFO com.hazelcast.core.LifecycleService - hz.client_1 [seatunnel] [5.1] HazelcastClient 5.1 (20220228 - 21f20e7) is STARTED
WARNING: An illegal reflective access operation has occurred
WARNING: Illegal reflective access by com.hazelcast.internal.networking.nio.SelectorOptimizer (file:/root/apache-seatunnel-2.3.3/starter/seatunnel-starter.jar) to field sun.nio.ch.SelectorImpl.selectedKeys
WARNING: Please consider reporting this to the maintainers of com.hazelcast.internal.networking.nio.SelectorOptimizer
WARNING: Use --illegal-accesswarn to enable warnings of further illegal reflective access operations
WARNING: All illegal access operations will be denied in a future release
2023-12-19 00:11:21,294 INFO com.hazelcast.client.impl.connection.ClientConnectionManager - hz.client_1 [seatunnel] [5.1] Trying to connect to cluster: seatunnel
2023-12-19 00:11:21,298 INFO com.hazelcast.client.impl.connection.ClientConnectionManager - hz.client_1 [seatunnel] [5.1] Trying to connect to [localhost]:5801
2023-12-19 00:11:21,352 INFO com.hazelcast.core.LifecycleService - hz.client_1 [seatunnel] [5.1] HazelcastClient 5.1 (20220228 - 21f20e7) is CLIENT_CONNECTED
2023-12-19 00:11:21,352 INFO com.hazelcast.client.impl.connection.ClientConnectionManager - hz.client_1 [seatunnel] [5.1] Authenticated with server [localhost]:5801:772efc0a-4c18-4a4b-baa7-b82b9ae4a395, server version: 5.1, local address: /127.0.0.1:36095
2023-12-19 00:11:21,356 INFO com.hazelcast.internal.diagnostics.Diagnostics - hz.client_1 [seatunnel] [5.1] Diagnostics disabled. To enable add -Dhazelcast.diagnostics.enabledtrue to the JVM arguments.
2023-12-19 00:11:21,384 INFO com.hazelcast.client.impl.spi.ClientClusterService - hz.client_1 [seatunnel] [5.1] Members [1] {Member [localhost]:5801 - 772efc0a-4c18-4a4b-baa7-b82b9ae4a395
}2023-12-19 00:11:21,421 INFO com.hazelcast.client.impl.statistics.ClientStatisticsService - Client statistics is enabled with period 5 seconds.
2023-12-19 00:11:21,706 INFO org.apache.seatunnel.engine.client.job.JobExecutionEnvironment - add common jar in plugins :[]
2023-12-19 00:11:21,733 INFO org.apache.seatunnel.core.starter.utils.ConfigBuilder - Loading config file from path: /root/apache-seatunnel-2.3.3/config/v2.batch.config.template
2023-12-19 00:11:21,799 INFO org.apache.seatunnel.core.starter.utils.ConfigShadeUtils - Load config shade spi: [base64]
2023-12-19 00:11:21,848 INFO org.apache.seatunnel.core.starter.utils.ConfigBuilder - Parsed config file: {env : {execution.parallelism : 2,job.mode : BATCH,checkpoint.interval : 10000},source : [{schema : {fields : {name : string,age : int}},row.num : 16,parallelism : 2,result_table_name : fake,plugin_name : FakeSource}],sink : [{plugin_name : Console}]
}2023-12-19 00:11:21,885 INFO org.apache.seatunnel.api.configuration.ReadonlyConfig - Config uses fallback configuration key plugin_name instead of key factory
2023-12-19 00:11:21,886 INFO org.apache.seatunnel.api.configuration.ReadonlyConfig - Config uses fallback configuration key plugin_name instead of key factory
2023-12-19 00:11:21,895 INFO org.apache.seatunnel.plugin.discovery.AbstractPluginDiscovery - Load SeaTunnelSink Plugin from /root/apache-seatunnel-2.3.3/connectors/seatunnel
2023-12-19 00:11:21,911 INFO org.apache.seatunnel.plugin.discovery.AbstractPluginDiscovery - Discovery plugin jar: FakeSource at: file:/root/apache-seatunnel-2.3.3/connectors/seatunnel/connector-fake-2.3.3.jar
2023-12-19 00:11:21,912 INFO org.apache.seatunnel.plugin.discovery.AbstractPluginDiscovery - Discovery plugin jar: Console at: file:/root/apache-seatunnel-2.3.3/connectors/seatunnel/connector-console-2.3.3.jar
2023-12-19 00:11:21,915 INFO org.apache.seatunnel.engine.core.parse.ConfigParserUtil - Currently, incorrect configuration of source_table_name and result_table_name options dont affect job running. In the future we will ban incorrect configurations.
2023-12-19 00:11:21,915 INFO org.apache.seatunnel.api.configuration.ReadonlyConfig - Config uses fallback configuration key plugin_name instead of key factory
2023-12-19 00:11:21,915 INFO org.apache.seatunnel.api.configuration.ReadonlyConfig - Config uses fallback configuration key plugin_name instead of key factory
2023-12-19 00:11:21,916 WARN org.apache.seatunnel.engine.core.parse.ConfigParserUtil - This configuration is not recommended. A source/transform(FakeSource) is configured with result_table_name option value of fake, but subsequent transform/sink(Console) is not configured with source_table_name option.
2023-12-19 00:11:21,919 INFO org.apache.seatunnel.engine.core.parse.MultipleTableJobConfigParser - start generating all sources.
2023-12-19 00:11:21,919 INFO org.apache.seatunnel.api.configuration.ReadonlyConfig - Config uses fallback configuration key plugin_name instead of key factory
2023-12-19 00:11:21,953 INFO org.apache.seatunnel.plugin.discovery.AbstractPluginDiscovery - Load SeaTunnelSource Plugin from /root/apache-seatunnel-2.3.3/connectors/seatunnel
2023-12-19 00:11:21,970 INFO org.apache.seatunnel.plugin.discovery.AbstractPluginDiscovery - Discovery plugin jar: FakeSource at: file:/root/apache-seatunnel-2.3.3/connectors/seatunnel/connector-fake-2.3.3.jar
2023-12-19 00:11:21,974 INFO org.apache.seatunnel.plugin.discovery.AbstractPluginDiscovery - Load plugin: PluginIdentifier{engineTypeseatunnel, pluginTypesource, pluginNameFakeSource} from classpath
2023-12-19 00:11:22,003 INFO org.apache.seatunnel.engine.core.parse.MultipleTableJobConfigParser - start generating all transforms.
2023-12-19 00:11:22,003 INFO org.apache.seatunnel.engine.core.parse.MultipleTableJobConfigParser - start generating all sinks.
2023-12-19 00:11:22,004 INFO org.apache.seatunnel.api.configuration.ReadonlyConfig - Config uses fallback configuration key plugin_name instead of key factory
2023-12-19 00:11:22,011 INFO org.apache.seatunnel.api.configuration.ReadonlyConfig - Config uses fallback configuration key plugin_name instead of key factory
2023-12-19 00:11:22,090 INFO org.apache.seatunnel.engine.client.job.ClientJobProxy - Start submit job, job id: 789162834679300097, with plugin jar [file:/root/apache-seatunnel-2.3.3/connectors/seatunnel/connector-fake-2.3.3.jar, file:/root/apache-seatunnel-2.3.3/connectors/seatunnel/connector-console-2.3.3.jar]
2023-12-19 00:11:22,893 INFO org.apache.seatunnel.engine.client.job.ClientJobProxy - Submit job finished, job id: 789162834679300097, job name: SeaTunnel
2023-12-19 00:11:22,956 WARN org.apache.seatunnel.engine.client.job.JobMetricsRunner - Failed to get job metrics summary, it maybe first-run
2023-12-19 00:11:24,370 INFO org.apache.seatunnel.engine.client.job.ClientJobProxy - Job (789162834679300097) end with state FINISHED
2023-12-19 00:11:24,416 INFO org.apache.seatunnel.core.starter.seatunnel.command.ClientExecuteCommand -
***********************************************Job Statistic Information
***********************************************
Start Time : 2023-12-19 00:11:21
End Time : 2023-12-19 00:11:24
Total Time(s) : 2
Total Read Count : 32
Total Write Count : 32
Total Failed Count : 0
***********************************************2023-12-19 00:11:24,416 INFO com.hazelcast.core.LifecycleService - hz.client_1 [seatunnel] [5.1] HazelcastClient 5.1 (20220228 - 21f20e7) is SHUTTING_DOWN
2023-12-19 00:11:24,422 INFO com.hazelcast.client.impl.connection.ClientConnectionManager - hz.client_1 [seatunnel] [5.1] Removed connection to endpoint: [localhost]:5801:772efc0a-4c18-4a4b-baa7-b82b9ae4a395, connection: ClientConnection{alivefalse, connectionId1, channelNioChannel{/127.0.0.1:36095-localhost/127.0.0.1:5801}, remoteAddress[localhost]:5801, lastReadTime2023-12-19 00:11:24.411, lastWriteTime2023-12-19 00:11:24.371, closedTime2023-12-19 00:11:24.420, connected server version5.1}
2023-12-19 00:11:24,422 INFO com.hazelcast.core.LifecycleService - hz.client_1 [seatunnel] [5.1] HazelcastClient 5.1 (20220228 - 21f20e7) is CLIENT_DISCONNECTED
2023-12-19 00:11:24,431 INFO com.hazelcast.core.LifecycleService - hz.client_1 [seatunnel] [5.1] HazelcastClient 5.1 (20220228 - 21f20e7) is SHUTDOWN
2023-12-19 00:11:24,433 INFO org.apache.seatunnel.core.starter.seatunnel.command.ClientExecuteCommand - Closed SeaTunnel client......
2023-12-19 00:11:24,433 INFO org.apache.seatunnel.core.starter.seatunnel.command.ClientExecuteCommand - Closed metrics executor service ......
2023-12-19 00:11:24,438 INFO org.apache.seatunnel.core.starter.seatunnel.command.ClientExecuteCommand - run shutdown hook because get close signal3. SeaTunnel-Web安装部署
3.1 下载安装包 安装包下在地址如下
https://seatunnel.apache.org/download解压
tar -zxvf apache-seatunnel-web-bin-${project.version}.tar.gz解压目录如下 3.2 初始化数据库脚本或修改配置application.yml中的数据库连接信息
3.2.1 不使用它的初始化脚本自动创建 事先手动执行好脚本然后在修改application.yml文件中的数据库连接信息
3.2.2 使用脚本初始化数据库 首先设置变量如下
export HOSTNAMElocalhost
export PORT3306
export USERNAMEroot
export PASSWORD123456然后执行
sh apache-seatunnel-web-bin-2.3.3/script/init_sql.sh如果环境变量有冲突需要改下名字和init_sql.sh中的环境变量的名字可以加一个前缀可以加上前缀STWEB_ 然后把init_sql.sh中上面的那几个环境变量也加上这个前缀即可然后执行初始化命令
3.3 修改端口与数据源
vim conf/application.yml修改端口号和数据源信息 3.4 两个文件拷贝配置 需要将apache-seatunnel-2.3.3/config/hazelcast-client和apache-seatunnel-2.3.3/connectors/plugin-mapping.properties文件拷贝到apache-seatunnel-web-bin-2.3.3的conf下。
3.5 拷贝jar到lib下 3.6 启动
sh bin/seatunnel-backend-daemon.sh startjps查看java进程如下 这里有个很坑的地方就是执行命令如果是进入bin路径执行访问首页的时候就会有问题访问首页就会报404的错
sh seatunnel-backend-daemon.sh start访问首页报错如下 3.7 访问首页 访问ip:8081/ui此端口为conf/application.yml中配置的端口
http://192.168.1.4:8081/登录不上有可能是没有启动mysql数据库
service mysqld start #使用service启动mysql服务
service mysqld status #查看MYSQL运行状态
service mysqld stop #使用service停止mysql服务
service mysqld restart #使用service重启mysql服务
systemctl enable mysqld.service #设置MySQL服务开机自动启动
systemctl is-enabled mysqld.service #确认MySQL服务已经被设置为自动启动3.8 执行myslq-jdbc–mysl-jdbc的单表数据同步 执行是成功的但是在我的CentOs7.x的虚拟机上我是没有安装hadoop3.1.3的环境执行看日志是没有报错的官方说是这个hadoop的环境不是必须的也是有道理的但是之前的文章在本地调试的时候没有hadoop环境会报错所以建议需要本地编译构建的小伙伴还是安装一个hadoop以免执行任务报错。
4. 总结 本次分享就到此结束了踩了一些坑还是请教了官方的大佬才知道的是哪里有问题希望我的分享对你有所帮助请一键三连么么么哒
