maria-discuss team mailing list archive
-
maria-discuss team
-
Mailing list archive
-
Message #05669
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