topic Re: enable centralized logging for sense system performance analyzer in Management & Governance

enable centralized logging for sense system performance analyzer

AarizShah — Sat, 16 Nov 2024 04:22:19 GMT

Hi,

I am trying to use the sense system performance analyzer. It's requirement is to enabe the centralized logging. I tried reading few articles. One of the articles asks me to go to C:\Program Files\Qlik\Sense\Logging\ in QMC or centralized node

However, the logging folder does not even exist there. Is there any other way to enable centralized logging so that we can start using the sense system performance analyzer

Regards

Re: enable centralized logging for sense system performance analyzer

rzenere_avvale — Wed, 16 Oct 2019 09:23:27 GMT

Goodmorning @AarizShah ,

are you following this kb article? https://support.qlik.com/articles/000059077
The mentioned folder C:\Program Files\Qlik\Sense is the default folder for installing QS. If you have installed QS in a different folder you should check for <Disk>:\<QS installation folder>\Logging.

I hope this helps,
Riccardo

Re: enable centralized logging for sense system performance analyzer

AarizShah — Wed, 16 Oct 2019 10:30:08 GMT

Hi @rzenere_avvale ,

Many thanks for the reply. You were right. It was at another location. However, when I try to execute the command

Qlik.Logging.Service.exe validate, I get an error Failed to Validate logging database

Do you have any suggestions on how to fix this?

Regards

Aariz

Re: enable centralized logging for sense system performance analyzer

rzenere_avvale — Wed, 16 Oct 2019 10:36:57 GMT

Hm, could you check another could of things?

did you run the command from an elevated prompt (so with Administrator rights)?
is the Qlik Sense Logging Service running? Usually I set it to 'Manual' run when I don't have the centralized logging configured

Riccardo

Re: enable centralized logging for sense system performance analyzer

AarizShah — Wed, 16 Oct 2019 10:46:05 GMT

You are actually right. The service was stopped and set to manual. However, it is not starting. Windows event log viewer shows this error

The description for Event ID 0 from source PostgreSQL cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:

FATAL: password authentication failed for user "senselog_writer"
DETAIL: Role "qlogs_writer" does not exist.
Connection matched pg_hba.conf line 82: "host all all ::1/128 md5"

Re: enable centralized logging for sense system performance analyzer

AarizShah — Wed, 16 Oct 2019 10:48:07 GMT

Where can I set this user role, password etc? The user that starts the service is a different one than mentioned here

Re: enable centralized logging for sense system performance analyzer

rzenere_avvale — Wed, 16 Oct 2019 10:53:39 GMT

I'm not sure why it is reported 'senselog_writer'. 'qlogs_writer' is a user that exists only in the repository, just like 'postgres' or 'qliksenserepository'.
Did you change anything in the file C:\ProgramData\Qlik\Sense\Log\QlikCentralizedLogging.config ?
Also, on which version of QS are you working?

Re: enable centralized logging for sense system performance analyzer

AarizShah — Wed, 16 Oct 2019 11:36:06 GMT

I only changed one entry in the QlikCentralizedLogging to enable CentralizedLoggingLogEnabled

Re: enable centralized logging for sense system performance analyzer

rzenere_avvale — Wed, 16 Oct 2019 11:53:56 GMT

Ok... So I'm still not sure why you get that 'qsenselog_writer'. Could you check the file C:\ProgramData\Qlik\Sense\Log\QlikCentralizedLogging.config and look if, for some reasons, it is mentioned qsenselog_writer?
Also, another question that I should have asked you before: in your environment has ever been configured the centralized logging? The kb article I mentioned earlier is used to enable/disable the centralized logging when you have already configured it. If during your installation you haven't selected the possibility to use it, then the QLogs database (which is the one used by this configuration) hasn't been created and neither the users. In this case, the kb article to follow should be this: https://support.qlik.com/articles/Basic/How-to-set-up-the-Qlik-Sense-Logging-Service?articleId=How-to-set-up-the-Qlik-Sense-Logging-Service

Re: enable centralized logging for sense system performance analyzer

AarizShah — Wed, 16 Oct 2019 12:01:44 GMT

Yes, it was never configured. This is the first time I have to configure it. regarding the error, I pasted a wrong event. For the logging error, the correct event error is

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

Re: enable centralized logging for sense system performance analyzer

rzenere_avvale — Wed, 16 Oct 2019 12:04:16 GMT

Great! That kind of error should be expected when you turn on the service without the actual database available (or, if you didn't modify the 'main' monitoring apps, every time the monitoring apps are reloaded)
Please try following the kb article I posted in my previous response, and let me know how it goes.

Riccardo

Re: enable centralized logging for sense system performance analyzer

AarizShah — Fri, 18 Oct 2019 09:53:42 GMT

Hi,

Before I proceed to installing the db, I ran the validation command on two different QS servers. Below is two different errors that I am getting

QS server1:

D:\Program Files\Qlik\Sense\Logging>Qlik.Logging.Service.exe validate
Failed to validate logging database. Database does not exist or is an invalid version.

QS server2:

C:\Program Files\Qlik\Sense\Logging>Qlik.Logging.Service.exe validate
Failed to validate the logging database : The Qlik Logging Service is disabled
        CentralizedLoggingEnabled: False
        LoggingToFileEnabled: True
        MaximumDatabaseSizeInGB: Max db size not enforced
        DB Host: localhost
        DB Name: QLogs
        DB Writer User: qlogs_writer
        DB Reader User: qlogs_reader
        DB Port: 4432

It looks like both servers have their own repository and Qlogs database. If I want to enable centralized logging, which database will be used to collect all the logs from all the nodes? Is there something else I need to do before enabling centralized logging?

Aariz

Re: enable centralized logging for sense system performance analyzer

Gencho — Fri, 08 May 2020 02:23:14 GMT

Hello @AarizShah

When I did the installation on my environment I skipped set the Qlog database (2017 release) after a couple of years I had to investigate how to enable these logs to set up the monitoring apps of Qlik Sense so I did the research as follows:

I enabled the Centralized login mode, just follow the first 2 steps of this document
https://support.qlik.com/articles/Basic/How-To-Enable-Disable-Centralize-Logging-Mode?articleId=How-To-Enable-Disable-Centralize-Logging-Mode&_ga=2.132294030.1485086901.1588875783-717424028.1586818199&_gac=1.15726276.1586818201.Cj0KCQjwm9D0BRCMARIsAIfvfIZMK-L5Yj3iti_qUYucxgOQv5xuUHSeoV20D99DloYpUaH-ADsYqpcaAl1KEALw_wcB
Then you'll need to set up the logging service, just run in the prompt the command:
cd "C:\Program Files\Qlik\Sense\Logging\"
Then run
.\Qlik.Logging.Service.exe setup --hostname FQDNofTheDatabase --port 4432 --postgres_user postgres --postgres_pswd PostgresUserPassword --writer_pswd IntendedWritePassword --reader_pswd ReaderWritePassword

Just remember to change the password of postgres_pswd (you set this password when you did the installation) and for writer_pswd the default is qlogs_reader and the password of reader_pswd the pwd by is qlogs_writer
Then you need to run the command
.\Qlik.Logging.Service.exe update --hostname localhost --port 4432 --postgres_user postgres --postgres_pswd Administrat0r --writer_pswd qlogs_reader --reader_pswd qlogs_writer --database_logging on

Change the same before mentioned
You will have a message like connection successful, by the way, this is the document that I followed for steps 2,3 and 4
https://support.qlik.com/articles/Basic/How-to-set-up-the-Qlik-Sense-Logging-Service?articleId=How-to-set-up-the-Qlik-Sense-Logging-Service&_ga=2.132294030.1485086901.1588875783-717424028.1586818199&_gac=1.15726276.1586818201.Cj0KCQjwm9D0BRCMARIsAIfvfIZMK-L5Yj3iti_qUYucxgOQv5xuUHSeoV20D99DloYpUaH-ADsYqpcaAl1KEALw_wcB

Hope these instructions help
Regards

Re: enable centralized logging for sense system performance analyzer

grangerats — Mon, 15 Feb 2021 19:17:59 GMT

Thanks! I was also in the same position: Didn't setup centralized logging a few years back. In my case, I wanted to use the "Sense System Performance Analyzer" app (Imported manually from C:\ProgramData\Qlik\Sense\Repository\DefaultApps\ ), but couldn't because it relies on the QLogs data connection, which needs centralized logging to be setup and turned on.

In my case, the steps were a bit different:

On the machine where Qlik Sense is installed, open an elevated command prompt.
Switch to the exe's dir for convenience: cd "C:\Program Files\Qlik\Sense\Logging\"
Get the "QLogs" db catalog setup/provisioned using the "postgres" account.
- Qlik.Logging.Service.exe setup -h HostFqdn -p HostPort -u postgres -x ExistingPostgressUserPwd -w NewQlogsWriterPwd -r NewQlogsReaderPwd
- FYI, the .exe has a "help" command, that is useful.
Turn on centralized (db) logging.
- Qlik.Logging.Service.exe update -h HostFqdn -p HostPort -u postgres -x ExistingPostgressUserPwd -d on
- FYI: You can add options in this command to have Qlik purge logs after X days/hours and/or set a GB size limit on the logs (again, use the exe's "help" command).
Back in the QMC, edit the "QLogs" data connection and update the password for the qlogs_reader account to match what you set back in step #3.
Reboot the server.
- I tried to avoid this, but even after restarting the "logging" Windows Service, it didn't appear that log information was being captured in the new QLogs db catalog. The App would reload find, but I couldn't find any data. After a reboot, I re-loaded the App and was able to find Windows Event data in the App.