Gem install mysql failure

Ruby
1

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

2

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.

3

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

4

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

5

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