Database connection to remote machine

Rails
1

HiAll,

Here is strange problem.

Application is on cloud server. Database server is on another instance
and application hosted on different instance.

databse server ip : 170.2.14.131
application server ip : 170.2.14.137

development:
adapter: mysql
database: database_name
username: ************
password: ************
host: 170.2.14.131

This is my database.yml configuration for development environment.

Now when i am trying to connect through my application it’s using
application server IP instead of remote databse IP.

Please suggest.

2

On 20 March 2012 07:44, Dharmdip R. [email protected] wrote:

development:
adapter: mysql
database: database_name
username: ************
password: ************
host: 170.2.14.131

This is my database.yml configuration for development environment.

Now when i am trying to connect through my application it’s using
application server IP instead of remote databse IP.

Have you restarted the server since you changed database.yml?
Are you running in development mode on the server?
You could try putting an error in your database.yml to make sure it is
using it. Put invalid username in for example.

Colin

For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

–
gplus.to/clanlaw

3

Overcome issue by setting Mysql privileges , thanks for all support.