Title

MariaDB must generate audit records for all direct access to the database(s). (Cat II impact)

Discussion

In this context, direct access is any query, command, or call to MariaDB that comes from any source other than the application(s) that it supports. Examples would be the command line or a database management utility program. The intent is to capture all activity from administrative and nonstandard sources.

Check Content

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.

Fix Text

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

Additional Identifiers

Rule ID: SV-253772r961839_rule

Vulnerability ID: V-253772

Group Title: SRG-APP-000508-DB-000358

Expert Comments

CCIs tied to check.

Controls tied to check. These are derived from the CCIs shown above.