← Back to team overview

maria-discuss team mailing list archive

SSL issue with Windows MariaDB client

 

Good morning,

Whilst testing SSL of a MariaDB server version 10.4.8 running Linux from a
Windows 10 machine I noted that connection using MySQL client
(mysql-8.0.18-winx64) connects successfully, however connections with
MariaDB client (mariadb-10.4.8-winx64) fails.

In case of MariaDB I have downloaded the file (
https://downloads.mariadb.org/interstitial/mariadb-10.4.8/winx64-packages/mariadb-10.4.8-winx64.zip/from/https%3A//mirror.serverion.com/mariadb),
whilst for MySQL client I used (
https://dev.mysql.com/downloads/file/?id=490026).


C:\temp\mariadb-10.4.8-winx64>mysql --user=penzk001 --password
--host=<hostname> --port=3306 --tls-version=TLSv1.2
--ssl-ca=c:\temp\CACert.pem
Enter password: ********
ERROR 2026 (HY000): Unknown SSL error (0x80090308)

C:\temp\mariadb-10.4.8-winx64\bin> cd ..\mysql-8.0.18-winx64\bin
C:\temp\mysql-8.0.18-winx64\bin>  mysql --user=penzk001 --password
--host=<hostname> --port=3306 --tls-version=TLSv1.2
--ssl-ca=c:\temp\CACert.pem
Welcome to the MySQL monitor.  Commands end with ; or \g.
...
mysql>\s
...
SSL:                    Cipher in use is DHE-RSA-AES128-GCM-SHA256
...
mysql>

To ensure that the SSL certificate is valid I also tried
"--ssl-mode=VERIFY_IDENTITY" with the mysql-8.0.18 client and it worked
fine.

Regards
Kenneth

Follow ups