topic Re: java.sql.SQLException: I/O Error: GSS Failed: No valid credentials provided (Mechanism level: Failed to find any Kerberos tgt) in Talend Studio

java.sql.SQLException: I/O Error: GSS Failed: No valid credentials provided (Mechanism level: Failed to find any Kerberos tgt)

tk3 — Fri, 15 Nov 2024 22:28:05 GMT

Hi,

I created a job in windows 10 and it runs successfully. Inside the job, i have two connections and one of it is using AD connection. In windows, i start Talen Open Studio with 'run as a different user' option and enter the AD name and password.

Now i move that job to a Ubuntu server that has already joined domain, and i login to that server using the same AD name and password. When i test run the job in command line , i encountered the error in the Subject.

Could someone guide me on how to check and fix this issue?

Thanks.

Re: java.sql.SQLException: I/O Error: GSS Failed: No valid credentials provided (Mechanism level: Failed to find any Kerberos tgt)

Anonymous — Mon, 17 Oct 2022 08:06:26 GMT

Hello,

What does your job look like? Are you getting this issue when executing a Job with HDFS source and target?

Do these KB articles help?

https://community.talend.com/s/article/A-Job-with-HDFS-source-or-target-fails-with-a-GSS-initiate-failed-error-even-though-the-Kerberos-ticket-is-generated-on-the-JobServer-GCeED

https://community.talend.com/s/article/GSSException-No-valid-credentials-provided-Exception-When-Executing-a-Job-with-tHbaseInput-Component-R8pQg

Best regards

Sabrina

Re: java.sql.SQLException: I/O Error: GSS Failed: No valid credentials provided (Mechanism level: Failed to find any Kerberos tgt)

tk3 — Mon, 17 Oct 2022 09:42:58 GMT

Hi, Thanks for your response.

This is how my job looks like. The 'DMS-Prod_Talend' is connected using windows authentication method. And my issue is not the same as in the KB articles.

For Microsoft SQL Server connection, is there any specific setup i need to do so that Talend Open Studio is able to pull credential info from domain? This is the direction i am looking into for now. Will share if i find anything.

Re: java.sql.SQLException: I/O Error: GSS Failed: No valid credentials provided (Mechanism level: Failed to find any Kerberos tgt)

Anonymous — Tue, 18 Oct 2022 03:28:25 GMT

Hello,

Are you trying to connect secured SQL server connection(Kerberos authorization needed to authenticate sql server using windows authentication)?

Please try these following steps

1. Changed jtds driver to mssql JDBC driver

2. Append "integratedSecurity=true;authenticationScheme=JavaKerberos" to jdbc url additional parameter

And feel free to let us know if this related topic and doc helps

https://community.talend.com/t5/Design-and-Development/Need-help-connecting-SQL-Server-using-Kerberos/m-p/201266#M109917

https://confluence.atlassian.com/bitbucketserverkb/use-integrated-authentication-over-kerberos-when-connecting-to-mssql-on-linux-779171623.html

Best regards

Sabrina

Re: java.sql.SQLException: I/O Error: GSS Failed: No valid credentials provided (Mechanism level: Failed to find any Kerberos tgt)

tk3 — Thu, 20 Oct 2022 02:42:48 GMT

Thanks. That's what i am trying to do.

Re: java.sql.SQLException: I/O Error: GSS Failed: No valid credentials provided (Mechanism level: Failed to find any Kerberos tgt)

Anonymous — Thu, 20 Oct 2022 06:21:44 GMT

Hello,

Don't hesitate to post your issue here.

Best regards

Sabrina