SV-253736r961521_rule
V-253736
SRG-APP-000400-DB-000367
MADB-10-008300
CAT II
10
Verify that the idle_transaction_wait is set to a value greater than 0 or is set to the value needed by the administrator. The value of idle_transaction_wait can be validated by issuing SHOW VARIABLES. Example:
Locate the MariaDB Enterprise Server configuration files in /etc/my.cnf.d/. Add the following:
Under the [mariadb] section:
idle_transaction_timeout = 60
After making changes to the .cnf file, stop and restart the database service.
The system parameter idle_transaction_timeout specifies in seconds when a connection will be terminated due to inactivity. After a connection is terminated, a new request to the database must be preceded by an authentication, which is not cached within the database.
Run the following SQL:
MariaDB> SHOW GLOBAL VARIABLES LIKE 'idle_transaction_timeout';
If the value is 0, this is a finding.
V-253736
False
MADB-10-008300
The system parameter idle_transaction_timeout specifies in seconds when a connection will be terminated due to inactivity. After a connection is terminated, a new request to the database must be preceded by an authentication, which is not cached within the database.
Run the following SQL:
MariaDB> SHOW GLOBAL VARIABLES LIKE 'idle_transaction_timeout';
If the value is 0, this is a finding.
M
5475