topic Re: T_Rest on XRAY Cloud API - No trust Certificate found in Talend Studio

T_Rest on XRAY Cloud API - No trust Certificate found

DSébastien1669215068 — Wed, 23 Nov 2022 15:25:46 GMT

Hello,

I'm trying to connect to the API of X-Ray Cloud with TOS DI 8 but it's not working.

First, i had a problem with ssl certification that i tried to fix by downloading the certificate from

https://xray.cloud.getxray.app.

With KeyStore Explorer, I have created an jks file that I used in to tSetKeyStore before the tRest but I still have a problem :

Can you help me to solve this problem?

Best regards.

S. De Witte

Re: T_Rest on XRAY Cloud API - No trust Certificate found

Anonymous — Thu, 24 Nov 2022 05:57:22 GMT

Hello @De Witte Sébastien ,

Could you please try to import the ssl certificate to the JRE's cacerts file (in the studio machine) by the below command like :

keytool -import -file my.pem -alias MY_CA_Root -keystore "%JAVA_HOME%/jre/lib/security/cacerts" -storepass changeit

then re-try the job?

Best regards

Aiming

Re: T_Rest on XRAY Cloud API - No trust Certificate found

DSébastien1669215068 — Thu, 24 Nov 2022 08:26:51 GMT

Hello Achen,

I managed to import the ssl certificate but I still have the problem.

Best regards.

S. De Witte

Re: T_Rest on XRAY Cloud API - No trust Certificate found

Anonymous — Thu, 24 Nov 2022 08:35:02 GMT

@De Witte Sébastien , Thanks for the feedback, please disable the tSetKeyStore component in the job and restart studio to retry?

Re: T_Rest on XRAY Cloud API - No trust Certificate found

DSébastien1669215068 — Thu, 24 Nov 2022 09:31:22 GMT

@Aiming Chen

If i don't use the tSetKeyStore component, I have the following error :

Best regards

S. De Witte

Re: T_Rest on XRAY Cloud API - No trust Certificate found

Anonymous — Fri, 25 Nov 2022 01:03:18 GMT

@De Witte Sébastien

Did you ever import the ssl certification to the jks file that's created by KeyStore Explorer?

if no, please import it to try to use tSetKeyStore again?

if it still doesn't help, how about to use tSetKeyStore to point to the keystore file %JAVA_HOME%/jre/lib/security/cacerts ? (the Truststore passwd is changeit)

Re: T_Rest on XRAY Cloud API - No trust Certificate found

DSébastien1669215068 — Fri, 25 Nov 2022 07:53:00 GMT

Hello @Aiming Chen ,

I tried both solutions you proposed but i still have the problem.

Do yo know if it is possible to disable ssl certification control in Talend? On the same PC, with postman, I can access to the API if the SSL certificate validation is disable.

Best regards.

Sébastien De Witte

Re: T_Rest on XRAY Cloud API - No trust Certificate found

Anonymous — Mon, 28 Nov 2022 01:22:44 GMT

@De Witte Sébastien , to disable the ssl validation, you can add the below JVM parameters

-Dcom.sun.net.ssl.checkRevocation=false in job's RUN->Advanced settings

BTW:

I created a simple job with tREST+tLogRow to invoke the api "https://xray.cloud.getxray.app/api/v1/authenticate", but can't reproduce your issue in TOS 8

Re: T_Rest on XRAY Cloud API - No trust Certificate found

DSébastien1669215068 — Wed, 30 Nov 2022 08:22:05 GMT

@Aiming Chen ,

Thanks to all your support.

I will continue to search a solution but I think it's due to my entreprise security.

Yesterday I tried the same Trest on my customer context and it's OK.

Best regards.

Sébastien De Witte