MySQL Connector/ODBC Test fails while configuring the Ad Hoc Report ODBC driver

Document ID : KB000004186
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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)

 BOXI Connection Error.png

MySQL_Connector_ODBC.png

 

Environment:
CA Spectrum 10.xCABI 4.1
Cause:

The BOXI machine does not have privilege to access the MySQL server

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. Run the MySQL commands below:

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.