# Setup issues SSL/TLS to MariaDB

**URL:** https://dietpi.com/forum/t/setup-issues-ssl-tls-to-mariadb/2691
**Category:** Troubleshooting
**Created:** [13 November 2018 12:29 UTC](https://dietpi.com/forum/t/setup-issues-ssl-tls-to-mariadb/2691 "2018-11-13T12:29:12Z")
**Posts on this page:** 1
**Showing post:** 1

<div class="post-metadata">

### Author: ![PiOSFan](https://dietpi.com/forum/letter_avatar_proxy/v4/letter/p/a88e4f/32.png) [@PiOSFan](https://dietpi.com/forum/u/PiOSFan)
#### Post date: [13 November 2018 12:29 UTC](https://dietpi.com/forum/t/setup-issues-ssl-tls-to-mariadb/2691/1 "2018-11-13T12:29:12Z")

</div>

Hi everyone,  
I set up a LAMP Environment on my Raspi 3. As I would like to make the MariaDB available from clients in the Internet, I was looking for a solution to use SSL for encryption. I used this manual:  
[https://www.cyberciti.biz/faq/how-to-setup-mariadb-ssl-and-secure-connections-from-clients/](https://www.cyberciti.biz/faq/how-to-setup-mariadb-ssl-and-secure-connections-from-clients/)

Everything works fine until I set ssl\_cert = /etc/mysql/ssl/server-cert.pem. In this case the variable have\_ssl changes to DISABLED.

MariaDB [(none)]\> SHOW VARIABLES LIKE ‘%ssl%’;

```nohighlight
+---------------------+----------------------------+
| Variable_name | Value |
+---------------------+----------------------------+
| have_openssl | NO |
| have_ssl | YES |
| ssl_ca | /etc/mysql/ssl/ca-cert.pem |
| ssl_capath | /etc/mysql/capath |
| ssl_cert | |
| ssl_cipher | |
| ssl_crl | |
| ssl_crlpath | |
| ssl_key | |
| version_ssl_library | YaSSL 2.4.2 |
+---------------------+----------------------------+

```

```nohighlight
MariaDB [(none)]> SHOW VARIABLES LIKE '%ssl%';
+---------------------+--------------------------------+
| Variable_name | Value |
+---------------------+--------------------------------+
| have_openssl | NO |
| have_ssl | DISABLED |
| ssl_ca | /etc/mysql/ssl/ca-cert.pem |
| ssl_capath | /etc/mysql/capath |
| ssl_cert | /etc/mysql/ssl/server-cert.pem |
| ssl_cipher | |
| ssl_crl | |
| ssl_crlpath | |
| ssl_key | |
| version_ssl_library | YaSSL 2.4.2 |
+---------------------+--------------------------------+

```

I checked the mysql fault log, but no mesages at all. The path seems right.  
Is there a way to create error messages to see why have\_ssl changes? I am wondering that usually there are huge logs to investigate for error reasons, and for SSL connection there is not a single entry?  
How can I determine, why have\_ssl changed to DISABLED? Which requirements have to be fulfilled to change to yes? I couldn’t find information on this in the maria reference or in forums.

Thank you very much in advance.

Cheers,  
Markus

---

_[View the full topic](https://dietpi.com/forum/t/setup-issues-ssl-tls-to-mariadb/2691)._