topic Re: Talend to MySQL connection with SSL enabled in Talend Studio

Talend to MySQL connection with SSL enabled

RMukherjee08 — Fri, 15 Nov 2024 22:54:27 GMT

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 — Fri, 20 May 2022 08:53:59 GMT

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 — Fri, 20 May 2022 12:40:46 GMT

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 — Mon, 23 May 2022 08:12:37 GMT

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