LibreOffice Version: 6.1.5.2 (x64)
MySQL version 5.7.25
mysql-connector-java-8.0.15
The connection to the data source “MyDB” could not be established.
The server time zone value ‘CDT’ 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.
Hello,
Don’t remember what prompted the change (vaguely remember MySQL update) but just add:
?serverTimezone=America/Chicago
to the end of your JDBC Datasource string. I believe UTC with + or - hours also works.
Reference list → List of tz database time zones
Datasource URL can be found from main Base menu Edit->Databese->Properties...
Partly this is my fault for not asking which JDBC connection you are using - MySQL(JDBC) or JDBC. I was referring to the latter, you appear to have the former.
In your case there is another complication. While you can add the timezone info onto the DB name and can connect, once saved & closed the DB name is wrong. This is reported in tdf#119786.
Two methods to fix while bug is being fixed. One is to change to an older java connector (tested with 5.1.45) which works without added timezone info. Second method is to use JDBC Connection Type ( from menu - Edit->Database->Connection Type...) then set up using JDBC (not ‘MySQL (JDBC)’) type. The datasource becomes:
mysql://localhost/YOUR_DB_NAME?serverTimezone=America/ChicagoThank you!
I downgraded to 5.1.47 and the connection has returned.
Take the rest of the day off, with pay.
Thank you for the fast reply. My only problem is I don’t know where to edit the JDBC Datasource string. My search hasn’t led to an answer.
Have a great evening.
Thanks, phat phingers hit the wrong button. My bad.
From the Base>Edit>Database>Properties the options are Advanced Properties (General, Name of MySQL database and User Authentication) and Additional Settings (Host name, Port number & MySQL JDBC driver class) and Data Conversion (Character set). I don’t see a Datasource URL.
Sorry, but I must be missing something obvious.