DB connection password not saved

[_AnonymousUser]

Hi,
I run Open Data Integration v5.5.1 in x86_64 Debian GNU/Linux in order to import a project from a third party just modifying its connection parameters and I am having a strange issue when changing Metadata/DB Connections: the password seems to be not kept after closing the edit window. As per the "Check" button, the modified connection is initially fine, but after propagating the changes to the jobs and closing the assistant, running the jobs yield an Oracle DB connection error due to wrong credentials. When I edit again the connection parameters it turns out that the password has been changed (presumably to the project's default) as the "Check" button and the number of asterisks in the password field show.
Please can someone guide me to debug this issue?
Thanks in advance,
Antonio 

[Anonymous]

Hi amla,
You are using Open JDK not Oracle JDK to execute Talend Job?
Best regards
Sabrina

[Anonymous]

I'm pretty sure that the DB save the password (the number of asterisks is random), I think your credentials are wrong
Can you generate the documentation of your job and check the password ? hehe
To do so (desactive "hide password" in the project settings, right click on your job and click generate doc as HTML)

Then compare your password and check if Talend saved it right 

Hi,
Nice tip. Thank you! Didn't know I could reveal the password. Following your advice it turns out that:

No, the number of asterisks is not random, it matches the number of characters in the passwords.
My credentials aren't wrong as they yield a proper connection when I press "Check" button. Only the password gets mysteriously wrong when I save changes and propagate them to the jobs and only with "Oracle with SID" connections (MySQL connections behave normally).
Following your advice as a conceptual proof I firstly generated a HTML doc from one of the jobs right after importing the project which showed the right default password from my project provider. Then I modified the Oracle-connection password and regenerated the HTML doc, and the password XML entry looks like this:

 <column name="Contrase&#241;a" value="&quot;&#28;!&#1;&#65533;h&#27;Dq&#65533;&#65533;1&#65533;&quot;"/>

So as per the strange character codes in the "value" attribute it gets clear the password is getting corrupted somewhere in there as mine has only letters and numbers. And the issue happens right after hitting the form Accept button.

[Anonymous]

Hi amla,
You are using Open JDK not Oracle JDK to execute Talend Job?
Best regards
Sabrina

Hi Sabrina,
Yes, but using Oracle JDK makes no difference at all (I'm using it right now after reimporting/reopening the original project and the issue is still there). In fact, since Java 7, Oracle JDK has been built on top of OpenJDK plus some third-party, mainly graphical, pieces. So unless Talend is using some special hashing/cyphering algorithm with the Oracle connection passwords (I said MySQL connections work ok) it shouldn't make any difference, and it doesn't as I'm having the same problem with Oracle JDK.
Best regards,
amla

[Anonymous]

This is similar to the problem that I am having  https://community.talend.com/t5/Design-and-Development/Help-Database-Connection-Password-not-persist...: https://www.talendforge.org/forum/viewtopic.php?id=37405
Although, for me, Oracle works (Oracle with service name), and MSSQL does not.
I tried the generate as doc workaround.
When I add the Oracle connection, Generate works fine, and I see the password as expected.
When I add the MSSQL connection, the Generate doc does not work (it outputs the HTML/XML files, but there is nothing in the HTML).  It looks like Talend is not saving the characters correctly, and is putting in garbage.

[Anonymous]

Hi gchaisty,
And does your XML file contain a corrupted password?
Regards

[Jcs19]

I think you should open a ticket gchaisty or amla 

[Anonymous]

I think you should open a ticket gchaisty or amla 

Where can I do that? According to:
https://support.talend.com/otrs/customer.pl
it seems that I need some credentials different from the ones I'm using in this forum, but no registration form is at sight there.

[Anonymous]

Where can I do that? According to:

it seems that I need some credentials different from the ones I'm using in this forum, but no registration form is at sight there.

Nevermind. I found the proper link. Now I reported this issue as #TDI-30227.
Kind regards,
Antonio