1.97 MADB-10-011200

Information

MariaDB must generate audit records when successful logons or connections occur.

GROUP ID: V-253764
RULE ID: SV-253764r961824

For completeness of forensic analysis, it is necessary to track who/what (a user or other principal) logs on to the DBMS.

NOTE: Nessus has provided the target output to assist in reviewing the benchmark to ensure target compliance.

Solution

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"
]
}'
));

See Also

https://workbench.cisecurity.org/benchmarks/26720