Logging database setup failed

[rohitk1609]

Hi Techies,

I have tried to install Qlik Sense several times but it is failing with message "Logging database setup failed". Then I installed Qlik Sense without enable centralized logging and it installed successfully.

I tried to configure centralized logging by CMD but it is giving me error "Failed to execute database setup".

Qlik Sense version: September 2018.

User has full rights of admin and same is service user.

It was working earlier, then I uninstalled and try to install this error comes.

[wynandack]

Try running Qlik.Logging.Service.exe update -w (then your password for the qlogs_writer)

Try running cmd as the service account that runs the qlik services

[rohitk1609]

I have executed the command with service user it shows me success message but there are two errors.

1.no pg_hba.conf entry for host "fe80::48ba:9bbb:54f3:2003%17", user "qlogs_writer", database "QLogs", SSL off

then I checked pg_hba.conf , it was missing so I copied it from another server then again same error is coming

2018-10-23 15:45:27,933  [Qlik.Logging.Service.exe] root [ERROR] - QLService::OnStart failed to setup service for execution!

My question is with which password authentication is happening ?

1. I set in Definition section:

2. Second i set password for qlogs_writer by command:

Qlik.Logging.Service.exe update -w

where else we can set password which is mismatching ?

[rohitk1609]

I have restarted the machine and now this is the error:

no pg_hba.conf entry for host "fe80::48ba:9bbb:54f3:2003%17", user "qlogs_writer", database "QLogs", SSL off

I am not sure Password issue is fixed or not

[wynandack]

Hi, just check your account expiration date there as well

The SSL off setting is in the postgresql.conf file, but mine is still commented out by default.

try adding the following into the hba conf to test

host      all             all             ::1/128                 md5

host      all             all             0.0.0.0/0              md5

Check this help guide for more info on the postgres config on qlik as well:

https://help.qlik.com/en-US/sense/February2018/Subsystems/PlanningQlikSenseDeployments/Content/Deplo...

[rohitk1609]

Hey Wynand, Thanks for your continue support: I made below entry in config file at C:\Program Files\Qlik\Sense\Repository\PostgreSQL\9.6\share but still same error. I am not sure from where this host entry comes and not found fe80::48ba:9bbb:54f3:2003%17 ?

#TYPE    DATABASE    USER    ADDRESS    METHOD

host all all Trust

host      all             all             ::1/128                 md5

host      all             all             0.0.0.0/0              md5

host    QLogs          +qlogs_users     0.0.0.0/0               md5

host    QLogs          +qlogs_users     ::1/128                md5

fe80::48ba:9bbb:54f3:2003%17 QLogs          +qlogs_users     0.0.0.0/0               md5

[wynandack]

I believe it could be added by the install of sense, try removing it, and restarting repository service, and service dispatcher

[rohitk1609]

How to remove it ??

I restarted the services many times

[wynandack]

Just # comment it out of the hba config, then restart repo to take the settings

[rohitk1609]

It is coming in error logs as:

DevartLogDatabase::Connect failed!

Exception:

no pg_hba.conf entry for host "fe80::48ba:9bbb:54f3:2003%17", user "qlogs_writer", database "QLogs", SSL off

I have tried to add it in hba config to test but not working.

[wynandack]

Do you get the same if you remove it from the config file? the ::1 and 0.0.0.0 should allow any connection. I assume the fe80 is your server ipv6 address? Try switching ipv6 off and only have ipv4 to test