Base - Connect MySQL JDBC TimeZone error Forgets the database name

asked 2020-04-03 18:46:57 +0200

ikopanas gravatar image

updated 2020-08-10 00:29:20 +0200

Alex Kemp gravatar image

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 (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:

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...

edit retag flag offensive close merge delete



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

Ratslinger gravatar imageRatslinger ( 2020-04-03 19:07:03 +0200 )edit

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.

ikopanas gravatar imageikopanas ( 2020-04-03 19:37:45 +0200 )edit

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.

Ratslinger gravatar imageRatslinger ( 2020-04-03 20:00:51 +0200 )edit