WARNING: Running pip install with root privileges is generally not a good idea. Try `pip3 install --user` instead.Collecting openpyxl Certificate did not match expected hostname: files.pythonhosted.org. Certificate

WARNING: Running pip install with root privileges is generally not a good idea. Try `pip3 install --user` instead.Collecting openpyxl  Certificate did not match expected hostname: files.pythonhosted.org. Certificate: {'subject': ((('countryName', 'US'),), (('stateOrProvinceName', 'California'),), (('localityName', 'San Francisco'),), (('organizationName', 'Fastly, Inc.'),), (('commonName', 'default.ssl.fastly.net'),)), 'issuer': ((('countryName', 'BE'),), (('organizationName', 'GlobalSign nv-sa'),), (('commonName', 'GlobalSign RSA OV SSL CA 2018'),)), 'version': 3, 'serialNumber': '35BD36211EF5162AD8296685', 'notBefore': 'Dec 17 17:21:08 2021 GMT', 'notAfter': 'Jan 18 17:21:08 2023 GMT', 'subjectAltName': (('DNS', 'default.ssl.fastly.net'), ('DNS', 'fastly.com'), ('DNS', '*.a.ssl.fastly.net'), ('DNS', '*.hosts.fastly.net'), ('DNS', '*.global.ssl.fastly.net'), ('DNS', '*.fastly.com'), ('DNS', 'a.ssl.fastly.net'), ('DNS', 'purge.fastly.net'), ('DNS', 'mirrors.fastly.net'),

# pip3 install openpyxl 하는데 위와 같이 에러가 발생 하면서 설치가 안된다.

신뢰할 수 있는 루트 인증 기관에 등록이 안되서 그렇다.

# pip3 install --trusted-host pypi.org --trusted-host files.pythonhosted.org pip setuptools

등록 해주고 설치 하면 정상적으로 설치 된다.

# pip3 install openpyxl
WARNING: Running pip install with root privileges is generally not a good idea. Try `pip3 install --user` instead.
Collecting openpyxl
  Downloading https://files.pythonhosted.org/packages/7b/60/9afac4fd6feee0ac09339de4101ee452ea643d26e9ce44c7708a0023f503/openpyxl-3.0.10-py2.py3-none-any.whl (242kB)
    100% |████████████████████████████████| 245kB 2.0MB/s
Collecting et-xmlfile (from openpyxl)
  Downloading https://files.pythonhosted.org/packages/96/c2/3dd434b0108730014f1b96fd286040dc3bcb70066346f7e01ec2ac95865f/et_xmlfile-1.1.0-py3-none-any.whl
Installing collected packages: et-xmlfile, openpyxl
Successfully installed et-xmlfile-1.1.0 openpyxl-3.0.10

 

만약에 이렇게도 안된다면

# pip3 install --trusted-host pypi.python.org --trusted-host files.pythonhosted.org --trusted-host pypi.org openpyxl(패키지이름)

해서 설치 하면 된다.