Getting access denied when trying to connect Enterprise Dashboard to MySQL external database

Products

• CA Application Test
• CA Continuous Application Insight (PathFinder)
• Service Virtualization

Issue/Introduction

DevTest installed on an AWS environment.

Enterprise Dashboard works fine when connecting to Derby. 

When configured to connect to a MySQL external database getting the below error 

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager': Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Invocation of init method failed; nested exception is java.lang.NullPointerException 


2018-04-20 18:18:36,869Z (14:18) [main] INFO com.ca.dradis.InternalDatabase - Internal database running on 0.0.0.0 port 1530 
2018-04-20 18:18:37,652Z (14:18) [main] ERROR org.apache.tomcat.jdbc.pool.ConnectionPool - Unable to create initial connections of pool. 
java.sql.SQLException: Access denied for user 'Bogus_App_id'@'127.0.0.1' (using password: YES) 
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078) 

Environment

All supported DevTest environments 

MySQL v5.7

Cause

Using a much older MySQL JDBC driver.

Resolution

Updated the MySQL JDBC driver to a newer version that works with MySQL v5.7.

Additional Information

Refer to KB: MySQL Cookbook for DevTest