Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

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

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Sonja_Bauernfeind
Digital Support
Digital Support

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

Last Update:

Apr 12, 2023 6:29:15 AM

Updated By:

Sonja_Bauernfeind

Created date:

Apr 1, 2019 7:57:04 AM

The Windows Event log reports: 

FATAL: password authentication failed for user "qlogs_reader"  DETAIL: Password does not match for user "qlogs_reader"
Connection matched pg_hba.conf line 80: "host all all ::1/128 md5"

This indicates that the wrong password is being passed for the qlogs_reader user. 

Resolution:

To correct the password:

  1. Stop all Qlik Sense services, except the Database Repository.
  2. Open a command prompt (with administrative privileges)
  3. Go to C:\Program Files\Qlik\Sense\Logging with...
    cd "C:\Program Files\Qlik\Sense\Logging"​
  4. Run these commands in that order: 
    "C:\Program Files\Qlik\Sense\Logging"\Qlik.Logging.Service.exe setup --hostname FQDNofTheDatabase --port 4432 --postgres_user postgres --postgres_pswd PostgresUserPassword --writer_pswd IntendedWritePassword --reader_pswd ReaderWritePassword​
    "C:\Program Files\Qlik\Sense\Logging"\Qlik.Logging.Service.exe update --hostname FQDNofTheDatabase --port 4432 --postgres_user postgres --postgres_pswd PostgresUserPassword --writer_pswd IntendedWritePassword --reader_pswd ReaderWritePassword --database_logging off
  5.  Restart the server host.

 

Environment:

Qlik Sense Enterprise on Windows 

Labels (1)
Contributors
Version history
Last update:
‎2023-04-12 06:29 AM
Updated by: