
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 ?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi ,
Im just running .sh file inside linux machine

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Best regards
Sabrina

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
