mysql error using Rails-- Please help
- by Cypher
Alright I am sry for the noob question but this has been driving me up a wall-especially because I got it to work yesterday and I can't remember what I did....
I am just trying to use mysql with rails with a mongrel server. I set up the server fine and can run rails applications that don't need mysql but when I create a project using (for example) rails -d mysql blog and then create some simple controller e.g. ruby script/generate Test then put this code in the controller...
class TestController < ApplicationController
def index
render :text => 'WORK'
end
end
then when I start the server up and open up localhost:3000/test I get the following error:
= Booting Mongrel
= Rails 2.3.5 application starting on http://0.0.0.0:3000
= Call with -d to detach
= Ctrl-C to shutdown server
/!\ FAILSAFE /!\ Mon May 10 20:15:06 -0500 2010
Status: 500 Internal Server Error
Can't connect to MySQL server on 'localhost' (10061)
C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapter
s/mysql_adapter.rb:589:in 'real_connect'
C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapter
s/mysql_adapter.rb:589:in 'connect'
C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapter
s/mysql_adapter.rb:203:in 'initialize'
C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapter
s/mysql_adapter.rb:75:in 'new'
C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapter
s/mysql_adapter.rb:75:in 'mysql_connection'
C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapter
s/abstract/connection_pool.rb:223:in 'send'
C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapter
s/abstract/connection_pool.rb:223:in 'new_connection'
C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapter
s/abstract/connection_pool.rb:245:in 'checkout_new_connection'
C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapter
s/abstract/connection_pool.rb:188:in 'checkout'
C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapter
s/abstract/connection_pool.rb:184:in 'loop'
C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapter
s/abstract/connection_pool.rb:184:in 'checkout'
C:/Ruby/lib/ruby/1.8/monitor.rb:242:in 'synchronize'
C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapter
s/abstract/connection_pool.rb:183:in 'checkout'
C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapter
s/abstract/connection_pool.rb:98:in 'connection'
C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapter
s/abstract/connection_pool.rb:326:in 'retrieve_connection'
C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapter
s/abstract/connection_specification.rb:123:in 'retrieve_connection'
C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapter
s/abstract/connection_specification.rb:115:in 'connection'
etc...
In the browser i get a 'We're sorry, but something went wrong'
Does anyone know what I am doing wrong?