If you are having problems logging in due to an exception caused by an unrecognized time zone, you can fix it using the solution provided in this article.
Exception:
exception=java.sql.SQLException: Cannot create PoolableConnectionFactory (The server time zone value 'EDT' 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.)
Solution:
Add "serverTimezone=<timezone>" to the <Resource name> snippet of the ..\apache-tomcat\conf\server.xml file where indicated below (in bold):
<Resource name="UserDatabase" auth="Container"
type="org.apache.catalina.UserDatabase"
description="User database that can be updated and saved"
factory="org.apache.catalina.users.MemoryUserDatabaseFactory"
pathname="conf/tomcat-users.xml" />
<Resource name="jdbc/nastel_permv3_db_ds"
scope="Shareable"
type="javax.sql.DataSource"
maxWait="5000"
maxActive="4"
maxIdle="2" username="mysql_user" password="nastel" url="jdbc:mysql://localhost:3306/nastel_permv3?serverTimezone=UTC"
driverClassName="com.mysql.jdbc.Driver"
auth="Container"/>
<Resource name="jdbc/nastel_apwmq_db_ds"
scope="Shareable"
type="javax.sql.DataSource"
maxWait="5000"
maxActive="4"
maxIdle="2" username="mysql_user" password="nastel" url="jdbc:mysql://localhost:3306/nastel_apwmq?serverTimezone=UTC"
driverClassName="com.mysql.jdbc.Driver"
auth="Container"/>