mysql的连接无法设置一些参数

[zackyoungh]

代码如下

public static final String JDBC_URL_PATTERN =
            "jdbc:mysql://%s:%s/?useInformationSchema=true&nullCatalogMeansCurrent=false&useUnicode=true&characterEncoding=UTF-8&characterSetResults=UTF-8&zeroDateTimeBehavior=CONVERT_TO_NULL";

如果我想加上userSSL=false,这时候应该怎么弄；
不让老是碰到

No appropriate protocol (protocol is disabled or cipher suites are inappropriate)

得手动修改java.security才能解决

希望这连接参数配置优化一下

[leonardBang]

It makes sense to me, could you change the title and description in English ?

[ashulin]

I have the same requirement，maybe we can add a connection.pool.url.* options similar to debezium.*;

[miaogr86]

@leonardBang 数据库连接地址上增加userSSL=false 可以解决，但是怎么可以增加这个参数

[qq443672581]

1. 下载对应版本的源码
2. 找到 PooledDataSourceFactory 添加useSSL=false 参数
3. flink-connector-mysql-cdc 模块下 mvn spotless:apply
4. flink-connector-mysql-cdc 模块下 mvn install 替换maven仓库中官方的jar即可

[paul8263]

Hi @leonardBang ,
This issue is related to #674

I think we should allow user to add or even customize the JDBC URL parameters by configurations.

I'd like to help . Could you please assign this issue to me?

[paul8263]

Hi @leonardBang ,
Considering #674 , can we only set

useInformationSchema=true&nullCatalogMeansCurrent=false&useUnicode=true&characterEncoding=UTF-8&characterSetResults=UTF-8

as mandatory parameters and

zeroDateTimeBehavior=CONVERT_TO_NULL

as the default optional value?
Thus the user will be able to overwrite 'zeroDateTimeBehavior=CONVERT_TO_NULL' and add custom ones so that those compatibility issues can be avoided.

[leonardBang]

Could you use English for better communication? feel free to reopen once updated the description.

[ruanhang1993]

When fix the bug #1188, I find that the jdbc properties are not set to the connection rightly. This issue should be reopened and fixed again.

[ruanhang1993]

I am willing to help to fix this ticket and add some IT tests.

[leonardBang]

Thanks @ruanhang1993 for taking this, I've assigned this ticket to you.