Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

MariaDB Database connection with ssl server side

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

Labels (2)
3 Replies
Anonymous
Not applicable
Author

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
Not applicable
Author

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

Anonymous
Not applicable
Author

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.