Restore backup of Production Database for use in Test environment, server id changes?


(John Burrows) #1
  • which versions are you using (SonarQube, Scanner, Plugin, and any relevant extension)
    SonarQube v6.7.6 LTS on both servers: Production & Test
    Both Server configured with Apache HTTPD front-end setup with reverse proxy & SSL
    Both Servers configured exactly the same, except of course database instance and server names
    Both Servers are Red Hat Enterprise Linux Server release 7.6 (Maipo)
    Both Servers utilize Oracle Database v12.2:
    sonarqbp - Production Database Instance
    sonarqbt - Test Database Instance

  • what are you trying to achieve
    Duplicating Production Environment in Test Environment

  • what have you tried so far to achieve this

    • Backed up oracle database sonarqbp (production instance) and restore into sonarqbt (test instance).
    • Removed data/es5 folder and let SonarQUbe rebuild it.
    • Re-applied Test SonarQube license to Test SonarQube application when started.


Edition Data Center Edition


Expiration March 9, 2020

Server ID 76564E69-AWfLudG4Znk2XyDi-6sk

Invalid server ID. Please provide a license for the following server ID: 76564E69-AWfN3BbkCYqlOlKpsvso

Do I need to ask Support for a new license for my Test Instance, even though the Server itself, nor the Database type and instance ID has not changed?

John B

(G Ann Campbell) #2

Hi John,

You will need to get a new license, although I believe it’s your sales contact, not Support, that will supply it.