SQL Connection to Google Cloud SQL using SSL

Connecting to SQL
1

Is it possible to use SSL when connecting to Google Cloud SQL?

When using my Navicat client I need to configure certificates - so I have no idea how that would work with DF?

2

DreamFactory does not have settings for secure vs insecure sql connections. What most people have done who have a need for this type of connection is to create a persistent secure tunnel between the machine hosting DreamFactory and the destination database server. Then you can add it to your dreamfactory as a service as localhost with the appropriate port number for the tunnel connection.

1 Like
3

Is it possible to have a script run (prior to the DF service attempting to connect to the MySQL DB) that would setup the tunnel and provide the local port number back to the service?

4

No such functionality exists within DreamFactory. This is more a question of configuring your infrastructure. I would look into autossh and cron to start and maintain the connection. Then it will always be available to DF.