search

dreamfactorysoftware / dreamfactory

DreamFactory API Management Platform
https://www.dreamfactory.com
Apache License 2.0
1.56k stars 314 forks source link

Feature Request: SSH Tunnel on DB Connections #234

Open tylers-username opened 5 years ago

tylers-username commented 5 years ago

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 commented 5 years ago

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 commented 5 years ago

@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 commented 5 years ago

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 commented 5 years ago

@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 commented 4 years ago

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