Attunity Certificate error on the Web Console

[syada369]

Hi,

This is regarding Attunity replicate console.

We are facing certificate error while trying to access one of the URL for web console.

It says untrusted certificate and website cannot be trusted by the company.

When checked with my certificate authority team, they asked me to make my application use the certificate provided by them.

Tried different ways but nothing seems to be working,

Please help.

Thanks

[Madhavi_Konda · Accepted solution]

Hi Team,

Please make sure correctly configured SSL PFX file containing both (private key and certificate) and that the common name field in the certificate matches the name browsers will use to reference the machine.

1. Stop Attunity Replicate server and Attunity Replicate UI server.

2. Open CMD (as administrator)

3. Change path to where Replicate is installed (default is C:\Program Files\Attunity\Replicate\bin)

4. Run the following command:

RepUiCtl.exe certificate clean

if your data is on another directory

RepUiCtl.exe -d f:\attunity\replicate\data certificate clean

5. Run mmc.exe

6. From the file menu click Add/Remove Snap-in

7. From the window of Snap-ins, choose certificates and double click it

8. From the popup which will be opened, choose “Computer account” and Next

9. Click “Finish” in the “select computer” dialog to choose the local computer

10. Click ok to close the snap-in selection window

11. Import the PFX file by right clicking on the “Personal” folder under the certificate tree on the left. Enter the password as required

12. Double click your certificate from the personal folder, and choose the “details” pane

13. Scroll down in the details window until you see the “Thumbprint” details and copy them to the clipboard

14. In the command line(run as administrator), run the following commands:

netsh http add sslcert ipport=0.0.0.0:443 certhash=[YOUR_CERTIFICATE_THUMBPRINT_WITHOUT_BLANKS] appid={4dc3e181-e14b-4a21-b022-59fc669b0914}

netsh http add sslcert ipport=[::]:443 certhash=[YOUR_CERTIFICATE_THUMBPRINT_WITHOUT_BLANKS] appid={4dc3e181-e14b-4a21-b022-59fc669b0914}

15. Close the CMD and mmc utility

16. Start the Attunity Replicate server and Attunity Replicate UI server

Example for the commands mentioned in #14:

netsh http add sslcert ipport=0.0.0.0:443 certhash=5f6eccba751a75120cd0117389248ef3ca716e61 appid={4dc3e181-e14b-4a21-b022-59fc669b0914}

netsh http add sslcert ipport=[::]:443 certhash=5f6eccba751a75120cd0117389248ef3ca716e61 appid={4dc3e181-e14b-4a21-b022-59fc669b0914}

===

if you have done above, and still having issue, could you provide the repuictl log for review, under ~\data\logs directory.

and new certificate error and what certificate it is using,, and all the certificate in MMC / computer / personal certificate .

Thanks,
Madhavi