SV-253676r960909_rule
V-253676
SRG-APP-000101-DB-000044
MADB-10-001600
CAT II
10
Update necessary audit filters. For 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.
Log in to MariaDB Enterprise Server and verify the audit log location.
MariaDB> SHOW GLOBAL VARIABLES LIKE 'server_audit_file_path';
Verify the necessary audit filters are in place:
MariaDB> SELECT * FROM mysql.server_audit_filters;
In another terminal, view the audit log file:
$ tail -f /var/log/mysql/audit.log
Back in the MariaDB shell, run a query which matches an audit filter. Example if query_events is ALL:
MariaDB> SELECT * FROM mysql.help_topic;
Verify the entry was logged in the audit log and contains the necessary event user information. If not, this is a finding.
V-253676
False
MADB-10-001600
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.
Log in to MariaDB Enterprise Server and verify the audit log location.
MariaDB> SHOW GLOBAL VARIABLES LIKE 'server_audit_file_path';
Verify the necessary audit filters are in place:
MariaDB> SELECT * FROM mysql.server_audit_filters;
In another terminal, view the audit log file:
$ tail -f /var/log/mysql/audit.log
Back in the MariaDB shell, run a query which matches an audit filter. Example if query_events is ALL:
MariaDB> SELECT * FROM mysql.help_topic;
Verify the entry was logged in the audit log and contains the necessary event user information. If not, this is a finding.
M
5475