We receive the following error when stating LAC to our external Database. "Data Explorer cannot connect to the server. No such entity: api keys"
Further investigation of the logs show this: "Unable to create datasource pool: jdbc:(DatabaseType):/(DatabaseIP):3306 lacapikeys null, java.lang.RuntimeException: Unable to use data source Cannot create PoolableConnectionFactory (The server time zone value 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 specific time zone value if you want to utilize time zone support.)
Your application server and Database servers are listed as two different timezones.
Release : 5.4
Component : LIVE API CREATOR
To resolve you must configure either the Database server or JDBC driver (via the 'serverTimezone' configuration property) to use the same timezone value if you want to utilize time zone support
The Below are examples for MySQL:
Updating the JDBC String: jdbc:mysql://<server-name>[:port-number (default 3306)]/[database-name]?serverTimezone=UTC
or
Updating MySQL Server: SET GLOBAL time_zone = '-5:00';