Forum: Ruby on Rails SSH database configuration

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
Ad411880cdcaf541c1a3c7268fc479fc?d=identicon&s=25 Alvaro Perez (kabish)
on 2007-07-27 13:02
How can I configure Rails to connect to a database via SSH? In the
config file we have:

development:
  adapter:
  database:
  username:
  password:
  host:

No connection type, ssh port...

Thank you,
Alvaro.
00973881979aa0a660ffbbb2f7a907fb?d=identicon&s=25 Peter De Berdt (Guest)
on 2007-07-27 13:15
(Received via mailing list)
On 27 Jul 2007, at 13:02, Alvaro Perez wrote:

> No connection type, ssh port...
Why don't you use ssh port forwarding or a reverse ssh tunnel
(depending on your needs). Make sure the tunnel is created at startup.

Reverse SSH tunneling can be a very interesting solution if the
target server is behind a firewall. I'm using autossh to tunnel some
of our customers' pcs to our server and it works just great (autossh
will restore the ssh tunnel if the connection drops etc.).

You can then just connect to 127.0.0.1 on a port of your preference.

Lots of articles on ssh port forwarding around the net: http://
www.google.com/search?client=safari&rls=en&q=ssh+port
+forwarding&ie=UTF-8&oe=UTF-8
Reverse ssh tunneling: http://www.google.com/search?
client=safari&rls=en&q=reverse+ssh+tunneling+autossh&ie=UTF-8&oe=UTF-8


Best regards

Peter De Berdt
Ad411880cdcaf541c1a3c7268fc479fc?d=identicon&s=25 Alvaro Perez (kabish)
on 2007-07-27 14:19
Peter,

I've used Putty (as I'm on a Windows machine) to create a SSH tunnel and
it works very fine. Thank you very much for thye idea.

Regards,
Alvaro

Peter De Berdt wrote:
> On 27 Jul 2007, at 13:02, Alvaro Perez wrote:
>
>> No connection type, ssh port...
> Why don't you use ssh port forwarding or a reverse ssh tunnel
> (depending on your needs). Make sure the tunnel is created at startup.
>
> Reverse SSH tunneling can be a very interesting solution if the
> target server is behind a firewall. I'm using autossh to tunnel some
> of our customers' pcs to our server and it works just great (autossh
> will restore the ssh tunnel if the connection drops etc.).
>
> You can then just connect to 127.0.0.1 on a port of your preference.
>
> Lots of articles on ssh port forwarding around the net: http://
> www.google.com/search?client=safari&rls=en&q=ssh+port
> +forwarding&ie=UTF-8&oe=UTF-8
> Reverse ssh tunneling: http://www.google.com/search?
> client=safari&rls=en&q=reverse+ssh+tunneling+autossh&ie=UTF-8&oe=UTF-8
>
>
> Best regards
>
> Peter De Berdt
B84d42a3a5c343f8fc6ab7d7f47fd3f5?d=identicon&s=25 Robby Russell (Guest)
on 2007-07-27 16:23
(Received via mailing list)
Alvaro Perez wrote:
> No connection type, ssh port...
>
> Thank you,
> Alvaro.

Do you mean a SSH Tunnel?

* http://docs.planetargon.com/PostgreSQL_SSH_Tunnel
* http://docs.planetargon.com/MySQL_SSH_Tunnel

Good luck!

Robby


--
Robby Russell
http://www.robbyonrails.com/
http://www.planetargon.com/
Ad411880cdcaf541c1a3c7268fc479fc?d=identicon&s=25 Alvaro Perez (kabish)
on 2007-07-27 16:24
Yep, exactly that.

Thanks!



Robby Russell wrote:
> Alvaro Perez wrote:
>> No connection type, ssh port...
>>
>> Thank you,
>> Alvaro.
>
> Do you mean a SSH Tunnel?
>
> * http://docs.planetargon.com/PostgreSQL_SSH_Tunnel
> * http://docs.planetargon.com/MySQL_SSH_Tunnel
>
> Good luck!
>
> Robby
>
>
> --
> Robby Russell
> http://www.robbyonrails.com/
> http://www.planetargon.com/
F48118fe74b0c7f6fd82a0ee422fa34e?d=identicon&s=25 snacktime (Guest)
on 2007-07-27 18:44
(Received via mailing list)
What database are you using?  If possible I would try to use a native
secure link such as ssl with authentication, much more efficient.
Postgresql for example can use ssl with client authentication.  Not
sure about mysql.

Chris
This topic is locked and can not be replied to.