Here's what I've found that works, unfortunately I don't know how to push it back up to where ever gem install is pulling mysql from.
1) Go to http://tmtm.org/downloads/mysql/ruby/ and download mysql- ruby-2.7.3.tar.gz (or whatever version you'ld like - but the gemspec that follows will need some doctoring) 2) Unpack the download: "gzcat mysql-ruby-2.7.3.tar.gz | tar xvf -" will give you a new directory mysql-ruby-2.7.3 3) In the directory mysql-ruby-2.7.3, add the following as "mysql.gemspec" (without the equal... lines:-) ================== require 'rubygems' require 'rake' spec = Gem::Specification.new do |s| s.name = "mysql" s.version = "2.7.3" s.email = "[EMAIL PROTECTED]" s.homepage = "http://www.tmtm.org/en/mysql/ruby"; s.platform = Gem::Platform:RUBY s.summary = "MySQL/Ruby provides the same functions for Ruby programs that the MySQL C API provides for C programs." s.files = FileList['[A-Za-z]*'].to_a s.autorequire = "lib/mysql.bundle" s.extensions = ["./extconf.rb"] end if $0 == __FILE__ Gem::manage_gems Gem::Builder.new(spec).build end ================== 4) In the directory mysql-ruby-2.7.3 type: gem build mysql.gemspec 5) In the directory mysql-ruby-2.7.3 type gem install mysql --version=2.7.3 NOTE: I have used this to install a functional mysql (2.7.3) in the following environment Mac OS X 10.5.5 Ruby 1.8.7 (2008-08-11 patchlevel 72) [powerpc-darwin9] Rails 2.2.2 gem 1.3.1 mysql Ver 14.12 Distrib 5.0.51a, for apple-darwin8.6.0 (powerpc) using readline 5.0 I realize that the sequence above is wedded to the wwu (wonderful world of unix) but that's how it is. I should do nicely under any varient of linux that includes bash (you may need to change the sh to bash in several places) and the gnu c development tools. If you're working on a MS variant you might want to seriously consider getting the uwin environment from ATT (it's free and functional) and adding the gnu tools. You will need to have mysql installed prior to steps 4 and 5. If you see any noise about missing mysql includes or libraries either you haven't installed them or the aren't in a location that can be found. The file "mysql_config" is key here and (on my system) lives in the same directory as the executible "mysql". If you can run mysql from the commandline you should be able to accomplish steps 4 and 5. After the install completes, all the files from the original tar.gz as well as your gemspec and all files built will be in the gem directory. Nothing is removed. One of these files is named test.rb After you have created a test database in mysql go to the mysql gem directory and type: ruby ./test.rb -- [hostname [user [passwd [dbname [port [socket [flag]]]]]]] On my system, I type: ruby ./test.rb -- localhost rickl t00tu44 test222mysql_development and what I get in response is: Loaded suite ./test Started ................................................................................................................. Finished in 4.354216 seconds. 113 tests, 379 assertions, 0 failures, 0 errors So there you go... Rick On Nov 28, 10:07 am, Tarscher <[EMAIL PROTECTED]> wrote: > putting the mysql bin in the path solved my problem. > > Many thank > Stijn > > On 28 nov, 20:30, Matthew Phillips <[EMAIL PROTECTED]> > wrote: > > > Matthew Phillips wrote: > > > there's something seriously screwed up with the new mysql gem, > > > especially for Vista users. You are not alone in having these problems > > > and I personally have not yet found a solution. > > > But just to point you in the right direction, make sure your mysql bin > > directory is in your path. Type PATH in the command prompt to see if it > > is. If not, add it. From there try again. > > -- > > 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 -~----------~----~----~----~------~----~------~--~---
