CEST problems while accessing on mariadb / mysql server

Support
,
1

NethServer Version: 7
Module: Maria Db

Hi,

I have some trouble to access existing databases using OpenOffice.

  • Connection within Nethserver (via php) runs fine
  • Network service is open to green
  • access from the same laptop, e.g. using HeidiSQL client runs fine, connection work

-> Openoffice shows the following error message:

grafik

Different sources read that the list of time zones within the server need to be updated. Are there any experiences on that?

THX
Thorsten

2

You may need to pass additional parameters with the connection string:

https://ask.libreoffice.org/en/question/154384/base-connect-mysql-jdbc-timezone-error/

Example:

?useLegacyDatetimeCode=false&serverTimezone=Europe/Berlin

…or whichever correct timezone suits

1 Like
3

Fairly complicated and not very nice … but it works…
Thank you. But maybe there is some way to solve on the server side?

4

Maybe it’s possible to handle it. Here some info:

https://bugs.mysql.com/bug.php?id=85816

set your server with a non DST aware time zone, such as UTC, and then let all adjustments be made between the client(s) time zone and this neutral time zone.