Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

Qliksenserepository password error: the authentication password fails for user "qliksenserepository"

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Sebastian_Linser

Qliksenserepository password error: the authentication password fails for user "qliksenserepository"

Last Update:

Mar 29, 2023 1:21:33 AM

Updated By:

Sonja_Bauernfeind

Created date:

Dec 5, 2018 8:31:00 AM

The Qlik Sense Enterprise on Windows Repository logs password errors.

Example errors:

FATAL:  the authentication password fails for user "qliksenserepository"
DETAIL:  The password does not match for the user«qliksenserepository».

Failure creating schema. 28P01: the authentication password fails for user "qliksenserepository"

Waiting for Message Queue to start. Error 28P01: the authentication password fails for user "qliksenserepository"

Retry attempt: 1/10. Previous result: 28P01: the authentication password fails for user "qliksenserepository"


Resolution

The password for the PostgreSQL repository was changed incorrectly or a micro-service was installed with the wrong password. 

For detailed instructions on how to change the password correctly and how to update individual micro-services, see: How to change the Qlik Sense Enterprise on Windows PostgreSQL password.

 

Environment:

Qlik Sense Enterprise on Windows, all versions

 

Labels (1)
Comments
Rakesh_HB
Support
Support
Christopher-Reiter

Regarding the section that uses -plain-password in the services.conf file - is it possible to re-encrypt that after the change of the password?  It is not common to allow plain passwords in configuration files.

 

Sebastian_Linser

@Christopher-Reiter 

Hello,

yes its possible to re encrypt the password by taking  -plain-password of in the services.conf 

and then just to rerun the configure-service.ps1 scripts for all the microservices which will save the passwords encoded again. Similar to this article here https://community.qlik.com/t5/Knowledge/Postgres-database-moved-to-new-host-but-some-Qlik-Sense-is-s...

 

best regards

Sebastian

KeyReaL
Contributor II
Contributor II

Hello support,

@Sebastian_Linser, can you tell me.....

There is a problem after replacing passwords in the PostgreSQL database

(Article: https://community.qlik.com/t5/knowledge/how-to-Reset-forgotten-postgreSQL-PASSWORD-IN-QLIK-SENSE/TA-...)

I can't get to the platform, error: "Fails to Access The Site"

All services are launched,

In Qliksenseutil, the password coincides,

Using the CMD, I make backup the base with a new password, successfully, the new password accepts.

 

Found your article (https://community.qlik.com/t5/knowledge/qlikserepository-password-and-and-an-eror-contacting-the/ta-...)

I am making password updates, a message comes out for all files:

  Reading the Settings File.

  Saving the Modified Settings.

  Exporting the Copy of the Invocation Parameters.

  <file> configuration Successful.

 

The problem is not solved...

Regards, Kirill.

Sonja_Bauernfeind
Digital Support
Digital Support

Hello @KeyReaL 

It looks like this may require a direct investigation. Please log a support ticket and include your Qlik Sense log files (How To Collect Log Files From Qlik Sense Enterprise on Windows ) and include detailed steps on what steps you have carried out.

All the best,
Sonja 

gandalfgray
Specialist II
Specialist II

The solution shown presumes that the Sense repository database is at localhost and uses port 4432, it should maybe be pointed out that if your deployment has the database somewhere else you should use the path and port applicable for your situation instead of localhost 4432

slivacic1
Partner - Contributor
Partner - Contributor

Also,  be aware if you changed Postgres version to 12.5 that .\Configure-Service.ps1 scripts can have an old Postgres version and you need to change it 

[string]$postgresHome = "$senseInstallPath\Repository\PostgreSQL\9.6",

 

Version history
Last update:
‎2023-03-29 04:21 AM
Updated by: