Live API Creator: Data Explorer cannot connect to the server. No such entity: api keys"

Products

• CA Live API Creator

Issue/Introduction

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

Cause

Your application server and Database servers are listed as two different timezones.

Environment

Release : 5.4

Component : LIVE API CREATOR

Resolution

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';