I have to make my MariaDB authentication a bit safer than default. I tried to set up SSL support for this, but found only an old howto here:
How to enable MySQL SSL on Ubuntu
I followed it, however after checking I get this:
MariaDB [(none)]> show variables like "%ssl%";
+---------------+----------------------------+
| Variable_name | Value |
+---------------+----------------------------+
| have_openssl | NO |
| have_ssl | DISABLED |
| ssl_ca | /etc/mysql/ca-cert.pem |
| ssl_capath | |
| ssl_cert | /etc/mysql/server-cert.pem |
| ssl_cipher | |
| ssl_crl | |
| ssl_crlpath | |
| ssl_key | /etc/mysql/server-key.pem |
+---------------+----------------------------+
9 rows in set (0.00 sec)
MariaDB [(none)]> \s
...
SSL: not in use
...
This source was written in 2011. Maybe it is outdated, or I've made a mistake somewhere. When I generated .pems
there were no errors. My /var/log/mysql/error.log
file is empty.
Do you have any ideas?
ssl
appears not to be set-up. Start your your research here: MariaDB secure connection. mariadb.com/kb/en/mariadb/secure-connections-overview