Issue with type Password in context

[Fernandez]

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 ?

[Anonymous]

@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

[sushantk19]

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

[Fernandez]

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.

[sushantk19]

@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

[Fernandez]

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 :

[sushantk19]

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

[Fernandez]

I'm using 7.3.1 version.

And before 7.2.1