Talend to MySQL connection with SSL enabled

RMukherjee08 · ‎2022-05-20

Hi Team,

I need to configure the MySQL SSL certificate in Talend for establishing a secure connection with MySQL DB from Talend.

Could you please help me to guiding the the steps which I need to follow for configuring the MySQL SSL certificates through Talend.

Thanks in advance.

Regards,

Ritupan Mukherjee

Anonymous · ‎2022-05-20

Hello,

Could you please take a look at this KB article about:

Feel free to let us know if it is what you are looking for.

Best regards

Sabrina

RMukherjee08 · ‎2022-05-20

Hi,

I am getting the error as per below while running the talend job to load data in MySQL cloud instance.

I have the access to the MySQL DB (can connect to the server from MySQL application with SSL certificates enabled)

error:

Starting job dummy_01 at 17:18 20/05/2022.

[statistics] connecting to socket on port 3697

[statistics] connected

Exception in component tDBOutput_1

java.sql.SQLException: Access denied for user 'user_name'@'server_IP' (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(Unknown Source)

at drl_rover.dummy.dummy_01.tBigQueryInput_1Process(dummy_01.java:952)

at drl_rover.dummy.dummy_01.runJobInTOS(dummy_01.java:2111)

at drl_rover.dummy.dummy_01.main(dummy_01.java:1890)

[statistics] disconnected

Job dummy_01 ended at 17:18 20/05/2022. [Exit code = 1]

Anonymous · ‎2022-05-23

Hello,

Are you running remote access for your MySql server?

Please make sure Talend does propagate the information, specifically, your password when you edit the DB connection settings.

Could you please post your job setting screenshots on community which will be helpful for us to address your issue? Please mask your sensitive data.

Best regards

Sabrina