Qlik Sense Repository and Logging Password Expires Every 3 Months

[reycarloluber]

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.

[Andre_Sostizzo]

@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

[reycarloluber · Accepted solution]

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

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.