topic Re: Connecting to a mysql database via SSH in Talend Studio

Connecting to a mysql database via SSH

Anonymous — Thu, 17 Jan 2019 22:26:08 GMT

Pls can anyone help with the process of using the tMySqlInput to connect to a database via SSH connection.

Re: Connecting to a mysql database via SSH

vapukov — Thu, 17 Jan 2019 22:44:04 GMT

you can not do this from tMySQLInput component, but you can create ssh tunnel outside of Talend (with several gui tools) or right from Talend with tSystem component:

ssh -L 1234:localhost:3306 mysql.server.remote

after this you need use new localhost and new port (1234 in example) in tMySQLInput settings

UPDATE:

of course you must have installed/enabled ssh command in case of Windows machine if choose command-line (tSystem) way

Re: Connecting to a mysql database via SSH

Anonymous — Thu, 17 Jan 2019 23:04:29 GMT

Thanks for the reply.

However for the tSystem option will it need to be connected to the tMySqlInput ???

Re: Connecting to a mysql database via SSH

vapukov — Thu, 17 Jan 2019 23:28:25 GMT

Not exactly

Just before, for example in PreJob

Re: Connecting to a mysql database via SSH

Anonymous — Wed, 23 Jan 2019 14:23:44 GMT

Tried doing it on my system (MacOs)
did a quick connection to ssh and tried to connect to the mysql via the tmysqlinput and I got connection failed.