MySQL Connector/ODBC Test fails while configuring the Ad Hoc Report ODBC driver in CA Spectrum / CABI BOXI integration

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:

1. Open a bash shell (bash -login)
   
   
2. Navigate to the $SPECROOT/mysql/bin directory
   
   
3. 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)
   
   
4. 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;
   
   
5. The MySQL Connector/ODBC driver test should run successfully.