Databases
StackOverflow2013
Postsdbo
POInstalling mysql-2.9.0 gem on Windows fails due to lack of libmysql
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POInstalling mysql-2.9.0 gem on Windows fails due to lack of libmysql
    primarykey
    data
    text
    <p>I'm trying to install Redmine 2.1.4 on Windows Server 2003. For it to work, I need to install <code>activerecord-mysql-adapter</code> gem, which in turn seems to rely on <code>mysql-2.9.0.gem</code>. I've downloaded the latter from <a href="http://rubygems.org/gems/mysql" rel="nofollow noreferrer">rubygems</a> and executed:</p> <pre><code>gem install mysql-2.9.0.gem </code></pre> <p>which gives the following output:</p> <pre><code>C:\&gt;gem install mysql-2.9.0.gem Temporarily enhancing PATH to include DevKit... Building native extensions. This could take a while... ERROR: Error installing mysql-2.9.0.gem: ERROR: Failed to build gem native extension. C:/Ruby193/bin/ruby.exe extconf.rb checking for main() in -llibmysql... no *** 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 --without-make-prog --srcdir=. --curdir --ruby=C:/Ruby193/bin/ruby --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-libmysqllib --without-libmysqllib Gem files will remain installed in C:/Ruby193/lib/ruby/gems/1.9.1/gems/mysql-2.9.0 for inspection. Results logged to C:/Ruby193/lib/ruby/gems/1.9.1/gems/mysql-2.9.0/ext/mysql_api/gem_make.out </code></pre> <p>I'm guessing, one possibility is I'm lacking MySQL C Connector library. I've downloaded both <code>mysql-connector-c-6.0.2-win32.msi</code> and <code>mysql-connector-c-6.0.2-win32-vs2005.msi</code> from <a href="http://dev.mysql.com/downloads/connector/c/" rel="nofollow noreferrer">http://dev.mysql.com/downloads/connector/c/</a>, but both installers exited with: <img src="https://i.stack.imgur.com/Azas3.png" alt="enter image description here"></p> <p>I also tried copying <code>C:\Program Files\MySQL\MySQL Server 5.1\lib\debug\libmysql.dll</code> to <code>C:\Ruby193\bin</code>, but it also didn't solve the mysql-2.9.0.gem installation issue.</p> <p>What else can I try?</p> <p><strong>EDIT</strong></p> <p>From the logs I figured, Ruby was looking for libs under, surprise, surprise, $RUBY_HOME\lib, not $RUBY_HOME\bin, as found in some sources mentioned in the question. So moving the libmysql from $MySQL_HOME\lib to $RUBY_HOME\lib helped a little, but now Ruby cannot find some other libs and headers. So I'm guessing, I need to use the an option like: </p> <pre><code>C:\&gt;gem install mysql-2.9.0.gem --platform=ruby --with-opt-lib="C:/Program Files/MySQL/MySQL Server 5.1/lib" --with-opt-include="C:/Program Files/MySQL/MySQL Server 5.1/include" </code></pre> <p>which won't work either (probably because of spaces in path). </p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USmmm
    1. USmmm
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    3. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POInstalling mysql-2.9.0 gem on Windows fails due to lack of libmysql
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POInstalling mysql-2.9.0 gem on Windows fails due to lack of libmysql
      1. This table or related slice is empty.
      1. VTUpMod
    1. COWhat does mkmf.log say? In my exp, you either gem install mysql, or mysql2.
      singulars
      1. POInstalling mysql-2.9.0 gem on Windows fails due to lack of libmysql
      1. USpguardiario
    2. COI wasn't aware of those logs - thanks for that - edited my question.
      singulars
      1. POInstalling mysql-2.9.0 gem on Windows fails due to lack of libmysql
      1. USmmm
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload