Connecting eperi sEcure Platform to the configured MariaDB database fails

Condition

The attempt to connect eperi sEcure Platform to a MariaDB database fails. The following error message appears in the eperi sEcure Platform Admin Console:

Cannot create connection to the configured database: 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.

Cause

This error is thrown by the MySQL JDBC Driver. Your MariaDB database server is configured to a time zone like, EDT, PDT, CEST, etc. These time zone values are not recognizable since Java 8.

Remedy

Procedure

  1. Login to your server via SSH as root user.
  2. Change your MariaDB time zone by editing the MariaDB configuration file (/etc/my.cnf).
  3. Add the time zone details in the mysqld section of the configuration file. Set the default time zone to UTC: 
    [mysqld]
default-time-zone='+00:00'
  4. Restart MariaDB: 
    sudo service mysql restart