topic Re: Automation of SSL Authentication in Talend Studio

Automation of SSL Authentication

Anonymous — Thu, 04 May 2017 12:53:17 GMT

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.

Re: Automation of SSL Authentication

Anonymous — Fri, 05 May 2017 08:30:19 GMT

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

Re: Automation of SSL Authentication

Anonymous — Fri, 05 May 2017 10:34:22 GMT

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.

Re: Automation of SSL Authentication

Anonymous — Mon, 08 May 2017 10:57:24 GMT

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

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.

Re: Automation of SSL Authentication

Anonymous — Wed, 10 May 2017 07:32:07 GMT

Hi @shong,

Any solution to this problem ?

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

Thanks & Regards.

Re: Automation of SSL Authentication

Anonymous — Thu, 11 May 2017 07:42:45 GMT

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

Re: Automation of SSL Authentication

Anonymous — Thu, 11 May 2017 13:17:13 GMT

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.

Re: Automation of SSL Authentication

cterenzi — Thu, 11 May 2017 13:43:12 GMT

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

Re: Automation of SSL Authentication

Anonymous — Thu, 11 May 2017 14:07:28 GMT

Hello cterenzi,

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

Best Regards.