Database connection to remote machine

rubyonrails-talk
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

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.

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

3

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