topic Qlik Sense Repository and Logging Password Expires Every 3 Months in Management & Governance

Qlik Sense Repository and Logging Password Expires Every 3 Months

reycarloluber — Sat, 16 Nov 2024 18:55:17 GMT

Hi,

Currently, the postgres, qliksenserpository, qlogs_writer and qlogs_reader passwords expire every 3 months. I was able to update the password on PostgreSQL to a new one but I don't know how to reflect those password in Qlik Sense. Currently, Qlik Sense is still using the old password to connect to PostgreSQL. To mitigate the issue, I currently set the accounts at pg_hba.conf to trust so there will be no down time. But it would be better to bring it back to md5 for security purposes.

How do I set Qlik Sense to use the new password? I can't seem to see the option to change it in QMC like how data connection has a password text box. We're currently using November 2019.

Re: Qlik Sense Repository and Logging Password Expires Every 3 Months

Andre_Sostizzo — Mon, 23 Mar 2020 19:30:07 GMT

@reycarloluber, unfortunately there is not way to perform this via QMC. You will need to user the QlikSenseUtil tool. Some documentation is found under https://support.qlik.com/articles/000025107

Re: Qlik Sense Repository and Logging Password Expires Every 3 Months

reycarloluber — Thu, 26 Mar 2020 06:28:46 GMT

Thanks @Andre_Sostizzo

I was able to fix the issue on the Qlik Sense Repository by following the links below:

1. https://support.qlik.com/articles/000005425

2. https://support.qlik.com/articles/Basic/Qliksenserepository-password-error-in-the-event-logs-after-changing-the-database-service-user-password?articleId=Qliksenserepository-password-error-in-the-event-logs-after-changing-the-database-service-user-password

As for the Qlik Logging, this link didn't work https://support.qlik.com/articles/000070267. However, I was able to update the password using the update command on Qlik.Logging.Service.exe via cmd. I've updated the hostname, port, reader and writer password.