MySQL 8 JDBC Driver LDAP Authentication Issue: BadAuthenticationPlugin Error When Connecting to Doris

[zhenyue-xu]

Problem Description

I'm encountering an issue when trying to connect to Doris with LDAP authentication using MySQL 8 JDBC driver. The same approach works perfectly with MySQL 5 driver but fails with MySQL 8.

Error Message:

com.mysql.cj.exceptions.WrongArgumentException: !AuthenticationProvider.BadAuthenticationPlugin!

Working Solution with MySQL 5 Driver

Following the official Doris documentation https://doris.apache.org/docs/admin-manual/auth/ldap , I can successfully connect using MySQL 5 JDBC driver (com.mysql.jdbc.Driver) with this configuration:

Custom Plugin:

public class MysqlClearPasswordPluginWithoutSSL extends MysqlClearPasswordPlugin {
    @Override  
    public boolean requiresConfidentiality() {
        return false;
    }
}

Connection Configuration:

// MySQL 5 - WORKING ✅
connectionInfo.put("authenticationPlugins", "org.example.MysqlClearPasswordPluginWithoutSSL");
connectionInfo.put("defaultAuthenticationPlugin", "org.example.MysqlClearPasswordPluginWithoutSSL");
connectionInfo.put("disabledAuthenticationPlugins", "com.mysql.jdbc.authentication.MysqlNativePasswordPlugin");

Failed Attempt with MySQL 8 Driver

When using MySQL 8 JDBC driver (com.mysql.cj.jdbc.Driver), I tried adapting the configuration:

Custom Plugin for MySQL 8:

public class MySQL8LdapPlugin extends MysqlClearPasswordPlugin {
    @Override
    public boolean requiresConfidentiality() {
        return false;
    }
}

Connection Configuration:

// MySQL 8 - FAILING ❌
connectionInfo.put("authenticationPlugins", "org.example.MySQL8LdapPlugin");
connectionInfo.put("defaultAuthenticationPlugin", "org.example.MySQL8LdapPlugin");
connectionInfo.put("disabledAuthenticationPlugins", "com.mysql.cj.protocol.a.authentication.MysqlNativePasswordPlugin");

Questions

1. Is there official support for MySQL 8 JDBC driver with Doris LDAP authentication?
2. What's the correct way to implement the authentication plugin for MySQL 8 driver?
3. Are there any additional configuration parameters needed for MySQL 8?

Additional Information

The MySQL 8 driver architecture seems to have changed the authentication plugin system significantly compared to MySQL 5. The package names and class structures are different:

• MySQL 5: com.mysql.jdbc.authentication.*
• MySQL 8: com.mysql.cj.protocol.a.authentication.*

Any guidance on the correct approach for MySQL 8 LDAP authentication would be greatly appreciated!