Base - Connect MySQL JDBC TimeZone error Forgets the database name

[ikopanas]

I know this one has already been answered. But I think I deal with something diferent.

I use an Ubuntu server 18.04 with mysql and a client with Windows 10 connecting with LibreOffice 6.3.5.2 (x64)

Everything was working fine when I got a message (probably caused by the summer time change):
“The Server time zone value ‘EEST’ is unrecognised or represends more than one time zone …”

Checked the windows client time zone is (UTC+02:00) and the Ubuntu Server timezone was EEST (Athens,Greece)

So I went to the LO (Edit/Database/Properties) and add to the database name instead of BusinessMonitor this: BusinessMonitor?useLegacyDatetimeCode=false&serverTimezone=Europe/Athens found from another similar post:

Base - Connect MySQL JDBC TimeZone error

When trying to connect to MySQL via JDBC I’m getting timezone error, I think I know how to solve it but I’ve to set properties to the JDBC connection but I dont know how to do it in Base… any other ideas? The message is something like this “The server time zone value’GMT Summer Time’ is not recognised or represents more than one timezone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specific time zone value if you want to util…

Checked the database connection and it worked saved the changes but the next time I tried to login instead of the full string the database name was just Athens saved and could not connect…

[Ratslinger]

Hello,

If this consistently happens, Datasource URL partially deleted, then it is certainly some type of bug. Having used JDBC connectors on many different databases (including MySQL) have not seen this problem.

Report on Bugzilla

[ikopanas]

Hello @Ratslinger and thanks. Is there a way to adjust the two different time zones and avoid the problem.
The database connection was working fine until the time changed by one hour 3 days ago.

[Ratslinger]

Sorry, only keep MySQL around in hopes of answering some questions. Dumped it some time ago for PostgreSQL. May be best on a MySQL forum to ask.