unsupported authentication method: mysql_clear_password

[michael1593]

error message:

when i try to connected mysql then alert exception.
mysql version: 8.0.22
maxwell version: 1.40.0

The config.properties part is as follows:

ssl=PREFERRED
jdbc_options=useSSL=true&requireSSL=false&verifyServerCertificate=false&serverTimezone=Asia/Shanghai&characterEncoding=utf-8
output_ddl=true
bootstrapper=sync
output_commit_info=false
ignore_producer_error=false
metrics_type=http
http_diagnostic=true

when i use dbeaver do it like this, It is normal for me to use dbeaver to connect to mysql, only use ssl is enabled, and the certificate is not verified

[osheroff]

paste your mysql config, please? also the row in mysql.user for whoever you're logging in as.

[michael1593]

The plugin in mysql.user is authentication_pam, and I use this user as a config to connect to mysql and it will prompt unsupported authentication method: mysql_clear_password, I use plugins for mysql_native_password no problem, do you not support plugins for authentication_pam users.

[michael1593]

I see that only mysql_native_password and caching_sha2_password are supported in the Class Authenticator, can you support mysql_clear_password in the future or maybe you already support it, but I'm using it in the wrong way?

[osheroff]

Ok i looked into this a little, and yes, we don't support clear_password based auth. PRs welcome though