[me.lucko.luckperms.lib.mariadb.Configuration] useSsl option is deprecated, replaced by option sslMode

[cwchristerw]

I didn't find anything about sslMode in https://luckperms.net/wiki/Storage-system-errors

[cwchristerw]

I have used useSSL: true and verifyServerCertificate: false for many years now but now it gives me "[me.lucko.luckperms.lib.mariadb.plugin.tls.main.DefaultTlsSocketPlugin] IPv4 host "10.254.1.xxx" doesn't correspond to certificate CN" error

[cwchristerw]

In my case I should use sslMode: REQUIRED (https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-connp-props-security.html)

[RalphORama]

I had this issue too. I think data.pool-settings.properties in config.yml can take arbitrary connection string values, so all you have to do is add a line that reads sslMode: <mode>

From HikariConnectionFactory.java

    /**
     * Sets the given connection properties onto the config.
     *
     * @param config the hikari config
     * @param properties the properties
     */
    protected void setProperties(HikariConfig config, Map<String, Object> properties) {
        for (Map.Entry<String, Object> property : properties.entrySet()) {
            config.addDataSourceProperty(property.getKey(), property.getValue());
        }
    }

my current config.yml (note that I am using MariaDB):

    properties:
      useUnicode: true
      characterEncoding: utf8
      sslMode: verify-full
      #useSSL: true
      #verifyServerCertificate: true