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

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

book

Article ID: 93132

calendar_today

Updated On:

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