8 Replies Latest reply: Jul 22, 2016 4:47 PM by Ravi Mudigonda RSS

    Qlik Sense and SSL offloading

    Michael Forte

      Hello community!

       

      I am researching how to configure Qlik Sense with SSL offloading where the SSL certificate is installed on a load balancer. The load balancer then proxies traffic to the Qlik Server on port 443. I do not have IIS installed.

       

      I was not able to find any direct documentation on setting this (or I wasn't searching the proper terminology!). Does anyone have any insight into how this should be properly configured to avoid certificate issues in the browser and keep the SSL link throughout the connectivity.

       

      I believe this was possible with QlikView.

       

      Thank you for the assistance and apologies if this has been addressed before.

       

      Mike

        • Re: Qlik Sense and SSL offloading
          Gary Strader

          Hey Michael,

           

          I've never set up SSL offloading with Qlik.  The way I understand it is that the load balancer handles all HTTPS traffic, and it proxies that traffic unsecured to the application server (hence the "offloading" aspect of it).  So I don't understand why you say it proxies traffic to Qlik proxy on port 443, because that would require the Qlik proxy to continue to encrypt and decrypt HTTPS traffic.

           

          IIS is not used at all with Qlik Sense.  It has its own "proxy" service which is essential an HTTP/wen sockets server.

           

          If you need to set up SSL certs for Qlik Sense proxy, that should be covered in the installation and configuration PDFs.

            • Re: Qlik Sense and SSL offloading
              Michael Forte

              Hello Gary,

               

              Thank you for the reply and I apologize for any confusion. In a reference architecture for load balancing with SSL offloading to a Qlik Sense installation:

               

              • Traffic connects to qliksense.mycompany.com on port 443 which resolved to the load balancer.
              • The load balancer should be setup to proxy traffic to the Qlik Sense server (proxy node?) on port 80 (or another custom port ?)
              • Communication between the load balancer and the Qlik Sense server (proxy node?) is unsecured, hence the SSL offloading.

               

              A few questions:

              • Is the above conceptually correct?
              • Return traffic moves from the Qlik Sense server to the load balancer unsecured. However, is the return traffic from the load balancer to the client secured?
              • Qlik Sense QMC central node should be configured to Allow HTTP which will override the default service listen port HTTPS?
              • Qlik Sense QMC central node does not need to be configured with an SSL browser certificate thumbprint?
              • Is traffic between Qlik Sense central, data, and proxy nodes secured internally by Qlik Sense or do they require separate setup and a certificate?
                • Re: Qlik Sense and SSL offloading
                  Dave Vernon

                  Hi Michael,

                   

                  From what I know of the QlikSense Proxy Service, it is a load-balancer itself and can be connected to on either 80 or 443. You can add an SSL thumbprint directly to the Proxy which then allows for direct HTTPS access (the easy bit is adding it to QlikSense, the less easy bit is adding it to the windows server, but this tool is really helpful - "DigiCert Certificate Utility for Windows": https://www.digi.com/util/ ).

                   

                  So, in answer to your questions:

                  - Conceptually, I would not use an external load-balancer, I would use a QS node set up to run the QPS.

                  - I would connect qliksense.mycompany.com directly to the node running the QPS (there may be just one windows server in your deployment, running all the services, or you may have a node which is dedicated to running the QPS).

                  - It doesn't have to be unsecured, you could apply the certificate to the windows server and have the Proxy use it.

                  - You only apply the thumbprint within the Proxy (that you want to use over HTTPS).

                   

                  Regarding the internal traffic, as I understand it, it creates a self-signed certificate and uses that to manage traffic securely over TLS:

                   

                  https://help.qlik.com/sense/1.1/en-US/online/#../Subsystems/ServerDeploymentConfiguration/Content/Server/Server-Security…

                   

                  I hope that helps. I'm not a security expert, however, I've done a few installs for clients. I've not been asked to use a third party load balancer, is there a security reason for it?

                   

                  Dave

                    • Re: Qlik Sense and SSL offloading
                      Michael Forte

                      Thank you David.

                       

                      I have found the early version of Qlik Sense server 2.0.x to have a possible TLS Re-negotiation Denial of Service vulnerability. Because there is no web server running in front of QPS I cannot address this issue unless there is a setting in QPS itself. One solution would be to use a load balancer that would disable client-initiated renegotiation.

                       

                      Also, at this particular company, they tend to place a load balancer in front of most servers and use it for automatic DR failover. That said, Qlik Sense is going to force a change in thinking about DR.

                       

                      So far I have configured the load balancer with SSL offloading, configured QPS for HTTP access but cannot get the qliksense.mycompany.com:443 (SSL offloading) to work. I get a ERR_CONNECTION_RESET each time.

                       

                      Thanks,
                      Mike

                        • Re: Qlik Sense and SSL offloading
                          Dave Vernon

                          Interesting to know about the DoS vulnerability in 2.0.x. Do you know if they fixed it in the feature track, 2.1?

                           

                          Yea, QS is a distributed architecture in it's own right - definitely a good thing.

                           

                          Just a thought, but have you checked all the ports you would need? 4248, 8080 and 80 definitely, for HTTP. Websockets generally have proven to be problematic for some clients (I do OEM installations) over HTTP and that's without the added complexity of an external load balancer.

                           

                          Dave

                          • Re: Qlik Sense and SSL offloading
                            Ravi Mudigonda

                            Hi Mike (milton.forte)

                             

                            Were you able to resolve the issue with ERR_CONNECTION_RESET?

                             

                            I'm doing something similar and trying to setup a external load balancer in front of Qlik Proxy nodes and I get the same error. Wondering if you were able to resolve this error.

                             

                            Best,

                            Ravi Mudigonda