article Qliksenserepository password error: the authentication password fails for user "qliksenserepository" in Official Support Articles

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

Sebastian_Linser — Wed, 29 Mar 2023 08:21:33 GMT

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

Re: Qliksenserepository password error and an error contacting the license service

Rakesh_HB — Thu, 30 Sep 2021 09:40:57 GMT

With respect to the paths in recent versions, please check below,

https://community.qlik.com/t5/Knowledge/Postgres-database-moved-to-new-host-but-some-Qlik-Sense-is-still/ta-p/1714567

Re: Qliksenserepository password error and an error contacting the license service

Christopher-Reiter — Mon, 25 Oct 2021 12:35:32 GMT

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.

Re: Qliksenserepository password error and an error contacting the license service

Sebastian_Linser — Fri, 29 Oct 2021 12:49:37 GMT

@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-still/ta-p/1714567

best regards

Sebastian

Re: Qliksenserepository password error and an error contacting the license service

KeyReaL — Tue, 13 Sep 2022 06:48:52 GMT

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-P/1712725)

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-p/1715654)

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.

Re: Qliksenserepository password error and an error contacting the license service

Sonja_Bauernfeind — Tue, 13 Sep 2022 07:52:04 GMT

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

Re: Qliksenserepository password error and an error contacting the license service

gandalfgray — Thu, 22 Sep 2022 15:00:33 GMT

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

Re: Qliksenserepository password error and an error contacting the license service

slivacic1 — Wed, 18 Jan 2023 06:46:48 GMT

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",