MariaDB 10.5.x ODBC Access requires SSL certificates

Answered

Peter Kaye

• March 15, 2025 16:31

I have a server with several Drupal 10 sites using MariaDB 10.3.x.  ODBC access works fine. However with MariaDB 10.5 an SSL certificate is required.  The websites use Let's Encrypt to allow https connection. 

Can I use these certificates for ODBC connectivity? Or so I need to create new certificates created in cPanel or using OpenSSL? I need to provide values for the following for the ODBC driver: Key, Certificate, Certificate Authority, Ca Path and Cipher.

Any help much appreciated. Thanks.

 

• 

  Peter Kaye

  • March 17, 2025 00:11

  SOLVED!

  I'm wrong in saying that MariaDB 10.5 requires TLS keys for a remote ODBC connection. My problem was I failed to set up a wildcard entry under Remote Connections!  Sorry for my mistake.

  0
• 

  cPRex Jurassic Moderator

  • March 17, 2025 13:49

  I'm glad you found (and shared!!!!) the solution!

  0

Please sign in to leave a comment.