topic Re: Certificate for the local machine in Integration, Extension & APIs

Certificate for the local machine

g_bolshakov — Sat, 16 Nov 2024 18:07:15 GMT

Hi!

Please tell me what computer name should be specified in the Machine name box field when I export certificates for the local machine?

I am writing a telegram bot that works with the QRS API and uses authorization through my user. But when the bot works through my user, I can't use Qlik Sense because of the closed socket.

I found information that you can log in using a certificate - https://support.qlik.com/articles/000061628

I also found information on how to export certificates via QMC - https://help.qlik.com/en-US/sense/June2019/Subsystems/ManagementConsole/Content/Sense_QMC/export-certificates.htm

I have no idea what name to specify for my personal computer.

I will be grateful for any help!

Re: Certificate for the local machine

Marc — Thu, 17 Sep 2020 01:33:28 GMT

The name used on the exported certificate is irrelevant as you need to use the QlikClient certificate to communicate with the QRS API, not the Server Certificate.

Re: Certificate for the local machine

g_bolshakov — Thu, 17 Sep 2020 07:13:56 GMT

Marc, thank's.

It turns out that exporting certificates via qmc will not help for integration? How do I get a certificate for integration with the QRS API?

Re: Certificate for the local machine

Marc — Tue, 22 Sep 2020 13:09:35 GMT

When you export the certificates from the QMC they are generated in a directory on the Qlik Sense server. C:\ProgramData\Qlik\Sense\Repository\Exported Certificates\<host name entered>

Within this folder you will find certificates, depending on if you chose pem or windows format.

If Pem: Root Certificate (Public cert pem only), Server Certificate (Public cert & Private key pems' issued to <host name entered>), Client Certificate (Public cert & Private key pems')

If windows format, Root.cer, Server.pfx & Client.pfx

When connecting to the QRS APIs you need to use the Client certificate (pems' or pfx depending on the requirements of what you are using to make the API calls)

When using certificates you will need to connect to the QRS on port 4242.

E.g. https://senseserver:4242/qrs/about