topic Re: setting up centralized logging in multinode environment in Management & Governance

setting up centralized logging in multinode environment

AarizShah — Tue, 22 Oct 2019 07:26:19 GMT

Hi,

We have an environment were the postgre sql repository seems to be installed on all the nodes. My question is

1) Which server can act as the centralized logging database?

2) How to set other nodes to start using the centralized logging database that is set on for example the central node

3) Which configuration files contain the user, password, databse, hotname and connection detail that can be used to point to the centralized database?

Regards

Aariz

Re: setting up centralized logging in multinode environment

BTIZAG_OA — Tue, 22 Oct 2019 13:07:38 GMT

Hello Aarizshah,

Can you give more info about your env. Are you using 3.1 or earlier version(sync pers.)?

otherwise you should have 1 postgresql for 1 Qlik site. If all your Qlik servers running in the same site then you can enable centralized logging either on your central node(gets postgresql with default installation) or any other remote postpgresql server.

I highly suggest you read topic Multi-Node configuration at the following link

https://help.qlik.com/en-US/sense/June2019/Subsystems/PlanningQlikSenseDeployments/Content/Sense_Deployment/Qlik-Logging-Service-config-integration.htm

Re: setting up centralized logging in multinode environment

AarizShah — Mon, 28 Oct 2019 07:57:14 GMT

Qliksense June 2019 patch 2

Qliksenseserver: 13.32.4

Re: setting up centralized logging in multinode environment

AarizShah — Mon, 28 Oct 2019 08:15:04 GMT

Thanks for suggesting the article. I still could not understand what configuration will make it start using the central node database instead of its own database. I see no configuration setting or value that would point it to the central node. Can you please guide me here

Regards

Re: setting up centralized logging in multinode environment

BTIZAG_OA — Mon, 28 Oct 2019 08:58:43 GMT

Go to C:\programdata\qlik\sense\log\ open qlikcentralizedlogging.config in nnotepad

at the bottom change connection strings for qlogsreader&qlogswriter

"Host=localhost" to "Host=YourPostgreSQLServer" and save it. Repeat this on all other qlik nodes and restart Qlik Loggin Service.

You can verify it with

Open CMD.exe as Administrator
Go to Logging folder: cd C:\Program Files\Qlik\Sense\Logging
Run the following command: Qlik.Logging.Service.exe validate

https://support.qlik.com/articles/000059076

Make sure you created "Qlogs" db on your postgresql server and created users(qlogsreader&qlogswriter) with enough privileges to access.

Re: setting up centralized logging in multinode environment

AarizShah — Mon, 28 Oct 2019 09:30:21 GMT

Hi,

Once again, many thanks for the help. I am progressing but now stuck at one more point. It is giving an error that logging service is disabled. I went to services and started the Qlik logging service. However, it is still giving error that logging service is disabled.

Second thing is that I enabled the centralized logging and it also gave success message but when I validate it, it is still in false status

C:\Program Files\Qlik\Sense\Logging>Qlik.Logging.Service.exe update -d on
Successfully updated the configuration file
Successfully updated the database settings

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

Can you please guide here

Regards

Re: setting up centralized logging in multinode environment

BTIZAG_OA — Wed, 30 Oct 2019 10:31:56 GMT

Hello again,

Can you check from services.msc "Qlik Logging Service" is up&running. If its disabled try to change startup type to manuel and run it.

Re: setting up centralized logging in multinode environment

AarizShah — Thu, 31 Oct 2019 07:52:52 GMT

Hi,

Yes, Qlik Logging service is up and running. I even tried to restart it, but am still getting error that logging service is disabled when i try to validate it.

The other error is that when I try to enable centralize logging, i get success message but when I check it next time, it is still false. Please check the prevouis post when I have posted the CMD output

Regards