We're updating the issue view to help you get more done. 

Cannot create MySQL Datasource

Description

Any attempt to create a MySQL Datasource results in this error message and the inability to complete the setup:

"The server time zone value 'PDT' 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."

Attempting to set the TIMEZONE setting within the config has no effect, otherwise it's left at the default. All other settings are at default values. Username and password are correct and tested elsewhere. I've attempted this from both the SERVER and WEB admin consoles, same result.

I've restarted LUCEE and MySQL and I still get the same result. I've upgraded MySQL from 5.7.18 to 5.7.21 and still get the same result.

I tried (via the Application Extensions Console) to downgrade the JDBC driver from version 8.0.9 to 6.0.6 and still get the same result.

Environment

Mac OS 10.13.4, MySQL versions 5.7.18 and 5.7.21, Java version: 1.8.0_131 (Oracle Corporation) 64bit, Tomcat version: 8.0.36, JDBC Driver versions: 6.0.6 and 8.0.9, Lucee 5.2.6.60 (express).

Status

Assignee

Michael Offner

Reporter

Jason C

Sprint

None

Fix versions

Affects versions

5.2.6.60

Priority

Blocker