Connection to data base with tunneling ssh

How do I do a connection to data base uses a tunneling ssh?

which database, version and os?

The OS is ubuntu 18.04, the ignition version is 7.9 and the database I am working with is MySql 5.7, is there a way to do it from ignition?

The MySQL JDBC driver does not support SSH as a connection protocol (I don’t think any JDBC driver does), so you would need to use an SSH ‘tunnel’ to route traffic from the JDBC driver over SSH to the remote database. See here for more information.

1 Like

I have identical setup. I use TCP/IP ssh to connect a remote machine on LAN at from my laptop. This works with Ignition The screenshot of workbench is below.

1 Like