SSH connection to MySQL

[ldipeso]

We have a FileMaker database that we'd like to connect to a MySQL database. The FileMaker database is hosted with MacUSA.net

However, our current host for the MySQL database (another company) does not allow external connections to their database server, but does allow connections through an SSH tunnel. Is FileMaker Server (or client) capable of establishing such a connection?

[Dali]

If you can, I suggest you create the tunnel and System DSN on the machine where FileMaker Server 9 Advanced is installed (I'm not sure if they will allow you to open a tunnel, something you'll need to find out with MacUSA).

In order for you to connect to mysql server you would first need to establish an SSH tunnel (google for some ssh clients that support tunneling).

Once you have the tunnel running, you'd need to setup a system DSN to connect to mysql through the tunnel port on local machine (127.0.0.1) and then use that DSN in filemaker server.

Just remember that the tunnel must be open in order for filemaker to access mysql.

Do some research on SSH tunneling, it can be somewhat tricky if you've never done it before.

Good luck.