Windows Event logs report error FATAL: password authentication failed for user "qlogs_reader"

[Sebastian_Linser]

Centralized logging has been deprecated with the Qlik Sense Enterprise on Windows May 2021 release. This article applies to environments which have retained old Monitoring Apps. No support can be provided on Qlik Centralized logging as all Qlik Sense versions using it have reached end of life. 

If an old set of Qlik Sense Monitoring Apps (such as the License Monitor or Operations Monitor) have been maintained after the deprecation of Centralized Logging, these Monitoring Apps may still attempt to use an incorrect data connection.

This will lead to the following error: 

error FATAL: password authentication failed for user "qlogs_reader" DETAIL: Role "qlogs_reader" does not exist. Connection matched pg_hba.conf line 80: "host all all 127.0.0.1/32 md5"

In this instance, the License and Operations Monitor are attempting to connect to the Centralized Logging Database rather than reading from disk. 

Environment

Qlik Sense Enterprise on Windows 

Resolution:

1. Open the Qlik Sense Management Console
2. Open the Apps menu
3. Duplicate the affected app
   
   1. Select the app
   2. Click More actions
   3. Select Duplicate
      
      
4. Open the duplicated app (either click the provided link or navigate to the Qlik Sense hub)
5. Open the Data load editor
6. Search for db_v_file_override 
   
   
   
   
7. Change:
   
   SET db_v_file_override    =    0
   
   to
   
   SET db_v_file_override    =    1
   
   
   
   
   • The default value is 0 which attempts to use the Centralized Logging Database to supplement the License and Operations Monitor
   • The value of 1 sets the License and Operations Monitor to only use the files on the disk and make no attempt to query the Centralized Logging Database
     
     
8. Publish (and Replace) the old app version