Gem install mysql failure

ruby-talk
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

···

--
Posted via http://www.ruby-forum.com/\.

2

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

···

On Mar 5, 3:47 pm, Paul Hammer <paul_ham...@hotmail.com> wrote:

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

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

3

Chris Shea wrote:

···

On Mar 5, 3:47 pm, Paul Hammer <paul_ham...@hotmail.com> 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

--
Posted via http://www.ruby-forum.com/\.

4

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

···

On Mar 5, 6:39 pm, Paul Hammer <paul_ham...@hotmail.com> wrote:

Chris Shea wrote:
> On Mar 5, 3:47 pm, Paul Hammer <paul_ham...@hotmail.com> 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

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

5

Chris Shea 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 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

···

On Mar 5, 6:39 pm, Paul Hammer <paul_ham...@hotmail.com> wrote:

--
Posted via http://www.ruby-forum.com/\.