Authenticating with the Collibra Platform fail in sprint boot integration

Hi @anie.issac,

Thanks for trying the file source template.

Regarding the above error, it seems that there was a timeout when trying to connect from the Collibra Integration Library to your Collibra instance.

Can you please confirm the following:

• What is the version of the Collibra instance?
• Is there a proxy server between the machine where the Spring Boot integration is located and the Collibra instance?
• Does the Collibra instance require two-way SSL (using a Key Store and/or Trust Store file)?
• From the same machine, using a web browser can the same Collibra instance be accessed?

Thank you

thanks for quick response
Please find my updates

• What is the version of the Collibra instance? Collibra version is 2022.08.1
• Is there a proxy server between the machine where the Spring Boot integration is located and the Collibra instance?Yes. there is proxy between Collibra and Sydneywater network. If so, where can I specify proxy details?
• Does the Collibra instance require two-way SSL (using a Key Store and/or Trust Store file)? We are using Collibra cloud instance which is secure ( https). How do i confirm if Collibra instance uses two-way SSL? In console, section 14 is blank.
• From the same machine, using a web browser can the same Collibra instance be accessed? yes. i can access using web browser.

Hi @anie.issac,

Thanks for the information provided.

Since a proxy is being used, you would need to set the following configuration properties (explained in the Collibra Integration Library documentation) in the application.properties file of your template:

• collibra.proxy.host – The host name of the proxy server
• collibra.proxy.port – The port number of the proxy server

Additionally, if your proxy server requires authentication, the following should also be set:

• collibra.proxy.username – The proxy server username
• collibra.proxy.password – The proxy server password

thanks for the updates.
i have updated proxy and now im receiving error related to certificare validation. please find below
{“message”:“An unexpected error occurred during execution.”,“details”:“javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target”,“cause”:“sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target”

I tried adding Collibra instance certificate to cacert, but i dont have required permission to edit cacert. Is there a option to skip ssl verification?(some thing like --ssl-no-revoke while doing CURL command)
please advise?

Hi @anie.issac,

Thanks for the update.

Regarding this error, can you please confirm whether there is a log that indicates the following?

 Successfully authenticated with the Collibra Platform.

Also, is this error when starting/deploying the integration or when triggering the synchronization please?

To skip the SSL verification, there is this – collibra.trust-self-signed-certificates – property. However, you can also specify a TrustStore file (and a KeyStore file) using the following properties:

• collibra.ssl.trust-store
• collibra.ssl.trust-store-password
• collibra.ssl.key-store
• collibra.ssl.key-store-password

More information is also available in the Collibra Integration Library documentation.

thanks for the updates.
I dont have log that states - ```
Successfully authenticated with the Collibra Platform.

Please find attached snippet from log file
I get the error while deploying the maven project using command    -     mvn spring-boot:run -Djasypt.encryptor.password=*****

regards
Anie

[error_0509.txt|attachment](upload://rsLDgkzvGzddTrHAW93IHwqVaZB.txt) (2.9 KB)

Hi @anie.issac,

Thanks for the information provided.

It seems that the initial request to the Collibra instance is failing. Therefore, it might be ideal to try the following:

Thanks