# Action Controller: Exception caught

**URL:** <https://www.ruby-forum.com/t/action-controller-exception-caught/58029>\
**Category:** Rails\
**Created:** [April 17, 2006, 9:39pm UTC](https://www.ruby-forum.com/t/action-controller-exception-caught/58029 "2006-04-17T21:39:09Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![fidogesiwuj](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/f/e9bcb4/32.png) [@fidogesiwuj](https://www.ruby-forum.com/u/fidogesiwuj)\
**Post date:** [April 17, 2006, 9:39pm UTC](https://www.ruby-forum.com/t/action-controller-exception-caught/58029/1 "2006-04-17T21:39:09Z")

</div>

Hi, I’m running the cookbook example from [ONLamp.com](http://ONLamp.com). I have tried to  
test my site and it comes up with the the message on the site:

ActiveRecord::StatementInvalid in RecipeController#index

Mysql::Error: Lost connection to MySQL server during query: SHOW FIELDS  
FROM recipes

RAILS\_ROOT: ./script/…/config/…  
Application Trace | Framework Trace | Full Trace

c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active\_record/connection\_adapters/abstract\_adapter.rb:120:in  
`log' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/connection_adapters/mysql_adapter.rb:185:in `execute’  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active\_record/connection\_adapters/mysql\_adapter.rb:293:in  
`columns' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/base.rb:696:in `columns’  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active\_record/calculations.rb:213:in  
`column_for' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/calculations.rb:135:in `calculate’  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active\_record/calculations.rb:64:in  
`count' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action_controller/pagination.rb:172:in `count\_collection\_for\_pagination’  
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action\_controller/pagination.rb:196:in  
`paginator_and_collection_for' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action_controller/pagination.rb:129:in `paginate’  
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action\_controller/scaffolding.rb:109:in  
`list' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action_controller/scaffolding.rb:97:in `index’  
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action\_controller/base.rb:910:in  
`send' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action_controller/base.rb:910:in `perform\_action\_without\_filters’  
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action\_controller/filters.rb:368:in  
`perform_action_without_benchmark' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action_controller/benchmarking.rb:69:in `perform\_action\_without\_rescue’  
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action\_controller/benchmarking.rb:69:in  
`measure' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action_controller/benchmarking.rb:69:in `perform\_action\_without\_rescue’  
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action\_controller/rescue.rb:82:in  
`perform_action' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action_controller/base.rb:381:in `send’  
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action\_controller/base.rb:381:in  
`process_without_filters' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action_controller/filters.rb:377:in `process\_without\_session\_management\_support’  
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action\_controller/session\_management.rb:117:in  
`process' c:/ruby/lib/ruby/gems/1.8/gems/rails-1.1.2/lib/dispatcher.rb:38:in `dispatch’  
c:/ruby/lib/ruby/gems/1.8/gems/rails-1.1.2/lib/webrick\_server.rb:115:in  
`handle_dispatch' c:/ruby/lib/ruby/gems/1.8/gems/rails-1.1.2/lib/webrick_server.rb:81:in `service’  
c:/ruby/lib/ruby/1.8/webrick/httpserver.rb:104:in `service' c:/ruby/lib/ruby/1.8/webrick/httpserver.rb:65:in `run’  
c:/ruby/lib/ruby/1.8/webrick/server.rb:155:in `start_thread' c:/ruby/lib/ruby/1.8/webrick/server.rb:144:in `start’  
c:/ruby/lib/ruby/1.8/webrick/server.rb:144:in `start_thread' c:/ruby/lib/ruby/1.8/webrick/server.rb:94:in `start’  
c:/ruby/lib/ruby/1.8/webrick/server.rb:89:in `each' c:/ruby/lib/ruby/1.8/webrick/server.rb:89:in `start’  
c:/ruby/lib/ruby/1.8/webrick/server.rb:79:in `start' c:/ruby/lib/ruby/1.8/webrick/server.rb:79:in `start’  
c:/ruby/lib/ruby/gems/1.8/gems/rails-1.1.2/lib/webrick\_server.rb:67:in  
`dispatch' c:/ruby/lib/ruby/gems/1.8/gems/rails-1.1.2/lib/commands/servers/webrick.rb:59 c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:18:in `require\_\_’  
c:/ruby/lib/ruby/site\_ruby/1.8/rubygems/custom\_require.rb:18:in  
`require' c:/ruby/lib/ruby/gems/1.8/gems/activesupport-1.3.1/lib/active_support/dependencies.rb:147:in `require’  
c:/ruby/lib/ruby/gems/1.8/gems/rails-1.1.2/lib/commands/server.rb:30  
c:/ruby/lib/ruby/site\_ruby/1.8/rubygems/custom\_require.rb:18:in  
`require__' c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:18:in `require’  
c:/ruby/lib/ruby/gems/1.8/gems/activesupport-1.3.1/lib/active\_support/dependencies.rb:147:in  
`require’  
script/server:3

c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active\_record/connection\_adapters/abstract\_adapter.rb:120:in  
`log' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/connection_adapters/mysql_adapter.rb:185:in `execute’  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active\_record/connection\_adapters/mysql\_adapter.rb:293:in  
`columns' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/base.rb:696:in `columns’  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active\_record/calculations.rb:213:in  
`column_for' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/calculations.rb:135:in `calculate’  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active\_record/calculations.rb:64:in  
`count' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action_controller/pagination.rb:172:in `count\_collection\_for\_pagination’  
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action\_controller/pagination.rb:196:in  
`paginator_and_collection_for' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action_controller/pagination.rb:129:in `paginate’  
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action\_controller/scaffolding.rb:109:in  
`list' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action_controller/scaffolding.rb:97:in `index’  
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action\_controller/base.rb:910:in  
`send' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action_controller/base.rb:910:in `perform\_action\_without\_filters’  
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action\_controller/filters.rb:368:in  
`perform_action_without_benchmark' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action_controller/benchmarking.rb:69:in `perform\_action\_without\_rescue’  
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action\_controller/benchmarking.rb:69:in  
`measure' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action_controller/benchmarking.rb:69:in `perform\_action\_without\_rescue’  
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action\_controller/rescue.rb:82:in  
`perform_action' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action_controller/base.rb:381:in `send’  
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action\_controller/base.rb:381:in  
`process_without_filters' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action_controller/filters.rb:377:in `process\_without\_session\_management\_support’  
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action\_controller/session\_management.rb:117:in  
`process' c:/ruby/lib/ruby/gems/1.8/gems/rails-1.1.2/lib/dispatcher.rb:38:in `dispatch’  
c:/ruby/lib/ruby/gems/1.8/gems/rails-1.1.2/lib/webrick\_server.rb:115:in  
`handle_dispatch' c:/ruby/lib/ruby/gems/1.8/gems/rails-1.1.2/lib/webrick_server.rb:81:in `service’  
c:/ruby/lib/ruby/1.8/webrick/httpserver.rb:104:in `service' c:/ruby/lib/ruby/1.8/webrick/httpserver.rb:65:in `run’  
c:/ruby/lib/ruby/1.8/webrick/server.rb:155:in `start_thread' c:/ruby/lib/ruby/1.8/webrick/server.rb:144:in `start’  
c:/ruby/lib/ruby/1.8/webrick/server.rb:144:in `start_thread' c:/ruby/lib/ruby/1.8/webrick/server.rb:94:in `start’  
c:/ruby/lib/ruby/1.8/webrick/server.rb:89:in `each' c:/ruby/lib/ruby/1.8/webrick/server.rb:89:in `start’  
c:/ruby/lib/ruby/1.8/webrick/server.rb:79:in `start' c:/ruby/lib/ruby/1.8/webrick/server.rb:79:in `start’  
c:/ruby/lib/ruby/gems/1.8/gems/rails-1.1.2/lib/webrick\_server.rb:67:in  
`dispatch' c:/ruby/lib/ruby/gems/1.8/gems/rails-1.1.2/lib/commands/servers/webrick.rb:59 c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:18:in `require\_\_’  
c:/ruby/lib/ruby/site\_ruby/1.8/rubygems/custom\_require.rb:18:in  
`require' c:/ruby/lib/ruby/gems/1.8/gems/activesupport-1.3.1/lib/active_support/dependencies.rb:147:in `require’  
c:/ruby/lib/ruby/gems/1.8/gems/rails-1.1.2/lib/commands/server.rb:30  
c:/ruby/lib/ruby/site\_ruby/1.8/rubygems/custom\_require.rb:18:in  
`require__' c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:18:in `require’  
c:/ruby/lib/ruby/gems/1.8/gems/activesupport-1.3.1/lib/active\_support/dependencies.rb:147:in  
`require’  
script/server:3

Request

Parameters: None

Show session dump

* * *

flash: !ruby/hash:ActionController::Flash::FlashHash {}

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

Anyone got any ideas how to fix this? I have tried restarting the server  
but that doesnt work.

---

<div class="post-metadata">

**Author:** ![fidogesiwuj](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/f/e9bcb4/32.png) [@fidogesiwuj](https://www.ruby-forum.com/u/fidogesiwuj)\
**Post date:** [April 17, 2006, 10:57pm UTC](https://www.ruby-forum.com/t/action-controller-exception-caught/58029/2 "2006-04-17T22:57:49Z")

</div>

Fido Gesiwuj wrote:

> ActiveRecord::StatementInvalid in RecipeController#index
> 
> Mysql::Error: Lost connection to MySQL server during query: SHOW FIELDS  
> FROM recipes

Get the native mysql drivers for your Windows machine at:  
[http://www.vandomburg.net/pages/mysql-ruby-windows](http://www.vandomburg.net/pages/mysql-ruby-windows)

That fixed it for me on my XP boxes. If you’re using 2k, by any chance,  
I still haven’t been able to fix that.

---

<div class="post-metadata">

**Author:** ![fidogesiwuj](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/f/e9bcb4/32.png) [@fidogesiwuj](https://www.ruby-forum.com/u/fidogesiwuj)\
**Post date:** [April 18, 2006, 1:02pm UTC](https://www.ruby-forum.com/t/action-controller-exception-caught/58029/3 "2006-04-18T13:02:48Z")

</div>

Does it matter that I’m connecting to a computer from my paid host? I  
have changed the config.yml thing.

---

<div class="post-metadata">

**Author:** ![fidogesiwuj](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/f/e9bcb4/32.png) [@fidogesiwuj](https://www.ruby-forum.com/u/fidogesiwuj)\
**Post date:** [April 18, 2006, 1:18pm UTC](https://www.ruby-forum.com/t/action-controller-exception-caught/58029/4 "2006-04-18T13:18:35Z")

</div>

Oh, now it has another message:

Mysql::Error in RecipeController#index

Access denied for user ‘gesnet’@‘82.163.144.137’ to database ‘cookbook’

---

<div class="post-metadata">

**Author:** ![fidogesiwuj](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/f/e9bcb4/32.png) [@fidogesiwuj](https://www.ruby-forum.com/u/fidogesiwuj)\
**Post date:** [April 18, 2006, 2:38pm UTC](https://www.ruby-forum.com/t/action-controller-exception-caught/58029/5 "2006-04-18T14:38:13Z")

</div>

Fido Gesiwuj wrote:

> Oh, now it has another message:
> 
> Mysql::Error in RecipeController#index
> 
> Access denied for user ‘gesnet’@‘82.163.144.137’ to database ‘cookbook’

Looks like now you need to set up permissions or lower your firewall on  
your db server.

---

<div class="post-metadata">

**Author:** ![fidogesiwuj](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/f/e9bcb4/32.png) [@fidogesiwuj](https://www.ruby-forum.com/u/fidogesiwuj)\
**Post date:** [April 18, 2006, 10:24pm UTC](https://www.ruby-forum.com/t/action-controller-exception-caught/58029/6 "2006-04-18T22:24:40Z")

</div>

> Looks like now you need to set up permissions or lower your firewall on  
> your db server.

I’ve set the database up to accept connections from my IP (although I  
guess that my router’s firewall will be something to do with this).

---

<div class="post-metadata">

**Author:** ![fidogesiwuj](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/f/e9bcb4/32.png) [@fidogesiwuj](https://www.ruby-forum.com/u/fidogesiwuj)\
**Post date:** [April 22, 2006, 1:08pm UTC](https://www.ruby-forum.com/t/action-controller-exception-caught/58029/7 "2006-04-22T13:08:27Z")

</div>

Bryan D. wrote:

> Get the native mysql drivers for your Windows machine at:  
> [http://www.vandomburg.net/pages/mysql-ruby-windows](http://www.vandomburg.net/pages/mysql-ruby-windows)
> 
> That fixed it for me on my XP boxes. If you’re using 2k, by any chance,  
> I still haven’t been able to fix that.

I’m the maintainer of that distribution and am currently investigating  
the segfaults on Windows 2000. If you’re interested in testing out a  
release that should fix that, drop me a note.

- Roderick van Domburg  
[http://www.vandomburg.net](http://www.vandomburg.net)

---

<div class="post-metadata">

**Author:** ![fidogesiwuj](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/f/e9bcb4/32.png) [@fidogesiwuj](https://www.ruby-forum.com/u/fidogesiwuj)\
**Post date:** [April 18, 2006, 11:32pm UTC](https://www.ruby-forum.com/t/action-controller-exception-caught/58029/8 "2006-04-18T23:32:25Z")

</div>

Fido Gesiwuj wrote:

> > Looks like now you need to set up permissions or lower your firewall on  
> > your db server.
> 
> I’ve set the database up to accept connections from my IP (although I  
> guess that my router’s firewall will be something to do with this).

You have to grant privileges to the user you want to access the server  
at that ip, or at least at ‘%’. If you don’t do that, mysql will tell  
you that you’re not authorized.