topic [resolved] Can't connect to MariaDB in Talend Studio

[resolved] Can't connect to MariaDB

_AnonymousUser — Wed, 09 Mar 2016 08:07:25 GMT

Hi !
I'm working on a project and i would like to connect a MariaDB database.
With putty i can connect to the database.

Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 177
Server version: 5.5.44-MariaDB MariaDB Server
Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

But when I go on talend, i got a time out...
My database is running on a virtual server in localhost, have you go a idea about what's going wrong ?
Bests regards

Re: [resolved] Can't connect to MariaDB

Anonymous — Thu, 10 Mar 2016 03:35:24 GMT

Hi,
What's Talend build version you are using? Did you start your DB server on a virtual server in localhost?
Could you please upload the connection setting screenshot into forum?
Best regards
Sabrina

Re: [resolved] Can't connect to MariaDB

_AnonymousUser — Thu, 10 Mar 2016 04:19:51 GMT

Hi !
I'm working on a project and i would like to connect a MariaDB database.
With putty i can connect to the database.
But when I go on talend, i got a time out...
My database is running on a virtual server in localhost, have you go a idea about what's going wrong ?

Hi,
VMs like docker runs MariaDB on an alternativ port instead the default port 3306, so check the port of your MariaDB installation and take care, that the same port is entered in the MySQL Connection in Talend.
Richard

Re: [resolved] Can't connect to MariaDB

_AnonymousUser — Thu, 10 Mar 2016 10:45:47 GMT

Hi !
I found the problem yesterday, that was the firewall of the server, the port for MySQL wasn't set...
Thanks for replies !