Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
Hi @shong,
Any solution to this problem ?
I even tried the array command option but still getting errors.
Thanks & Regards.
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.
See if this article is helpful:
http://stackoverflow.com/questions/7571949/answer-password-to-keytool-in-batch-files
Hello cterenzi,
Thanks for your reply, but I want to use the command in tsystem component.
Best Regards.