MADB-10-011300 - MariaDB must generate audit records when unsuccessful logons or connection attempts occur.

Information

For completeness of forensic analysis, it is necessary to track failed attempts to log on to MariaDB. While positive identification may not be possible in a case of failed authentication, as much information as possible about the incident must be captured.

NOTE: Nessus has not performed this check. Please review 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://dl.dod.cyber.mil/wp-content/uploads/stigs/zip/U_MariaDB_Enterprise_10-x_V2R1_STIG.zip

Item Details

Category: AUDIT AND ACCOUNTABILITY

References: 800-53|AU-12c., CAT|II, CCI|CCI-000172, Rule-ID|SV-253765r961824_rule, STIG-ID|MADB-10-011300, Vuln-ID|V-253765

Plugin: MySQLDB

Control ID: 4ae2310a734846e1fe8a990529366f5d3a9a1bc6673f6ed7562b8edd06bf1eae