Solved LiteBans database issue

Discussion in 'Spigot Plugin Help' started by Lolok, May 1, 2019.

  1. Error:
    Code (Text):
    [15:47:55 INFO]: [LiteBans] Enabling LiteBans v2.3.15
    [15:47:56 INFO]: [LiteBans] Using default database drivers.
    [15:47:56 INFO]: [LiteBans] Loading SQL driver: mysql (com.mysql.cj.jdbc.Driver)
    [15:47:56 INFO]: [LiteBans] Connecting to database...
    [15:48:06 ERROR]: [LiteBans] litebans-pool - Exception during pool initialization.
    [15:48:06 ERROR]: [LiteBans] Failed to connect to [jdbc:mysql://localhost:3306/litebans;useSSL=false] using mysql driver.
    [15:48:06 ERROR]: [LiteBans] Error: Failed to initialize pool: 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.
    [15:48:06 ERROR]: [LiteBans] Cause: 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.
    [15:48:06 ERROR]: [LiteBans] Cause: 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.
    [15:48:06 INFO]: [LiteBans] v2.3.15 enabled. Startup took 10797 ms.
     
    Config:
    https://hastebin.com/azuwefafox.php
     
    • Agree Agree x 1
  2. Nvm I fixed the issue by adding in options string "&serverTimezone=UTC"
     
  3. @Lolok I have same problem, which options? (File)
     
  4. In LiteBans/config.yml find
    options: 'useSSL=false'
    and add this &serverTimezone=UTC

    Should look like this:
    options: 'useSSL=false&serverTimezone=UTC'
     
    • Like Like x 2