How to fix this - ERROR: Failed building wheel for mysqlclient

[Ram]

Hi, I’m running into this blocking issue while setting up Django with MySQL database. I’m pasting here what I tried so far on Ubuntu 18.04 OS.

$ sudo apt install nginx mysql-server python3-pip python3-dev libmysqlclient-dev 
$ sudo apt install mysql-client
$ sudo mysql_secure_installation
$ sudo mysql ( configured new db requirements )
$ sudo -H pip3 install --upgrade pip
$ sudo -H pip3 install virtualenv
$ pip install django gunicorn mysqlclient (virtualenv) 

This is where mysqlclient was not getting installed. Here is the error snippet.

(vkdev)user@ubuntu-hejjjj:~/testproject$ pip install mysqlclient
Collecting mysqlclient
  Using cached https://files.pythonhosted.org/packages/d0/97/7326248ac8d5049968bf4ec708a5d3d4806e412a42e74160d7f266a3e03a/mysqlclient-1.4.6.tar.gz
Building wheels for collected packages: mysqlclient
  Building wheel for mysqlclient (setup.py) ... error
  ERROR: Command errored out with exit status 1:
.......   
.......
  /usr/bin/ld: cannot find -lssl
  /usr/bin/ld: cannot find -lcrypto
  collect2: error: ld returned 1 exit status
  error: command 'x86_64-linux-gnu-gcc' failed with exit status 1
  ----------------------------------------
  ERROR: Failed building wheel for mysqlclient
  Running setup.py clean for mysqlclient
Failed to build mysqlclient
Installing collected packages: mysqlclient
    Running setup.py install for mysqlclient ... error
    ERROR: Command errored out with exit status 1:

Since mysqlclient install is failed here, I continued to try these steps but I don’t have luck so far.

$ pip install django gunicorn (virtualenv)
$ sudo apt install python3-dev libmysqlclient-dev
$ sudo apt-get install python3-pymysql
$ sudo apt-get install python3.6-dev
$ sudo apt-get install python3.7-dev libmysqlclient-dev gcc default-libmysqlclient-dev

I appreciate if someone has a clue with appropriate steps.

Thanks

~Ram

[Kasper Laudrup]

Hi Ram,

On 23/11/2019 23.48, Ram wrote:
> Hi, I’m running into this blocking issue while setting up Django with
> MySQL database. I’m pasting here what I tried so far on Ubuntu 18.04 OS.
>

> |/(vkdev)user@ubuntu-hejjjj:~/testproject$ pip install mysqlclient

> Collecting mysqlclient Using cached
> https://files.pythonhosted.org/packages/d0/97/7326248ac8d5049968bf4ec708a5d3d4806e412a42e74160d7f266a3e03a/mysqlclient-1.4.6.tar.gz
> Building wheels for collected packages: mysqlclient Building wheel
> for mysqlclient (setup.py) ... error ERROR: Command errored out with
> exit status 1: ....... ....... /usr/bin/ld: cannot find -lssl
> /usr/bin/ld: cannot find -lcrypto collect2: error: ld returned 1
> exit status error: command 'x86_64-linux-gnu-gcc' failed with exit
> status 1 ---------------------------------------- ERROR: Failed
> building wheel for mysqlclient Running setup.py clean for
> mysqlclient Failed to build mysqlclient Installing collected
> packages: mysqlclient Running setup.py install for mysqlclient ...

> error ERROR: Command errored out with exit status 1:/ |
>

You most likely need the package for openssl. Try installing the libssl
package, ie. something like:

# apt install libssl1.1

Hopefully that should do it.

Kind regards,

Kasper Laudrup

[Ram]

Hello Kasper,

I tried installing libssl1.1 globally and then tried mysqlclient install in virtualenv, but the result is the same and mysqlclient is still failed with same error.

Thanks

~Ram

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/f67170f6-e3b7-294d-9e56-2abf9752edda%40stacktrace.dk.

[Integr@te System]

Hi man,

Clear cache and try other method to requisite install.

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CA%2BOi5F0mmgO2jDRsDtXF6ZaVzku59QXFdrdRF%3DnwonnLb6CoMw%40mail.gmail.com.

[Ram]

Hello Integr,

I did not understand your suggestion? How do I clear cache in Python virtual environment? and what is other method you suggest based on the install error that I'm hitting.

Best regards,

~Ram

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAP5HUWon%2BVbxsTJwg1KrqrOqH6Hz%3D2DMSeTJpJZv%2BWwgeVYMiQ%40mail.gmail.com.