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 -- Posted via http://www.ruby-forum.com/.
No that''s about it... when you say "having trouble", could you be more specific? What''s the error stack say? On 7/14/06, Dan Langevin <dan.langevin@gmail.com> wrote:> > 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 > > -- > Posted via http://www.ruby-forum.com/. > _______________________________________________ > Rails mailing list > Rails@lists.rubyonrails.org > http://lists.rubyonrails.org/mailman/listinfo/rails >-------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060715/4c73f7e1/attachment.html
Brian Hogan 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)" -- Posted via http://www.ruby-forum.com/.
Well that''s messed up... host name wrong? On 7/15/06, Dan <dan.langevin@gmail.com> wrote:> > Brian Hogan 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)" > > > > > -- > Posted via http://www.ruby-forum.com/. > _______________________________________________ > Rails mailing list > Rails@lists.rubyonrails.org > http://lists.rubyonrails.org/mailman/listinfo/rails >-------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060715/bf8f5aac/attachment.html
Brian Hogan 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 -- Posted via http://www.ruby-forum.com/.
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? On 7/15/06, Dan Langevin <dan.langevin@gmail.com> wrote:> > Brian Hogan 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 > > > -- > Posted via http://www.ruby-forum.com/. > _______________________________________________ > Rails mailing list > Rails@lists.rubyonrails.org > http://lists.rubyonrails.org/mailman/listinfo/rails >-------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060717/03133560/attachment.html
Brian Hogan 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? -- Posted via http://www.ruby-forum.com/.
anonymous wrote:> Brian Hogan 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 -- Posted via http://www.ruby-forum.com/.
Dan: Could very well be the password thing then. On 7/17/06, Dan Langevin <dan.langevin@gmail.com> wrote:> > anonymous wrote: > > Brian Hogan 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 > > -- > Posted via http://www.ruby-forum.com/. > _______________________________________________ > Rails mailing list > Rails@lists.rubyonrails.org > http://lists.rubyonrails.org/mailman/listinfo/rails >-------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060717/a4b52bb3/attachment.html