Help needed to setup SSH tunnel for MariaDB

[mgdorset]

Hi,

I'm quite a beginner to networks/remote access and just really could do with an idiots guide on how to setup an SSH tunnel for the following: I have a synology server running at work, where we have a database running on MariaDB that was installed via the Package centre on the DS.

I would like to setup a SSH tunnel, so I can access the MariaDB database from home.

Could anyone help with some simple directions, of what I need to do on my home computer/work server to allow this. I just want a setup that's easy to do, but also keeping my home PC/work server safe!

Thanks!

Martyn

 

[fredbert]

Welcome to the forum.

Do you really mean a SSH tunnel or do you just want to use SSH for command line access?

To get access from home LAN to work LAN you would have to make the NAS accessible through the work firewall. So that would mean opening port forwarders on the work firewall and point them to them to the NAS’s LAN IP. If you already have a VPN service to get access to the work LAN then I would use that and then just use an SSH client from home to access the NAS on its LAN IP.

 

[mgdorset]

Welcome to the forum.

Do you really mean a SSH tunnel or do you just want to use SSH for command line access?

To get access from home LAN to work LAN you would have to make the NAS accessible through the work firewall. So that would mean opening port forwarders on the work firewall and point them to them to the NAS’s LAN IP. If you already have a VPN service to get access to the work LAN then I would use that and then just use an SSH client from home to access the NAS on its LAN IP.

Hi, thanks for your reply!

From what I've read, I'm assuming it's a SSH tunnel?

The MariaDB database on the work synology NAS is used with an Access front end application, which I would have at home and would need that to connect to the work DB via the tunnel. Hope that makes sense? We do not have a VPN.

 

[fredbert]

You could install and run VPN Server on the NAS. That would require certain ports to be forwarded to the NAS, but there’s no getting around doing that if you exposed SSH on the NAS.

Personally I would use OpenVPN or L2TP/IPsec VPN, then access the database.

 

[mgdorset]

You could install and run VPN Server on the NAS. That would require certain ports to be forwarded to the NAS, but there’s no getting around doing that if you exposed SSH on the NAS.

Personally I would use OpenVPN or L2TP/IPsec VPN, then access the database.

OK... so I'm beginning to follow now! If I install VPN server on the work NAS and use OpenVPN on my home PC and connect like that, will the MariaDB hosted on the server appear like it's a local database on my home PC?