Welcome Guest | Login

Best practices for connecting to a database behind a firewall

I want to use a db for a Rails application hosted on HostingRails.  But, this database is within my company's network, and not available to the web.

I do not want to build a web service layer within the network and expose that web service.

What is the best (i.e. secure with good performace) method of doing this?

SSH tunneling?
Opening a specific port on the db server and only allowing requests for a specific IP to access it?

2008-05-22 09:55 AM


If your database sever has a public IP address, you can open the specific port (3306 by default) on the database server and allow only the HostingRails servers IP to access this port. You may need to check your firewalls documentation to know how to it with your particular firewall.

2008-05-22 12:28 PM

It does not have a public IP address.  But, it may be possible to get one.

Any other ideas assuming I cannot get a public IP.

2008-05-22 12:41 PM


You will have to connect to the DB server from the HostingRails Server right..? Then I don't think there is no further workarounds.

2008-05-22 03:28 PM

Regards,
Rahul

Hello Guest! In order to post you must be an active client with us, please log in or sign up today!