Qlik Sense Logging Service not starting after qlogs_writer and qlogs_reader passwords changed

[indre_maslinska]

Hello,

The Qlik Sense Logging Service does not start after the qlogs_writer and qlogs_reader passwords update using CMD command "Qlik.Logging.Service.exe update --writer_pswd password" and "Qlik.Logging.Service.exe update --reader_pswd password". The error from Windows Event Viewer is: FATAL: password authentication failed for user "qlogs_writer" DETAIL: Password does not match for user "qlogs_writer". Connection matched pg_hba.conf line 92: "host all all ::/0 md5"

I added the line "host all all ::/0 md5" to pg_hba.conf and checked passwords in QlikCentralizedLogging.config using ConnectionStringEditor - the passwords match the new ones. I also restarted all services and server. Maybe I have to change passwords anywhere else? Like the password for qliksenserepository user after password update?

Thanks for your help!

[indre_maslinska]

Thanks for your help!

[Bastien_Laugiero · Accepted solution]

Hello! 

It is possible that the password defined on Postgres side does it not correct for the user qlogs_writer.

Try to connect to PostgreSQL using Pgadmin following https://community.qlik.com/t5/Knowledge-Base/Installing-and-Configuring-PGAdmin-4-to-access-the-Post...

Then right click on the Qlogs database and select "Query Tool"

Finally run the following command to update the password for qlogs_writer on PostgreSQL side

ALTER ROLE qlogs_writer WITH ENCRYPTED PASSWORD '<qlogs_writer_password>';

Hope this helps! 

[indre_maslinska]

Hello @Bastien_Laugiero !

It works! Thank You!

Best Regards,

Indre