Issue installing CA Release Automation (All in One) - MYSQL

book

Article ID: 194607

calendar_today

Updated On:

Products

CA Release Automation - Release Operations Center (Nolio) CA Release Automation - DataManagement Server (Nolio)

Issue/Introduction

While installing CA Release Automation (All in One) with MySQL 8 we get the error "Failed to connect to database***"

Cause

As per recommendation with respect to MySQL, it is suggested to use connector MySQL 8.0.11 with MySQL. The error observed is due to the fact of using connector 5.1.21

Using MySQL 8 with MySQL Connector 5.1.21, results in below error

"Failed to connect to database. 'jdbc:mysql://127.0.0.1:3306/' for user 'root'. Unable to load"

Environment

Release : 6.4, 6.5, 6.6, 6.7

Component : CA RELEASE AUTOMATION RELEASE OPERATIONS CENTER

DB: MySQL 8

JDBC Connector: 5.1.21

Resolution

Recommendation: 

1: MySQL 8 is not supported yet for 6.7 so please avoid using MySQL 8 and instead use supported MySQL version.

2: The connector version 8 will not be supported for 6.7 and hence you will have to use 5.1.** version of connector. An upgraded minor version like 5.1.46 is fine as we don't expect major change in minor version upgrades.

You can try JDBC connector version 5.1.46 as it seems to installed and works with MySQL 8. However, please note it can only be used for Test instance and not for any production/development instance as RA doesn't support MySQL 8 and 5.1.46 is not a recommended driver for MySQL 8 which can lead to unexpected future issues related to application and DB connectivity.

Note: Any issue reported for RA (version till 6.7) + MySQL 8 will fall under unsupported configuration matrix and will restrict us to provide any technical assistance on same.