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 -~----------~----~----~----~------~----~------~--~---