Hello, I have a problem with installing pipy package ‘openpyxl’.
I tried installing it from settings, I tried downgrading my python version( I have 3.11.0 now ).
I tried via terminal with command pip install openpyxl and the same error occurs every single time.
The error is : WARNING: Retrying (Retry(total=4, connect=None, read=None, redirect=None, status=None)) after connection broken by ‘ProtocolError(‘Connection aborted.’, FileNotFoundError(2, ‘No such file or directory’))’: /simple/db-sync/
WARNING: Retrying (Retry(total=3, connect=None, read=None, redirect=None, status=None)) after connection broken by ‘ProtocolError(‘Connection aborted.’, FileNotFoundError(2, ‘No such file or directory’))’: /simple/db-sync/
WARNING: Retrying (Retry(total=2, connect=None, read=None, redirect=None, status=None)) after connection broken by ‘ProtocolError(‘Connection aborted.’, FileNotFoundError(2, ‘No such file or directory’))’: /simple/db-sync/
WARNING: Retrying (Retry(total=1, connect=None, read=None, redirect=None, status=None)) after connection broken by ‘ProtocolError(‘Connection aborted.’, FileNotFoundError(2, ‘No such file or directory’))’: /simple/db-sync/
WARNING: Retrying (Retry(total=0, connect=None, read=None, redirect=None, status=None)) after connection broken by ‘ProtocolError(‘Connection aborted.’, FileNotFoundError(2, ‘No such file or directory’))’: /simple/db-sync/
ERROR: Could not find a version that satisfies the requirement db-sync (from versions: none)
ERROR: No matching distribution found for db-sync
Please help me, thanks.
Pretty weird looking error. Are you perchance behind a corporate proxy or firewall?
The answers to this stackoverflow question about a similar-looking error suggest that having set the environment variable SSLKEYLOGFILE can cause this. Does this variable exist in your environment?
Possibly unrelated, but it looks like pip is trying to install a package called db-sync. It looks abandoned, and openpyxl does not depend on it. Do you know why that package would be installed?
Hello, thank you for your time.
I don’t have that variable anywhere, I tried by turning off my firewall and no proxy, nor with proxy, same error. Can I download the package manually ?
Yes, you can download the wheel from openpyxl · PyPI and install it with pip install openpyxl-3.1.5-py2.py3-none-any.whl. You will also need to download and install et-xmlfile, which openpyxl depends on, in the same way.