Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I installed qlik replicate in linux vm.
i m trying to access the qlik console from the a remote server
using https://<ip>:<port>/attunityreplicate
But im getting secure connection failed. i would like to know how to disable it.
Hello @swaroopchippada ,
You're right, it's impossible to disable HTTPS while Replicate running on Linux.
Regarding the error, obviously it indicates an issue in the SSL/TLS handshake in the first Client Hello (1) communication. There are much helpful links in Google, I think the problem may be relevant to firewall setting, or proxy etc. It's better to work with the DBA to troubleshoot it.
Good luck,
John.
Hello @swaroopchippada ,
Thanks for reaching out to Qlik Replicate.
Not sure what's the error messages you got, and where the problem is: it was caused by Linux side (eg firewall settings etc), or the browser security settings lead an access problem, or something else.
BTW, the default URL of the console is like: https://192.168.33.185:3552/attunityreplicate
where the IP Address is the Replicate Server IP, default port number is 3552.
And do you get any helpful clue from the Linux side Replicate server log file? Default file name is "/opt/attunity/replicate/data/logs/repsrv.log".
Hope this helps.
John.
Hi John,
Thanks for your reply.
This is my repsrv.log
and current status is running.
we installed the above service in a linux VM example - 192.X.X.129
I am trying to access it from another VM which is within the same segment and has a browser in it, so the source IP from where the application is accessed is 192.X.X.20
I m able to access other apps running in 192.X.X.129 server from the 192.X.X.20
but unable to access qlik application from the remote server. I got the below error.
So I wanted to know if I could disable https.
Hello @swaroopchippada ,
Thanks for the detailed information. However looks to me the error message:
The page you are trying to view cannot be shown because the authenticity of the received data could not be verified
was come from browser rather than Qlik Replicate. If I'm correct you are running Firefox, is that correct? could you please try other browser eg Edge, or Chrome.
Regards,
John.
Hello team,
If our response has been helpful, please consider clicking "Accept as Solution". This will assist other users in easily finding the answer.
Regards,
Sushil Kumar
Hi John,
Yes, I was using Firefox. However, as suggested I tried Chrome, but it wasn't working in Chrome as well.
Also, I did curl, and I'm getting the below response.
is there any issue with certificates or installation?
Let me know if I need to check anything else.
Thanks
Hello @swaroopchippada ,
Thanks for the update, however I still do not think it's Replicate issue as the error message signifies an issue in the SSL/TLS handshake, which translates to an SSL connection error. Potential causes include an outdated cURL package, connection errors, or some software setup etc. So let's narrow down the issue from various sides:
1. OS version
2. openssl version
3. proxy, VPN or tunnel settings
4. disable the internet security firewall
5. restart service
6. try to telnet the port number
7. reboot OS server
8. maybe disable HPPTS and use HTTP but not recommended
I'm pasting some command results (curl command with Verbose option enabled) in my labs for your comparison, hope it helps.
John.
[root@CentOS85 ~]# openssl version < |
Hi John,
We will try option 8 (i.e. disabling HTTPS and using HTTP) as we are just doing a POC.
How to do in Linux version ? I can't find any service configuration xml .
Thanks
Hi @swaroopchippada ,
Please check this article titled "Force Qlik Replicate to use HTTP instead of HTTPS for version 2023.5 and above" if it helps.
Regards,
Desmond
Dear @swaroopchippada
You can disable https in Qlik replicate linux version by modifying the host_configuration entry in the GlobalRepo.sqlite file in Replicate data folder. You will need a sqlite editor and knowledge on how to use it for this change, such as the DB Browser for SQLite.
Here are the steps you need to follow:
1 Stop the Qlik Replicate server service and the Qlik Replicate UI service
2 Open GlobalRepo.sqlite in any sqlite browser (as administrator)
3 Go to Browse data
4 Go to Objects
5 Locate host_configuration
6 Locate the JSON column
7 Edit the JSON column by changing the following: "host_https_port": 0, "test_https": false, "allow_unsafe_protocols": true
8 Save the GlobalRepo.sqlite file
9 Start the Qlik Replicate server service and Qlik Replicate UI service
I hope this helps you. 😊
If our response has been helpful, please consider clicking "Accept as Solution". This will assist other users in easily finding the answer
Regards,
Deepak