Automation of SSL Authentication

[Anonymous]

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.

[Anonymous]

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

[Anonymous]

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

Best Regards.

[Anonymous]

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.

[Anonymous]

Hi @shong,

Any solution to this problem ?

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

Thanks & Regards.

[Anonymous]

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

[Anonymous]

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.

Thanks & Regards.

[cterenzi]

See if this article is helpful:
http://stackoverflow.com/questions/7571949/answer-password-to-keytool-in-batch-files

[Anonymous]

Hello cterenzi,

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

Best Regards.