3. Resetting Database doesn't work at Section 3 with pipenv install MANY ERRORS

1

Hi,
I’m at resetting the database section 3.

When I move the storefront folder in Visual Studio Code and try to do pipenv install I got a lot of errors.

I tried many many ways and also learned about pipfile.lock. But nothing solved my problem.

I’m using a mac.

Can anyone please help? I want to continue the course.

Runy

(base) runycalmera@MacBook-Pro storefront % pipenv install
Installing dependencies from Pipfile.lock (f41128)…
An error occurred while installing asgiref==3.3.4; python_version >= ‘3.6’ --hash=sha256:92906c611ce6c967347bbfea733f13d6313901d54dcca88195eaeb52b2a8e8ee --hash=sha256:d1216dfbdfb63826470995d31caed36225dcaf34f182e0fa257a4dd9e86f1b78! Will try again.
An error occurred while installing django==3.2.4 --hash=sha256:66c9d8db8cc6fe938a28b7887c1596e42d522e27618562517cc8929eb7e7f296 --hash=sha256:ea735cbbbb3b2fba6d4da4784a0043d84c67c92f1fdf15ad6db69900e792c10f! Will try again.
An error occurred while installing django-debug-toolbar==3.2.1 --hash=sha256:e759e63e3fe2d3110e0e519639c166816368701eab4a47fed75d7de7018467b9 --hash=sha256:a5ff2a54f24bf88286f9872836081078f4baa843dc3735ee88524e89f8821e33! Will try again.
An error occurred while installing mysqlclient==2.0.3 --hash=sha256:71c4b330cf2313bbda0307fc858cc9055e64493ba9bf28454d25cf8b3ee8d7f5 --hash=sha256:0ac0dd759c4ca02c35a9fedc24bc982cf75171651e8187c2495ec957a87dfff7 --hash=sha256:3381ca1a4f37ff1155fcfde20836b46416d66531add8843f6aa6d968982731c3 --hash=sha256:fc575093cf81b6605bed84653e48b277318b880dc9becf42dd47fa11ffd3e2b6 --hash=sha256:f6ebea7c008f155baeefe16c56cd3ee6239f7a5a9ae42396c2f1860f08a7c432! Will try again.
An error occurred while installing pytz==2021.1 --hash=sha256:83a4a90894bf38e243cf052c8b58f381bfe9a7a483f6a9cab140bc7f702ac4da --hash=sha256:eb10ce3e7736052ed3623d49975ce333bcd712c7bb19a58b9e2089d4057d0798! Will try again.
An error occurred while installing sqlparse==0.4.1; python_version >= ‘3.5’ --hash=sha256:0f91fd2e829c44362cbcfab3e9ae12e22badaa8a29ad5ff599f9ec109f0454e8 --hash=sha256:017cde379adbd6a1f15a61873f43e8274179378e95ef3fede90b5aa64d304ed0! Will try again.
Installing initially failed dependencies…
[pipenv.exceptions.InstallError]: Collecting asgiref==3.3.4
[pipenv.exceptions.InstallError]: Using cached asgiref-3.3.4-py3-none-any.whl (22 kB)
[pipenv.exceptions.InstallError]: Collecting django==3.2.4
[pipenv.exceptions.InstallError]: Using cached Django-3.2.4-py3-none-any.whl (7.9 MB)
[pipenv.exceptions.InstallError]: Collecting django-debug-toolbar==3.2.1
[pipenv.exceptions.InstallError]: Using cached django_debug_toolbar-3.2.1-py3-none-any.whl (199 kB)
[pipenv.exceptions.InstallError]: Collecting mysqlclient==2.0.3
[pipenv.exceptions.InstallError]: Using cached mysqlclient-2.0.3.tar.gz (88 kB)
[pipenv.exceptions.InstallError]: Preparing metadata (setup.py): started
[pipenv.exceptions.InstallError]: Preparing metadata (setup.py): finished with status ‘error’
[pipenv.exceptions.InstallError]: error: subprocess-exited-with-error
[pipenv.exceptions.InstallError]:
[pipenv.exceptions.InstallError]: × python setup.py egg_info did not run successfully.
[pipenv.exceptions.InstallError]: │ exit code: 1
[pipenv.exceptions.InstallError]: ╰─> [16 lines of output]
[pipenv.exceptions.InstallError]: /bin/sh: mysql_config: command not found
[pipenv.exceptions.InstallError]: /bin/sh: mariadb_config: command not found
[pipenv.exceptions.InstallError]: /bin/sh: mysql_config: command not found
[pipenv.exceptions.InstallError]: Traceback (most recent call last):
[pipenv.exceptions.InstallError]: File “”, line 2, in
[pipenv.exceptions.InstallError]: File “”, line 34, in
[pipenv.exceptions.InstallError]: File “/private/var/folders/0r/skqlxkl92r7glf86t35gvz_w0000gn/T/pip-install-1kgxs02e/mysqlclient_5b6a473af61d47c1a7e9f5509c84e88e/setup.py”, line 15, in
[pipenv.exceptions.InstallError]: metadata, options = get_config()
[pipenv.exceptions.InstallError]: File “/private/var/folders/0r/skqlxkl92r7glf86t35gvz_w0000gn/T/pip-install-1kgxs02e/mysqlclient_5b6a473af61d47c1a7e9f5509c84e88e/setup_posix.py”, line 70, in get_config
[pipenv.exceptions.InstallError]: libs = mysql_config(“libs”)
[pipenv.exceptions.InstallError]: File “/private/var/folders/0r/skqlxkl92r7glf86t35gvz_w0000gn/T/pip-install-1kgxs02e/mysqlclient_5b6a473af61d47c1a7e9f5509c84e88e/setup_posix.py”, line 31, in mysql_config
[pipenv.exceptions.InstallError]: raise OSError(“{} not found”.format(_mysql_config_path))
[pipenv.exceptions.InstallError]: OSError: mysql_config not found
[pipenv.exceptions.InstallError]: mysql_config --version
[pipenv.exceptions.InstallError]: mariadb_config --version
[pipenv.exceptions.InstallError]: mysql_config --libs
[pipenv.exceptions.InstallError]: [end of output]
[pipenv.exceptions.InstallError]:
[pipenv.exceptions.InstallError]: note: This error originates from a subprocess, and is likely not a problem with pip.
[pipenv.exceptions.InstallError]: error: metadata-generation-failed
[pipenv.exceptions.InstallError]:
[pipenv.exceptions.InstallError]: × Encountered error while generating package metadata.
[pipenv.exceptions.InstallError]: ╰─> See above for output.
[pipenv.exceptions.InstallError]:
[pipenv.exceptions.InstallError]: note: This is an issue with the package mentioned above, not pip.
[pipenv.exceptions.InstallError]: hint: See above for details.
ERROR: Couldn’t install package: [Requirement(_name=‘asgiref’, vcs=None, req=NamedRequirement(name=‘asgiref’, version=‘==3.3.4’, req=Requirement.parse(‘asgiref==3.3.4; python_version >= “3.6”’), extras=, editable=False, _parsed_line=<Line (editable=False, name=asgiref, path=None, uri=None, extras=(), markers=python_version >= ‘3.6’, vcs=None, specifier===3.3.4, pyproject=None, pyproject_requires=None, pyproject_backend=None, ireq=asgiref==3.3.4)>), markers=‘python_version >= “3.6”’, _specifiers=‘==3.3.4’, index=None, editable=False, hashes=frozenset({‘sha256:92906c611ce6c967347bbfea733f13d6313901d54dcca88195eaeb52b2a8e8ee’, ‘sha256:d1216dfbdfb63826470995d31caed36225dcaf34f182e0fa257a4dd9e86f1b78’}), extras=(), abstract_dep=None, _line_instance=<Line (editable=False, name=asgiref, path=None, uri=None, extras=(), markers=python_version >= ‘3.6’, vcs=None, specifier===3.3.4, pyproject=None, pyproject_requires=None, pyproject_backend=None, ireq=asgiref==3.3.4)>, _ireq=None), Requirement(_name=‘django’, vcs=None, req=NamedRequirement(name=‘django’, version=‘==3.2.4’, req=Requirement.parse(‘django==3.2.4’), extras=, editable=False, _parsed_line=<Line (editable=False, name=django, path=None, uri=None, extras=(), markers=None, vcs=None, specifier===3.2.4, pyproject=None, pyproject_requires=None, pyproject_backend=None, ireq=django==3.2.4)>), markers=None, _specifiers=‘==3.2.4’, index=‘pypi’, editable=False, hashes=frozenset({‘sha256:66c9d8db8cc6fe938a28b7887c1596e42d522e27618562517cc8929eb7e7f296’, ‘sha256:ea735cbbbb3b2fba6d4da4784a0043d84c67c92f1fdf15ad6db69900e792c10f’}), extras=(), abstract_dep=None, _line_instance=<Line (editable=False, name=django, path=None, uri=None, extras=(), markers=None, vcs=None, specifier===3.2.4, pyproject=None, pyproject_requires=None, pyproject_backend=None, ireq=django==3.2.4)>, _ireq=None), Requirement(_name=‘django-debug-toolbar’, vcs=None, req=NamedRequirement(name=‘django-debug-toolbar’, version=‘==3.2.1’, req=Requirement.parse(‘django-debug-toolbar==3.2.1’), extras=, editable=False, _parsed_line=<Line (editable=False, name=django-debug-toolbar, path=None, uri=None, extras=(), markers=None, vcs=None, specifier===3.2.1, pyproject=None, pyproject_requires=None, pyproject_backend=None, ireq=django-debug-toolbar==3.2.1)>), markers=None, _specifiers=‘==3.2.1’, index=‘pypi’, editable=False, hashes=frozenset({‘sha256:e759e63e3fe2d3110e0e519639c166816368701eab4a47fed75d7de7018467b9’, ‘sha256:a5ff2a54f24bf88286f9872836081078f4baa843dc3735ee88524e89f8821e33’}), extras=(), abstract_dep=None, _line_instance=<Line (editable=False, name=django-debug-toolbar, path=None, uri=None, extras=(), markers=None, vcs=None, specifier===3.2.1, pyproject=None, pyproject_requires=None, pyproject_backend=None, ireq=django-debug-toolbar==3.2.1)>, _ireq=None), Requirement(_name=‘mysqlclient’, vcs=None, req=NamedRequirement(name=‘mysqlclient’, version=‘==2.0.3’, req=Requirement.parse(‘mysqlclient==2.0.3’), extras=, editable=False, _parsed_line=<Line (editable=False, name=mysqlclient, path=None, uri=None, extras=(), markers=None, vcs=None, specifier===2.0.3, pyproject=None, pyproject_requires=None, pyproject_backend=None, ireq=mysqlclient==2.0.3)>), markers=None, _specifiers=‘==2.0.3’, index=‘pypi’, editable=False, hashes=frozenset({‘sha256:71c4b330cf2313bbda0307fc858cc9055e64493ba9bf28454d25cf8b3ee8d7f5’, ‘sha256:0ac0dd759c4ca02c35a9fedc24bc982cf75171651e8187c2495ec957a87dfff7’, ‘sha256:3381ca1a4f37ff1155fcfde20836b46416d66531add8843f6aa6d968982731c3’, ‘sha256:fc575093cf81b6605bed84653e48b277318b880dc9becf42dd47fa11ffd3e2b6’, ‘sha256:f6ebea7c008f155baeefe16c56cd3ee6239f7a5a9ae42396c2f1860f08a7c432’}), extras=(), abstract_dep=None, _line_instance=<Line (editable=False, name=mysqlclient, path=None, uri=None, extras=(), markers=None, vcs=None, specifier===2.0.3, pyproject=None, pyproject_requires=None, pyproject_backend=None, ireq=mysqlclient==2.0.3)>, _ireq=None), Requirement(_name=‘pytz’, vcs=None, req=NamedRequirement(name=‘pytz’, version=‘==2021.1’, req=Requirement.parse(‘pytz==2021.1’), extras=, editable=False, _parsed_line=<Line (editable=False, name=pytz, path=None, uri=None, extras=(), markers=None, vcs=None, specifier===2021.1, pyproject=None, pyproject_requires=None, pyproject_backend=None, ireq=pytz==2021.1)>), markers=None, _specifiers=‘==2021.1’, index=None, editable=False, hashes=frozenset({‘sha256:83a4a90894bf38e243cf052c8b58f381bfe9a7a483f6a9cab140bc7f702ac4da’, ‘sha256:eb10ce3e7736052ed3623d49975ce333bcd712c7bb19a58b9e2089d4057d0798’}), extras=(), abstract_dep=None, _line_instance=<Line (editable=False, name=pytz, path=None, uri=None, extras=(), markers=None, vcs=None, specifier===2021.1, pyproject=None, pyproject_requires=None, pyproject_backend=None, ireq=pytz==2021.1)>, _ireq=None), Requirement(_name=‘sqlparse’, vcs=None, req=NamedRequirement(name=‘sqlparse’, version=‘==0.4.1’, req=Requirement.parse(‘sqlparse==0.4.1; python_version >= “3.5”’), extras=, editable=False, _parsed_line=<Line (editable=False, name=sqlparse, path=None, uri=None, extras=(), markers=python_version >= ‘3.5’, vcs=None, specifier===0.4.1, pyproject=None, pyproject_requires=None, pyproject_backend=None, ireq=sqlparse==0.4.1)>), markers=‘python_version >= “3.5”’, _specifiers=‘==0.4.1’, index=None, editable=False, hashes=frozenset({‘sha256:0f91fd2e829c44362cbcfab3e9ae12e22badaa8a29ad5ff599f9ec109f0454e8’, ‘sha256:017cde379adbd6a1f15a61873f43e8274179378e95ef3fede90b5aa64d304ed0’}), extras=(), abstract_dep=None, _line_instance=<Line (editable=False, name=sqlparse, path=None, uri=None, extras=(), markers=python_version >= ‘3.5’, vcs=None, specifier===0.4.1, pyproject=None, pyproject_requires=None, pyproject_backend=None, ireq=sqlparse==0.4.1)>, _ireq=None)]
Package installation failed…

2

Hi Calmera.

This stackoverflow thread will hopefully help you.

3

I am having the same problem and the stackoverflow did not help either

4

Ok I had this problem too as I said above and last night after couple hours got it working. Here is what I had to do. I am using a mac os fyi.

First I checked my setup.py. The Database configuration, I did not have the correct username and password for my database. I fixed it but the problem still was there.

I had to reinstall pipenv.
brew update
brew install pipx
pipx ensurepath
pipx install pipenv

if brew did not work so I tried this.
brew update-reset

Then I went and removed the pipenv of my project.
/Users/parissa/.local/share/virtualenvs

It gave errors it could not find django
pip install django --upgrade

Then it gave errors that it could not find dango toolbar so
pip install django-debug-toolbar

then it gave errors it could not find mysql so reinstalled that
pip install mysqlclient

Order may be off but whatever error I got I reinstalled it then it started to work again. Probably there was a better way? Sure but this is what I had to do :slight_smile:

5

Did anybody find an answer to this problem?

6

This is because the folder storefront was not updated properly, particularly the pipfile and its line stating the python version.

The solution is to change the python version to “*3.9”, meaning version 3.9 and up are valid, or just “*” meaning all versions are good to go.

image
image900×718 59.8 KB