topic Re: Sense doesn't install certificates in Management & Governance

Sense doesn't install certificates

Anonymous — Wed, 28 Feb 2018 20:38:55 GMT

I'm having trouble reaching the Hub/QMC after removing my local certificates.

Followed some guide here: Re: Error 500 - Internal server error - Cannot establish a connection to Qlik Sense: Qlik Sense Management Console

, which suggested I remove the certificate and have Qlik Sense recreate them.

What ever I do they are not recreated and now I'm stuck.

See my logs which states:

Command=Start repository;Result=-1;ResultText=Error: Certificates are not correctly installed

I've tried starting/stopping/restarting the services multiple times. I even rebooted the machine.

I found some docs here: https://help.qlik.com/en-US/sense/September2017/Subsystems/PlanningQlikSenseDeployments/Content/Deployment/Services.htm

stating that "Recreate certificates by running the QRS in bootstrap mode."

The steps should be:

Do the following:

Stop all Qlik Sense services except Qlik Sense Repository Database.
Run repository.exe -bootstrap from an elevated command prompt.
Start Qlik Sense services.

The output halts on Waiting for certificates to be installed (see screenshot). It's not possible to run repository in a non-elevated command prompt so that's not the issue.

More info: i'm running my Qlik Sense using an account named qsservice.

Re: Sense doesn't install certificates

Levi_Turner — Thu, 01 Mar 2018 01:54:36 GMT

I am assuming that you're on Qlik Sense June 2017 or newer. From https://help.qlik.com/en-US/sense/September2017/Subsystems/PlanningQlikSenseDeployments/Content/Deployment/Services.htm, you are missing a key command line parameter. You ought to run Repository.exe -bootstrap -iscentral *. The waiting for certificates message is signaling that the node thinks it ought to be a RIM node, where certificates are distributed to it rather than generating their own.

Previous threads may've missed this distinction since historically Qlik Sense would re-generate certificates if needed. Due to the architectural changes needed to allow failover inside of Qlik Sense (STT - Failover in Qlik Sense - Practical Guide and Implications - YouTube) this step is needed.

* At some point it was Repository.exe -bootstrap -standalone so I typically would recommend running Repository.exe -bootstrap -standalone -iscentral which would eliminate any confusion.

Hope that helps.

Re: Sense doesn't install certificates

Anonymous — Thu, 01 Mar 2018 06:45:19 GMT

This worked!

However, now I have a secondary problem that my proxy doesn't work, ie hub/qmc still unavailable.

See log for more info but basically

Web exception: Protocol error: Response stream exists. Remote endpoint 'https://localhost:4242/' [..] Not available Proxy Not available Not available Configure proxy -2146233079 Could not contact local repository to retrieve local server node configuration

If i open https://localhost:4242 in my browser I get a certification error (see attached screenshot).

The translation is roughly:

The server could not prove it's localhost since its certificate originates from static-31.15.37.161.se.ip.tdc.net

When removing all certificates via the MCC, Qlik generates another certificate from static-31.15.37.161.se.ip.tdc.net so how can this be an improper configuration?

Re: Sense doesn't install certificates

Levi_Turner — Thu, 01 Mar 2018 15:40:04 GMT

It isn't an improper configuration. It's a misalignment of the host used (localhost) and the Common Name / Subject Alternative Name of the certificate (static-31.15.37.161.se.ip.tdc.net). You can either click continue to get past this point or use the Chrome interstitial command "badidea" to bypass it (https://www.reddit.com/r/sysadmin/comments/42xd4i/chrome_danger_shortcut_changed_to_badidea/).

Re: Sense doesn't install certificates

jamshed07 — Tue, 05 May 2020 11:07:13 GMT

this is very useful article ,follow this

https://support.qlik.com/articles/000005402