topic Re: Qliksense generating old certificate after server migration in Management & Governance

Qliksense generating old certificate after server migration

trigotrt — Mon, 08 Mar 2021 14:00:11 GMT

hi folks,

few weeks ago, we had migrate our qliksense server to another machine and now hub and qmc gets unaviable every time I need to restart the machine or the services . I noticed that the problem is in the certificate. After every restart qliksense server is creating the certificate for the old and for the new machine. I saw it in the mmc´s (microsoft management console) snap-ins.

Does anyone know where I can remove this reference to the old machine?

Re: Qliksense generating old certificate after server migration

Bastien_Laugiero — Tue, 09 Mar 2021 07:37:28 GMT

Hello!

I know three places that contains the machine name referenced in the certificate:

C:\ProgramData\Qlik\Sense\host.cfg (Encrypted base64)
QSR Database -> ServerNodeConfiguration
QSR Database -> LocalConfig (For older version of Qlik Sense)

Can you check these three places and make sure the hostname is the same. (case included)

Hope this helps!

Re: Qliksense generating old certificate after server migration

trigotrt — Wed, 10 Mar 2021 17:08:20 GMT

Hi, thanks for your reply 😃

1) C:\ProgramData\Qlik\Sense\host.cfg (Encrypted base64):

2) QSR Database -> ServerNodeConfiguration:

3) QSR Database -> LocalConfig (For older version of Qlik Sense)

I checked 1 and 2, they are correct, unffortunatelly they are not causing the problem.

Do you have any more idea?

Re: Qliksense generating old certificate after server migration

Bastien_Laugiero — Thu, 11 Mar 2021 07:26:16 GMT

Hi,

Thanks for your feedback.

If these places are correct I would then suggest to recreate all Qlik Sense certificates on the central node and redistribute to the rim.

Note: This will require to re-enter the password of your data connection from the QMC post certificate re-creation.

So idea would be to remove the new and old certificates on the central node (please make sure you back them up first) and then run the bootstrap command documented here:

https://community.qlik.com/t5/Knowledge-Base/How-to-recreate-or-just-delete-certificates-in-Qlik-Sense-No/ta-p/1712692

Hope this helps!