# Gem install mysql failure **URL:** \ **Category:** ruby-talk\ **Created:** [5 March 2007 22:47 UTC](https://rubytalk.org/t/gem-install-mysql-failure/35901 "2007-03-05T22:47:24Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Paul\_Hammer](https://avatars.discourse-cdn.com/v4/letter/p/f6c823/32.png) [@Paul\_Hammer](https://rubytalk.org/u/Paul_Hammer)\ **Post date:** [5 March 2007 22:47 UTC](https://rubytalk.org/t/gem-install-mysql-failure/35901/1 "2007-03-05T22:47:24Z")
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/\](http://www.ruby-forum.com/%5C). ---
**Author:** ![Chris\_Shea1](https://avatars.discourse-cdn.com/v4/letter/c/b487fb/32.png) [@Chris\_Shea1](https://rubytalk.org/u/Chris_Shea1)\ **Post date:** [5 March 2007 23:00 UTC](https://rubytalk.org/t/gem-install-mysql-failure/35901/2 "2007-03-05T23:00:06Z")
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 \ 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/. ---
**Author:** ![Paul\_Hammer](https://avatars.discourse-cdn.com/v4/letter/p/f6c823/32.png) [@Paul\_Hammer](https://rubytalk.org/u/Paul_Hammer)\ **Post date:** [6 March 2007 01:39 UTC](https://rubytalk.org/t/gem-install-mysql-failure/35901/3 "2007-03-06T01:39:28Z")
Chris Shea wrote: > **···** > > > On Mar 5, 3:47 pm, Paul Hammer \ 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/\](http://www.ruby-forum.com/%5C). ---
**Author:** ![Chris\_Shea1](https://avatars.discourse-cdn.com/v4/letter/c/b487fb/32.png) [@Chris\_Shea1](https://rubytalk.org/u/Chris_Shea1)\ **Post date:** [6 March 2007 02:00 UTC](https://rubytalk.org/t/gem-install-mysql-failure/35901/4 "2007-03-06T02:00:07Z")
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](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/\](http://cygwin.com/%5C)), but I'm guessing it's not. HTH, Chris > **···** > > On Mar 5, 6:39 pm, Paul Hammer \ wrote: > > > Chris Shea wrote: > > \> On Mar 5, 3:47 pm, Paul Hammer \ 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/. ---
**Author:** ![Paul\_Hammer](https://avatars.discourse-cdn.com/v4/letter/p/f6c823/32.png) [@Paul\_Hammer](https://rubytalk.org/u/Paul_Hammer)\ **Post date:** [6 March 2007 22:06 UTC](https://rubytalk.org/t/gem-install-mysql-failure/35901/5 "2007-03-06T22:06:50Z")
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](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/\](http://cygwin.com/%5C)), 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 \ wrote: > > -- > Posted via [http://www.ruby-forum.com/\](http://www.ruby-forum.com/%5C).