Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Jul 3, 2024 9:59:43 AM
Mar 8, 2023 9:12:59 AM
During installation, Qlik Sense Enterprise on Windows prompts you to choose a password for its PostgreSQL repository. This password can be changed. The process is split into three steps.
- 1. Changing the PostgreSQL password in the database
- 2. Changing the Connection String to QSR and QSMQ Database
- 3. Changing the Connection String for Micro-Services
1. Changing the PostgreSQL password in the database
- Download and install pgAdmin 4
- Connect to your Qlik Sense PostgreSQL database:
-
Host name/address: localhost (if the database has been installed on the local machine)
-
Port: 4432
-
Maintenance database (*): postgres
-
Username: postgres
-
Password: Your current password
(*) Note that the maintenance database name may differ if this was not a standard installation and changes were made during setup. Consult your configuration file if necessary.
-
- Right Click on the postgres database.
- Click Query Tool
- Copy the following queries into the Query Tool, replacing Example Password with your new password:
ALTER USER postgres WITH PASSWORD 'Example_Password';
ALTER USER qliksenserepository WITH PASSWORD 'Example_Password';
- Run the Query
This has changed the password in the database itself. We will now move on to modifying the connection strings used by the database.
2. Changing the Connection String to QSR and QSMQ Database
For this step, we will need the QlikSenseUtil stored in C:\Program Files\Qlik\Sense\Repository\Util\QlikSenseUtil\.
It has to be repeated on all nodes.
- On the Qlik Sense central node, stop all services except the Qlik Sense Repository Database Service
- Open QlikSenseUtil
- Open the Connection String Editor and Read the current configuration. This decrypts the current data.
- Change the Password in the following two connectionStrings:
- QSR
- QSMQ
- Hit Save Value in config file encrypted
We have now changed the connection strings to the QSMQ database and the QSR database.
3. Changing the Connection String for Micro-Services
Qlik Sense has introduced micro-services, all of which will require to have their connection strings modified.
To make changing them easier, we have provided a Configure-Service.ps1 for each. They can be located in:
Always run PowerShell as administrator.
- C:\Program Files\Qlik\Sense\Licenses\Configure-Service.ps1
- C:\Program Files\Qlik\Sense\NotifierService\install\Configure-Service.ps1
- C:\Program Files\Qlik\Sense\AppDistributionService\Configure-Service.ps1
- C:\Program Files\Qlik\Sense\HybridDeploymentService\Configure-Service.ps1
- C:\Program Files\Qlik\Sense\MobilityRegistrarService\install\Configure-Service.ps1
- C:\Program Files\Qlik\Sense\PrecedentsService\install\Configure-Service.ps1
- C:\Program Files\Qlik\Sense\NLAppSearch\install\Configure-Service.ps1
Depending on your version of Qlik Sense, the above list may not be complete. Review C:\Program Files\Qlik\Sense\ for any additional micro-service folders that include a Configure-Service.ps1. You can obtain a list of all relevant folders by running the following command in a command prompt: dir /s configure-service.ps1
To update your password using Configure-Service.ps1:
- Open an elevated Powershell and change the directory to (for example with the license service) C:\Program Files\Qlik\Sense\Licenses
- Run the Configure-Service.ps1 script as follows, providing the correct hostname and the new password:
.\Configure-Service.ps1 YourPostgresHostName 4432 qliksenserepository ExamplePassword
You may receive the following: WARNING: Skipping the database initialization. No superuser or password specified.
This is expected. It does not indicate that the password change has failed. - Repeat these steps for the remaining micro-services. Your PostgreSQL password has now been changed.
If you have not installed Qlik Sense in its default location or have upgraded PostgreSQL, the Configure-Service.ps1 script must be adjusted for each microservice.
Example for changing the install path:
Before:
[string]$senseInstallPath = "$env:ProgramFiles\Qlik\Sense"
After:
[string] $senseInstallPath = "D:\Program Files\Qlik\Sense",
Example for changing the PostgreSQL version:
Before:
[string]$postgresHome = "$senseInstallPath\Repository\PostgreSQL\9.6"
After:
[string]$postgresHome = "$senseInstallPath\Repository\PostgreSQL\12.5"
or
[string]$postgresHome = "$senseInstallPath\Repository\PostgreSQL\14"
Depending on the PostgreSQL version under C:\Program Files\Qlik\Sense\Repository\PostrgreSQL\
Micro-Services Alternative method:
The alternative is to find all the PowerShell files programmatically.
Note that in our example we assume the default install directory and the default port of 4432. You may need to adapt the script accordingly.
# Set the Installation Directory for Qlik Sense
$installDir = 'C:\Program Files\Qlik\Sense\'
# Specify the new password for the qliksenserepository account
$password = 'MyNewPassword'
$files = Get-ChildItem -Path $installDir -Include Configure-Service.ps1 -Recurse
foreach ($file in $files) {
$ScriptToRun=$($file.FullName)
&$ScriptToRun localhost 4432 qliksenserepository $password
}
Bonjour,
Avec la restriction des caractères avec QPI 1.3.0, la modification a bien fonctionnée pour moi. Quels sont les impacts sur l’utilisation de l’authentification SAML sur ce changement.
1- Changeur du mot de PASSE Postgres
2- Modification de la config via QlikSenseUtil
Dans l’Environnement de DEV, tous est ok, sans ADFS
Environnement PROD, La QMC ne s’ouvre plus. Tous les services démarrent, mais j’ai des erreurs lors du test de la connexion avec QlikSenseUtil
Le problème est-il lié a l'ADFS ou au changement de mot de passe ?
