Qlik Community


Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING

Qlik Sense Logging Service does not have support for SSL Database traffic encryption

Showing results for 
Search instead for 
Did you mean: 
Digital Support
Digital Support

Qlik Sense Logging Service does not have support for SSL Database traffic encryption

When Database traffic encryption is enabled the Qlik Sense Logging service will not function. When Service is started the service will stop with a 1064 error

For related information please see Qlik Sense - Setting up database traffic encryption


  • Qlik Sense Enterprise November 2018



This is working as designed. The Qlik Sense Logging service is stopping due to it trying to communicate to a database and failing as the database was configured to accept only encrypted traffic. The centralize logging connection string is missing the "Ssl Mode=Require". Traffic then is unencrypted and as result it is rejected by the database and the service reaction is to fail to start with the 1064 error. 

Currently there is no way to modify the connection string from the centralize logging, other than keeping it in cleartext. A Feature Request has been registered.

Feature Request ID(s):

  • 2511 - Enable SSL/TLS on Qlik Logging Service



! Qlik has previously received feedback on this feature and recorded the request for future review.  For up to date information and to express you would like the Feature implemented please contact support at support.qlik.com referencing this article. 


NOTE! The workaround consists of adding encryption to the database connection by making the centralize logging connection string appear in cleartext.

  1. Go to %Program Files%\Qlik\Sense\Repository\Util\QlikSenseUtil.
  2. Open QlikSenseUtil.exe as Admin (right-lick > run as administrator)
  3. In QlikSenseUtil.exe > select "Connection String Editor".
  4. In the file path to config file, place:


    Before making any changes backup file "QlikCentralizedLogging.config" file.

  5. Take the unencrypted connection string.
  6. Open notepad as administrator.
  7. Navigate and open C:\ProgramData\Qlik\Sense\Log\QlikCentralizedLogging.config
  8. Find and remove "<connectionStrings configProtectionProvider="DataProtectionConfigurationProvider"> "  all the way to " </connectionStrings>" 
  9. Now on the same location add the unencrypted connection string ( including the " <connectionStrings>" and  "</connectionStrings>" ) .
  10. Add Ssl Mode=Require.

    For example, step 9 and 10:

    <add name="qlogs_reader" connectionString="user id=qlogs_reader;password=123;host=qlikmachine;port=4432;database=QLogs;Ssl Mode=Require;" providerName="Devart.Data.PostgreSql" />
    <add name="qlogs_writer" connectionString="user id=qlogs_writer;password=123;host=qlikmachine;port=4432;database=QLogs;Ssl Mode=Require;" providerName="Devart.Data.PostgreSql" />
  11. Save the file.
  12. Now start the Qlik Logging Service.
Labels (1)
Version history
Last update:
‎2020-11-09 07:59 AM
Updated by: