STIGhubSTIGhub
STIGhub— A free STIG search and compliance tool·STIGs updated 1 hour ago
Powered by Pylon·Privacy·Terms·Feedback·© 2026 Beacon Cloud Solutions, Inc.
← Back to MariaDB Enterprise Server Security Technical Implementation Guide

V-286200

CAT II (Medium)

MariaDB must invalidate session identifiers upon user logout or other session termination.

Rule ID

SV-286200r1292147_rule

STIG

MariaDB Enterprise Server Security Technical Implementation Guide

Version

V1R1

CCIs

CCI-001185

Discussion

Captured sessions can be reused in replay attacks. This requirement limits the ability of adversaries to capture and continue to employ previously valid session IDs. This requirement focuses on communications protection for the MariaDB session rather than for the network packet. The intent of this control is to establish grounds for confidence at each end of a communications session in the ongoing identity of the other party and in the validity of the information being transmitted. Session IDs are tokens generated by MariaDB to uniquely identify a user's (or process's) session. MariaDB will make access decisions and execute logic based on the session ID. Unique session IDs help to reduce predictability of said identifiers. Unique session IDs address man-in-the-middle attacks, including session hijacking or insertion of false information into a session. If the attacker is unable to identify or guess the session information related to pending application traffic, they will have more difficulty in hijacking the session or otherwise manipulating valid sessions. When a user logs out, or when any other session termination event occurs, the DBMS must terminate the user session(s) to minimize the potential for sessions to be hijacked.

Check Content

As the DBA (root), run:
 
SHOW GLOBAL VARIABLES LIKE 'tcp_keepalive_interval';
SHOW GLOBAL VARIABLES LIKE 'tcp_keepalive_probes';
SHOW GLOBAL VARIABLES LIKE 'tcp_keepalive_time';
SHOW GLOBAL VARIABLES LIKE 'tcp_nodelay';
SHOW GLOBAL VARIABLES LIKE 'max_statement_time';
 
If these settings are not configured, this is a finding.

Fix Text

As the administrator, locate the .cnf file to change. 

Edit the "mariadb-enterprise.cnf" configuration file located in "/etc/my.cnf.d/".

In the [mariadb] section, add the lines:

tcp_keepalive_interval =number of seconds
tcp_keepalive_probes =number of probes
tcp_keepalive_time = number of seconds
tcp_nodelay =boolean (1 or 0)
max_statement_time = number of seconds
 
Restart MariaDB if required for configuration changes to take effect:

systemctl restart mariadb

More information on global system variables can be found at https://mariadb.com/docs/server/server-management/variables-and-modes/server-system-variables.