topic Re: Need to see password from repository entry in Talend Studio

Need to see password from repository entry

_AnonymousUser — Thu, 16 Aug 2012 15:55:18 GMT

An ex-employee created some repository entries for databases we need to connect to. Unfortunately we are now having problems connecting to one of these. When I pull up the repository entry for the connection, I can see everything except for the db password - he, unfortunately did not write this down anywhere else, so, my question, is how do I get talend to display the password instead of asterisks? On built-in connections the passwords are in full view, so i am hoping it is just a parameter that I need to change. thanks for your assistance.

Re: Need to see password from repository entry

_AnonymousUser — Thu, 16 Aug 2012 16:08:36 GMT

Build a simple job with just a database connection to the database.
Start the job.
Go to your workspace.
Navigate to the folder .Java/src/%project_name%/%job_name%/contexts
Open any .properties file.
It contains the password in clear text.
OR build a job with the repository context parameters added and add a tJava with
System.out.println(context.DATABASENAME_Password);
in it.

Re: Need to see password from repository entry

_AnonymousUser — Thu, 16 Aug 2012 16:57:46 GMT

Unfortunately, neither of these methods worked. I did find it though in a metadata connections property file from an export the previous employee created.
I would like to get either one of the suggestions working though, for other projects where i do not have an export. The context file was available, but it had nothing in it (except for a comment line with the date on it); the tJava did not recognize the variable to be printed. So what am I missing?

Re: Need to see password from repository entry

alevy — Fri, 17 Aug 2012 01:52:15 GMT

JimmyRussels suggestion works if the connection setting have been converted to context variables.
If not, just drag the repository item into a job and then change the property type to built-in and the password will be in the clear.
Pretty hopeless security really!

Re: Need to see password from repository entry

_AnonymousUser — Fri, 17 Aug 2012 07:22:14 GMT

Well of course you have to change DATABASENAME to your database name.
What exactly do you mean by "repository entries"? Database connections in the metadata section?
OK another way:
Create a tYourDatbaseTypeInput component with the database connection and put a tJavaRow behind it.
Create a correct SQL Statement (SELECT 1 FROM DUAL on Oracle e.g.).
Write the following in your tJavaRow:

System.out.println(password_tYourDatabaseTypeInput_1);

For Oracle e.g:

tOracleInput -> tJavaRow
System.out.println(password_tOracleInput_1);

If that still does not work, the passwords are encrypted with DES, Key "Talend-Key". See
http://talendforge.org/svn/tos/branches/jobserver-karaf/org.talend.commons.runtime/src/org/talend/commons/utils/PasswordEncryptUtil.java
(Ignore that it's jobserver-karaf, it's the same for all Talend versions).

Re: Need to see password from repository entry

Anonymous — Fri, 17 Aug 2012 08:13:35 GMT

JimmyRussels suggestion works if the connection setting have been converted to context variables.
If not, just drag the repository item into a job and then change the property type to built-in and the password will be in the clear.
Pretty hopeless security really!

Great answer Alevy!!!
For same issue I was thinking since the password encryption type is PBEWithMD5AndDES, I was looking for SALT and PASSWORD text, silly me!!!

Re: Need to see password from repository entry

fataboubou — Fri, 29 Jun 2018 12:56:24 GMT

hello,

this solve my issue!

Welldone

Re: Need to see password from repository entry

MZein — Thu, 31 Oct 2019 21:24:10 GMT

could you please tell me where to find passphrase in talend to decrypt password in .item files

regards

Re: Need to see password from repository entry

Anonymous — Fri, 01 Nov 2019 02:57:07 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

Re: Need to see password from repository entry

PPat9713 — Fri, 04 Mar 2022 16:45:53 GMT

This worked for me. Thank you

Re: Need to see password from repository entry

mKaposvari — Tue, 08 Aug 2023 09:40:02 GMT

Hello everyone!

If someone finds this post after so many years as I did, I figured out another way because the others were not totally clear or not working.

You can go into the code view of the DB connection and there you can find the part of the code which decrypts the password.

Something like:

routines.system.PasswordEncryptUtil.decryptPassword("")

If you use tJava you can put that value into a String variable and then print it on the console, like:

String dbPW = routines.system.PasswordEncryptUtil.decryptPassword("");

System.out.println(dbPW);

I hope this helps someone getting the DB password!

Kind regards,

Mark