Troubleshooting the SRM_user for NetOps Report Manager Service-to-Spectrum Integration

Products

• Network Observability
• Spectrum
• CA Performance Management

Issue/Introduction

I am trying it implement the solution but having trouble succeeding.

When installing the Report Manager I am getting errors at the stage of Database Connection Test.

Environment

Dx NetOps 24.3.x

Resolution

Database Connection Test Failed

1. 1. Error Information:
      Unable to open database connection:
      (jdbc:mysql://oc_host:3306/reporting?useUnicode=true&characterEncoding=UTF-8&useSSL=false with SRM_user3) Access denied for user
      'SRM_user'@'reportmanager.company.internal' to database 'reporting'
      
      

It is usually caused by the wrong password or wrong user grands

1. 1. 1. 1. Reset password:
            mysql> ALTER user ‘SRM_user’@’reportmanager.company.internal’ IDENTIFIED BY ‘password’;
            
            
         2. Verify correct grands and fix following the TechDocs if needed:
            mysql> SHOW grants for 'SRM_user'@'reportmanager.company.internal';
            
            

   2. Error Information:
      Unable to open database connection:
      (jdbc:mysql://oc_host:3306/reporting?useUnicode=true&characterEncoding=UTF-8&useSSL=false with SRM_user) Public Key Retrieval is not allowed

It is usually caused by the wrong host value provided when creating the SRM_user

1. 1. 1. 1. Test the connection from Report Manager host to Spectrum One Click host:
            • sudo yum install -y mysql
            • mysql -h <OneClick_IP> -u SRM_user -p 
              Enter password:
              ERROR 1045 (28000): Access denied for user 'SRM_user'@'reportmanager.company.internal' (using password: YES)
              
              
            • This value visible after 'SRM_user'@ needs to be used when creating the user.
         2. Check created users:
            • mysql> SELECT user, host FROM mysql.user;
         3. Fix user definition as required:
            • mysql> DROP user 'SRM_user'@'reportmanager';
            • mysql> CREATE user 'SRM_user'@'reportmanager.company.internal' IDENTIFIED BY ‘password'; 

Additional Information

1. Connect to MySQL:
   
   • $ cd /opt/CA/OneClick/mysql/bin/
   • $ ./mysql --defaults-file=../my-spectrum.cnf -uroot -p
2. Collect basic information:
   
   • SELECT user, host FROM mysql.user;
   • SHOW grants for 'SRM_user'@'HOSTNAME_YOU_FIND_IN_FIRST_OUTPUT';