topic Re: [resolved] Context DB Password Value in Talend Studio

[resolved] Context DB Password Value

peterko — Mon, 28 Jul 2014 11:12:02 GMT

Hello,
How can I change the value of the password in the context of database connections? I need to change out TOS, only in the configuration file.
There is a need for some hash value? Or simply write to the configuration file plaintext passwords? Currently in the configuration file is not stored plaintext passwords, so we need to find out how to easily change the configuration file.
Thank you

Re: [resolved] Context DB Password Value

Anonymous — Mon, 28 Jul 2014 11:38:42 GMT

Hi,
You can use Implicit Context Load(or tContextLoad) to define password as a context parameter and put value into an external file or database.
When your job is exported and running external to Talend, you can change password value in specified file or table directly.
Or define it as a local context parameter, then you will be able to change it in the context file.
Best regards
Sabrina

Re: [resolved] Context DB Password Value

peterko — Mon, 28 Jul 2014 14:49:48 GMT

Thank you,
but to me it would be sufficient if the password to be changed in context file.
Problem is that when I create a context, then the password is not stored in the file as plain text, but it looks like some hash.
Therefore it is sufficient to change the password in the configuration file that generated the TOS DI and then change the value of password value? I exported Context of DB connection using the "Export as context".
Thank you

Re: [resolved] Context DB Password Value

Anonymous — Tue, 29 Jul 2014 08:32:15 GMT

Hi,
There is no password info in your context file? Did you check your context file when export your job as .zip file?
Best regards
Sabrina

Re: [resolved] Context DB Password Value

peterko — Tue, 29 Jul 2014 09:49:25 GMT

Hi,
in my exported context file is password value, but it is not a value which I entered. Therefore, I am wondering if I can then change only in the open form.
Line in the context file looks as follows:

    <contextParameter comment="" name="Etl_Password" prompt="Etl_Password?" promptNeeded="false" type="id_Password" value="nLOBLe5G7cO3f0QfJhGzUg=="/>

And my password value, which is in the exported file is not the same, I've entered.
Thanks

Re: [resolved] Context DB Password Value

Anonymous — Tue, 29 Jul 2014 10:32:50 GMT

Hi,
Did you check Default. properties file under demo/.zip filename/context/? In addition, DB connection password has been encrypted since 5.5. You cannot change info in properties file directly but make it in .bat file.
For example;

 java -Xms256M -Xmx1024M -cp ../lib/dom4j-1.6.1.jar;../lib/systemRoutines.jar;../lib/userRoutines.jar;.;job1_0_1.jar; test.job1_0_1.job1 --context=Default --context_param db_user=root --context_param db_password=1234 %*

Best regards
Sabrina

Re: [resolved] Context DB Password Value

peterko — Tue, 29 Jul 2014 10:53:03 GMT

Thank you very much Sabrina!

Re: [resolved] Context DB Password Value

Anonymous — Tue, 29 Jul 2014 11:01:40 GMT

Hi pantolik,
If this issue is fixed, may I ask you to mark this topic as resolved? You can click the "Set this topic as resolved" link which is right underneath your initial post? This way, other users will be informed that this thread has been resolved.
Many thanks

Best regards
Sabrina

Re: [resolved] Context DB Password Value

Anonymous — Mon, 09 Mar 2015 17:33:24 GMT

hi,
there is more simple way:
in the context parameters,
the login type is string,
the password type is "password-type": that means it is encrypted,
if you choose String type, when you export the jobs, the password value will be in clear.

Re: [resolved] Context DB Password Value

bhagyarekha — Mon, 14 Nov 2016 06:04:46 GMT

Hi Xdshi,
I have used context for passwords,earlier it was working fine but i do not know what happens now if i keep the password column in string mode it is working.if i keep it in password mode it is not working.
the password i entered is correct.i did copy and paste between "password"
Appreciate for quick response.
Regards,
rekha

Re: [resolved] Context DB Password Value

Anonymous — Mon, 14 Nov 2016 06:32:02 GMT

Hi,

if i keep it in password mode it is not working.

Could you please give us some screenshots of your problem?
Best regards
Sabrina

Re: [resolved] Context DB Password Value

bhagyarekha — Mon, 14 Nov 2016 07:11:58 GMT

Hi please see the below screen shots
permission were their but still am getting that error.
i have tried for tmysqlconnection using password mode.even that is not worked

Re: [resolved] Context DB Password Value

Anonymous — Mon, 14 Nov 2016 07:21:41 GMT

can you try to manually give the password in the password field and see if that works?

Re: [resolved] Context DB Password Value

bhagyarekha — Mon, 14 Nov 2016 07:22:47 GMT

Hi sankalp
yes it is working,if i give it manually
regards,
rekha

Re: [resolved] Context DB Password Value

Anonymous — Mon, 14 Nov 2016 07:43:01 GMT

You will need to show your context to me. Can you please share that screenshot? I tried doing it (keeping password as datatype password) and it worked for me.

Re: [resolved] Context DB Password Value

bhagyarekha — Mon, 14 Nov 2016 07:51:30 GMT

In the past i have used. it got worked. but now it is not.i have re installed talend(6.3 version) again am facing the same problem.

Re: [resolved] Context DB Password Value

Anonymous — Mon, 14 Nov 2016 07:57:55 GMT

Well something must have changed that is why this issue is coming. Can you please share screenshot of your context with me?

Re: [resolved] Context DB Password Value

bhagyarekha — Mon, 14 Nov 2016 08:08:22 GMT

hi,
plz find the screen shot

Re: [resolved] Context DB Password Value

Anonymous — Mon, 14 Nov 2016 08:32:25 GMT

I do not any issues with your context here. I thing..You are using context.Password1 and context.Port1 -- I hope you intend to you didnt intend to use context.Password in place of Password1.
Also Can you try to print on console following variables
context.Password1 (not context.Password)
context.HostName
context.Port1
context.UserName
and confirm that details are correct?

Re: [resolved] Context DB Password Value

bhagyarekha — Mon, 14 Nov 2016 08:44:47 GMT

no actually i am using correct one i have sent you he sample.am using correct spell
Thank you
regards,
rekha