flink sink to mysql红色警告: WARN: Establishing SSL connect

最新推荐文章于 2024-07-23 14:18:49 发布

Thomas2143

最新推荐文章于 2024-07-23 14:18:49 发布

阅读量469

点赞数

分类专栏：总结

本文链接：https://blog.youkuaiyun.com/qq_35515661/article/details/118146476

版权

总结专栏收录该内容

791 篇文章 ¥99.90 ¥299.90

订阅专栏

在使用Flink将数据sink到MySQL时遇到警告：Establishing SSL connection without server's identity verification is not recommended。该警告提示不应建立未验证服务器身份的SSL连接。为遵循MySQL 5.5.45+等版本的要求，应默认使用SSL连接，除非明确设置useSSL=false。解决方案是在jdbc URL中添加配置来处理SSL验证问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

当sink到mysql的时候出现下面的红色文字警告.

警告信息

Tue Jun 22 18:13:16 CST 2021 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification

解决方法

jdbc中的url添加

useSSL=false

 // sink to sink_person
        tableEnv.executeSql(
            """

了解本专栏

订阅专栏解锁全文

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

Thomas2143

关注关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
分享

复制链接

分享到 QQ

分享到新浪微博

扫一扫
打赏
打赏
打赏举报

举报

专栏目录

订阅专栏

Windows PC上创建大数据职业技能竞赛实验环境之三--Spark、Hive、Flume、Kafka和Flink环境的搭建

liu9ang的博客

04-10

2348

在前述hadoop-base基础容器环境的基础上，实现Spark、Hive、Flume、kafka和Flink实验环境的搭建。我们已将前述的hadoop-base基础容器进行可阶段的保存： sudo docker commit "hadoop base v3" hadoop-base centos/hadoop-base:v3 现在，如果已经将前述作业的hadoop-base容器停用并删除，用保存的centos/hadoop-base:v3镜像重新开启hadoop-base容器。加入共享目录，暴露ss

创建flink项目时右边的全部爆红

weixin_45793819的博客

07-08

510

右边的爆红原因： scala的SDK版本问题，和flink的版本不兼容，之前使用的是scala 2.11.18,本本问题解决措施 1重新下载scala的SDK 链接：https://pan.baidu.com/s/1bMJ9uVY3RZ3o_wzNvYCIGg 提取码：a3p4 下载完解压后安装sdk 2 配置SDK的环境变量验证是否安装成功修改下IDEA的SDK ...

参与评论您还未登录，请先登录后发表或查看评论

Mysql使用SSL连接

weixin_44462773的博客

09-27

1万+

Mysql使用SSL连接1.描述2.安装 OpenSSL3. 使用 OpenSSL 创建 SSL 证书和私钥3.1 修改mysql 的my.ini配置文件3.2 创建 SSL 证书和私钥3.3 验证是否连接成功4. 添加信任证书到密钥库5.jdbc访问 1.描述项目部署时要求对数据库进行加密连接，需要用到SSL连接，记录一下。首先在 MySQL 上执行如下命令, 查询当前版本的mysql是否支持 SSL: show variables like '%ssl%'; 当 have

Establishing SSL connection without server's identity verification is not recommended的简单解决方案

大鱼的博客

09-26

706

运行mybatis是出现警告： Wed Sep 26 20:25:47 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements...

二百、Flink——Flink写入MySQL报错：Establishing SSL connection without server‘s identity verification is not r

tiantang2renjian的博客

11-01

308

Flink写入MySQL报错：Establishing SSL connection without server's identity verification is not recommended

连接mysql数据库警告： Establishing SSL connection without server‘s identity verification is not recommended.

hahaha_1112的博客

02-18

4405

连接mysql数据库警告： Establishing SSL connection without server's identity verification is not recommended.

WARN: Establishing SSL connection without server‘s identity verificatio

qq_42730111的博客

07-24

654

问题出处：使用数据源连接数据的时候问题原因：警告：不建议在没有服务器身份验证的情况下建立SSL连接。根据MySQL 5.5.45+、5.6.26+和5.7.6+的要求，如果没有设置explicit选项，默认情况下必须建立SSL连接。为了符合不使用SSL的现有应用程序，verifyServerCertificate属性设置为“false”。您需要通过设置useSSL=false显式禁用SSL，或者设置useSSL=true并为服务器证书验证提供信任库。解决方法：跳过SSL校验解决一： "jdbc:mys

解决Establishing SSL connection without server‘s identity verification is not recommended.

TLJava^v^的博客

06-06

6922

每次从数据库中进行查询或者其他操作控制台都会出现以下警告，虽说不是error，但是很显眼。。Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit optio

【已解决】Flink连接JDBC报错 org.apache.flink.runtime.client.JobExecutionException: Job execution failed.

qq_31412425的博客

06-10

4596

true修改为false即可。集成环境Idea2020。

pip安装出现的问题之SSL，一大堆WARNING问题

热门推荐

君兮月影的博客

07-09

5万+

WARN: Establishing SSL connection without server's identity verification is not recommended 的解决方法

解决IDEA中Maven加载依赖包慢的问题

p15097962069的博客

11-10

388

解决IDEA中Maven加载依赖包慢的问题

连接数据库时出现WARN: Establishing SSL connection without server‘s identity verification is not recommended.

zhangkai__的博客

07-02

4497

连接数据库时出现WARN: Establishing SSL connection without server‘s identity verification is not recommended.

解决“WARN: Establishing SSL connection without server‘s identity verification is not recommended.”问题

qq_53388511的博客

05-11

2万+

解决Spring Boot中遇到的“WARN: Establishing SSL connection without server's identity verification is not recommended.”问题

springmvc 配置数据库连接池报错 Establishing SSL connection without server's identi

ppwwp的专栏

02-11

854

Establishing SSL connection without server’s identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if e...

警告:Establishing SSL connection without server’s identity verification is not recommended的解决

曰业而安的博客

05-30

1502

在springBoot项目启动时红色警告： Sat May 30 11:07:33 CST 2020 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if ex

解决Hive的Establishing SSL connection without server's identity verification is not recommended问题

someby的博客

10-13

2451

问题描述： hive> Sat Oct 13 15:36:32 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SS...