MariaDB Database connection with ssl server side

[Anonymous]

Hello dear community friends,
I have a MariaDB that I want to access with the Talend Open Studio for Data Integration.
However, I do not get the connection established.
The connection must use ssl and a username. However, I can not get it. I always get an "Acces Denied for user authentication with password".
Does any of you have experience in it and can help me?
Thank you.
VG

[Anonymous]

Hello,

Here is a component tSetKeystore which submits authentication data of a truststore with or without keystore to validation for the SSL connection.

Could you please have a look at this component reference about:

https://help.talend.com/reader/AihX5D_msseybwaTdP8dig/wkAW6b0YPXbk2pJLrzB~ew

Are you able to connect your MariaDB Database successfully through client without using talend tool?

 

Best regards

Sabrina

[Anonymous]

Thanks for your help, i will try it and report to you.
Yes, other Tools can connect. With DSN and without DSN.

[Anonymous]

Hello,
So I have now set up a truststore with the ca of the database server. I connected the keystore to the database connection via "on job ok".
However, I still get the same error message.