On 24 January 2012 10:56, David Ekdahl <li...@ruby-forum.com> wrote: > Hello, > > First of all I am not a Ruby programmer. The reason I am writing this > post is because I took over the administration of a CentOS-server > running a Ruby-application because the former administrator is no longer > available in the company. I am novice in both Linux and Ruby so bear > with me. > > As stated, we have a CentOS server running Apache and Ruby 1.8.7. We > have a Ruby application with a database.yml pointint to two adapters. > One mysql for the application itself to store data, and one adapter for > reading data. Both of them are pointing towards localhost. > > Now we need to move the reading database from localhost to > remote.host.local since we have a new mysql server in the network. > > When i change the > host: localhost to host: remote.host.local i get 400 Internal server > error when i start my application. > > I have verified the connection from the CentOS server, and to the remote > server. Iptables is configured to pass through data on port 3306 > The remote MySQL server is accepting data from user@ip-adress-of-CentOS. > Privileges is configured to GRANT ALL on the database from the remote > user. > > When i run mysql -h remote.host.local -u user -p i get a valid > connection. > > Is there anywhere else but the database.yml file i need to specify > something? I have verified with the developer of the application that he > uses only database.yml to connect to the MySQL server.
Have a look in the rails log (log/development.log or log/production.log in the rails project folder dependent on which mode you are using) to see if there is more info there. Colin > > My hair is turning gray because of this problem... > Thank you in advance. > David. > > -- > Posted via http://www.ruby-forum.com/. > > -- > You received this message because you are subscribed to the Google Groups > "Ruby on Rails: Talk" group. > To post to this group, send email to rubyonrails-talk@googlegroups.com. > To unsubscribe from this group, send email to > rubyonrails-talk+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/rubyonrails-talk?hl=en. > -- gplus.to/clanlaw -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk@googlegroups.com. To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.