126: The specified module could not be found - ../mysql.so

Rails
1

Hi All,

I het following error:
126: The specified module could not be found. - C:/InstantRails/ruby/
lib/ruby/gems/1.8/gems/mysql-2.7.3-x86-mswin32/ext/mysql.so

mysql.so is present in the dir. I have rails 2.2

Someone seen this before?

Thanks.
Stijn

2

i thnk ur mysql is not working properly try to install it again

3

Installing results in:
gem install mysql
Successfully installed mysql-2.7.3-x86-mswin32
1 gem installed
Installing ri documentation for mysql-2.7.3-x86-mswin32…
Installing RDoc documentation for mysql-2.7.3-x86-mswin32…
ERROR: While generating documentation for mysql-2.7.3-x86-mswin32
… MESSAGE: Unhandled special: Special: type=17, text=""
… RDOC args: --op C:/InstantRails/ruby/lib/ruby/gems/1.8/doc/
mysql-2.7.3-x86-mswin32/rdoc --exclude ext --main README --quiet ext
README docs/README
.html
(continuing with the rest of the installation)

4

Matthew P. 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.

5

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.

6

putting the mysql bin in the path solved my problem.

Many thank
Stijn

On 28 nov, 20:30, Matthew P. [email protected]

7

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 = “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

  1. In the directory mysql-ruby-2.7.3 type:

gem build mysql.gemspec

  1. 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

8

Matthew,

I am also getting the same error and looks like the solution that you
gave worked. How can I add the path

Please help

Thanks,
Ahmed

On Nov 28 2008, 2:30 pm, Matthew P. <rails-mailing-l…@andreas-

9

Ruby N. wrote in post #766819:

Matthew,

I am also getting the same error and looks like the solution that you
gave worked. How can I add the path

Please help

Thanks,
Ahmed

On Nov 28 2008, 2:30 pm, Matthew P. <rails-mailing-l…@andreas-

MySQL bin path:
Look out for the folder where you installed MySQL.
For eg. If you installed MySQL in “C:\Program Files\MySQL 5.0″ then your
bin path will be “C:\Program Files\MySQL 5.0\bin”

How to set path variable?

  1. Go to Start -> Run
  2. Type the following

sysdm.cpl

  1. Click the Advanced Tab
  2. Click on the “Environment Variables” button
  3. Click on the New button under “User Variables” panel
  4. Enter the value of Variable Name as ‘Path’ (sans quotes)
  5. Enter the value of Variable Values as MySQLBin path (depends on your
    install location as explained above)
  6. Click OK