Problem with my set file my.cnf - Source

Revision: 78853
User: Alexandre Feltin
Date: 2019-01-23 20:50

Hello everyone,

I have a problem with my.cnf file from MariaDB.
I created a rpm to deploy MariaDB 5.5.52 automatically with an already set my.cnf file.
(file located in /etc/my.cnf). 
Automatically, the original MariaDB file at installation is kept somewhere else under my.cnf.origin because the program deploy my set file my.cnf.
I want to make an SSL connection to MariaDB.
The certificates are well created and located in /etc/mysql-ssl (with the necessary rights of course).
However, I get:
<<code>>
+---------------+----------+
| Variable_name | Value    |
+---------------+----------+
| have_openssl  | DISABLED |
| have_ssl      | DISABLED |
| ssl_ca        |          |
| ssl_capath    |          |
| ssl_cert      |          |
| ssl_cipher    |          |
| ssl_key       |          |
+---------------+----------+
<</code>>
However, when I use the original file of MariaDB, everything works (I added the 3 more lines for the certificates links in my.cnf.origin that I moved in /etc)
I get that and it's great: 
<<code>>
+---------------+--------------------------------+
| Variable_name | Value                          |
+---------------+--------------------------------+
| have_openssl  | YES                            |
| have_ssl      | YES                            |
| ssl_ca        | /etc/mysql-ssl/ca-cert.pem     |
| ssl_capath    |                                |
| ssl_cert      | /etc/mysql-ssl/server-cert.pem |
| ssl_cipher    |                                |
| ssl_key       | /etc/mysql-ssl/server-key.pem  |
+---------------+--------------------------------+
<</code>>
Is it possible to use my file which has exactly the same content as that of an original file generated by MariaDB?
The rights are exactly the same for my.cnf files (whether it's the original one or the one I created).

Thank you in advance.

Best regards,
Alex.

Answer

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

Problem with my set file my.cnf - Source

Answer

Products

Services

Pricing

Resources

About Us

Download MariaDB