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?
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&serverTimezone=Europe/Berlin</url>
normal with a &, but xml needs HTML & ->"&
"
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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'
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
yes i got the same problem and i solve it by adding the time zone to the string url as @adrianoatl declared
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.