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

Martin Bastek

Hello

Same error on Config page:

he 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.

 

The System Time zone ist CEST +2 EU Berlin

timedatectl

Local time: Fr 2019-09-06 14:08:37 CEST
Universal time: Fr 2019-09-06 12:08:37 UTC
RTC time: Fr 2019-09-06 12:08:37
Time zone: Europe/Berlin (CEST, +0200)

 

Have anybody a idee?

 

Martin Bastek

my solution:

1. Back to UTC Time
2. Finish the setup wizard
3. Set Time back to CEST
4. Add Time Zone in dbconfig.xml (serverTimezone=Europe/Berlin)

example:


<url>jdbc:mysql://address=(protocol=tcp)(host=localhost)(port=3306)/jira?sessionVariables=default_storage_engine=InnoDB&amp;serverTimezone=Europe/Berlin</url>

normal with a &, but xml needs HTML & -> "&amp;"