Asp Forum - gem install mysql failure

Paul Hammer

3/5/2007 10:47:00 PM

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

4 Answers

Chris Shea

3/5/2007 10:56:00 PM

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

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

3/6/2007 1:39:00 AM

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

Chris Shea

3/6/2007 1:57:00 AM

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

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/wi...
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://c...), but I'm guessing it's not.

HTH,
Chris

Paul Hammer

3/6/2007 10:07:00 PM

Chris Shea wrote:
> On Mar 5, 6:39 pm, Paul Hammer <paul_ham...@hotmail.com> 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-....
>
> 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/wi...
> 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://c...), 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

--
Posted via http://www.ruby-....

comp.lang.ruby

gem install mysql failure

Paul Hammer

Chris Shea

Paul Hammer

Chris Shea

Paul Hammer

x Login to ForumsZone