Aman, Jeremy, thanks so much! I deleted that mysql.rb file, and migrations are running quite nicely from both the command line utility and from within irb as well now. I have *other* problems now, but at least this one is solved.
Cheers! -Steve On Jul 2, 1:59 pm, Aman Gupta <themastermi...@gmail.com> wrote: > On Thu, Jul 2, 2009 at 1:58 PM, Steve H<p.wi...@gmail.com> wrote: > > > 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? > > Removing the file should work, you can also see if there's a mysql > directory in there you need to delete. > > Also the migrator was moved to an extension, simply require > 'sequel/extensions/migration' > > Aman > > > > > > > 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 -~----------~----~----~----~------~----~------~--~---
