Server ID change to the new one after change in the sonar properties how to fix it

[Amneet Padda]

Hi 

We have recently upgraded to SonarQube 6.7.1 and server ID is based on the jdbc.host.url if it changes than the server ID also changes.

During maintenance activity, administrator changed the jdbc.host.url to IP  of the same db machine instead of the URL which we are using as their was some connectivity issue.

Now the Server ID value has changed and even when we change the jdbc.host.url to URL one a totally new server ID appears.

How can we fix this issue without involving the Vendor.

Regards

Aman

[nicolas...@sonarsource.com]

H Aman,

Indeed, as documented (also mentioned in sonar.properties): Note that if the database connection string is updated, the server ID will be re-generated and a new license will be needed. And to avoid any misunderstanding: this does not mean that the Server ID is computed based on the JDBC URL. The Server ID remains completely random, however if the JDBC URL changes then it's invalidated and regenerated.

 How can we fix this issue without involving the Vendor.

You cannot. Once your ServerID is regenerated then you need to obtain new license for it. And ultimately be cautious with any future JDBC URL property update.

Best regards,

Nicolas

[G. Ann Campbell]

Hi Aman,

To expand on what @Nicolas wrote, you can't address this without contacting "the vendor" but there won't be an additional charge for the generation of a new license key just to resume the use of what you already purchased - in case that was your concern.

Ann