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:
- Stop all Qlik Sense services, except the Database Repository.
- Open a command prompt (with administrative privileges)
- Go to C:\Program Files\Qlik\Sense\Logging with...
cd "C:\Program Files\Qlik\Sense\Logging"
- 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
- Restart the server host.
Environment:
Qlik Sense Enterprise on Windows