SV-253730r961443_rule
V-253730
SRG-APP-000374-DB-000322
MADB-10-007600
CAT II
10
On the OS command line run the following command to get the time zone the system is in:
date | awk '{print $5;}'
If the system is in UTC, to set the time zone for timestamps to UTC, modify the MariaDB configuration file located within /etc/my.cnf.d/ and set the variable time_zone to SYSTEM under the server section. Restart MariaDB Enterprise Server.
Example:
[server]
Timezone = SYSTEM
If the OS system timezone is not set to UTC, to set the time zone for timestamps to UTC, modify the MariaDB configuration file located within /etc/my.cnf.d/ and set the variable time_zone to UTC under the server section. Restart MariaDB Enterprise Server.
Example:
[server]
Timezone = UTC
Check the current timezone value by running the following command as an administrative user:
MariaDB> SHOW GLOBAL VARIABLES LIKE '%zone%';
If time_zone = SYSTEM, and system_time_zone is not equal to UTC, this is a finding.
If time_zone is not SYSTEM and is not UTC, this is a finding.
V-253730
False
MADB-10-007600
Check the current timezone value by running the following command as an administrative user:
MariaDB> SHOW GLOBAL VARIABLES LIKE '%zone%';
If time_zone = SYSTEM, and system_time_zone is not equal to UTC, this is a finding.
If time_zone is not SYSTEM and is not UTC, this is a finding.
M
5475