Upgrading the database makes the license invalid (due to the checksum for “Server ID" changes)

[Valeriia_Iuzhakova]

Hi Everyone,
We’re experiencing the following issue:
Pre-conditions: We are upgrading SonarQube (Developer Edition) from version 7.7 to 7.9.3 LTS and deploying it to the test environment first.

Problem: We need to migrate SonarQube DB from MySQL to PostgreSQL (because SonarQube does not support the following versions of MySQL DB).
The thing is when we changing the database type, the checksum for “Server ID" changes as well. In this case, with the DB upgrade, the check of the “Server ID" code will not pass, and which makes the only license we have invalid. So how should we proceed with the upgrade of the DB?

Looking forward for your advice.
Kind regards,
Valeriia

[Rebse (Gilbert Rebhan)]

Hi Valeriia,

we had the same problem when upgrading our db version and did as proposed here

Upgrades with docker containers changes server ID?

Hi @NemligTim, Yes, it will, as the license is tied to a specific ServerID. Just send your new ServerID (in your Administration menu, System infos) to your Sales rep, with the old one, so he/she can adjust the license key and generate a new one, tied to this new ServerID. Carine

and

Will the Server ID change if I move SonarQube to a new host/instance?

Vineet, You cannot edit your Server ID. If you have a stable Server ID (your Database won’t be wiped and started again), you should request a new license from contact@sonarsource.com. Best regards, Colin

If your update runs within normal business time you will get a quick respone with a new license
from Sonarsources sales team.

Gilbert

[Valeriia_Iuzhakova]

Thank you a lot, Gilbert