V-286235

Discussion

Public key cryptography is a valid authentication mechanism for individuals, machines, and devices. For Public Key Infrastructure (PKI) solutions, status information for certification paths includes certificate revocation lists or certificate status protocol responses. For Personal Identity Verification (PIV) cards, certificate validation involves the construction and verification of a certification path to the Common Policy Root trust anchor, which includes certificate policy processing. Implementing a local cache of revocation data to support path discovery and validation also supports system availability in situations where organizations are unable to access revocation information via the network.

Check Content

Verify that TLS is enabled and certificates are configured. As a DBA, run: 

SHOW GLOBAL VARIABLES LIKE 'ssl_%';

Confirm that certificate paths are configured (for example):
- ssl_ca.
- ssl_cert.
- ssl_key.

If TLS certificates are not configured when public key-based authentication is required, this is a finding.

Verify that a Certificate Revocation List (CRL) file or CRL directory is configured by running: 

SHOW GLOBAL VARIABLES LIKE 'ssl_crl%';

Expected variables include "ssl_crl" and "ssl_crlpath".

If both variables are empty when public key authentication is used, this is a finding.

Verify that the CRL file or directory exists on the system.

Example:
ls -l /etc/my.cnf.d/certs/

Confirm the CRL file or CRL directory referenced by "ssl_crl" or "ssl_crlpath" exists and is readable by the MariaDB server process.

If the CRL file or directory does not exist or is not accessible, this is a finding.