Five Stars

Automation of SSL Authentication

Hello,

 

We have a job which gives data using API. The job runs fine but the problem is SSL Authentication. After every few days we have to export the latest certificate from the website and install it manually using cmd. Is there any way in talend which can help us to automate this process ?

 

Thanks & Regards.

8 REPLIES
Community Manager

Re: Automation of SSL Authentication

Hi
It is possible to install the certificate using cmd with tSystem component, but I am not sure if it is possible to export the latest certificate from the website. Any API are available for this?

Regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
Five Stars

Re: Automation of SSL Authentication

Hi Shong,

 

Thanks for the reply, I'll use the tSystem component and let you know the result.

We use Holiday api for our job. We regularly have to keep on updating the certificate, so trying to find out a way to automate it Smiley Happy

 

Best Regards.

Five Stars

Re: Automation of SSL Authentication

Hi Shong,

 

I entered the following lines in tsystem component but we are getting an error related to password.

 

tsystem component:-

"cmd /c CD C:\\Program Files\\Java\\jre7\\bin & keytool -import -alias HolidayAPI3 -keystore ..\\lib\\security\\cacerts -file C:\\backup\\HolidayAPICer.cer & changeit & yes"

 

Error log:-

Enter keystore password: Keystore password is too short - must be at least 6 characters

Enter keystore password: Keystore password is too short - must be at least 6 characters

Enter keystore password: Keystore password is too short - must be at least 6 characters

Too many failures - try later

'changeit' is not recognized as an internal or external command,

operable program or batch file.

'yes' is not recognized as an internal or external command,

operable program or batch file.

 

Any idea why it is not accepting the password & next input value 'yes' ?

 

Thanks & Regards.

Five Stars

Re: Automation of SSL Authentication

Hi shong,

 

Any solution to this problem ?

I even tried the array command option but still getting errors.

 

Thanks & Regards.

Community Manager

Re: Automation of SSL Authentication

Hi
changeit is not recognized as an internal or external command, if you have installed a tool that contains this command, you need to set the path <tool installation dir>/bin/ to the system Path variable before launching studio.
Does the command work in CMD? How do you install certificate using CMD?

Here is a KB article about how to execute multiple commands using Array command on tSystem.
https://help.talend.com/pages/viewpage.action?pageId=190513238

Regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
Five Stars

Re: Automation of SSL Authentication

Hi Shong,

 

changeit is not a command, when we enter the keytool command in CMD and press enter we have to provide the password, "changeit" is the password. This commands work in CMD.

 

I have attached the screenshots of the process run in CMD & below is the complete process to install a certificate.

 

1] Export the certificate file from browser & install it.

2] Find the jre7 folder in your system. (eg:- C:\Program Files \Java\jre7\bin )

3] Open cmd & type :-

    cd C:\Program Files \Java\jre7\bin

 

    keytool -import -alias abc1 -keystore ..\lib\security\cacerts -file C:\Users\p1701901\Desktop\Projects\Talend\TALEND\TOS_DI-20151214_1327-V6.1.1\HolidayAPICER.cer

4] CMD will ask for password ( changeit ) & type yes.

 

This works perfectly in cmd, but we are facing problem in tsystem. It considers changeit & yes as commands but they are input values.

 

Screenshot_1.pngScreenshot_2.pngScreenshot_3.png

 

 

Thanks & Regards.

Ten Stars

Re: Automation of SSL Authentication

Five Stars

Re: Automation of SSL Authentication

Hello cterenzi,

Thanks for your reply, but I want to use the command in tsystem component.

Best Regards.