The Validating Certificate Test Doesn't Prompt to Select a New Certificate

Issue

I have obtained and installed a new certificate. However, when I test my connection, the Validating Certificate Test detects the old certificate and doesn't prompt me to select the new certificate.

Environment

Connector: MariaDB

Resolution

To resolve this issue, do the following:

1. Depending on your MariaDB version, do the following:
   • For versions 10.4 and above, use the FLUSH SSL command to dynamically update and reload the certificate files.
   • For versions below 10.4, restart your database.
2. In Fivetran, go to your MariaDB connector page.
3. Select the Setup tab.
4. Click Test connection.
5. The Validating Certificate Test generates a pop-up window. Choose the new certificate.

Cause

This issue occurs when you install a new certificate, but MariaDB continues to serve the old certificate until you refresh the SSL context.