Skip site navigation (1)Skip section navigation (2)
Date:      Fri, 26 Mar 2021 09:29:30 -0600
From:      Gary Aitken <freebsd@dreamchaser.org>
To:        FreeBSD Mailing List <freebsd-questions@freebsd.org>
Subject:   mysql time-zone ambiguity?
Message-ID:  <dba947d1-c5bd-b732-55da-4651d9297dff@dreamchaser.org>

Next in thread | Raw E-Mail | Index | Archive | Help
mysql57-server installed;  When testing a jdbc connection I get:

The server time zone value 'MDT' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the 'serverTimezone' configuration property) to use a more specific time zone value if you want to utilize time zone support.

A diff says that /usr/share/zoneinfo/America/Denver is the same as /etc/localtime.

And the mysql time by default is set to 'SYSTEM':

garya@localhost [(none)]> select @@GLOBAL.time_zone, @@SESSION.time_zone;
+--------------------+---------------------+
| @@GLOBAL.time_zone | @@SESSION.time_zone |
+--------------------+---------------------+
| SYSTEM             | SYSTEM              |
+--------------------+---------------------+
1 row in set (0.00 sec)

on 11.4-RELEASE

Feels like the system is reporting the timezone as MDT and mysql wants something
like MDT/Denver?  I thought MDT was unique; Arizona is different.
Seems like this should default properly; ideas for what I have screwed up?
Also running ntpd if that matters.

Gary



Want to link to this message? Use this URL: <http://docs.FreeBSD.org/cgi/mid.cgi?dba947d1-c5bd-b732-55da-4651d9297dff>