Python "cannot import 'ssl' from 'urllib3.util.ssl_'"错误

Question

我正在尝试设置一个Python脚本来运行Windows任务计划程序的批处理文件，但在运行该文件时遇到错误。

该代码在我的Jupyter Notebook和PyCharm中都可以使用，但在尝试运行批处理文件时失败。

在脚本中导入的模块：

from pyathena import connect
import pandas as pd
import numpy as np
import win32com.client as win32
import datetime
from IPython.display import HTML

错误信息：

C:UsersjrainesDesktop>"C:UsersjrainesAppDataLocalContinuumanaconda3python.exe" "C:UsersjrainesDownloadsPartners Email New.py"
Traceback (most recent call last):
  File "C:UsersjrainesDownloadsPartners Email New.py", line 27, in <module>
    region_name='us-east-1')
  File "C:UsersjrainesAppDataLocalContinuumanaconda3libsite-packagespyathena__init__.py", line 54, in connect
    from pyathena.connection import Connection
  File "C:UsersjrainesAppDataLocalContinuumanaconda3libsite-packagespyathenaconnection.py", line 9, in <module>
    from boto3.session import Session
  File "C:UsersjrainesAppDataLocalContinuumanaconda3libsite-packagesboto3__init__.py", line 16, in <module>
    from boto3.session import Session
  File "C:UsersjrainesAppDataLocalContinuumanaconda3libsite-packagesboto3session.py", line 17, in <module>
    import botocore.session
  File "C:UsersjrainesAppDataLocalContinuumanaconda3libsite-packagesbotocoresession.py", line 30, in <module>
    import botocore.credentials
  File "C:UsersjrainesAppDataLocalContinuumanaconda3libsite-packagesbotocorecredentials.py", line 42, in <module>
    from botocore.utils import InstanceMetadataFetcher, parse_key_val_file
  File "C:UsersjrainesAppDataLocalContinuumanaconda3libsite-packagesbotocoreutils.py", line 31, in <module>
    import botocore.httpsession
  File "C:UsersjrainesAppDataLocalContinuumanaconda3libsite-packagesbotocorehttpsession.py", line 7, in <module>
    from urllib3.util.ssl_ import (
ImportError: cannot import name 'ssl' from 'urllib3.util.ssl_' (C:UsersjrainesAppDataLocalContinuumanaconda3libsite-packagesurllib3utilssl_.py)

当我在Jupyter Notebook和PyCharm中运行脚本时，我没有看到此错误消息，但是当我在命令行上运行它时，我收到上述错误。 我也安装了"C：\Users\jraines\AppData\Local\Continuum\anaconda3\lib\site-packages\urllib3\ssl_.py"文件。

Answer 1

我使用以下步骤解决了问题。 我的 Python 版本是 3.7.4。

yum  install zlib-devel bzip2-devel openssl-devel ncurses-devel sqlite-devel readline-devel tk-devel gdbm-devel db4-devel libpcap-devel xz-devel libffi-devel
reinstall python3.7.4

导入 SSL 是可以