SV-253667r1136896_rule
V-253667
SRG-APP-000023-DB-000001
MADB-10-000200
CAT I
10
Integrate MariaDB security with an organization-level authentication/access mechanism providing account management for all users, groups, roles, and any other principals.
As the database administrator, install and configure the PAM authentication module:
MariaDB> INSTALL SONAME 'auth_pam';
PAM supports many authentication methods including LDAP, Active Directory, and Kerberos. Each method must be configured properly in the /etc/pam.conf file or the /etc/pam.d directory.
To alter non-PAM authenticated users to using PAM:
MariaDB> ALTER USER 'username'@'host' IDENTIFIED VIA pam USING mariadb_ldap;
If all accounts are authenticated by the organization-level authentication/access mechanism, such as LDAP, Kerberos, or Active Directory, and not by MariaDB, this is not a finding.
If any accounts are managed by the DBMS, review the system documentation for justification and approval of these accounts.
If any DBMS-managed accounts exist that are not documented and approved, this is a finding.
As the OS administrator, review the configuration in the /etc/pam.conf file or the /etc/pam.d directory. If there are no configuration file(s), this is a finding.
Example for LDAP authentication and authorization via PAM would be /etc/pam.d/mariadb_ldap:
#############################
auth required pam_ldap.so
account required pam_ldap.so
#############################
Verify that PAM is installed:
MariaDB> SHOW PLUGINS;
If pam is not listed as active, this is a finding.
To find users not using PAM plugin for authentication:
MariaDB> SELECT user, host, plugin FROM mysql.user WHERE plugin != 'pam';
If any users are returned, this is a finding.
V-253667
False
MADB-10-000200
If all accounts are authenticated by the organization-level authentication/access mechanism, such as LDAP, Kerberos, or Active Directory, and not by MariaDB, this is not a finding.
If any accounts are managed by the DBMS, review the system documentation for justification and approval of these accounts.
If any DBMS-managed accounts exist that are not documented and approved, this is a finding.
As the OS administrator, review the configuration in the /etc/pam.conf file or the /etc/pam.d directory. If there are no configuration file(s), this is a finding.
Example for LDAP authentication and authorization via PAM would be /etc/pam.d/mariadb_ldap:
#############################
auth required pam_ldap.so
account required pam_ldap.so
#############################
Verify that PAM is installed:
MariaDB> SHOW PLUGINS;
If pam is not listed as active, this is a finding.
To find users not using PAM plugin for authentication:
MariaDB> SELECT user, host, plugin FROM mysql.user WHERE plugin != 'pam';
If any users are returned, this is a finding.
M
5475