Skip to main content
Announcements
UPGRADE ADVISORY for Qlik Replicate 2024.5: Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
PetervB
Contributor
Contributor

Regenerating SSL for Qlik Replicate

Good day, 

I require assistance with generating a new SSL for Qlik Replicate. I have been thru the motions on the community forum but a struggling with generating the self signed certificate and syntax.

Labels (1)
1 Solution

Accepted Solutions
Kent_Feng
Support
Support

Hello @PetervB ,

Besides @john_wang 's reply, you can also try this way to refresh your SSL certificate:

1- Stop Replicate services

2 - Rename the data folder under the SSL folder (\Program Files\Attunity\Replicate\data\ssl\data)

3 - Delete self-signed certificates in the management console

  1. Open a command prompt and enter MMC to open the console (on Windows Server, open "Manage computer certificates")
  2. Click the File drop-down menu and select Add/Remove snap-in

     

    Kent_Feng_0-1707788698045.png

     

  3. Select Certificates and click Add

     

    Kent_Feng_1-1707788698071.png

     

  4. Select Computer account. Click Next, then click Finish.

    Kent_Feng_2-1707788698047.png

     

  5. Click OK to close the Add or Remove Snap-ins window
  6. Open Certificates and navigate to Local Computer, then Personal, then Certificates

    Kent_Feng_3-1707788698049.png

     

  7. In the list of certificates shown, select the certificates where the "Issued To" value and the "Issued By" value equal your computer name and delete them.
  8. Close the Management Console.

4 - Run COMMAND as administrator and navigate to the ..\Attunity\Replicate\bin directory and then run the following command:
RepUiCtl.exe certificate clean

5 - Start Replicate services.

Thanks.

*** Greetings from Down Under ***

View solution in original post

6 Replies
john_wang
Support
Support

Hello @PetervB ,

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

If you just want to let Qlik Replicate to re-generate the self signed certificate, you just need to:

1- Stop Replicate services

2- Rename the folder, or delete the existing certificate files. The default location on Windows is: C:\Program Files\Attunity\Replicate\data\ssl\data

3- Startup the services again.

Qlik Replicate will detect if these certificate files while services startup, and create them if these files do not exist.

Hope this helps.

John.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
PetervB
Contributor
Contributor
Author

Thank you so much John. The certificate files were auto-regenerated. However, when attempting to log on to the console, I get the following error...

PetervB_0-1707743888017.png

 

PetervB
Contributor
Contributor
Author

For info, have tried MS Edge and Chrome browsers to no avail. Have been logging in daily to check our tasks. The server on which Qlik Replicate is installed, was rebooted this morning, and error only appeared post reboot.

john_wang
Support
Support

Hello @PetervB ,

Thanks for the feedback. The message "Can't reach this page" in general means the Qlik Replicate services was not startup , or it's started but not ready for connection yet (in a few seconds only). Please check the 2 services status, and if any clue in "repsrv.log"/"repuictl.log" (default location is "C:\Program Files\Attunity\Replicate\data\logs" ).

Hope this helps.

John.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
Kent_Feng
Support
Support

Hello @PetervB ,

Besides @john_wang 's reply, you can also try this way to refresh your SSL certificate:

1- Stop Replicate services

2 - Rename the data folder under the SSL folder (\Program Files\Attunity\Replicate\data\ssl\data)

3 - Delete self-signed certificates in the management console

  1. Open a command prompt and enter MMC to open the console (on Windows Server, open "Manage computer certificates")
  2. Click the File drop-down menu and select Add/Remove snap-in

     

    Kent_Feng_0-1707788698045.png

     

  3. Select Certificates and click Add

     

    Kent_Feng_1-1707788698071.png

     

  4. Select Computer account. Click Next, then click Finish.

    Kent_Feng_2-1707788698047.png

     

  5. Click OK to close the Add or Remove Snap-ins window
  6. Open Certificates and navigate to Local Computer, then Personal, then Certificates

    Kent_Feng_3-1707788698049.png

     

  7. In the list of certificates shown, select the certificates where the "Issued To" value and the "Issued By" value equal your computer name and delete them.
  8. Close the Management Console.

4 - Run COMMAND as administrator and navigate to the ..\Attunity\Replicate\bin directory and then run the following command:
RepUiCtl.exe certificate clean

5 - Start Replicate services.

Thanks.

*** Greetings from Down Under ***
SushilKumar
Support
Support

Hello team,

 

If our response has been helpful, please consider clicking "Accept as Solution". This will assist other users in easily finding the answer. if you require further assistance, please raise a Support case. 

 

Regards,

Sushil Kumar