How to install a Qlik Sense Rim Node in an environment with Secure PostgreSQL

[Andrew_Delaney]

The Qlik Sense Installer does not support SSL/TLS connections to PostgreSQL but does require a successful connection attempt to progress. This complicates adding rim nodes to environments who have set an SSL requirement on their PostgreSQL databases.

Environment:

Qlik Sense Enterprise on Windows any version

Resolution:

For Qlik Sense June 2018 and later

1. Run the installation file with SkipValidation=true to disable the check against the database in the installer.
2. Do not check the option to run the services after installation
3. In your Qlik Sense installation, to open the Connection String Editor, navigate to C:\Program Files\Qlik\Sense\Repository\Util\QlikSenseUtil and R-click run as administrator the QlikSenseUtil.exe file.
4. In the Diagnostics Tool, click the Connection String Editor tab.
5. In the Connection String Editor, click Read to see the encrypted connection string.
6. Update the connection string credentials with the corrected connection string.
7. Click Save value above in config file encrypted to save your changes.
8. Start the Qlik Sense Services
9. Add node using QMC as normal

In prior versions of Qlik Sense the SkipValidation flag does not apply to the database connection, which means we have to take further steps.

1. Download PostgreSQL 9.6 Installer
2. Run the installer and instrall PostgreSQL 9.6 on the rim node. You can follow the defaults for this installer, though I recommend unchecking installing stack builder at the end as it is not required.
3. Once this has been installed, open a command prompt and run the following:
   "C:\Program Files\PostgreSQL\9.6\bin\createdb.exe" -h localhost -p 5432 -U postgres -T template0 QSR
   and enter the password selected during the postgresql installation. This creates the database the installer will check for.
4. Install Qlik Sense, selecting to add server to an existing cluster.
   In the database information screen use the following information:
   Database host name: localhost
   Database port: 5432
   Database user: postgres
   Database user password: The one entered during the previous installation
5. Continue with the installation, but uncheck Install Logging Database and uncheck Run Qlik Services after installation
6. In your Qlik Sense installation, to open the Connection String Editor, navigate to C:\Program Files\Qlik\Sense\Repository\Util\QlikSenseUtil and double-click the QlikSenseUtil.exe file.
7. In the Diagnostics Tool, click the Connection String Editor tab.
8. In the Connection String Editor, click Read to see the encrypted connection string.
9. Update the connection string credentials with the corrected connection string.
10. Click Save value above in config file encrypted to save your changes.
11. Start the Qlik Sense Services
12. Add node as normal