Connection to data base with tunneling ssh

[crbejaranoh]

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

[R.Alamsha]

@crbejaranoh

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

which database, version and os?

[crbejaranoh]

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?
Thank

[PGriffith]

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.

[R.Alamsha]

@crbejaranoh

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?

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