Documentation forDatabase Performance Analyzer

Upgrade DPA on a Linux-based OS

If you are upgrading from DPA 2022.3 and you configured DPA 2022.3 for SAML authentication, be aware that DPA 2022.4 and later include changes to the SAML configuration. After the upgrade, no one will be able to log in with SAML until you update the configuration.

  • Before you upgrade, make sure you have a local login available.

  • After the upgrade, log in as a local user and complete the steps under "SAML configuration changes" in the DPA 2022.4 Release Notes to update the SAML configuration.

  1. Review the upgrade checklist and prepare your environment.
  2. Download the most recent version of DPA from the SolarWinds Customer Portal.

  3. Log in to the DPA server as a user that owns all of the files in the DPA installation directory.

    If the Find SQL indexes were moved to a custom location, the user must also own all of the files in the custom location.

    To determine if the Find SQL indexes were moved and where, open the following file in a text editor:

    /home/solarwinds/dpa_V_v/DPA/iwc/tomcat/ignite_config/idc/system.properties

    Look for either of the following lines:

    • com.solarwinds.dpa.findSql.index.location=your_custom_location (if all indexes were moved to the same directory)

    • com.solarwinds.dpa.findSql.index.location.db_id=your_custom_location (if indexes for a specific database were moved)

    If neither of those lines are present, the indexes are in the default location:

    /home/solarwinds/dpa_V_v/DPA/iwc/tomcat/ignite_config/lucene-index/

  4. Install the new version in a new directory on your existing server.
  5. Run ./shutdown.sh from the old installation directory.

  6. Locate the directory that was created when you installed the new version:

    /home/dpa_x_x = old installation home

    /home/dpa_y_y = new DPA home

  7. Copy or move these directories from the old installation to the new:

    /iwc/tomcat/conf/
    /iwc/tomcat/ignite_config/
    /iwc/tomcat/logs/
    /iwc/tomcat/licensing

    Do not copy hotfix files.

    For example:

    mv OLD_home/iwc/tomcat/ignite_config/* NEW_home/iwc/tomcat/ignite_config/

    or

    cp -rp OLD_home/iwc/tomcat/ignite_config/* NEW_home/iwc/tomcat/ignite_config/

    Copying Find SQL index data might take some time.

  8. If you are upgrading from DPA 2023.2.100 or earlier to DPA 2023.4 or later, complete the following steps:

    1. Open /iwc/tomcat/conf/context.xml in a text editor.

    2. Delete the following string:

      useRelativeRedirects="false"

      This string fixed an issue in previous versions of Tomcat. It is no longer needed, and it should be removed for security reasons.

    3. Save the file.

  9. If you encrypted the keystore password for SSL/TLS in the Tomcat server configuration file used by DPA, copy or move the following file from the old installation to the new:

    /iwc/tomcat/lib/swdpa-customutil-1.0.0.jar

  10. If you changed the default SolarWinds DPA ports, then you must modify the server.xml file in the new installation to incorporate the port changes from your earlier installation.
  11. Run ./startup.sh from the new directory.

To complete the upgrade:

  • Update any system startup files or cron job scripts that were created for the older version.

  • Ensure the older version of DPA cannot start because this will cause conflicts with your ports, monitored instances, and the repository.

  • If you have configured DPA to use a custom certificate for SSL/TLS, migrate the custom certificate.

If one or more DPA licenses are expired, you must remove the expired licenses before DPA can complete the repository upgrade. When all licenses are compliant, you can complete the upgrade process by opening DPA and clicking Proceed with upgrade.