Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

When a customer needs to change the iQSonar database settings (either because they are changing the connection credentials, or because they are migrating the DB to a different server instance) there is currently no simple method to change the settings in the User Interface.

The following guide lays out a step-by-step procedure to migrate the scan-engine to use a different back-end database connection

Migrate a single-scan-engine installation

To migrate a single-scan-engine configuration to use a database on a new server, or when you are changing the credentials used to by the scan engine to access the DB:

  1. Pause all active projects, and wait until the server is idle
  2. stop the iQSonar ScanEngine service
  3. Back up the iQSonarSE database from the old server
  4. Restore the iQSonarSE database to the new server
  5. Make a backup of your iqsonar.key file, and your iQuate.iQSonar.ScanEngine.exe.config files. These are found in the folder "C:\Program Files\iQuate\iQSonar ScanEngine 4.0\bin" in a default installation.
  6. Uninstall iQSonar, and then delete the folder “C:\Program Files\iQuate\iQSonar ScanEngine 4.0\”
  7. Install the new version of iQSonar using a “custom” install, but make sure you do not allow it to start the service. When prompted for the iqsonar.key, point to the location of the key you backed up in step 5
  8. In Notepad or Notepad++, open the iQuate.iQSonar.ScanEngine.exe.config you backed up in step 5. This is copy 1 of the config file.
    Run Notepad or Notepad++ as an Administrative user, and open the new copy of iQuate.iQSonar.ScanEngine.exe.config in the C:\Program Files\iQuate\iQSonar ScanEngine 4.0\bin folder.  This is copy 2 of the config file.
  9. From copy one of the config file, find the section <appSettings file="user.config">, and copy the  following keys over into copy 2, replacing the values for any keys that already exist, and adding in new keys for the ones that don’t exist:
    1. KSitePrivate
    2. KSitePublic
    3. KSiteSignature
    4. installation-uuid
  10. Save copy 2 of the config file.
  11. ONLY NOW can you start the service.
  12. Once the service has started, you can log in to the UI and unpause the project.

Migrate a multiple-scan-engine installation

  1. Pause all active projects, and wait until the server is idle
  2. Stop the iQSonar ScanEngine service on all servers
  3. Back up the iQSonarSE database from the old server
  4. Restore the iQSonarSE database to the new server if you are migrating the DB to a new location.
  5. We will upgrade the scan engine server which hosts the User Interface first.
    1. Make a backup of your iqsonar.key file, and your iQuate.iQSonar.ScanEngine.exe.config files. These are found in the folder "C:\Program Files\iQuate\iQSonar ScanEngine 4.0\bin" in a default installation.
    2. Uninstall iQSonar, and then delete the folder “C:\Program Files\iQuate\iQSonar ScanEngine 4.0\”
    3. Install the new version of iQSonar using a “custom” install, but make sure you do not allow it to start the service. When prompted for the iqsonar.key, point to the location of the key you backed up in step 5. Ensure you have the correct database settings for the new database location/credentials.
    4. In Notepad or Notepad++, open the iQuate.iQSonar.ScanEngine.exe.config you backed up in step 5. This is copy 1 of the config file.
      Run Notepad or Notepad++ as an Administrative user, and open the new copy of iQuate.iQSonar.ScanEngine.exe.config in the C:\Program Files\iQuate\iQSonar ScanEngine 4.0\bin folder.  This is copy 2 of the config file.
      1. KSitePrivate
      2. KSitePublic
      3. KSiteSignature
      4. installation-uuid
    6. From copy one of the config file, find the section <appSettings file="user.config">, and copy the  following keys over into copy 2, replacing the values for any keys that already exist, and adding in new keys for the ones that don’t exist (Note: the installation-uuid is different for each scan engine. The other three values should be consistent across all your servers):
    7. Save copy 2 of the config file.
  1. Restart the service on the UI server. This should upgrade the DB.
  2. Wait until the DB has finished upgrading and the version-number shown for the scan-engine in the UI is correct.
  3. Repeat step 5 a – g for all other scan engines, without starting the service on the servers.
  4. Once all scan engine servers have been upgraded, and the database upgrade has been completed by the UI server, THEN restart the service.
    At this point touch base with iQuate support staff to double check if there are any additional SQL commands to be executed.
  5. Verify that all your scan engines display the correct build number in the UI.
  6. Now you can unpause any projects which were paused in step one.





  • No labels