topic Re: MariaDB Database connection with ssl server side in Talend Studio

MariaDB Database connection with ssl server side

Anonymous — Thu, 20 Sep 2018 14:45:46 GMT

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

Re: MariaDB Database connection with ssl server side

Anonymous — Tue, 25 Sep 2018 03:36:23 GMT

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

Re: MariaDB Database connection with ssl server side

Anonymous — Tue, 25 Sep 2018 06:36:51 GMT

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

Re: MariaDB Database connection with ssl server side

Anonymous — Tue, 25 Sep 2018 15:50:18 GMT

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.