Gem install mysql failure

I’ve been using Ruby with Watir for a few months now to scrape data
off of internal web pages where I work. I’m fairly happy with the
results,
although I want to improve these processes. I want to put this data
into
mysql, so I tried using this command to load mysql:

gem install mysql

The result I got is below. Can anyone help me here?

Paul

Select which gem to install for your platform (i386-mswin32)

  1. mysql 2.7.3 (mswin32)
  2. mysql 2.7.1 (mswin32)
  3. mysql 2.7 (ruby)
  4. mysql 2.6 (ruby)
  5. mysql 2.5.1 (ruby)
  6. Cancel installation

5
Building native extensions. This could take a while…
*** extconf.rb failed ***
Could not create Makefile due to some reason, probably lack of
necessary libraries and/or headers. Check the mkmf.log file for more
details. You may need configuration options.

Provided configuration options:
–with-opt-dir
–without-opt-dir
–with-opt-include
–without-opt-include=${opt-dir}/include
–with-opt-lib
–without-opt-lib=${opt-dir}/lib
–with-make-prog
–srcdir=.
–curdir
–ruby=c:/program files/ruby/bin/ruby
–with-mysql-config
–without-mysql-config
–with-mysql-dir
–without-mysql-dir
–with-mysql-include
–without-mysql-include=${mysql-dir}/include
–with-mysql-lib
–without-mysql-lib=${mysql-dir}/lib
–with-mysqlclientlib
–without-mysqlclientlib
–with-mlib
–without-mlib
–with-mysqlclientlib
–without-mysqlclientlib
–with-zlib
–without-zlib
–with-mysqlclientlib
–without-mysqlclientlib
–with-socketlib
–without-socketlib
–with-mysqlclientlib
–without-mysqlclientlib
–with-nsllib
–without-nsllib
–with-mysqlclientlib
–without-mysqlclientlib

ERROR: While executing gem … (RuntimeError)
ERROR: Failed to build gem native extension.
Gem files will remain installed in c:/Program
Files/ruby/lib/ruby/gems/1.8/gem
mysql-2.5.1 for inspection.

Results logged to c:/Program
Files/ruby/lib/ruby/gems/1.8/gems/mysql-2.5.1/gem
ake.out

On Mar 5, 3:47 pm, Paul H. [email protected] wrote:

Building native extensions. This could take a while…
–with-opt-lib
–without-mysql-include=${mysql-dir}/include
–with-mysqlclientlib
ERROR: While executing gem … (RuntimeError)
Posted viahttp://www.ruby-forum.com/.
Try one of the mswin32 options instead. I think the rule is if you
installed via the One-Click Installer, you have to.

Chris S. wrote:

On Mar 5, 3:47 pm, Paul H. [email protected] wrote:

Building native extensions. This could take a while…
–with-opt-lib
–without-mysql-include=${mysql-dir}/include
–with-mysqlclientlib
ERROR: While executing gem … (RuntimeError)
Posted viahttp://www.ruby-forum.com/.
Try one of the mswin32 options instead. I think the rule is if you
installed via the One-Click Installer, you have to.

I’m new to gem also. Is the mswin32 option a command line option to
gem?

What is the One-Click Installer? Where can I read about this?

Paul

On Mar 5, 6:39 pm, Paul H. [email protected] wrote:

installed via the One-Click Installer, you have to.

I’m new to gem also. Is the mswin32 option a command line option to
gem?

What is the One-Click Installer? Where can I read about this?

Paul


Posted viahttp://www.ruby-forum.com/.

Paul,

What I meant was: when you run ‘gem install mysql’ choose an install
option with (mswin32) at the end. So when faced with this:

Select which gem to install for your platform (i386-mswin32)

  1. mysql 2.7.3 (mswin32)
  2. mysql 2.7.1 (mswin32)
  3. mysql 2.7 (ruby)
  4. mysql 2.6 (ruby)
  5. mysql 2.5.1 (ruby)
  6. Cancel installation

Choose 1 or 2.

The Ruby O.-Click Installer is found here:
http://rubyinstaller.rubyforge.org/wiki/wiki.pl
It installs Ruby, and sets environment options, and installs a lot of
helpful tools (like rubygems and the Win32API bindings). I assumed
your installation of Ruby was handled by it, many Windows
installations are.

The other main possibility is that Ruby is installed on top of Cygwin
(http://cygwin.com/), but I’m guessing it’s not.

HTH,
Chris

Chris S. wrote:

On Mar 5, 6:39 pm, Paul H. [email protected] wrote:

installed via the One-Click Installer, you have to.

I’m new to gem also. Is the mswin32 option a command line option to
gem?

What is the One-Click Installer? Where can I read about this?

Paul


Posted viahttp://www.ruby-forum.com/.

Paul,

What I meant was: when you run ‘gem install mysql’ choose an install
option with (mswin32) at the end. So when faced with this:

Select which gem to install for your platform (i386-mswin32)

  1. mysql 2.7.3 (mswin32)
  2. mysql 2.7.1 (mswin32)
  3. mysql 2.7 (ruby)
  4. mysql 2.6 (ruby)
  5. mysql 2.5.1 (ruby)
  6. Cancel installation

Choose 1 or 2.

The Ruby O.-Click Installer is found here:
http://rubyinstaller.rubyforge.org/wiki/wiki.pl
It installs Ruby, and sets environment options, and installs a lot of
helpful tools (like rubygems and the Win32API bindings). I assumed
your installation of Ruby was handled by it, many Windows
installations are.

The other main possibility is that Ruby is installed on top of Cygwin
(http://cygwin.com/), but I’m guessing it’s not.

HTH,
Chris

Hi Chris,

Thanks for your help. This has gotten me further. I selected 1. mysql
2.7.3 (mswin32), and the install completed quickly without an error.

Next, I did a web search and found this example ruby script:

require “mysql”

begin
# connect to the MySQL server
dbh = Mysql.real_connect(“localhost”, “testuser”, “testpass”,
“test”)
# get server version string and display it
puts "Server version: " + dbh.get_server_info
rescue Mysql::Error => e
puts “Error code: #{e.errno}”
puts “Error message: #{e.error}”
puts “Error SQLSTATE: #{e.sqlstate}” if e.respond_to?(“sqlstate”)
ensure
# disconnect from server
dbh.close if dbh
end

Running this gave me the error:

Error code: 1045
Error message: Access denied for user ‘testuser’@‘localhost’ (using
password: YES)

I have tried searching for where mysql is been installed, and can’t find
it.

Installing mysql in the past I’ve been able to set the root password. I
didn’t get that chance here.

So, I now have questions:

This is progress because the login has been attempted, right?
What users & passwords come along with a gem install? How do I set
these?
I’d like to run mysql by hand also. Where has mysql been installed?

Paul

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs