The server time zone value 'CEST' is unrecognized or represents more than one time zone

Hi,

since 4.5.1 we experience this exception quite often. When it hits, Openfire is unusable.

Do you have any idea, why this happens?

We use MySQL 5 and I saw the driver shipped with Openfire 4.5.1 is MySQL 8.

With the previous version, we were using (Openfire 4.1.5) everything worked fine.

We tried to set the serverTimezone value in openfire.xml but it didn’t help.

Any help appreciated.

java.sql.SQLException: ConnectionManager.getConnection() failed to obtain a connection after 11 retries. The exception from the last attempt is as follows: java.sql.SQLException: 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.
        at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager.java:204) ~[xmppserver-4.5.1.jar:4.5.1]

Solved.

We added &serverTimezone=UTC instead of &serverTimezone=UTC

to the JDBC URL :wink:

1 Like