Feature Request: SSH Tunnel on DB Connections

[tylers-username]

As a platform.sh user, all of our web application databases are restricted to local access. This means that in order to connect you must SSH into the machine or create an SSH tunnel.

This is a common feature built into reporting tools such as RJ Metrics which assume that database access will be restricted in such a way.

[wjgilmore]

Hi @tylerssn thank you for the feedback. Are you presently running DreamFactory on platform.sh? I was under the impression DreamFactory and Platform.sh were incompatible due to the way Platform.sh restricts writing to the filesystem. Has this changed?

[tylers-username]

@wjgilmore - I was able to get 3.0.0 working on Platform.sh without any issue during my Dream Factory trial. The caveat is that I have a lot of experience with the nuances of Platform.sh. I'm happy to share my .platform.app.yaml if you'd like. That coupled with the Laravel Platform.sh composer package made it pretty simple to get up and running with Redis cache and all that fun stuff.

In the context of my issue description, I am actually using Dream Factory Cloud. And, even if I were on Platform.sh, the same would still apply. The Dream Factory server still needs access to external databases and in our case, they'd be running on other Platform.sh projects.

[tylers-username]

On the topic of running Dream Factory on Platform.sh, below is a fork of what I had success with a week or two ago. Note that there is also a .lando.dist.yaml and README.md to painlessly get this thing launched with both a dev environment as well as on Platform.sh

https://gitlab.com/tylerssn/dream-factory

[wjgilmore]

@tylerssn wonderful yes incorporating your Lando PR will happen within the next few weeks, you might have noticed DreamFactory 3.0 was officially released this morning so we've spent the last few weeks tying up loose ends for that. We will definitely check out your fork with the Platform.sh integration too!

[TBG-FR]

+1 for SSH Tunnel option
With some hosts you're forced to use SSH Tunnel, so that would be realy useful