topic Re: register ssl certificate on qlikview webserver in QlikView

register ssl certificate on qlikview webserver

Masi_Sahargahi — Sat, 16 Nov 2024 20:19:40 GMT

Hi,

Recently we are forced to change all websites from http to https.

I registered ssl sertificate based on the following instruction:

https://community.qlik.com/t5/QlikView-Documents/Enable-SSL-QlikView-Webserver/ta-p/1495958

I did all the steps and as a last step I run the below command in cmd and I got this message:

The ssl certificate successfully registered,

netsh http add sslcert ipport=0.0.0.0:443 certhash=0000000000003ed9cd0c315bbb6dc1c08da5e6 appid={00112233-4455-6677-8899-AABBCCDDEEFF}

I changed the port from 80 to 443 and sleceted "use https"( in qlikview web server), then I reseted qlikview web server.

But nothing happened after that and access point didn’t load with new configuration.

Any help would be highly appreciated.

Re: register ssl certificate on qlikview webserver

kaushiknsolanki — Sat, 03 Aug 2019 06:23:09 GMT

HI,

Did you try manually typing the URL with HTTPS?

What error did it throw.

Regards,

Kaushik Solanki

Re: register ssl certificate on qlikview webserver

Masi_Sahargahi — Sat, 03 Aug 2019 10:46:28 GMT

https://ServerIP:443/qlikview

error: "This site can’t be reached"

Also when I run qlikview data access in server I get the same error.

Re: register ssl certificate on qlikview webserver

Masi_Sahargahi — Sun, 04 Aug 2019 05:35:04 GMT

any idea about it please?

Re: register ssl certificate on qlikview webserver

kaushiknsolanki — Wed, 07 Aug 2019 08:11:57 GMT

Hi,

You have IIS configured or you are using default Qlik Web Server?

Regards,

Kaushik Solanki

Re: register ssl certificate on qlikview webserver

Masi_Sahargahi — Wed, 07 Aug 2019 08:25:21 GMT

I don't have iis,I configured Qlik web server.

Re: register ssl certificate on qlikview webserver

Bill_Britt — Mon, 12 Aug 2019 17:45:47 GMT

Hi,

Go to C:\ProgramData\QlikTech\WebServer and open the Config.xml file. Make sure the third line is

https://_/ that is what tells QVWS to run as 443. If that is set correctly. Stop QVWS service open a cmd window and type

netstat -an | find "443" to see if something else is using port 443

Bill

Re: register ssl certificate on qlikview webserver

Masi_Sahargahi — Tue, 13 Aug 2019 04:25:37 GMT

Thanks bill,

Here is the first 5 row of web server config file :

-<Config>

http://_/

<DefaultQvs>QVS@biserver</DefaultQvs>

http://_:4750/QVWS/Service

Re: register ssl certificate on qlikview webserver

Bill_Britt — Tue, 13 Aug 2019 11:20:38 GMT

HI,

As you can see your config file is still set for non SSL. Try this, set the option in the QMC for SSL and port to 443 and click apply. Check the line http://_/ to see if it changed to https://_/

If not rename the config.xml file and Qlik should regenerate it. Check again to see if the line is showing https

Bill

Re: register ssl certificate on qlikview webserver

Sean_BI — Tue, 13 Aug 2019 14:38:07 GMT

Hi -

Can you check if you have https in QMC-->systems tabs- go to set->Select webserver-->go to general tab--> go to URL text box and type https://server name:4750/QVWS/Service.

Ensure you add "s" .

Ensure you select "use https:" check box under communication tab.

Ensure you type 443 "Port" box.

If this still not responding, please provide the screen shot.

Rgds,

Sean.

Re: register ssl certificate on qlikview webserver

Masi_Sahargahi — Wed, 14 Aug 2019 05:07:18 GMT

I have re_configed it again and this time config file is as below:

<?xml version="1.0"?>

-<Config>

https://_/

<DefaultQvs>Local</DefaultQvs>

http://_:4750/QVWS/Service

<TunnelUrl>/scripts/QVSTunnel.dll</TunnelUrl>

<QvsStatusUrl>/QvAJAXZfc/QvsStatus.aspx</QvsStatusUrl>

<LogLevel>Information</LogLevel>

<WriteStackTrace>False</WriteStackTrace>

but still my access point does not work

1.which url exactly should I type manually?

2-I read somewhere to add this tag to config file.is it necessary ?

Re: register ssl certificate on qlikview webserver

Masi_Sahargahi — Wed, 14 Aug 2019 05:32:40 GMT

Thanks for your reply,

I've done all of these steps but still no result,

the

first rows of config file are as below:

https://_/

<DefaultQvs>Local</DefaultQvs>

http://_:4750/QVWS/Service

<TunnelUrl>/scripts/QVSTunnel.dll</TunnelUrl>

<QvsStatusUrl>/QvAJAXZfc/QvsStatus.aspx</QvsStatusUrl>

<LogLevel>Information</LogLevel>

Re: register ssl certificate on qlikview webserver

Sean_BI — Thu, 15 Aug 2019 17:02:23 GMT

Okay.. Then it isn't qlikview issue at all. Qlikview is simple in terms of setting up SSL.

The only thing i can think of now is to check the qliview webserver log and windows logs to check what is stopping the access point page not getting loaded.

Type compmgmt.msc from command prompt

Go to Event Viewer-go to windows logs-go to applications

Go to Event Viewer-go to windows logs-go to security

Rgds,

Sean

Re: register ssl certificate on qlikview webserver

Sean_BI — Thu, 15 Aug 2019 18:08:58 GMT

You need to contact Networking team to enable Load balancer for access point.

Rgds,

Sean.

Re: register ssl certificate on qlikview webserver

Sean_BI — Sun, 18 Aug 2019 12:55:33 GMT

Hope your issue got resolved.

Rgds,

Sean.

Re: register ssl certificate on qlikview webserver

Masi_Sahargahi — Mon, 19 Aug 2019 05:53:27 GMT

Thanks for following,

I did'nt work on it,

But I think it might be related to ssl certificate.

Server's certificate details is as below:

and Server's qualified name is "fully-qualified name"

and after configuration I will check this address:

https://ics.edbi.ir/qlikview

but it doesnt work..

i'm really confused.Do I need to add this address to DNS ?

Re: register ssl certificate on qlikview webserver

Sean_BI — Tue, 20 Aug 2019 12:15:41 GMT

I understand why it does not work..

https://ics.edbi.ir/qlikview

The DNS entry should have a valid certificate key generated along with password.

It's not related to Qlikview issue.

You need to get hold of team who have created the DNS and configure Digital certificate with private key at DNS level.

Rgds,

Sean.

Re: register ssl certificate on qlikview webserver

Bill_Britt — Tue, 20 Aug 2019 12:19:09 GMT

How about just creating a CNAME in DNS and pointing it to the Webserver.

Re: register ssl certificate on qlikview webserver

Brett_Bleess — Thu, 22 Aug 2019 21:55:30 GMT

Masi, here is a post to a new Support Blog post a coworker just did a few weeks ago, will allow you to go back through things and be sure you did not miss anything.

https://community.qlik.com/t5/Qlik-Support-Updates-Blog/QlikView-AccessPoint-and-QMC-with-HTTPS/ba-p/1609779

Regards,
Brett

Re: register ssl certificate on qlikview webserver

Masi_Sahargahi — Sat, 14 Sep 2019 06:39:52 GMT

I inserted a record in DNS(server Ip and the name of ssl).It works now.

Thanks a lot