Time zone, after reboot comes back to SYSTEM (Debian Bookworm)
^Bart <[email protected]> Mon, 6 Nov 2023 09:38:06 +0100
| Newsgroups | comp.databases.mysql |
|---|---|
| Organization | A noiseless patient Spider |
| Message-ID | <[email protected]> |
Hi guys,
I login to MariaDB and I do:
MariaDB [(none)]> SHOW GLOBAL VARIABLES LIKE 'time_zone';
+---------------+--------+
| Variable_name | Value |
+---------------+--------+
| time_zone | SYSTEM |
+---------------+--------+
1 row in set (0,001 sec)
After it I do:
MariaDB [(none)]> SET GLOBAL time_zone = 'Europe/Rome';
Query OK, 0 rows affected (0,004 sec)
And I have:
MariaDB [(none)]> SHOW GLOBAL VARIABLES LIKE 'time_zone';
+---------------+-------------+
| Variable_name | Value |
+---------------+-------------+
| time_zone | Europe/Rome |
+---------------+-------------+
1 row in set (0,001 sec)
After a reboot, like what I wrote in the subject, the time zone value
comes back to system.
I did from command line:
# timedatectl set-timezone Europe/Rome
I have:
# timedatectl
Local time: lun 2023-11-06 09:31:30 CET
Universal time: lun 2023-11-06 08:31:30 UTC
RTC time: lun 2023-11-06 08:31:30
Time zone: Europe/Rome (CET, +0100)
System clock synchronized: yes
NTP service: active
RTC in local TZ: no
I inserted the timezone in 50-mysqld_safe.cnf
But after a reboot I have always the value sets on System.
I'll check asap from Knime if the timezone issue is fixed but I think I
did everything to fix it or I should do other things?
Regards.
^Bart