dyld troubles on macOS Mojave with mysql2 0.4.x

[thegcat]

When starting an existing rails 4 app on macOS Mojave with mysql2 0.4.6 (the results with mysql2 0.4.10 are the same):

dyld: lazy symbol binding failed: Symbol not found: _mysql_server_init
  Referenced from: /Users/thegcat/.rbenv/versions/2.3.7/lib/ruby/gems/2.3.0/gems/mysql2-0.4.6/lib/mysql2/mysql2.bundle
  Expected in: flat namespace

dyld: Symbol not found: _mysql_server_init
  Referenced from: /Users/thegcat/.rbenv/versions/2.3.7/lib/ruby/gems/2.3.0/gems/mysql2-0.4.6/lib/mysql2/mysql2.bundle
  Expected in: flat namespace

fish: 'rails s' terminated by signal SIGABRT (Abort)

I'm guessing the issue is related to some paths not being set correctly, but honestly I'm a bit at a loss here.

The mysql installation is a mysql 5.6 installed via homebrew, though the same errors also arise with mysql 5.7.

Different things I have tried, including building with --with-mysql-rpath=/usr/local/opt/mysql@5.6/lib, brew link --force-ing, exporting the mysql lib path in DYLD_LIBRARY_PATH amongst others did not yield a different result than above.

For the record: I had also tried mysql2 0.5.2, but as this won't even load into rails 4 I can't say wether it works better or not.

Any pointers on how to tackle this issue?

[sodabrew]

Could you try the latest point release of 0.4.x and see if that helps?

[thegcat]

I tried the different steps with 0.4.10 too and got the same error as written above. I have just tried it again to confirm, the error is the same.

[thegcat]

During the installation of the gem following message happens:

Don't know how to set rpath on your system, if MySQL libraries are not in path mysql2 may not load

Maybe this helps?

[thegcat]

I have in the meantime completely nuked my home-brew install as well as my rbenv install and installed both and everything in that anew on macOS 10.14, sadly to no avail neither with mysql2 0.4.6 nor 0.4.10.

[tesssie]

@thegcat I had this issue. Hope you have xcode command line installed. I had to to install some missing header files by
open /Library/Developer/CommandLineTools/Packages/macOS_SDK_headers_for_macOS_10.14.pkg

This linked helped me 52530212

[thegcat]

@tesssie thanks a lot for the suggestion, after recompiling the mysql2 gems this seems to work.

[tesssie]

@thegcat recompiling manually?

[thegcat]

Not really, just gem uninstall mysql2 and bundle install to install it back.

[tesssie]

oh :)

…

On Thu, Dec 6, 2018 at 11:23 AM Felix Schäfer ***@***.***> wrote: Not really, just gem uninstall mysql2 and bundle install to install it back. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#1001 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ArEV_6wtAw5AeMTv_XY-eBvSARCJyHacks5u2LDlgaJpZM4WTmGx> .

[D-Maher]

@tesssie, thanks for your solution! This worked like a charm for me.

[tesssie]

Happy to know that

…

On Thu 24 Jan, 2019, 5:02 AM Danny Maher, ***@***.***> wrote: @tesssie <https://github.com/tesssie>, thanks for your solution! This worked like a charm for me. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#1001 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ArEV_-29OHNOdGYvYEdGx9leKSVeRSRnks5vGPEXgaJpZM4WTmGx> .

[patriciojofre]

Thank you @tesssie , you save my life!!

[gilangmugnirespaty]

Thank you @tesssie