[Newbie] Errno::ECONNREFUSED

Hello-

Just trying to get a basic CRUD going using the sample database on XP
system. I have edited my database.yml file as follows:

development:
  adapter: mysql
  database: sample
  username: app
  password: app
  host: localhost

When I try to connect I get the following:

Errno::ECONNREFUSED in TestController#index
Connection refused
RAILS_ROOT: script/../config/..

Application Trace | Framework Trace | Full Trace

C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/activerecord-1.15.3/lib/active_record/vendor/mysql.rb:111:in
`new'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/activerecord-1.15.3/lib/active_record/vendor/mysql.rb:111:in
`real_connect'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/activerecord-1.15.3/lib/active_record/connection_adapters/
mysql_adapter.rb:389:in `connect'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/activerecord-1.15.3/lib/active_record/connection_adapters/
mysql_adapter.rb:152:in `initialize'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/activerecord-1.15.3/lib/active_record/connection_adapters/
mysql_adapter.rb:82:in `new'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/activerecord-1.15.3/lib/active_record/connection_adapters/
mysql_adapter.rb:82:in `mysql_connection'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/activerecord-1.15.3/lib/active_record/connection_adapters/
abstract/connection_specification.rb:262:in `send'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/activerecord-1.15.3/lib/active_record/connection_adapters/
abstract/connection_specification.rb:262:in `connection='
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/activerecord-1.15.3/lib/active_record/query_cache.rb:54:in
`connection='
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/activerecord-1.15.3/lib/active_record/connection_adapters/
abstract/connection_specification.rb:230:in `retrieve_connection'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/activerecord-1.15.3/lib/active_record/connection_adapters/
abstract/connection_specification.rb:78:in `connection'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/activerecord-1.15.3/lib/active_record/base.rb:763:in `columns'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/activerecord-1.15.3/lib/active_record/calculations.rb:257:in
`column_for'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/activerecord-1.15.3/lib/active_record/calculations.rb:116:in
`calculate'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/activerecord-1.15.3/lib/active_record/calculations.rb:45:in
`count'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/actionpack-1.13.3/lib/action_controller/pagination.rb:176:in
`count_collection_for_pagination'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/actionpack-1.13.3/lib/action_controller/pagination.rb:197:in
`paginator_and_collection_for'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/actionpack-1.13.3/lib/action_controller/pagination.rb:130:in
`paginate'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/actionpack-1.13.3/lib/action_controller/scaffolding.rb:7:in
`list'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/actionpack-1.13.3/lib/action_controller/scaffolding.rb:2:in
`index'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/actionpack-1.13.3/lib/action_controller/base.rb:1095:in `send'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/actionpack-1.13.3/lib/action_controller/base.rb:1095:in
`perform_action'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/actionpack-1.13.3/lib/action_controller/filters.rb:631:in
`call_filter'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/actionpack-1.13.3/lib/action_controller/filters.rb:635:in
`call_filter'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/actionpack-1.13.3/lib/action_controller/filters.rb:619:in
`perform_action_with_filters'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/actionpack-1.13.3/lib/action_controller/benchmarking.rb:65:in
`perform_action_with_benchmark'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/actionpack-1.13.3/lib/action_controller/rescue.rb:83:in `measure'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/actionpack-1.13.3/lib/action_controller/benchmarking.rb:66:in
`perform_action_with_benchmark'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/actionpack-1.13.3/lib/action_controller/rescue.rb:83:in
`perform_action_with_rescue'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/actionpack-1.13.3/lib/action_controller/base.rb:431:in `send'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/actionpack-1.13.3/lib/action_controller/base.rb:431:in `process'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/actionpack-1.13.3/lib/action_controller/filters.rb:624:in
`process_with_filters'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/actionpack-1.13.3/lib/action_controller/session_management.rb:
114:in `process_with_session_management_support'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/actionpack-1.13.3/lib/action_controller/base.rb:330:in `process'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/rails-1.2.3/lib/dispatcher.rb:41:in `dispatch'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/rails-1.2.3/lib/webrick_server.rb:118:in `handle_dispatch'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/rails-1.2.3/lib/webrick_server.rb:81:in `service'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/1.8/
webrick/httpserver.rb:104:in `service'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/1.8/
webrick/httpserver.rb:65:in `run'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/1.8/
webrick/server.rb:173:in `start_thread'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/1.8/
webrick/server.rb:95:in `start'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/activerecord-1.15.3/lib/active_record/vendor/mysql.rb:111:in
`new'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/activerecord-1.15.3/lib/active_record/vendor/mysql.rb:111:in
`real_connect'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/activerecord-1.15.3/lib/active_record/connection_adapters/
mysql_adapter.rb:389:in `connect'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/activerecord-1.15.3/lib/active_record/connection_adapters/
mysql_adapter.rb:152:in `initialize'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/activerecord-1.15.3/lib/active_record/connection_adapters/
mysql_adapter.rb:82:in `new'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/activerecord-1.15.3/lib/active_record/connection_adapters/
mysql_adapter.rb:82:in `mysql_connection'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/activerecord-1.15.3/lib/active_record/connection_adapters/
abstract/connection_specification.rb:262:in `send'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/activerecord-1.15.3/lib/active_record/connection_adapters/
abstract/connection_specification.rb:262:in `connection='
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/activerecord-1.15.3/lib/active_record/query_cache.rb:54:in
`connection='
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/activerecord-1.15.3/lib/active_record/connection_adapters/
abstract/connection_specification.rb:230:in `retrieve_connection'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/activerecord-1.15.3/lib/active_record/connection_adapters/
abstract/connection_specification.rb:78:in `connection'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/activerecord-1.15.3/lib/active_record/base.rb:763:in `columns'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/activerecord-1.15.3/lib/active_record/calculations.rb:257:in
`column_for'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/activerecord-1.15.3/lib/active_record/calculations.rb:116:in
`calculate'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/activerecord-1.15.3/lib/active_record/calculations.rb:45:in
`count'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/actionpack-1.13.3/lib/action_controller/pagination.rb:176:in
`count_collection_for_pagination'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/actionpack-1.13.3/lib/action_controller/pagination.rb:197:in
`paginator_and_collection_for'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/actionpack-1.13.3/lib/action_controller/pagination.rb:130:in
`paginate'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/actionpack-1.13.3/lib/action_controller/scaffolding.rb:7:in
`list'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/actionpack-1.13.3/lib/action_controller/scaffolding.rb:2:in
`index'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/actionpack-1.13.3/lib/action_controller/base.rb:1095:in `send'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/actionpack-1.13.3/lib/action_controller/base.rb:1095:in
`perform_action'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/actionpack-1.13.3/lib/action_controller/filters.rb:631:in
`call_filter'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/actionpack-1.13.3/lib/action_controller/filters.rb:635:in
`call_filter'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/actionpack-1.13.3/lib/action_controller/filters.rb:619:in
`perform_action_with_filters'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/actionpack-1.13.3/lib/action_controller/benchmarking.rb:65:in
`perform_action_with_benchmark'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/actionpack-1.13.3/lib/action_controller/rescue.rb:83:in `measure'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/actionpack-1.13.3/lib/action_controller/benchmarking.rb:66:in
`perform_action_with_benchmark'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/actionpack-1.13.3/lib/action_controller/rescue.rb:83:in
`perform_action_with_rescue'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/actionpack-1.13.3/lib/action_controller/base.rb:431:in `send'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/actionpack-1.13.3/lib/action_controller/base.rb:431:in `process'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/actionpack-1.13.3/lib/action_controller/filters.rb:624:in
`process_with_filters'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/actionpack-1.13.3/lib/action_controller/session_management.rb:
114:in `process_with_session_management_support'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/actionpack-1.13.3/lib/action_controller/base.rb:330:in `process'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/rails-1.2.3/lib/dispatcher.rb:41:in `dispatch'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/rails-1.2.3/lib/webrick_server.rb:118:in `handle_dispatch'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/
gems/rails-1.2.3/lib/webrick_server.rb:81:in `service'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/1.8/
webrick/httpserver.rb:104:in `service'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/1.8/
webrick/httpserver.rb:65:in `run'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/1.8/
webrick/server.rb:173:in `start_thread'
C:/Program Files/NetBeans 6.0 M9/ruby1/jruby-0.9.8/lib/ruby/1.8/
webrick/server.rb:95:in `start'
Request
Parameters: None

Show session dump

Hello-

Just trying to get a basic CRUD going using the sample database on XP
system. I have edited my database.yml file as follows:

development:
  adapter: mysql
  database: sample
  username: app
  password: app
  host: localhost

When I try to connect I get the following:

Errno::ECONNREFUSED in TestController#index
Connection refused
RAILS_ROOT: script/../config/..

...

Request
Parameters: None

Show session dump

---
flash: !map:ActionController::Flash::FlashHash {}

Response
Headers: {"cookie"=>[], "Cache-Control"=>"no-cache"}

Any help on getting me hooked up is appreciated.

Thanks,

Andrew Maddox

Did you create the database named "sample" that you specified in the database.yml file?

-Rob

Rob Biedenharn http://agileconsultingllc.com
Rob@AgileConsultingLLC.com

Hello-

I'm using the sample database that came preinstalled with Netbeans.

Thanks,

Andrew