SV-253670r960879_rule
V-253670
SRG-APP-000089-DB-000064
MADB-10-000500
CAT II
10
Configure MariaDB to generate audit records for at least the DoD minimum set of events.
Edit the mariadb-enterprise.cnf configuration file located in /etc/my.cnf.d/.
Under [mariadb], add the following:
server_audit_logging = ON
Save the configuration file. This change will not take effect until MariaDB Enterprise Server is restarted.
Using the MariaDB Enterprise Audit plugin, MariaDB can be configured to audit these requests.
The MariaDB Enterprise Audit plugin can be configured to audit these changes.
Update necessary audit filters. Ex:
MariaDB> DELETE FROM mysql.server_audit_filters WHERE filtername = 'default';
MariaDB> INSERT INTO mysql.server_audit_filters (filtername, rule)
VALUES ('default',
JSON_COMPACT(
'{
"connect_event": [
"CONNECT",
"DISCONNECT"
],
"query_event": [
"ALL"
]
}'
));
More information about MariaDB auditing can be found here: https://mariadb.com/docs/security/mariadb-enterprise-audit/
Verify the MariaDB Enterprise Audit plugin is loaded and actively logging:
MariaDB> SHOW GLOBAL STATUS LIKE 'Server_audit_active';
If the MariaDB Enterprise Audit is not active, this is a finding.
Check what filters are in place by running the following as an administrative user:
MariaDB> SELECT * FROM mysql.server_audit_filters;
Verify audit filters match organization-defined auditing requirements. If not, this is a finding.
V-253670
False
MADB-10-000500
Verify the MariaDB Enterprise Audit plugin is loaded and actively logging:
MariaDB> SHOW GLOBAL STATUS LIKE 'Server_audit_active';
If the MariaDB Enterprise Audit is not active, this is a finding.
Check what filters are in place by running the following as an administrative user:
MariaDB> SELECT * FROM mysql.server_audit_filters;
Verify audit filters match organization-defined auditing requirements. If not, this is a finding.
M
5475