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:
- Open a bash shell (bash -login)
- Navigate to the $SPECROOT/mysql/bin directory
- Launch the MySQL command prompt
Run: ./mysql -uroot -proot (for Windows platform)
Run: ./mysql --defaults-file=../my-spectrum.cnf -uroot -proot (for Linux/Solaris platform)
- At the MySQL command prompt, run the following MySQL commands:
mysql> GRANT ALL PRIVILEGES ON srmdbapi.* TO 'WEBI_user'@'<BOXI machine FQDN>' IDENTIFIED BY '0n3cl1Ck';
mysql> GRANT ALL PRIVILEGES ON srmdbapi.* TO 'CR_user'@'<BOXI machine FQDN>' IDENTIFIED BY '0n3cl1Ck';
mysql> FLUSH PRIVILEGES;
- The MySQL Connector/ODBC driver test should run successfully.
Feedback
thumb_up
Yes
thumb_down
No