# \[Newbie\] Errno::ECONNREFUSED

**URL:** <https://www.ruby-forum.com/t/newbie-errno-econnrefused/105084>\
**Category:** Rails\
**Created:** [May 25, 2007, 5:29pm UTC](https://www.ruby-forum.com/t/newbie-errno-econnrefused/105084 "2007-05-25T17:29:13Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![andrew\_maddox](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/6de8d8/32.png) [@andrew\_maddox](https://www.ruby-forum.com/u/andrew_maddox)\
**Post date:** [May 25, 2007, 5:29pm UTC](https://www.ruby-forum.com/t/newbie-errno-econnrefused/105084/1 "2007-05-25T17:29:13Z")

</div>

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

* * *

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

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

Any help on getting me hooked up is appreciated.

Thanks,

Andrew Maddox

---

<div class="post-metadata">

**Author:** ![andrew\_maddox](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/6de8d8/32.png) [@andrew\_maddox](https://www.ruby-forum.com/u/andrew_maddox)\
**Post date:** [May 25, 2007, 11:30pm UTC](https://www.ruby-forum.com/t/newbie-errno-econnrefused/105084/2 "2007-05-25T23:30:50Z")

</div>

On May 25, 2007, at 11:13 AM, andrew maddox wrote:

> host: localhost
> 
> When I try to connect I get the following:
> 
> Errno::ECONNREFUSED in TestController#index  
> Connection refused  
> RAILS\_ROOT: script/…/config/…  
> …
> 
> 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 B. [http://agileconsultingllc.com](http://agileconsultingllc.com)  
removed\_email\_address@domain.invalid

---

<div class="post-metadata">

**Author:** ![andrew\_maddox](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/6de8d8/32.png) [@andrew\_maddox](https://www.ruby-forum.com/u/andrew_maddox)\
**Post date:** [May 30, 2007, 1:06am UTC](https://www.ruby-forum.com/t/newbie-errno-econnrefused/105084/3 "2007-05-30T01:06:59Z")

</div>

Hello-

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

Thanks,

Andrew

On May 25, 3:29 pm, Rob B. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)