topic Re: Decryption of password in Talend Studio

Decryption of password

MHank2 — Fri, 15 Nov 2024 23:45:33 GMT

Hello,

I've made simple job that takes data from DB2 database and pushes the data to log. So its very simple but i have a problem with password decryption.

Locally on my machine everything works fine and the job is working well, but on the server - I assume that password is never decrypted properly and Talend cant create connection to DB.

Error that occurs : Connection authorization failure occurred. Reason: User ID or Password invalid.

Next i created step that prints out decrypted password in tJava like that :

System.out.println(routines.system.PasswordEncryptUtil.decryptPassword("decrypted string generated by talend in code tab"))

And locally it prints out decrypted password well, but on the server it just prints same string that is inside this function above like decryption is not working here.

What can i do to make it work on a different machine ?

Re: Decryption of password

Anonymous — Thu, 09 Sep 2021 06:46:20 GMT

Hello,

What's server are you trying to run? Remote Engine?

It has to do with the environment variable configuration for the home directory.

Best regards

Sarina

Re: Decryption of password

MHank2 — Thu, 09 Sep 2021 17:18:43 GMT

Hi ,

Im just running .sh file inside linux machine

Re: Decryption of password

Anonymous — Fri, 10 Sep 2021 05:57:43 GMT

Hello,

The password which is encrypted on windows is not getting correctly decrypted on Linux?

Are you using context groups and context parameters for db details to avoid this kind of issue?

Please check the below link.

https://help.talend.com/r/en-US/7.3/studio-user-guide-open-studio-for-data-integration/creating-context-group-and-define-context-variables-in-it

Best regards

Sabrina

Re: Decryption of password

MHank2 — Mon, 13 Sep 2021 15:31:49 GMT

Hello,

Yes this is excatly what happens. Password on Windows is not decrypted on Linux.

Right now I'm using context to avoid this issue and I'm passing parameters to the builded script.

So this is first solution to the problem.

I will try to create context as you suggested and I will come back with reply.

Re: Decryption of password

Anonymous — Tue, 14 Sep 2021 09:24:08 GMT

Hello,

Feel free to let us know if it helps.

In addition to that, have you thought of entering our competition?

https://community.talend.com/s/blog/aGn5b000000CaZw/getting-smart-about-talend-tip-of-the-day

There are rewards for winners!

Best regards

Sabrina