The Ultimate Guide to High Availability with MariaDB

Problem with my set file my.cnf

You are viewing an old version of this question. View the current version here.

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:

+---------------+----------+
| Variable_name | Value    |
+---------------+----------+
| have_openssl  | DISABLED |
| have_ssl      | DISABLED |
| ssl_ca        |          |
| ssl_capath    |          |
| ssl_cert      |          |
| ssl_cipher    |          |
| ssl_key       |          |
+---------------+----------+

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: 

+---------------+--------------------------------+
| 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  |
+---------------+--------------------------------+

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

HI,
I am not sure I understand where your problem comes from. Is it a packaging/deployment problem (related to RPM), or is it a problem of mariadb server not reading your specific my.cnf configuration file?

Could you please explain better the steps of your deployment and what you are trying achieve?

Regards,
Faustin

Comments

Comments loading...
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.