topic Re: Logging database setup failed in Management & Governance

Logging database setup failed

rohitk1609 — Mon, 22 Oct 2018 05:45:13 GMT

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.

Re: Logging database setup failed

wynandack — Mon, 22 Oct 2018 08:40:56 GMT

Hi, had the same issue on my one server, only option that worked was to create a backup of the qlog db, delete it and rerun the setup command: Qlik.Logging.Service.exe setup -h localhost -p 4432 -u postgres -x ******* -r ********* -w ******** -f, also ended up manually recreating the QLog user group, reader and writer accounts.

Re: Logging database setup failed

rohitk1609 — Mon, 22 Oct 2018 10:47:14 GMT

Thanks for your response wynand.

I am doing fresh installation so where to delete create a backup of the qlog db ??

Can you please explain me below statement in details how to do it ?

manually recreating the QLog user group, reader and writer accounts

Thanks,

Rohit

Re: Logging database setup failed

wynandack — Mon, 22 Oct 2018 11:12:14 GMT

OK, if its a clean install, no need to delete the qlogs db, just download and install pgadmin, connect to your localhost server, port should be 4432, user postgres and the password you made during install.

Once you in, select any db and select Tools, then Query tool.

Run this:

CREATE DATABASE "QLogs" ENCODING = 'UTF8'; --creates an empty QLogs database

Then just manually create the qlogs_users group ("can log in" - no under defenitions), qlogs_reader role and qlogs_writer role (give the two accounts login rights), (there is a script in the help files for sense) i prefer to do it manually. Then select properties for the accounts and set the passwords for each account, then select properties for the Qlogs db and make the qlogs_writer the db owner. (you would need to right click on the server and select refresh to see the new db and the users) then in cmd run: Qlik.Logging.Service.exe update -h 127.0.0.1 or localhost, then restart the the logging service

Re: Logging database setup failed

rohitk1609 — Tue, 23 Oct 2018 09:10:28 GMT

Thanks Wynand for your detail solution. I performed all the steps as you suggested. I have two concern at end:

1. Do I need to add both qlogs_reader and qlogs_writer to qlogs_users in membership

Second, How to check centralized logging is setup fine and logs from all servers are storing in centralize server ? Is there any check points or validation steps ??

Regards,

Rohit

Re: Logging database setup failed

wynandack — Tue, 23 Oct 2018 10:32:14 GMT

Yes, both users should be in the group, to check connection, select the qlogs db and under dashboard you should see qlogs_writer using Qlik.Logging.Service to connect. Expand the qlogs db - Schemas - Tables, then right click on leg_entries and View/edit data, select first 100 rows, you should see entries if all is ok, Check the following in the logging config file: C:\ProgramData\Qlik\Sense\Log\QlikCentralizedLogging.config

you can also enable the log file for the logging service:

(just restart the logging service if you make any changes to the config

Re: Logging database setup failed

rohitk1609 — Tue, 23 Oct 2018 11:12:22 GMT

Thanks for your response Wynand

1. This is false in logging config file:

<add key="CentralizedLoggingEnabled" value="False" />

<add key="LoggingToFileEnabled" value="True" />

Do I need to change False to True to make it effective in above statement under config file?

2. I am manually editing it to True:

<add key="CentralizedLoggingLogEnabled" value="True" /

3. I have checked the Dashboard Database Sessions are idle. Please check the snapshot.

Note: I am working on stand alone server. No rim node is attached yet.

Re: Logging database setup failed

wynandack — Tue, 23 Oct 2018 11:49:49 GMT

Yes, change to True to enable central logging, save the config, then restart your logging service

Re: Logging database setup failed

wynandack — Tue, 23 Oct 2018 11:55:49 GMT

Mine also shows as Idle under state, if you still not getting connections, try running the update command and then restarting the service, just replace the stars * with your password for the accounts:

Qlik.Logging.Service.exe update -h 127.0.0.1 -p 4432 -u postgres -x ******* -r ******** -w ********

Re: Logging database setup failed

rohitk1609 — Tue, 23 Oct 2018 12:16:42 GMT

I made it True but when I am starting the logging service it is saying:

2018-10-23 12:12:23,052 ICONDEL84-PC [Qlik.Logging.Service.exe] root [ERROR] - DevartLogDatabase::Connect failed!

Exception:

password authentication failed for user "qlogs_writer"

I have used same password which I used in super user password on the time of installation. My service user who is running the logging service has different password than super user password.

I have used super user password in definition part of qlogs_writer, qlogs_reader and qlogs_users .

Can you please help me to know where I am wrong ?

Re: Logging database setup failed

wynandack — Tue, 23 Oct 2018 13:12:05 GMT

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

Re: Logging database setup failed

rohitk1609 — Tue, 23 Oct 2018 16:12:37 GMT

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 ?

Re: Logging database setup failed

rohitk1609 — Tue, 23 Oct 2018 16:34:09 GMT

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

Re: Logging database setup failed

wynandack — Wed, 24 Oct 2018 05:43:15 GMT

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/Deployment/Installing-a-r…

Re: Logging database setup failed

rohitk1609 — Wed, 24 Oct 2018 07:24:56 GMT

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

Re: Logging database setup failed

wynandack — Wed, 24 Oct 2018 09:48:47 GMT

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

Re: Logging database setup failed

rohitk1609 — Wed, 24 Oct 2018 11:54:51 GMT

How to remove it ??

I restarted the services many times

Re: Logging database setup failed

wynandack — Wed, 24 Oct 2018 12:49:19 GMT

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

Re: Logging database setup failed

rohitk1609 — Wed, 24 Oct 2018 12:58:56 GMT

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.

Re: Logging database setup failed

wynandack — Wed, 24 Oct 2018 13:30:10 GMT

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