Doesn’t work while –require_secure_transport=ON

I’m so glad y’all had the thread you did here and here because it got me close to the answer! My client had the exact same issue with their WordPress site hosted on Azure App Service and using the Azure Database for MySQL flexible server. When trying to login, the first error would be:

Connections using insecure transport are prohibited while –require_secure_transport=ON

And then would get stuck in an infitinite loop, eventually stopping when a new error would lock me out for 30 minutes for too many failed attempts.

Unfortunately, overriding the class in a must-use plugin as you suggeted didn’t work, mainly because your PEXLECHRIS_ADMINER_DIR constant is not defined yet since must-use plugins are executed before other plugins, causing a fatal error.

In the end, I added the function to your class with a filter like this:

File: /wp-content/plugins/pexlechris-adminer/inc/class-pexlechris-adminer.php inserted at line 20

function connectSsl() {
    $conn = apply_filters('pexlechris_adminer_connectssl', array());
    if (is_array($conn)) return $conn;

    return array();
}

And then in my environment, I downloaded the DigiCertGlobalRootCA.crt.pem file (from here) and placed it in the html directory next to the directory where I have my WordPress installation and then added this code to my must-use plugin:

function au_adminer_connection_ssl($conn)
{
    // Go up to the parent directory "www" and into the "html" directory
    $adminer_crt = dirname(ABSPATH, 1) . '/html/DigiCertGlobalRootCA.crt.pem';
    if (file_exists($adminer_crt)) {
        $conn['ca'] = $adminer_crt;
    }
    return $conn;
}
add_filter('pexlechris_adminer_connectssl', 'au_adminer_connection_ssl');

With that, your plugin worked like a charm! I’d be grateful if you could include the connectSsl() function and filter in a future plugin update. Thank you!