topic Re: Qlik Replicate Server Warning when starting the server. in Qlik Replicate

Qlik Replicate Server Warning when starting the server.

NewbieQlik — Mon, 29 Jan 2024 04:04:53 GMT

Whenever we start the HA/Dr replicate servers (EC2 instances) we get below error. Is there any specific reason why we are getting this error?

The reason why I am asking this question is, we have monitoring enabled in production and every time when we start the instance a production incident gets created because of this warning.

[REST_SERVER ]W: Failed to initialize pam configuration, pam authentication disabled. (atctl_serve.c:275)

[SERVER ]W: Passthrough SQL filters are enabled [enable_passthrough_filter = true]. Qlik recommends turning this option off in repctl.cfg to improve security (server.c:735)

Re: Qlik Replicate Server Warning when starting the server.

john_wang — Mon, 29 Jan 2024 04:15:48 GMT

Hello @NewbieQlik ,

Thanks for reaching out to Qlik Community!

These are 2 different issues.

[REST_SERVER ]W: Failed to initialize pam configuration, pam authentication disabled. (atctl_serve.c:275)

This warning message indicates the PAM is not enabled, you can enable the PAM as mentioned in User Guide.

[SERVER ]W: Passthrough SQL filters are enabled [enable_passthrough_filter = true]. Qlik recommends turning this option off in repctl.cfg to improve security (server.c:735)

By default the Passthrough Filter is turned off. If you need it, please follow below steps to enable it:

1. Edit the file repctl.cfg, default location on Windows is "C:\Program Files\Attunity\Replicate\bin".

2. Edit the line and set it as:

"enable_passthrough_filter": true,

3. Save the file and restart Replicate services.

Hope this helps.

John.

Re: Qlik Replicate Server Warning when starting the server.

deepaksahirwar — Mon, 29 Jan 2024 09:45:37 GMT

Dear @NewbieQlik ,

Welcome to Qlik Community forum and thanks for reaching out here!

Solution:

Address Qlik Replicate Server Warnings to Reduce Production Incidents

Scenario:

You're receiving two warnings, one regarding failed PAM configuration and another about active passthrough SQL filters, in your Qlik Replicate HA/DR servers. These warnings trigger unnecessary production incidents.

Action:

1.PAM Warning:

If PAM authentication isn't required, disable it altogether:

Edit repctl.cfg, add [security] section, and set enable_pam = false.

If PAM is needed, implement alternative authentication methods for enhanced security.

2. Passthrough SQL Filter Warning:

Unless actively used, disable passthrough filters to improve security:

Edit repctl.cfg, set [server] section's enable_passthrough_filter to false.

Outcome: By disabling unnecessary warnings and addressing potential security concerns, you can:

Eliminate production incidents triggered by these specific warnings.

Enhance the overall security posture of your Qlik Replicate deployment.

Remember:

Before implementing changes, analyze your specific configuration and security requirements.

Consider updating your monitoring system to ignore these warnings and focus on critical issues.

By taking these steps, you can ensure efficient server operation and optimal security for your Qlik Replicate environment.

I hope this helps you resolve the issue.Have a nice day! 😊

If our response has been helpful, please consider clicking "Accept as Solution". This will assist other users in easily finding the answer

Best Regards,

Deepak