Gem native extension build fails after upgrade to MacOS 10.4 Mojave #1005

chriskozlowski · 2018-09-26T13:56:55Z

Hi,

Having trouble installing the mysql2 gem after upgrade to MacOS Mojave. Other gems with native extensions do work (i.e. nokogiri). Any help would be greatly appreciated. Thank you!

Environment:

[email protected] freshly installed via Homebrew
mysql2 versions attempted: 0.4.9, 0.4.10, 0.5.2 (same outcome for all)
XCode 10 - I ensured that latest command line tools were installed

Output from build step

ERROR:  Error installing mysql2:
	ERROR: Failed to build gem native extension.

    current directory: /Users/chriskozlowski/.rbenv/versions/2.3.7/lib/ruby/gems/2.3.0/gems/mysql2-0.5.2/ext/mysql2
/Users/chriskozlowski/.rbenv/versions/2.3.7/bin/ruby -r ./siteconf20180926-18671-1g3sg4b.rb extconf.rb
checking for rb_absint_size()... yes
checking for rb_absint_singlebit_p()... yes
checking for rb_wait_for_single_fd()... yes
-----
Using mysql_config at /usr/local/bin/mysql_config
-----
checking for mysql.h... yes
checking for errmsg.h... yes
checking for SSL_MODE_DISABLED in mysql.h... yes
checking for SSL_MODE_PREFERRED in mysql.h... yes
checking for SSL_MODE_REQUIRED in mysql.h... yes
checking for SSL_MODE_VERIFY_CA in mysql.h... yes
checking for SSL_MODE_VERIFY_IDENTITY in mysql.h... yes
checking for MYSQL.net.vio in mysql.h... yes
checking for MYSQL.net.pvio in mysql.h... no
checking for MYSQL_ENABLE_CLEARTEXT_PLUGIN in mysql.h... yes
checking for SERVER_QUERY_NO_GOOD_INDEX_USED in mysql.h... yes
checking for SERVER_QUERY_NO_INDEX_USED in mysql.h... yes
checking for SERVER_QUERY_WAS_SLOW in mysql.h... yes
checking for MYSQL_OPTION_MULTI_STATEMENTS_ON in mysql.h... yes
checking for MYSQL_OPTION_MULTI_STATEMENTS_OFF in mysql.h... yes
checking for my_bool in mysql.h... yes
-----
Don't know how to set rpath on your system, if MySQL libraries are not in path mysql2 may not load
-----
-----
Setting libpath to /usr/local/Cellar/[email protected]/5.7.23/lib
-----
creating Makefile

To see why this extension failed to compile, please check the mkmf.log which can be found here:

  /Users/chriskozlowski/.rbenv/versions/2.3.7/lib/ruby/gems/2.3.0/extensions/x86_64-darwin-18/2.3.0-static/mysql2-0.5.2/mkmf.log

current directory: /Users/chriskozlowski/.rbenv/versions/2.3.7/lib/ruby/gems/2.3.0/gems/mysql2-0.5.2/ext/mysql2
make "DESTDIR=" clean

current directory: /Users/chriskozlowski/.rbenv/versions/2.3.7/lib/ruby/gems/2.3.0/gems/mysql2-0.5.2/ext/mysql2
make "DESTDIR="
compiling client.c
compiling infile.c
compiling mysql2_ext.c
compiling result.c
compiling statement.c
linking shared-object mysql2/mysql2.bundle
ld: library not found for -lssl
clang: error: linker command failed with exit code 1 (use -v to see invocation)
make: *** [mysql2.bundle] Error 1

make failed, exit code 2

Gem files will remain installed in /Users/chriskozlowski/.rbenv/versions/2.3.7/lib/ruby/gems/2.3.0/gems/mysql2-0.5.2 for inspection.
Results logged to /Users/chriskozlowski/.rbenv/versions/2.3.7/lib/ruby/gems/2.3.0/extensions/x86_64-darwin-18/2.3.0-static/mysql2-0.5.2/gem_make.out

gem_make.out

gem_make.out.txt

The text was updated successfully, but these errors were encountered:

jeremy · 2018-09-26T14:47:51Z

ld: library not found for -lssl

Which openssl are you building against? Do you have it installed with Homebrew (brew install openssl)?

chriskozlowski · 2018-09-26T16:37:27Z

I believe the default Mac OS lib. I actually did install openssl via Homebrew to see if that would work but I do not know how to ensure that the build uses that version. I tried brew link openssl --force but that was a guess. Can you tell me how?

andrewhao · 2018-09-26T16:40:43Z

This worked for me: https://stackoverflow.com/a/39628463

$ bundle config --local build.mysql2 "--with-ldflags=-L/usr/local/opt/openssl/lib --with-cppflags=-I/usr/local/opt/openssl/include"

chriskozlowski · 2018-09-26T16:47:10Z

That worked! Thank you @andrewhao!

feliperaul · 2018-10-25T05:46:18Z

@andrewhao Thank you!

jeremy · 2018-10-25T21:56:54Z

To fix for a manual gem install:

brew install openssl
gem install mysql2 -- --with-opt-dir="$(brew --prefix openssl)"

To fix for all bundle installs:

brew install openssl
bundle config --global build.mysql2 --with-opt-dir="$(brew --prefix openssl)"
bundle install

jhas3c · 2018-11-16T06:19:14Z

I am still getting this error no solution worked. Please help.

Note: This issue is coming just after update to 10.4

jhas3c · 2018-11-16T06:50:58Z

Fixed it after updating mysql gem verion to 0.4.9 to 0.4.10.

… build error Refs. - https://qiita.com/tktcorporation/items/0ef8c930fc18ce72c301 - brianmario/mysql2#1005 (comment)

dukedorje · 2019-05-01T21:17:24Z

sudo installer -pkg /Library/Developer/CommandLineTools/Packages/macOS_SDK_headers_for_macOS_10.14.pkg -target /

from
https://gorails.com/setup/osx/10.14-mojave

catmando · 2019-06-26T16:16:07Z

This solution (mentioned above) worked for me:

brew install openssl
bundle config --global build.mysql2 --with-opt-dir="$(brew --prefix openssl)"
bundle install

HOWEVER I want to give a tip: This solution says to use --global which I think is correct, however other solutions mention doing bundle config --local ... but with different options.

You need to be aware that --local settings take precedence over --global, so if you using the --local option with some other settings, then later try to set global it will be ignored, and you will think it didnt' work.

joshuapinter · 2019-07-27T03:40:17Z

bundle config --local build.mysql2 "--with-ldflags=-L/usr/local/opt/openssl/lib --with-cppflags=-I/usr/local/opt/openssl/include"

This worked great. Except, it might actually be better to remove the --local flag here so that it doesn't update the project's .bundle/config file. This way, it's only set on your machine in ~/.bundle/config, since it's likely different from machine to machine.

As per Bundler docs.

paulohsilvavieira · 2019-08-12T21:20:34Z

brew install openssl
bundle config --global build.mysql2 --with-opt-dir="$(brew --prefix openssl)"
bundle install

this solution work for me!

jamesst20 · 2019-11-12T20:56:37Z

On MacOS Catalina, only this made it work : https://medium.com/@konole/tough-love-between-mysql2-ruby-gem-and-macos-mojave-2cb6d389ab16

For 0.3.20

brew tap frnhr/homebrew-mariadb-connector-c-2
brew install frnhr/mariadb-connector-c-2/mariadb-connector-c
env ARCHFLAGS="-arch x86_64" gem install mysql2 -v '0.3.20' -- --with-mysql-config=/usr/local/Cellar/mariadb-connector-c/2.2.2/bin/mariadb_config  --with-ldflags=-L/usr/local/opt/openssl/lib --with-cppflags=-I/usr/local/opt/openssl/include

For 0.4.10

brew tap frnhr/homebrew-mariadb-connector-c-2
brew install frnhr/mariadb-connector-c-2/mariadb-connector-c
env ARCHFLAGS="-arch x86_64" gem install mysql2 -v '0.4.10' -- --with-mysql-config=/usr/local/Cellar/mariadb-connector-c/2.2.2/bin/mariadb_config  --with-ldflags=-L/usr/local/opt/openssl/lib --with-cppflags=-I/usr/local/opt/openssl/include

davismattg · 2020-01-06T20:46:41Z

Posting for Googlers. To fix this issue I had to run

brew install openssl followed by rbenv install 2.5.3 (which was already installed) for the Ruby install to pick up the correct openssl version.

TheCorp · 2020-01-06T22:46:28Z

Saved me just now Matt :)

ccartano · 2020-01-13T17:28:26Z

I ran into this issue today; I fixed it by installing mysql first with homebrew, then installing the gem.
Currently running Mac Catalina 10.15.2

brew install mysql
gem install mysql2

NickWarm · 2020-02-07T09:53:48Z

I also confront with openssl issue.

ld: library not found for -lssl

I referenced this post,

brew install mysql2 and mysql gems with optional

-- --with-ldflags=-L/usr/local/opt/openssl/lib --with-cppflags=-I/usr/local/opt/openssl/include

This way is work for me.

brianmario/mysql2#1005 (comment)

tylerdavisgit · 2020-12-31T16:41:30Z

This worked for me: https://stackoverflow.com/a/39628463

$ bundle config --local build.mysql2 "--with-ldflags=-L/usr/local/opt/openssl/lib --with-cppflags=-I/usr/local/opt/openssl/include"

I tried this, but still receive an error (now caused by the flags):

From my mkmf.log file:

"clang -o conftest -I/Users/tylerdavis/.rbenv/versions/2.6.6/include/ruby-2.6.0/x86_64-darwin19 -I/Users/tylerdavis/.rbenv/versions/2.6.6/include/ruby-2.6.0/ruby/backward -I/Users/tylerdavis/.rbenv/versions/2.6.6/include/ruby-2.6.0 -I. -I/Users/tylerdavis/.rbenv/versions/2.6.6/include -D_XOPEN_SOURCE -D_DARWIN_C_SOURCE -D_DARWIN_UNLIMITED_SELECT -D_REENTRANT -O3 -ggdb3 -Wall -Wextra -Wdeclaration-after-statement -Wdeprecated-declarations -Wdivision-by-zero -Wimplicit-function-declaration -Wimplicit-int -Wmisleading-indentation -Wpointer-arith -Wshorten-64-to-32 -Wwrite-strings -Wmissing-noreturn -Wno-constant-logical-operand -Wno-long-long -Wno-missing-field-initializers -Wno-overlength-strings -Wno-parentheses-equality -Wno-self-assign -Wno-tautological-compare -Wno-unused-parameter -Wno-unused-value -Wunused-variable -Wextra-tokens -fno-common -pipe conftest.c -L. -L/Users/tylerdavis/.rbenv/versions/2.6.6/lib -L/usr/local/opt/openssl/lib --with-cppflags=-I/usr/local/opt/openssl/include -lruby.2.6 " clang: error: unsupported option '--with-cppflags=-I/usr/local/opt/openssl/include' checked program was: /* begin */ 1: #include "ruby.h" 2: 3: int main(int argc, char **argv) 4: { 5: return 0; 6: } /* end */

Karan-Jhaveri · 2021-02-11T03:39:31Z

Is there any other alternative?
I tried gem install mysql2 -- --with-opt-dir="$(brew --prefix openssl)" and it successfully installed mysql2-0.5.2
but while bundle install, getting the same error again.

ngyl88 · 2021-09-04T09:42:35Z

Hi @Karan-Jhaveri , I hope my reply is not too late. I think above comment will work for your case.

To whom concern, I think the cause of this issue is that openssl on mac is pointing to LibreSSL instead of OpenSSL stackoverflow discussion. This is the step I've done for verification.

    # To check which openssl you are using
    openssl version
    # Install tool that is used in common stack
    brew install openssl
    # Optional: Add the path to your terminal, if you want to overwrite your default openssl library.
    echo 'export PATH="/usr/local/opt/[email protected]/bin:$PATH"' >> ~/.zshrc
    # Verify openssl installation is successful
    ls /usr/local/opt/[email protected]/
    # Use this to install local gems
    bundle config --local build.mysql2 --with-cflags="-I/usr/local/opt/[email protected]/include" --with-ldflags="-L/usr/local/opt/[email protected]/lib" && bundle install

@chriskozlowski This issue seems to be MacOS default library and not an issue to this library. If this clarifies, maybe we could close the issue? (Sorry, my mistake, I think there's something could be done on the code side, I have link to relevant Pull Requests in my PR.)

puyo · 2022-03-08T03:47:33Z

If you happen to be using asdf on a Mac (which uses ruby-build), there is a PR that fixes these issues for mysql2 and all other gems that rely on openssl:

rbenv/ruby-build#1440

It'd be great if we got that one merged. Then I could stop patching ruby-build for all my developers using asdf.

tonyvince · 2024-05-23T08:53:44Z

I had to use

-- --with-cflags="-Wno-incompatible-function-pointer-types" --with-ldflags=-L/opt/homebrew/opt/openssl@3/lib --with-cppflags=-I/opt/homebrew/opt/openssl@3/include

options to install 0.5.3 version
Mac OS Sonoma 14.4 (23E214)
openssl@1 and openssl@3 installed via homebrew

drn mentioned this issue May 2, 2019

Manage ~/.bundle/config in dots drn/dots#32

Closed

klementtan mentioned this issue Sep 19, 2019

Error Install mysql2 0.4.5 gem #1071

Closed

peterkos mentioned this issue Jun 12, 2020

Potential install issue w/ mysql2 on bundle install codeRIT/hackathon-manager#254

Open

hsbt mentioned this issue Jul 21, 2020

Fix gem installations that rely on OpenSSL when build_package_mac_openssl() is used rbenv/ruby-build#1440

Closed

antw added a commit to antw/dotfiles that referenced this issue Aug 3, 2020

Bundler: Add OpenSSL config for mysql2 gem

6dc7c34

brianmario/mysql2#1005 (comment)

This was referenced Sep 4, 2021

update README for MacOS installation with linker failure #1209

Closed

Dynamically set Homebrew-installed OpenSSL flag #1204

Merged

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Gem native extension build fails after upgrade to MacOS 10.4 Mojave #1005

Gem native extension build fails after upgrade to MacOS 10.4 Mojave #1005

chriskozlowski commented Sep 26, 2018

jeremy commented Sep 26, 2018

chriskozlowski commented Sep 26, 2018

andrewhao commented Sep 26, 2018

chriskozlowski commented Sep 26, 2018

feliperaul commented Oct 25, 2018

jeremy commented Oct 25, 2018

jhas3c commented Nov 16, 2018 •

edited

Loading

jhas3c commented Nov 16, 2018

dukedorje commented May 1, 2019

catmando commented Jun 26, 2019 •

edited

Loading

joshuapinter commented Jul 27, 2019

paulohsilvavieira commented Aug 12, 2019 •

edited

Loading

jamesst20 commented Nov 12, 2019 •

edited

Loading

davismattg commented Jan 6, 2020

TheCorp commented Jan 6, 2020

ccartano commented Jan 13, 2020 •

edited

Loading

NickWarm commented Feb 7, 2020

tylerdavisgit commented Dec 31, 2020

Karan-Jhaveri commented Feb 11, 2021

ngyl88 commented Sep 4, 2021 •

edited

Loading

puyo commented Mar 8, 2022

tonyvince commented May 23, 2024 •

edited

Loading

Gem native extension build fails after upgrade to MacOS 10.4 Mojave #1005

Gem native extension build fails after upgrade to MacOS 10.4 Mojave #1005

Comments

chriskozlowski commented Sep 26, 2018

Environment:

Output from build step

gem_make.out

jeremy commented Sep 26, 2018

chriskozlowski commented Sep 26, 2018

andrewhao commented Sep 26, 2018

chriskozlowski commented Sep 26, 2018

feliperaul commented Oct 25, 2018

jeremy commented Oct 25, 2018

jhas3c commented Nov 16, 2018 • edited Loading

jhas3c commented Nov 16, 2018

dukedorje commented May 1, 2019

catmando commented Jun 26, 2019 • edited Loading

joshuapinter commented Jul 27, 2019

paulohsilvavieira commented Aug 12, 2019 • edited Loading

jamesst20 commented Nov 12, 2019 • edited Loading

davismattg commented Jan 6, 2020

TheCorp commented Jan 6, 2020

ccartano commented Jan 13, 2020 • edited Loading

NickWarm commented Feb 7, 2020

tylerdavisgit commented Dec 31, 2020

Karan-Jhaveri commented Feb 11, 2021

ngyl88 commented Sep 4, 2021 • edited Loading

puyo commented Mar 8, 2022

tonyvince commented May 23, 2024 • edited Loading

jhas3c commented Nov 16, 2018 •

edited

Loading

catmando commented Jun 26, 2019 •

edited

Loading

paulohsilvavieira commented Aug 12, 2019 •

edited

Loading

jamesst20 commented Nov 12, 2019 •

edited

Loading

ccartano commented Jan 13, 2020 •

edited

Loading

ngyl88 commented Sep 4, 2021 •

edited

Loading

tonyvince commented May 23, 2024 •

edited

Loading