Damon -
I had a similar problem on FC4 and discovered it was with the gem
install of the mysql interface for Ruby. Don''t use it! It''s
out of
date. (v2.6) Get v2.7 and install from source. This worked for me:
curl -O http://www.tmtm.org/en/mysql/ruby/mysql-ruby-2.7.tar.gz
tar zxvf mysql-ruby-*
cd mysql-ruby-*
ruby extconf.rb --with-mysql-config=/usr/bin/mysql_config
make
sudo make install
Make sure your --with-mysql-config is correct.
Good luck!
On Oct 19, 2005, at 8:52 AM, Damon Hill wrote:
> Good day.
> I have searched for almost 2 days now through the list as well as
> the web trying to find resolutions to this issue.
> I have update the mysql_adapter as described here
> http://dev.rubyonrails.com/ticket/2163
>
> My environment is Apache 2.0.55, RedHat Enterprise Linux 4, Rails
> 0.14.0, Ruby 1.8.2, MySQL 4.1.12, and SCGI 0.4.2.
>
> The application works just fine when running under WebBrick, but
> when attempting to run under Apache, the very first attempted query
> on the db reports the :
>
> Lost connection to MySQL server during query: SELECT COUNT(*)
> FROM brokers
>
> The full trace is:
> /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/
> active_record/connection_adapters/abstract_adapter.rb:67:in `log''
> /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/
> active_record/connection_adapters/mysql_adapter.rb:164:in
`execute''
> /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/
> active_record/connection_adapters/mysql_adapter.rb:297:in `select''
> /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/
> active_record/connection_adapters/mysql_adapter.rb:147:in
`select_one''
> /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/
> active_record/connection_adapters/abstract/database_statements.rb:
> 16:in `select_value''
> /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/
> active_record/base.rb:515:in `count_by_sql''
> /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.12.0.2668/lib/
> active_record/base.rb:508:in `count''
> /var/www/adchicken/public/../config/../app/controllers/
> broker_controller.rb:11:in `list''
> /var/www/adchicken/public/../config/../app/controllers/
> broker_controller.rb:3:in `index''
> /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.10.0.2668/lib/
> action_controller/base.rb:831:in `send''
> /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.10.0.2668/lib/
> action_controller/base.rb:831:in `perform_action_without_filters''
> /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.10.0.2668/lib/
> action_controller/filters.rb:295:in
`perform_action_without_benchmark''
> /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.10.0.2668/lib/
> action_controller/benchmarking.rb:69:in
> `perform_action_without_rescue''
> /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.10.0.2668/lib/
> action_controller/benchmarking.rb:69:in `measure''
> /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.10.0.2668/lib/
> action_controller/benchmarking.rb:69:in
> `perform_action_without_rescue''
> /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.10.0.2668/lib/
> action_controller/rescue.rb:82:in `perform_action''
> /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.10.0.2668/lib/
> action_controller/base.rb:364:in `send''
> /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.10.0.2668/lib/
> action_controller/base.rb:364:in
> `process_without_session_management_support''
> /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.10.0.2668/lib/
> action_controller/session_management.rb:116:in `process''
> /usr/local/lib/ruby/gems/1.8/gems/rails-0.14.0.2668/lib/
> dispatcher.rb:36:in `dispatch''
> /var/www/adchicken/public/dispatch.cgi:10
> Since this is my first app developed with RoR, I was hoping it
> would be much easier.
> However, little inconsistencies like this are making the experience
> not so enjoyable.
> Any assistance or suggestions in this matter would be greatly
> appreciated.
>
> Thanks in advance for the help.
>
> M Damon Hill
> Project Manager
> IFWORLD, Inc.
> www.ifworld.com
> "..as we''re sung to sleep by philosophies that sing save the
trees
> and kill the children...." -- while you were sleeping (casting crowns)
>
> _______________________________________________
> Rails mailing list
> Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org
> http://lists.rubyonrails.org/mailman/listinfo/rails
>
_______________________________________________
Rails mailing list
Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org
http://lists.rubyonrails.org/mailman/listinfo/rails