topic Re: Encrypting password issue in Talend Studio

Encrypting password issue

Anonymous — Thu, 24 Apr 2014 15:46:18 GMT

Hi
I followed the procedure described by Shong on this link :-
https://help.talend.com/pages/viewpage.action?pageId=28671224&focusedCommentId=31065832#comment-31065832
Now i have doubt regarding default value of context variable,is it the actual password or something else?
please light on the issue if anyone have gone through it.
Apart from this when i am trying to connect to oracle 10g database using procedure above described i am getting following error:
Exception in component tOracleInput_1
java.sql.SQLException: ORA-01017: invalid username/password; logon denied
When i manually enter password,no issue at all.I easily get connected to database and can fire any query i want.

Re: Encrypting password issue

Vianney — Thu, 24 Apr 2014 17:12:12 GMT

Hi,
The default value of your context variable must be the encrypted value.
Use this site to encrypt your password
http://rot13.com
Regards

Re: Encrypting password issue

Vianney — Thu, 24 Apr 2014 17:16:41 GMT

Note that ROT13 is a poor encoding method, just the 26 letters are encoded, and it's reversible : encode 2 times your password (click 2 times on Cypher) and your password will be shown again...

Re: Encrypting password issue

Anonymous — Fri, 25 Apr 2014 06:40:53 GMT

Hi Viannou,
First of all thanks for you reply and your suggestions regarding ROT13 algo and its pitfalls.
It works for me
Thanks a ton for that..
I have another doubt What if password contains some numeric value,in that ROT13 won't encrypt that.
Can you provide me any link or demo showing how to encrypt such password in talend job.

With Regards
Sanjay Tiwari

Re: Encrypting password issue

Vianney — Fri, 25 Apr 2014 09:01:04 GMT

Look at the ROT13 java code

            if (c >= 'a' && c <= 'm')
                c += 13;
            else if (c >= 'A' && c <= 'M')
                c += 13;
            else if (c >= 'n' && c <= 'z')
                c -= 13;
            else if (c >= 'N' && c <= 'Z')
                c -= 13;

It's based on the ascii table. It says : "when you have a 'a' transform it with de 13th leter after 'a' (= 'n') "
This should do the job for numbers...

            else if (c >= '0' && c <= '4')
                c += 5;
            else if (c >= '5' && c <= '9')
                c -= 5;

0 --> 5
1 --> 6
2 --> 7
3 --> 8
4 --> 9
5 --> 0
6 --> 1
7 --> 2
8 --> 3
9 --> 4

Re: Encrypting password issue

Anonymous — Fri, 25 Apr 2014 10:26:20 GMT

Hi
Thanks for nice explaination,So you are saying i should use ROT5 with ROT13.
what i have got you are just dividing the whole alphabets or number available such 26/2=13 in case of alphabets(ROT13) and 10/2=5 in case of numbers(ROT5).You are adding 13 or 5 accordingly,that's fine.
But what if password contains characters like #,@,$ and so on,in that case what to do? Would you please provide me code how can i use ROT47 if problem(@,#,$,%) cann't be solved using ROT13

Re: Encrypting password issue

Anonymous — Sun, 27 Apr 2014 07:03:57 GMT

rot13 is not encryption and should not be used for passwords.
If you really want to encrypt your passwords, you should be looking at something like pgp or gpg.
rot13 was maybe good enough 2000 years ago.

Re: Encrypting password issue

Anonymous — Sat, 03 May 2014 07:59:17 GMT

Thanks a ton tal00000 for your suggestions.I will go through what you have specified.