MariaDB must map PKI ID to an associated user account.
Overview
| Finding ID | Version | Rule ID | IA Controls | Severity |
| V-253701 | MADB-10-004200 | SV-253701r961044_rule | CCI-000187 | medium |
| Description | ||||
| The DoD standard for authentication is DoD-approved PKI certificates. Once a PKI is validated, it is mapped to the DBMS user account for the authentication identity and then can be used for authorization decisions. | ||||
| STIG | Date | |||
| MariaDB Enterprise 10.x Security Technical Implementation Guide | 2024-12-05 | |||
Details
Check Text (C-253701r961044_chk)
Query all users to confirm issuer and subject are configured correctly:
MariaDB>SELECT user, host, ssl_type, CAST(x509_issuer AS CHAR) AS issuer, CAST(x509_subject AS CHAR) AS subject FROM mysql.user;
If users are not mapped correctly, this is a finding.
Fix Text (F-57104r841627_fix)
Example command to create users with proper X509 certificate subject and issuer:
MariaDB>CREATE USER 'janedoe'@'%' IDENTIFIED BY 'Some_Password_Here_$9'
REQUIRE SUBJECT '/C=US/ST=Ohio/L=Columbus/O=MariaDB Corporation/CN=Jane Doe'
AND ISSUER '/C=US/ST=Ohio/L=Columbus/O=MariaDB Corporation/CN=MariaDB CA';