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

Article Id: 4186
Status: Published
Updated On: 23-03-2020 10:56
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.