Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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 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]
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