Re: mysql errors in production after upgrading to rails 2

I fixed it by installing the gem using this command:
gem install mysql -- --with-mysql-conf=/usr/bin/mysql --with-mysql-
lib=/usr/lib/mysql

Thanks!

On May 16, 11:25 am, Frederick Cheung <frederick.che...@...>
wrote:
> On 16 May 2008, at 07:27, phil wrote:
>
>
>
> > And the same query that I get this on:
> > ActiveRecord::StatementInvalid (Mysql::Error: Lost connection to MySQL
> > server during query:
>
> > I can run from the console.
>
> > So it definitely seem to be how mongrel is connecting to mysql. I am
> > not using the mysql gem (I wasn't before under 1.2.6 either) I am
> > connecting with the builtin mysql adaptor.
>
> The pure ruby mysql stuff is completely obsolete. Give the gem ago.
>
> Fred
>
> > On May 16, 12:31 am, Matthew Rudy Jacobs <rails-mailing-l...@andreas-
> > s.net> wrote:
> >> phil wrote:
> >>> I'm trying to upgrade our production server to rails 2. I've already
> >>> done this on my dev machine (osx) and it worked fine. But now, with
> >>> everything at the same version, but running in production mode, the
> >>> production machine - a CentOS5 box - is getting loads of:
> >>> ActiveRecord::StatementInvalid (Mysql::Error: Lost connection to
> >>> MySQL
> >>> server during query
> >>> errors.
>
> >>> i"ve looked around but not found any valid reason why this should be
> >>> happening. the mysql is version 5.0.22. Ruby 1.8.6 rails 2.0.2.
>
> >>> Without solving this I guess we are going back to Rails 1.2.6, but
> >>> the
> >>> real problem is that it is causing my boss and team to question the
> >>> entire stability of Rails!
>
> >>> I've just set the server to run in development mode and it works a
> >>> treat!!! What is up with that?
>
> >> what else have you tried?
>
> >> you tried running in production mode locally?
> >> you tried "ruby script/console production" on the box?
> >> is this mongrel and apache?
> >> or what?
>
> >> is it every query?
> >> or just some special long queries?
> >> --
> >> Posted viahttp://www.ruby-forum.com/.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@...
To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe@...
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---