The server time zone value 'AEST' is unrecognized

Onyx_Studio

I am attempting to set up my MySQL database in the Jira setup. This time around I am receiving the following error: 

Error connecting to database

The server time zone value 'AEST' 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.

How do I fix this? Never seen this error in previous installations

OS: Ubuntu Server 19.10

Mysql: 8.0.18-0ubuntu0.19.10.1 x86_64

Connector/J version 8.0.18

Jira Software Server: 8.6.1

Petter Gonçalves

Hello @Onyx_Studio

Thank you for reaching out.

Based on this discussion, it looks like the error you are facing is being explicitly thrown via the MySQL connector because it's not thrilled about the Server's time zone.

That being said, can you please set the server's time zone to a specific time zone, such as Australia/Melbourne) instead of a generic one (such as AEDT)?

AEST is an unreliable broad indicator of time and is inaccurate, so I believe that's the reason that SQL is returning that error.

Let us know if that fixes the error.