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.
MySQL Connector/ODBC Test fails while configuring the Ad Hoc Report ODBC driver in CA Spectrum / CABI BOXI integration
book
Article ID: 4186
calendar_today
Updated On:
Products
CA Spectrum
Issue/Introduction
Problem:
While configuring the Ad Hoc Report, the MySQL Connector/ODBC driver test fail and the following message is displayed:
Connection Failed: [HY000] [MySQL][ODBC 5.1 Driver] Host 'BOXI_hostname' is not allowed to connect to this MySQL server (IES 10901) (Error: INF)
Cause
The BOXI machine does not have privilege to access the MySQL server
Environment
CA Spectrum 10.2.x and below with CABI 4.1
Resolution
There are the steps to grant privilege to access the MySQL server on the SRM (Spectrum Report Manager) machine: