Unsupported contentThis version of the documentation is no longer supported. However, the documentation is available for your convenience. You will not be able to leave comments.

Upgrading the App Visibility server stops because of database encryption method

Issue

Upgrading the App Visibility server stops with the following message:

The currently installed instance of MySQL uses an old password encryption (hashing) method. Refer to product documentation to change the encryption method before upgrading the BMC Application Diagnostics Server components.

Probable Cause

The computer on which the App Visibility instance of the MySQL database is influenced by a global setting that changes the password encryption method.

Resolution

Perform the following procedure to reset the password encryption method.

  1. Navigate to the following directory:

    • (Windows) installationDirectory\ADOP_DB\bin
    • (Linux) installationDirectory/ADOP_DB/mysql/mysql-5.5.2-m2-linux-x86_64-glibc23/bin

    The default installationDirectory is at the following location:

    • (Windows) C:\Program Files\BMC Software\BMC Application Diagnostics
    • (Linux) /opt/bmc/BMC_Application_Diagnostics
  2. Run the following command to access the MySQL Console:
    • (Windows)mysql -u root -p
    • (Linux)
      ./mysql -u root -p -S /tmp/mysqladop.sock
  3. Enter the encrypted password of the MySQL root user.

  4. Change the old password encryption to the new by running the following commands:

    SET @@session.old_passwords = 0;
    SET PASSWORD FOR 'root'@'localhost' = PASSWORD('rootUserPassword');

    Replace rootUserPassword with the password (in plain text) of the MySQL root user.

  5. If the App Visibility portal is installed, run the following commands:

    SET PASSWORD FOR 'aps_portal'@'localhost' = '*7F746CA8184B8C57232C7375B86E6438B925F3FD';
    SET PASSWORD FOR 'aps_portal'@'localhost.localdomain' = '*7F746CA8184B8C57232C7375B86E6438B925F3FD';

  6. If the App Visibility collector is installed, run the following commands:

    SET PASSWORD FOR 'aps_collector'@'localhost' = '*7F746CA8184B8C57232C7375B86E6438B925F3FD';
    SET PASSWORD FOR 'aps_collector'@'localhost.localdomain' = '*7F746CA8184B8C57232C7375B86E6438B925F3FD';

Related topic

Upgrading-the-App-Visibility-server

 

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*