Conversation:

Notices

1. Douglas A. Whitfield (musicman)'s status on Tuesday, 09-Jun-2020 16:00:09 EDT Douglas A. Whitfield

   Remote profile options...
   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)'s status on Tuesday, 09-Jun-2020 16:02:54 EDT LinuxWalt (@lnxw48a1) {3EB165E0-5BB1-45D2-9E7D-93B31821F864}

     Remote profile options...

     • Douglas A. Whitfield
     @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)'s status on Tuesday, 09-Jun-2020 16:37:47 EDT Douglas A. Whitfield

     Remote profile options...
     I think the timezones just need to be loaded into MariaDB
   • Douglas A. Whitfield (musicman)'s status on Tuesday, 09-Jun-2020 16:40:45 EDT Douglas A. Whitfield

     Remote profile options...
     well, and to set the appropriate tz
   • LinuxWalt (@lnxw48a1) {3EB165E0-5BB1-45D2-9E7D-93B31821F864} (lnxw48a1)'s status on Tuesday, 09-Jun-2020 16:49:34 EDT LinuxWalt (@lnxw48a1) {3EB165E0-5BB1-45D2-9E7D-93B31821F864}

     Remote profile options...

     • Douglas A. Whitfield
     @musicman I would expect most applications to handle that as part of initial setup.
   • Douglas A. Whitfield (musicman)'s status on Tuesday, 09-Jun-2020 17:08:12 EDT Douglas A. Whitfield

     Remote profile options...

     • LinuxWalt (@lnxw48a1) {3EB165E0-5BB1-45D2-9E7D-93B31821F864}
     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)'s status on Tuesday, 09-Jun-2020 18:02:53 EDT LinuxWalt (@lnxw48a1) {3EB165E0-5BB1-45D2-9E7D-93B31821F864}

     Remote profile options...

     • Douglas A. Whitfield
     @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)'s status on Tuesday, 09-Jun-2020 19:48:47 EDT LinuxWalt (@lnxw48a1) {3EB165E0-5BB1-45D2-9E7D-93B31821F864}

     Remote profile options...
     They are not symlinks (well, most of them) on Debian / Ubuntu. I didn't check Fedora.
   • Douglas A. Whitfield (musicman)'s status on Wednesday, 10-Jun-2020 09:48:34 EDT Douglas A. Whitfield

     Remote profile options...

     • LinuxWalt (@lnxw48a1) {3EB165E0-5BB1-45D2-9E7D-93B31821F864}
     if you look at the output of timezonectl you will see the different fields. mysql is just picking up the wrong field.