Action Controller: Exception caught

fidogesiwuj · April 17, 2006, 9:39pm

Hi, I’m running the cookbook example from 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

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.

fidogesiwuj · April 17, 2006, 10:57pm

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

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.

fidogesiwuj · April 18, 2006, 1:02pm

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

fidogesiwuj · April 18, 2006, 1:18pm

Oh, now it has another message:

Mysql::Error in RecipeController#index

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

fidogesiwuj · April 18, 2006, 2:38pm

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.

fidogesiwuj · April 18, 2006, 10:24pm

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).

fidogesiwuj · April 22, 2006, 1:08pm

Bryan D. wrote:

Get the native mysql drivers for your Windows machine at:
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

fidogesiwuj · April 18, 2006, 11:32pm

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.