Connecting to a remote database

Rails
1

Hi,

I’m having trouble connecting to a remote database (mysql). I know that
my connection settings are correct, since I have a php app that is
connecting to the same database.

Are there any settings besides the following that I need in my database
config file? Any other suggestions?

development:
adapter: mysql
database: db_name
username: username
password: password
host: mysql45.secureserver.net

2

No that’s about it…
when you say “having trouble”, could you be more specific? What’s the
error
stack say?

3

Brian H. wrote:

No that’s about it…
when you say “having trouble”, could you be more specific? What’s the
error
stack say?

It says “A connection attempt failed because the connected party did not
properly respond after a period of time, or established connection
failed because connected host has failed to respond. - connect(2)”

4

Well that’s messed up… host name wrong?

5

Brian H. wrote:

Well that’s messed up… host name wrong?

No, checked it several times. It’s exactly the same as my php app is
using. Do you think that it could be something about the password (I
saw somewhere that Rails requires the new MySQL password hashing. This
MySQL DB is version 4.something not V5

6

Dan: It’s a possibility. I use MySQL 4.1 and 5.0 here… but it’s
acting
like the database can’t be found. What version database do you have?

7

anonymous wrote:

Brian H. wrote:

Dan: It’s a possibility. I use MySQL 4.1 and 5.0 here… but it’s
acting
like the database can’t be found. What version database do you have?

Could there be a firewall on the DB Machine that is allowing the machine
with the PHP app to pas but blocking off the requests from the MySQL
machine?

I don’t think so because the two apps are hosted on the same machine
(the PHP and RoR). It is MySQL 4.0.24

Thanks,

Dan

8

Brian H. wrote:

Dan: It’s a possibility. I use MySQL 4.1 and 5.0 here… but it’s
acting
like the database can’t be found. What version database do you have?

Could there be a firewall on the DB Machine that is allowing the machine
with the PHP app to pas but blocking off the requests from the MySQL
machine?

9

Dan: Could very well be the password thing then.