topic Re: password decryption from .item files? in Talend Studio

password decryption from .item files?

Anonymous — Sat, 16 Nov 2024 04:29:03 GMT

I'm currently trying to load contexts from job exports' .item files, but have some problems with the password encryption.

My test job has the password "jelszo", which is encrypted as "xlwfPYy+C+k=" in the .item file. But how could i get "xlwfPYy+C+k=" decrypted?

tContextLoad doesn't do the decryption, it just gives back the encrypted password; the only solution i found on this forum, PasswordEncryptUtil.decryptPassword("xlwfPYy+C+k=") doesn't work either (in fact, PasswordEncryptUtil.encryptPassword("jelszo") gives back "fe4fa1e083f07ef9", so it looks like a totally different encryption method).

Do you have any advice, or is it simply not possible? I mean, Talend surely decrypt these somehow, but if it's a method only the Studio / the Administration Center can use, then it's a dead end.

Many Thanks,

Balazs

Re: password decryption from .item files?

Anonymous — Mon, 14 Oct 2019 04:59:11 GMT

Hello,

In talend, you can write a routine to encrypt and decrypt stuff where you can use the standard java encryption mechanism

Have you tried to decypt the passwords using the routines to see if it come out the expexted result?

Best regards

Sabrina

Re: password decryption from .item files?

Anonymous — Tue, 15 Oct 2019 21:28:07 GMT

Thanks for the suggestion. With some tLibraryLoads (org.talend.utils.jar, commons-codec-1.10.jar and org.talend.daikon_0.2.0.RELEASE.jar), it's almost simple:

org.talend.utils.security.CryptoHelper.getDefault().decrypt("xlwfPYy+C+k=") gives back "jelszo" as it should.

Re: password decryption from .item files?

MZein — Thu, 31 Oct 2019 10:16:34 GMT

Could you please give me an explaination to your solution as I have the same problem and need to solve it quickly. I tried your solution but it gives me an error (org.talend.utils can not be resolved to a variable) so I thaink the problem is how to import this library

Looking forward to your suggestion

Regards

Re: password decryption from .item files?

Anonymous — Fri, 01 Nov 2019 02:57:18 GMT

Hello @MZein

Are your database passwords as stored in the .item files encrypted? There is a community article about:https://community.talend.com/t5/Design-and-Development/Data-encryption-in-Talend-7-2-1/ta-p/200397

Best regards

Sabrina