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 · Accepted solution]

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;"

[Onyx_Studio]

Hi Martin, can you explain in more detail the four steps you listed? Specifcally steps 1 and 3? What files are edited to modify this? I am having the same issue right now.

[Martin Bastek]

I use: timedatectl on ubuntu

Use:

timedatectl list-timezones

To List all Timezones

to set Timezone use (e.g)): sudo timedatectl set-timezone 'Europe/Berlin'

[adrianoatl]

Old, but it may help someone like it did for me:

vi <CONFLUENCE-DATA>/confluence.cfg.xml

add the timezone at the end of the line, with and after "?`":

jdbc:mysql://localhost:3306/database_name?serverTimezone=America/New_York 

 Restart Confluence.

[Hunm Mnb]

yes i got the same problem and i solve it by adding the time zone to the string url as @adrianoatl  declared