Skip to main content
Announcements
A fresh, new look for the Data Integration & Quality forums and navigation! Read more about what's changed.
cancel
Showing results for 
Search instead for 
Did you mean: 
MHank2
Contributor

Decryption of password

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 ?

Labels (2)
5 Replies
Anonymous
Not applicable

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

MHank2
Contributor
Author

Hi ,

Im just running .sh file inside linux machine

Anonymous
Not applicable

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-cont...

Best regards

Sabrina

 

MHank2
Contributor
Author

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.

 

Anonymous
Not applicable

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