Error installing mysql-python: library not found for -lssl

Question

I'm having trouble installing mysql-python. Created a new virtualenv and when installing mysql-python... here's the error message:

(env)$ pip install mysql-python
Collecting mysql-python
...

clang -bundle -undefined dynamic_lookup -isysroot /Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.12.sdk build/temp.macosx-10.12-x86_64-2.7/_mysql.o -L/usr /local/Cellar/mysql/5.7.16/lib -lmysqlclient -lssl -lcrypto -o build/lib.macosx-10.12-x86_64-2.7/_mysql.so
ld: library not found for -lssl
clang: error: linker command failed with exit code 1 (use -v to see invocation)
error: command 'clang' failed with exit status 1

Using homebrew, I have installed:

libressl
openssl
[email protected]
mysql

Already tried to brew link but brew refuses to do so.

The OS is MacOS Sierra.

Can anyone help? Thanks!

Seba Kim · Accepted Answer · 2017-10-23 11:57:26Z

43

You can set ssl library path explicitly.

LDFLAGS=-L/usr/local/opt/openssl/lib pip install mysqlclient

answered Oct 23, 2017 at 11:57

Seba Kim

5311 gold badge4 silver badges4 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Rockallite Over a year ago

The library installed. However, it fails to run with segmentation fault 11

ShinChven Over a year ago

Solved my problem.

Chris Over a year ago

Solved my problem as well.

cakraww Over a year ago

For more general (if installing openssl through brew): LDFLAGS="-L$(brew --prefix openssl)/lib" pip install mysqlclient

alstr · Accepted Answer · 2020-04-22 08:45:11Z

25

I tried updating Xcode's CLT, uninstalling mysql, checking mysql_config, etc., but had no luck.

I found that running brew info openssl shows:

...

For compilers to find openssl you may need to set:
  export LDFLAGS="-L/usr/local/opt/openssl/lib"
  export CPPFLAGS="-I/usr/local/opt/openssl/include"

...

Running those two commands, followed by pip install, worked for me (in my case when installing mysqlclient).

edited Apr 22, 2020 at 8:45

answered Dec 6, 2018 at 14:39

alstr

1,6042 gold badges22 silver badges43 bronze badges

3 Comments

FFinn Over a year ago

Thanks, that helped but one should run "brew info openssl" and not "brew info ssl" and then I run all "export" commands which helped me successfully run "pip3 install mysqlclient"

alstr Over a year ago

@FFinn Correct, thanks for pointing that out, I've updated the answer.

Asif Mohammed Over a year ago

saved a day. @alstr

user31415629 · Accepted Answer · 2017-12-07 16:06:24Z

13

Solved it with these steps:

brew uninstall mysql
brew install mysql-connector-c
pip install mysql-python
brew unlink mysql-connector-c
brew install mysql

Found the answer here https://stackoverflow.com/a/25920020/576192

Not sure if this is the right way, but this is how I managed to solve it.

edited Dec 7, 2017 at 16:06

user31415629

1,00510 silver badges25 bronze badges

answered Nov 14, 2016 at 16:04

danielcorreia

2,1462 gold badges24 silver badges36 bronze badges

Comments

Nate · Accepted Answer · 2019-03-01 16:44:52Z

11

I'm able to fix the error by running:

pip install -r requirements.txt --global-option=build_ext --global-option="-I/usr/local/opt/openssl/include" --global-option="-L/usr/local/opt/openssl/lib"

answered Mar 1, 2019 at 16:44

Nate

3513 silver badges7 bronze badges

1 Comment

Andrew Troiano Over a year ago

This worked for me . Brew states - openssl is keg-only, which means it was not symlinked into /usr/local, because macOS provides LibreSSL.

Jonny · Accepted Answer · 2017-03-14 11:44:30Z

8

I was finally able to fix it by

xcode-select --install

I was sure I had already done that... but obviously I hadn't. Definitely worth a shot!

answered Mar 14, 2017 at 11:44

Jonny

16.4k19 gold badges117 silver badges248 bronze badges

Comments

Hafiz Siddiq · Accepted Answer · 2019-11-27 16:31:26Z

3

For me on mac, running this command solved the issue

LDFLAGS=-L/usr/local/opt/openssl/lib pip install mysqlclient

Actually we need to set ssl library path to get this issue fixed.

answered Nov 27, 2019 at 16:31

Hafiz Siddiq

6993 gold badges11 silver badges26 bronze badges

2 Comments

Chris Over a year ago

Strangely enough this worked for me. I have no idea why but it worked.

Yuri Heupa Over a year ago

Hi @hafiz-siddiq, there's another answer like yours stackoverflow.com/a/46888783/2247042, this doesn't add value.

magicrebirth · Accepted Answer · 2017-06-07 14:16:29Z

2

Worked for me by doing this

$ brew uninstall mysql
$ brew install mysql-connector-c
$ brew unlink mysql-connector-c
$ brew install mysql
$ pip install mysql-python

Which is a slightly altered version of the recipe above (note: pip install at the end!)

answered Jun 7, 2017 at 14:16

magicrebirth

4,2642 gold badges28 silver badges22 bronze badges

1 Comment

JayRizzo Over a year ago

This also fixes the error I received ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command output. This fixes the issue for this substitution for the last line pip3 install mysqlclient

William · Accepted Answer · 2017-07-17 06:37:29Z

2

If you want to install mysql-python, I suggest you to install mysqlclient instead. The authors of these two modules are the same. By far, the authors all turn to keep maintaining mysqlclient. mysqlclient supports both Python 2 and Python 3. And you can use the same codes like mysql-python. Blew is my installation solution for you.

$ brew info openssl
$ brew unlink mysql-connector-c
$ brew install mysql
$ brew link --overwrite mysql-connector-c
$ pip install mysqlclient

If there is an error before pip install mysqlclient. Please fix it according to methane's answer. And run pip install mysqlclient again.

edited Jul 17, 2017 at 6:37

answered Jul 17, 2017 at 6:31

William

4,4282 gold badges26 silver badges21 bronze badges

Comments

Franke · Accepted Answer · 2017-01-21 00:28:24Z

1

Or download and install .dmg from the MySQL dev site: https://dev.mysql.com/downloads/file/?id=467834

answered Jan 21, 2017 at 0:28

Franke

1,28212 silver badges14 bronze badges

1 Comment

JayRizzo Over a year ago

This works too but, it also messes with me that there are 3 ways you can install mysql on your mac. brew pip and also the dmg file. and if you have more than just one, it becomes a nightmare with odd errors or breaking the DMG install by using pip or brew.

Edgar Ortega · Accepted Answer · 2019-01-04 19:02:19Z

For those of you who are installing MySQL v5.7 with Brew

Uninstall mysql-connector-c

$ brew uninstall mysql-connector-c

Install specific version, very likely you need to uninstall other installed versions

$ brew install [email protected]

You will need to add it to the PATH, since this is 'keg-only' formulae, this is printed after it is installed

$ echo 'export PATH="/usr/local/opt/[email protected]/bin:$PATH"' >> ~/.zshrc

Replace ~/.zshrc with the appropriate file.

Install mysql-connector-c

$ brew install mysql-connector-c

Check it is installed properly

$ which mysql
# /usr/local/opt/[email protected]/bin/mysql

$ mysql_config
# Usage: /usr/local/opt/[email protected]/bin/mysql_config [OPTIONS]
Compiler: Clang 10.0.0.10001145
Options:
        --cflags         [-I/usr/local/opt/[email protected]/include/mysql ]
        --cxxflags       [-I/usr/local/opt/[email protected]/include/mysql ]
        --include        [-I/usr/local/opt/[email protected]/include/mysql]
        --libs           [-L/usr/local/opt/[email protected]/lib -lmysqlclient -lssl -lcrypto]
        --libs_r         [-L/usr/local/opt/[email protected]/lib -lmysqlclient -lssl -lcrypto]
        --plugindir      [/usr/local/opt/[email protected]/lib/plugin]
        --socket         [/tmp/mysql.sock]
        --port           [0]
        --version        [5.7.24]
        --libmysqld-libs [-L/usr/local/opt/[email protected]/lib -lmysqld -lssl -lcrypto]
        --variable=VAR   VAR is one of:
                pkgincludedir [/usr/local/opt/[email protected]/include/mysql]
                pkglibdir     [/usr/local/opt/[email protected]/lib]
                plugindir     [/usr/local/opt/[email protected]/lib/plugin]

Now install mysqlclient

$ pip install mysqlclient

Arunas Bart · Accepted Answer · 2023-07-28 21:46:09Z

For those on MacOS (me on Ventura) using pip requirements.txt file, universal solution is:

LDFLAGS="-L$(brew --prefix openssl)/lib" pip install -r requirements.txt

where requirements.txt file contains mysqlclient, e.g:

asgiref==3.7.2
click==8.1.6
Django==4.2.3
mysqlclient==2.2.0
Pillow==10.0.0
sqlparse==0.4.4
svgwrite==1.4.3

To make life easier, you can use pip-compile requirements.in command, which uses in file of flexible content like this:

Django>=4.2,<5.0
mysqlclient>=2.2,<3.0

and run

pip-compile

which compiles requirements.txt from requirements.in, pyproject.toml, setup.cfg, or setup.py specs.

And finally do the LDFLAGS="-L$(brew --prefix openssl)/lib" pip install -r requirements.txt command.

One more note, later, if you need to upgrade packages, just run:

pip-compile -U

Good luck!

Collectives™ on Stack Overflow

Error installing mysql-python: library not found for -lssl

11 Answers 11

4 Comments

3 Comments

Comments

1 Comment

Comments

2 Comments

1 Comment

Comments

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

11 Answers 11

4 Comments

3 Comments

Comments

1 Comment

Comments

2 Comments

1 Comment

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related