gem install mysql failure

[Paul Hammer]

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

 

[Chris Shea]

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

Try one of the mswin32 options instead. I think the rule is if you
installed via the One-Click Installer, you have to.

 

[Paul Hammer]

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

 

[Chris Shea]

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

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

 

[Paul Hammer]

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