ace3 on the Strato server

Middleware vooraf

admin@ubuntu:~$ java -version
Command 'java' not found, but can be installed with:
sudo apt install openjdk-17-jre-headless # version 17.0.14+7-1~24.04, or
sudo apt install openjdk-21-jre-headless # version 21.0.6+7-1~24.04.1
sudo apt install default-jre # version 2:1.17-75
sudo apt install openjdk-11-jre-headless # version 11.0.26+4-1ubuntu1~24.04
sudo apt install openjdk-8-jre-headless # version 8u442-b06~us1-0ubuntu1~24.04
sudo apt install openjdk-19-jre-headless # version 19.0.2+7-4
sudo apt install openjdk-20-jre-headless # version 20.0.2+9-1
sudo apt install openjdk-22-jre-headless # version 22~22ea-1

admin@ubuntu:~$ mysql -V
mysql Ver 8.0.42-0ubuntu0.24.04.2 for Linux on x86_64 ((Ubuntu))

admin@ubuntu:~$ sudo apache2ctl -v
Server version: Apache/2.4.63 (Ubuntu)
Server built: 2025-02-06T13:16:03

Na installatie van java:

admin@ubuntu:~$ java -version
openjdk version "17.0.15" 2025-04-15
OpenJDK Runtime Environment (build 17.0.15+6-Ubuntu-0ubuntu124.04)
OpenJDK 64-Bit Server VM (build 17.0.15+6-Ubuntu-0ubuntu124.04, mixed mode, sharing)

MySQL set time zone

Je moet wel de timezones toevoegen aan MySQL (mysql_tzinfo_to_sql), maar het zetten van de global time_zone werkte hier niet.

Je moet het op OS-niveau ook instellen.

sudo timedatectl set-timezone Europe/Paris

admin@ubuntu:/etc/mysql/conf.d$ sudo timedatectl
Local time: Mon 2025-07-14 08:40:58 UTC
Universal time: Mon 2025-07-14 08:40:58 UTC
RTC time: Mon 2025-07-14 08:40:58
Time zone: Etc/UTC (UTC, +0000)
System clock synchronized: yes
NTP service: active
RTC in local TZ: no

admin@ubuntu:/etc/mysql/conf.d$ timedatectl list-timezones | grep Paris
Europe/Paris

admin@ubuntu:/etc/mysql/conf.d$ sudo timedatectl set-timezone Europe/Paris

admin@ubuntu:/etc/mysql/conf.d$ timedatectl
Local time: Mon 2025-07-14 10:43:58 CEST
Universal time: Mon 2025-07-14 08:43:58 UTC
RTC time: Mon 2025-07-14 08:43:58
Time zone: Europe/Paris (CEST, +0200)
System clock synchronized: yes
NTP service: active
RTC in local TZ: no

In MySQL blijft de globale time_zone op SYSTEM staan, maar de tijd wordt wel correct weergegeven:

mysql> select now();
+---------------------+
| now() |
+---------------------+
| 2025-07-14 11:17:04 |
+---------------------+
1 row in set (0.00 sec)
mysql> select @@global.time_zone;
+--------------------+
| @@global.time_zone |
+--------------------+
| SYSTEM |
+--------------------+
1 row in set (0.00 sec)

bron: https://linuxconfig.org/ubuntu-24-04-change-timezone

restart MySQL

sudo /etc/init.d/mysql restart

source: https://superuser.com/questions/282115/how-to-restart-mysql

MySQL login