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

[Sebastian_Linser]

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

[Rakesh_HB]

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-s...

[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]

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]

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]

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]

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