Conversation
Notices
-
Douglas A. Whitfield (musicman@nu.federati.net)'s status on Tuesday, 09-Jun-2020 20:00:09 UTC Douglas A. Whitfield I stumped (for now) our #Wildfly expert on this one:
"java.sql.SQLException: The server time zone value 'CDT' 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 specifc time zone value if you want to utilize time zone support."-
LinuxWalt (@lnxw48a1) {3EB165E0-5BB1-45D2-9E7D-93B31821F864} (lnxw48a1@nu.federati.net)'s status on Tuesday, 09-Jun-2020 20:02:54 UTC LinuxWalt (@lnxw48a1) {3EB165E0-5BB1-45D2-9E7D-93B31821F864} @musicman Not an answer, because I don't know, but look into #Java and time zones. I'd guess it probably has its own implementation of the Olsen #timezone database. -
Douglas A. Whitfield (musicman@nu.federati.net)'s status on Tuesday, 09-Jun-2020 20:37:47 UTC Douglas A. Whitfield I think the timezones just need to be loaded into MariaDB -
Douglas A. Whitfield (musicman@nu.federati.net)'s status on Tuesday, 09-Jun-2020 20:40:45 UTC Douglas A. Whitfield well, and to set the appropriate tz -
LinuxWalt (@lnxw48a1) {3EB165E0-5BB1-45D2-9E7D-93B31821F864} (lnxw48a1@nu.federati.net)'s status on Tuesday, 09-Jun-2020 20:49:34 UTC LinuxWalt (@lnxw48a1) {3EB165E0-5BB1-45D2-9E7D-93B31821F864} @musicman I would expect most applications to handle that as part of initial setup. -
Douglas A. Whitfield (musicman@nu.federati.net)'s status on Tuesday, 09-Jun-2020 21:08:12 UTC Douglas A. Whitfield mariadb tries to pull the info from CentOS. I think this is a timezonectl issue, but not sure.
If mariadb pulled 'America/Chicago' instead of CDT, then it would work fine. -
LinuxWalt (@lnxw48a1) {3EB165E0-5BB1-45D2-9E7D-93B31821F864} (lnxw48a1@nu.federati.net)'s status on Tuesday, 09-Jun-2020 22:02:53 UTC LinuxWalt (@lnxw48a1) {3EB165E0-5BB1-45D2-9E7D-93B31821F864} @musicman You might want to check to see whether the tz files are symlinks to "utc-5" and such. If they are, "Americas/Chicago" should be treated the same as CDT until we go back to standard time. -
LinuxWalt (@lnxw48a1) {3EB165E0-5BB1-45D2-9E7D-93B31821F864} (lnxw48a1@nu.federati.net)'s status on Tuesday, 09-Jun-2020 23:48:47 UTC LinuxWalt (@lnxw48a1) {3EB165E0-5BB1-45D2-9E7D-93B31821F864} They are not symlinks (well, most of them) on Debian / Ubuntu. I didn't check Fedora. -
Douglas A. Whitfield (musicman@nu.federati.net)'s status on Wednesday, 10-Jun-2020 13:48:34 UTC Douglas A. Whitfield if you look at the output of timezonectl you will see the different fields. mysql is just picking up the wrong field.
-