Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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!
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!