SV-253765r961824_rule
V-253765
SRG-APP-000503-DB-000351
MADB-10-011300
CAT II
10
Edit the necessary filters to include connect_events connect. 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"
]
}'
));
Check what filters are in place by running the following as an administrative user:
MariaDB> SELECT * FROM mysql.server_audit_filters;
Verify connect_events include connect in audit filters. If not, this is a finding.
Log in to and out of the MariaDB database server with both valid and invalid users. Verify the connect and disconnect are logged in the audit logfile or syslog depending on how it is configured.
If connect/disconnect and invalid logins are not logged, this is a finding.
V-253765
False
MADB-10-011300
Check what filters are in place by running the following as an administrative user:
MariaDB> SELECT * FROM mysql.server_audit_filters;
Verify connect_events include connect in audit filters. If not, this is a finding.
Log in to and out of the MariaDB database server with both valid and invalid users. Verify the connect and disconnect are logged in the audit logfile or syslog depending on how it is configured.
If connect/disconnect and invalid logins are not logged, this is a finding.
M
5475