New Data Source creation error in CABI JasperServer

Products

• CA Spectrum
• DX NetOps

Issue/Introduction

Manually creating a data source in CABI JasperServer for another DB, however, it throws an error in the test connection phase:

Environment

CABI JasperServer 7.1.1 or later

Cause

The root user being used to access the DB doesn't have privileges to do so.

Resolution

You can login to the MySQL DB as an admin user and run the following to grant privileges to the root user:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY '<PASSWORD>' WITH GRANT OPTION;

However, this is not the regular way you would connect CABI JasperServer to Spectrum.  We do not support any other data sources for CABI JasperServer other than Spectrum.