topic Issue with type Password in context in Talend Studio

Issue with type Password in context

Fernandez — Tue, 07 Apr 2020 16:26:43 GMT

Hi,

I just downloaded version 7.3.1 and now I'm getting an error with the type password in context variables.

I use type password for the connection to a MSSQL base:

Context

Component

When I launch the job from TOS, it's running fine.

But if I export the job and launch the .bat, I got this error:

tMSSqlInput_3;com.microsoft.sqlserver.jdbc.SQLServerException:Login failed for user...

I never got this issue with version 7.2.1

I just saw that the encryption value is different between :

7.2.1 =>ENC\:[xxxxxx]

7.3.1 =>enc\:routine.encryption.key.v1\:xxxxxx

Any idea please ?

Re: Issue with type Password in context

Anonymous — Fri, 17 Apr 2020 08:13:28 GMT

@Fernandez, I have made a testing on my side and I can't reproduce the issue with v7.3.1, the job works also when I export the job script. As I did, you export all the parameter as context variable. The difference is I am using Open Source JTDS driver.

Regards
Shong

Re: Issue with type Password in context

sushantk19 — Fri, 17 Apr 2020 08:38:51 GMT

Hello All,

I am also facing the same issue. When i make type of password as "password", my job throws an error:

xception in component tDBOutput_1 (job_Staging_000_sylius_Address)
java.sql.SQLNonTransientConnectionException: [Amazon][JDBC](10100) Connection Refused: [Amazon][JDBC](11640) Required Connection Key(s): PWD; [Amazon][JDBC](11480) Optional Connection Key(s): AccessKeyID, AuthMech, AutoCreate, BlockingRowsMode, ClusterID, DbGroups, DisableIsValidQuery, DriverLogLevel, EndpointUrl, FilterLevel, IAMDuration, Language, loginTimeout, OpenSourceSubProtocolOverride, plugin_name, profile, Region, SecretAccessKey, selectorProvider, selectorProviderArg, SessionToken, socketTimeout, ssl, sslcert, sslfactory, sslkey, sslpassword, sslrootcert, SSLTruststore , SSLTrustStorePath, tcpKeepAlive, TCPKeepAliveMinutes, unknownLength

But when i change the type to "String" in context, job works perfectly fine. i am using Talend 7.2.

Can you please suggest what should i change in context to make this work?

Password_issue.docx

Re: Issue with type Password in context

Fernandez — Tue, 21 Apr 2020 08:22:01 GMT

Hi,

I found the issue.

Each time we export jobs, the value of the encrypted password change with v7.3.1.

And i copied/pasted context variables from precedent export when I deployed on servers.

Re: Issue with type Password in context

sushantk19 — Tue, 21 Apr 2020 10:17:42 GMT

@Fernandez : didnt understand you completely. Are you also facing this issue? OR you could resolve this issue? Can you suggest a solution for this? how do i define the password? I am using TOS 7.2

Re: Issue with type Password in context

Fernandez — Tue, 21 Apr 2020 11:10:09 GMT

Actually there was no issue.

I don't know how helping.

I define the password like this:

and when I export my job, I get the encrypted value in my context file :

Re: Issue with type Password in context

sushantk19 — Tue, 21 Apr 2020 13:42:32 GMT

@Fernandez: whats your version of TOS? i do not know what is issue with TOS 7.2.

Re: Issue with type Password in context

Fernandez — Tue, 21 Apr 2020 13:48:00 GMT

I'm using 7.3.1 version.

And before 7.2.1