I was having the same problem on Snow Leopard and, after some time I did the following:
Removed all mysql gems I had: gem uninstall mysql In my case I had to specify both mysql-dir and mysql-config (and -arch x86_64 to 64 bits) export ARCHFLAGS="-arch i386 -arch x86_64" ; gem install --no-rdoc -- no-ri mysql -- --with-mysql-dir=/usr/local --with-mysql-config=/usr/ local/mysql/bin/mysql_config Hope it works On Oct 12, 9:17 pm, Sam Esam <[email protected]> wrote: > Hi > > ************* URGENT PLEASEEEEEEEEEEEEEEEEEEEEEEEEEE *********** > I still see the problem after following the above steps. > Please please help me. > > ~Sam. > > =========================================================================== > === > ruby script/server > => Booting Mongrel > => Rails 2.3.4 application starting onhttp://0.0.0.0:3000 > => Call with -d to detach > => Ctrl-C to shutdown server > /!\ FAILSAFE /!\ Mon Oct 12 17:15:15 -0700 2009 > Status: 500 Internal Server Error > uninitialized constant MysqlCompat::MysqlRes > > /usr/local/lib/ruby/gems/1.8/gems/activesupport-2.3.4/lib/active_support/de p > endencies.rb:440:in `load_missing_constant' > > /usr/local/lib/ruby/gems/1.8/gems/activesupport-2.3.4/lib/active_support/de p > endencies.rb:80:in `const_missing' > > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/conn e > ction_adapters/mysql_adapter.rb:9:in `define_all_hashes_method!' > > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/conn e > ction_adapters/mysql_adapter.rb:66:in `mysql_connection' > > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/conn e > ction_adapters/abstract/connection_pool.rb:223:in `send' > > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/conn e > ction_adapters/abstract/connection_pool.rb:223:in `new_connection' > > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/conn e > ction_adapters/abstract/connection_pool.rb:245:in > `checkout_new_connection' > > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/conn e > ction_adapters/abstract/connection_pool.rb:188:in `checkout' > > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/conn e > ction_adapters/abstract/connection_pool.rb:184:in `loop' > > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/conn e > ction_adapters/abstract/connection_pool.rb:184:in `checkout' > /usr/local/lib/ruby/1.8/monitor.rb:242:in `synchronize' > > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/conn e > ction_adapters/abstract/connection_pool.rb:183:in `checkout' > > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/conn e > ction_adapters/abstract/connection_pool.rb:98:in `connection' > > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/conn e > ction_adapters/abstract/connection_pool.rb:326:in `retrieve_connection' > > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/conn e > ction_adapters/abstract/connection_specification.rb:123:in > `retrieve_connection' > > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/conn e > ction_adapters/abstract/connection_specification.rb:115:in `connection' > > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/quer y > _cache.rb:9:in `cache' > > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/quer y > _cache.rb:28:in `call' > > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/conn e > ction_adapters/abstract/connection_pool.rb:361:in `call' > > /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.3.4/lib/action_controller/fa i > lsafe.rb:26:in `call' > /usr/local/lib/ruby/gems/1.8/gems/rack-1.0.0/lib/rack/lock.rb:11:in > `call' > /usr/local/lib/ruby/gems/1.8/gems/rack-1.0.0/lib/rack/lock.rb:11:in > `synchro nize' > /usr/local/lib/ruby/gems/1.8/gems/rack-1.0.0/lib/rack/lock.rb:11:in > `call' > > /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.3.4/lib/action_controller/di s > patcher.rb:114:in `call' > > /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.3.4/lib/action_controller/re l > oader.rb:34:in `run' > > /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.3.4/lib/action_controller/di s > patcher.rb:108:in `call' > > /usr/local/lib/ruby/gems/1.8/gems/rails-2.3.4/lib/rails/rack/static.rb:31:i n > `call' > /usr/local/lib/ruby/gems/1.8/gems/rack-1.0.0/lib/rack/urlmap.rb:46:in > `call' > /usr/local/lib/ruby/gems/1.8/gems/rack-1.0.0/lib/rack/urlmap.rb:40:in > `each' > /usr/local/lib/ruby/gems/1.8/gems/rack-1.0.0/lib/rack/urlmap.rb:40:in > `call' > > /usr/local/lib/ruby/gems/1.8/gems/rails-2.3.4/lib/rails/rack/log_tailer.rb: 1 > 7:in `call' > > /usr/local/lib/ruby/gems/1.8/gems/rack-1.0.0/lib/rack/content_length.rb:13: i > n `call' > /usr/local/lib/ruby/gems/1.8/gems/rack-1.0.0/lib/rack/chunked.rb:15:in > `call ' > > /usr/local/lib/ruby/gems/1.8/gems/rack-1.0.0/lib/rack/handler/mongrel.rb:61 : > in `process' > /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.1.5/lib/mongrel.rb:159:in > `proce ss_client' > /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.1.5/lib/mongrel.rb:158:in > `each' > /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.1.5/lib/mongrel.rb:158:in > `proce ss_client' > /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.1.5/lib/mongrel.rb:285:in > `run' > /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.1.5/lib/mongrel.rb:285 > =========================================================================== > === > > > > > > Jean Bombeur wrote: > > Actually, doing more research and an strace on the process I found the > > problem. > > > Looking in the wrong place for the location of the library, I added my > > mysql lib directory to ld.so.conf/mysql.conf config file and it fixed > > it. > > > Jean Bombeur wrote: > >> Anybody still has the issue? > > >> I have been using jruby for a while but today I was trying to setup > >> using the last version of ruby 1.9 and rails 2.3.4 and I got hit with > >> that. > > >> Also running centos and tried the ARCHFLAGS trick with no success. > > >> Pishty Ags wrote: > >>> Evan Green wrote: > >>>> This didn't seem to fix the error for me. I still get 'uninitialized > >>>> constant MysqlCompat::MysqlRes' > > >>>> Kyle Fox wrote: > >>>>> To fix this, specify ARCHFLAGS when you install the 'mysql' gem: > > >>>>> sudo env ARCHFLAGS="-arch x86_64" gem install mysql -- --with-mysql- > >>>>> config=/usr/local/mysql/bin/mysql_config > > >>>>> On Aug 27, 12:07 pm, Caleb Cullen <[email protected]> > > >>>> cheers, > > >>> on my Centos Machine, i had to install mysql-devel.x86_64 first, then i > >>> ran the command: > > >>> env ARCHFLAGS="-arch x86_64" gem install mysql -- > >>> --with-mysql-config=/usr/lib64/mysql/mysql_config > > >>> which did the trick. > > >>> thanks Kyle > > -- > 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 [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---

