I did a fresh install of XAMPP 8.2.0 in Windows 10 (
- Code: Select all
https://sourceforge.net/projects/xampp/files/XAMPP%20Windows/8.2.0/xampp-windows-x64-8.2.0-0-VS16-installer.exe
I created the neccessary certificates for server and client and changed the my.ini file and restarted MySQL.
I added this to my.ini:
- Code: Select all
### MySQL Server ###
## Securing the Database with ssl option and certificates ##
## There is no control over the protocol level used. ##
## mariadb will use TLSv1.0 or better. ##
ssl=1
ssl-ca=d:/apachefriends/xampp/mysql/ssl/ssl.crt/ca-cert.pem
ssl-cert=d:/apachefriends/xampp/mysql/ssl/ssl.crt/server-cert.pem
ssl-key=d:/apachefriends/xampp/mysql/ssl/ssl.key/server-key.pem
When I look if SSL is activated in MySQL I am getting this:
- Code: Select all
show variables like '%ssl%';
have_openssl NO
have_ssl YES
ssl_ca d:/apachefriends/xampp/mysql/ssl/ssl.crt/ca-cert.p...
ssl_capath
ssl_cert d:/apachefriends/xampp/mysql/ssl/ssl.crt/server-ce...
ssl_cipher
ssl_crl
ssl_crlpath
ssl_key d:/apachefriends/xampp/mysql/ssl/ssl.key/server-ke...
version_ssl_library WolfSSL 5.5.1
When I am trying to connect I am getting this:
- Code: Select all
mysql -u xxxxx -p --ssl-ca=ca-cert.pem --ssl-cert=client-cert.pem --ssl-key=client-key.pem
ERROR 2026 (HY000): SSL connection error: An unknown error occurred while processing the certificate. Error 0x80090327(SEC_E_CERT_UNKNOWN)
The strange thing is that "have_openssl" is "NO". In every guide I saw that this is "YES". So it looks like OpenSSL is not included in this MySQL version.
Is this possible?
Where can I find a MySQL which has OpenSSL included?
Or what am I doing wrong?