11 May 2019 Databases

Unknown or incorrect time zone: 'Europe/Berlin'

After installing a new application on one of my server, i got following error message:

Unknown or incorrect time zone: 'Europe/Berlin'

Changing the locale settings didn’t help

ahmet@testserver1:~$ mysql -u root -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 219
Server version: 10.1.38-MariaDB-0ubuntu0.18.04.1 Ubuntu 18.04

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> SET time_zone = 'Europe/Berlin';
ERROR 1298 (HY000): Unknown or incorrect time zone: 'Europe/Berlin'

The problem could be solved this way:

ahmet@testserver1:~$ mysql_tzinfo_to_sql /usr/share/zoneinfo/|mysql -u root mysql -p
Enter password:
Warning: Unable to load '/usr/share/zoneinfo//leap-seconds.list' as time zone. Skipping it.
  • LinkedIn
  • Tumblr
  • Reddit
  • Google+
  • Pinterest
  • Pocket
comments powered by Disqus
Impressum · Datenschutzerklärung · Haftungsausschluss