Ahh! Aman to my rescue. Glad you're on this list as well as the EM one :)
Yes, I installed the pure ruby mysql driver back when I had accidentally downloaded and installed MySQL x86_64, and my connection was super slow so I didn't replace it with x86 right away. I installed the pure ruby mysql gem manually (like an idiot). How can I now uninstall it? If I simply remove that mysql.rb file, will that work? Thanks for the help guys... -Steve On Jul 2, 1:35 pm, Aman Gupta <themastermi...@gmail.com> wrote: > On Thu, Jul 2, 2009 at 12:08 PM, Steve H<p.wi...@gmail.com> wrote: > > > Jeremey, thanks so much for replying to my question! > > >> Does it also work with em-mysql (if not, it could be > >> that sequel is trying to load that)? > > > em-mysql isn't really a standalone mysql driver. It requires > > mysqlplus itself to work. > > >> Can you try using the RUBYLIB > >> environment variable and make sure that one of the working mysql > >> libraries first? > > > I tried this. It didn't work, but maybe I was doing something wrong? > > > $ gem which mysql > > (checking gem mysql-2.7 for mysql) > > /System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/ > > 1.8/mysql.rb > > I'm not sure how you ended up with a mysql.rb in your lib/ruby/1.8, > but that's the pure ruby driver. You should be using the mysql or > mysqlplus gem instead, which has a C extension driver. > > Aman > > > > > $ export RUBYLIB=/System/Library/Frameworks/Ruby.framework/Versions/ > > 1.8/usr/lib/ruby/1.8/mysql.rb > > $ echo $RUBYLIB > > /System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/ > > 1.8/mysql.rb > > $ sequel mysql://localhost/castle_gameserver?user=root > > Error: Sequel::DatabaseConnectionError: NameError uninitialized > > constant Mysql::CLIENT_MULTI_RESULTS/Library/Ruby/Gems/1.8/gems/ > > sequel-3.1.0/lib/sequel/adapters/mysql.rb:97:in `connect' > > >> Also, try this from irb (without requiring any mysql stuff > >> explicitly): > > >> require 'sequel' rescue nil > >> p $: > > >> That should give an indication of what mysql library sequel is > >> loading. > > > $ irb > >>> require 'sequel' rescue nil > > => true > >>> p $: > > ["/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/ > > 1.8/mysql.rb", "/Library/Ruby/Gems/1.8/gems/sequel-3.1.0/bin", "/ > > Library/Ruby/Gems/1.8/gems/sequel-3.1.0/lib", "/Library/Ruby/Site/ > > 1.8", "/Library/Ruby/Site/1.8/powerpc-darwin9.0", "/Library/Ruby/Site/ > > 1.8/universal-darwin9.0", "/Library/Ruby/Site", "/System/Library/ > > Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8", "/System/ > > Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/ > > powerpc-darwin9.0", "/System/Library/Frameworks/Ruby.framework/ > > Versions/1.8/usr/lib/ruby/1.8/universal-darwin9.0", "."] > > => nil > > > :( > > > Any other ideas? All I want to do is be able to run migrations. Is > > there some way to do that from within irb? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to sequel-talk@googlegroups.com To unsubscribe from this group, send email to sequel-talk+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en -~----------~----~----~----~------~----~------~--~---