Uploaded image for project: 'Spigot'
  1. Spigot
  2. SPIGOT-3244

MySQL driver time zone problem

XMLWordPrintable

      When starting the new spigot 1.12-pre2 version with our currently working 1.11.2 plugin setup, many (all?) of the plugins using the MySQL database don't start with an SQL exception not recognizing the current time zone:

      com.mysql.cj.core.exceptions.InvalidConnectionAttributeException: The server time zone value 'CEST' 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.

      a few exaples:

      https://pastebin.com/jQXDUb3M

      This was never an issue with any previous versions of spigot.

      My guess is that this is related to the update to version 6 of the mysql driver. Is there any solution to this without having to update all plugins using a database connection (in our case quite a few)?

            Unassigned Unassigned
            minoneer minoneer
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: