MySQL / MariaDB and “CEST” as server time zone value

My Synology DS713+ had a couple of package updates, MariaDB being one of them.

I am running hibiscus-server, which has its own database on a MariaDB (MySQL) server there.

  • 5.5.54-MariaDB – this looks currently like the only relevant updated piece
  • hibiscus-server-2.7.0-1418
  • mysql-connector-java-6.0.5.jar

On restarting that hibiscus server the connection to the MariaDB server keeps failing:

detected error: java.rmi.RemoteException: connection to database.jdbc:mysql://localhost:3306/hibiscus?useUnicode=Yes&characterEncoding=ISO8859_1 failed; nested exception is:
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.

Looks like I have to investigate the problem with the server time zone.

I will keep watching my $HOME/.jameica/jameica.log .

Update 2017-04-26:

This article helped me reconnecting to my database:

The connection string suggested there looks like this:

  • jdbc:mysql://localhost/db?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC

The part in bold font got added.

I had to modify my connection string within this configuration file:

  • hibiscus-server…/cfg/

I appended the bold part shown above to the hibiscus connection string.

CAVEAT: The “=” signs need quoting – as already being done for other pieces within the old connection string.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: