mysql login connection exception on linux when works fine on Windows.

genie — Fri, 15 Nov 2024 23:23:58 GMT

I am having the same problem as this question and this question, but the setup is slightly different and none of the suggested solutions seems to apply. I'm not using a context for the username/password and my libraries are updated with the build and deployed each time. Adding "

?enabledTLSProtocols=TLSv1.2" made no difference.

I am trying to upgrade from Talend 7.1 to 7.3.1 and the login to mysql is failing:

Exception in component tDBOutput_4 (CRM_01_CheckUpdate)

java.sql.SQLException: Access denied for user 'EDWPROD'@'localhost' (using password: YES)

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)

at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)

at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:836)

at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456)

at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246)

at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199)

at java.sql.DriverManager.getConnection(DriverManager.java:664)

at java.sql.DriverManager.getConnection(DriverManager.java:247)

at crm.crm_01_checkupdate_0_1.CRM_01_CheckUpdate.tStatCatcher_1Process(CRM_01_CheckUpdate.java:6708)

at crm.crm_01_checkupdate_0_1.CRM_01_CheckUpdate.runJobInTOS(CRM_01_CheckUpdate.java:23865)

at crm.crm_01_checkupdate_0_1.CRM_01_CheckUpdate.main(CRM_01_CheckUpdate.java:23656)

The existing 7.1 job continues to work with the same username/password so nothing in the db has changed (MySql 8). I have simplified to the following job:

Which has the following result in dev on Windows:

The login information is all coming from the repository connection component (which is the way we've always done it).

What other information can I provide?

Re: mysql login connection exception on linux when works fine on Windows.

genie — Wed, 05 Jan 2022 22:58:44 GMT

When I ran it slightly differently, I received a new error:

Running jobs for CRM

Running: CRM_GetCount

Script: crm_etl/CRM_GetCount_0.1/CRM_GetCount/CRM_GetCount_run.sh

java.security.InvalidKeyException: Illegal key size

at javax.crypto.Cipher.checkCryptoPerm(Cipher.java:1039)

at javax.crypto.Cipher.implInit(Cipher.java:805)

at javax.crypto.Cipher.chooseProvider(Cipher.java:864)

at javax.crypto.Cipher.init(Cipher.java:1396)

at javax.crypto.Cipher.init(Cipher.java:1327)

at org.talend.daikon.crypto.CipherSources$2.get(CipherSources.java:94)

at org.talend.daikon.crypto.CipherSources$SymmetricKeyCipherSource.encrypt(CipherSources.java:141)

at org.talend.daikon.crypto.Encryption.encrypt(Encryption.java:52)

at routines.system.PasswordEncryptUtil.encryptPassword(PasswordEncryptUtil.java:53)

at routines.system.ResumeUtil.convertToJsonText(ResumeUtil.java:350)

at logintest.crm_getcount_0_1.CRM_GetCount.runJobInTOS(CRM_GetCount.java:1107)

at logintest.crm_getcount_0_1.CRM_GetCount.main(CRM_GetCount.java:963)

Exception in component tDBInput_1 (CRM_GetCount)

java.sql.SQLException: Access denied for user 'EDWPROD'@'localhost' (using password: YES)

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)

at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:12 2)

at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:836)

at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456)

at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246)

at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199)

at java.sql.DriverManager.getConnection(DriverManager.java:664)

at java.sql.DriverManager.getConnection(DriverManager.java:247)

at logintest.crm_getcount_0_1.CRM_GetCount.tDBInput_1Process(CRM_GetCount.java:542)

at logintest.crm_getcount_0_1.CRM_GetCount.runJobInTOS(CRM_GetCount.java:1144)

at logintest.crm_getcount_0_1.CRM_GetCount.main(CRM_GetCount.java:963)

Job Returned: 1

Error: 1 returned an error code, dying

This lead me to the article: https://community.talend.com/s/question/0D53p00007vCn3SCAS/javasecurityinvalidkeyexception-illegal-key-size?language=en_US

We upgraded Java to 11 and it works fine.

Fixed.

topic Re: mysql login connection exception on linux when works fine on Windows. in Talend Studio

mysql login connection exception on linux when works fine on Windows.

Re: mysql login connection exception on linux when works fine on Windows.