ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

New Data Source creation error in CABI JasperServer

book

Article ID: 241332

calendar_today

Updated On:

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:

Cause

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

Environment

CABI JasperServer 7.1.1 or later

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.

Attachments