SV-253672r960885_rule
V-253672
SRG-APP-000091-DB-000066
MADB-10-000700
CAT II
10
The MariaDB Enterprise Audit plugin can be configured to audit these changes.
Update necessary audit filters to include query_event ALL. Example:
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"
]
}'
));
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 query_events ALL is included in corresponding audit filters. If not, this is a finding.
MariaDB> SHOW GLOBAL VARIABLES LIKE 'server_audit_file_path';
As a Linux user with sufficient privileges to view logs, tail the audit log file.
$ tail -f /var/log/mysql/server_audit.log (default location)
In another terminal run:
MariaDB> SHOW GRANTS;
If an audit record is not produced in the first terminal, this is a finding.
V-253672
False
MADB-10-000700
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 query_events ALL is included in corresponding audit filters. If not, this is a finding.
MariaDB> SHOW GLOBAL VARIABLES LIKE 'server_audit_file_path';
As a Linux user with sufficient privileges to view logs, tail the audit log file.
$ tail -f /var/log/mysql/server_audit.log (default location)
In another terminal run:
MariaDB> SHOW GRANTS;
If an audit record is not produced in the first terminal, this is a finding.
M
5475