Information
If passwords are used for authentication, MariaDB must transmit only encrypted representations of passwords.
GROUP ID: V-253698
RULE ID: SV-253698r961029
The DoD standard for authentication is DoD-approved PKI certificates.
Authentication based on User ID and Password may be used only when it is not possible to employ a PKI certificate and requires AO approval.
In such cases, passwords need to be protected at all times, and encryption is the standard method for protecting passwords during transmission.
DBMS passwords sent in clear text format across the network are vulnerable to discovery by unauthorized users. Disclosure of passwords may easily lead to unauthorized access to the database.
Solution
As the administrator locate the MariaDB configuration file to change. This varies depending on setup and how configuration files are managed but should be in /etc/my.cnf.d/ . It is recommended to have a separate configuration file within this directory for SSL connection information.
In the [server] section add the lines for SSL:
ssl
ssl-ca=/path/to/ssl/ca-cert.pem
ssl-cert=/path/to/ssl/server-cert.pem
ssl-key=/path/to/ssl/server-key.pem
Restart of the MariaDB Server and verify SSL is being used.
MariaDB> STATUS;
Verify line beginning with "SSL:".