Python Simple-Salesforce exe出现SSL错误

Question

我正在用简单的Salesforce在Python中运行Salesforce数据库的查询。它在开发环境中工作得很好，但是当我使用py2exe编译它并在命令提示符中运行它时，我得到了一个错误，我知道这可能与SSL有关，但不知道如何解决它。我没有包含完整的代码，但是错误中引用的第11行是sf = Salesforce(username='myusername', password='mypassword', security_token='mytoken')

我试过sf = Salesforce(username='myusername', password='mypassword', security_token='mytoken', verify=False)，但没有成功

我的代码：

from simple_salesforce import Salesforce
sf = Salesforce(username='myusername', password='mypassword', security_token='mytoken')
data = sf.query_all(select id from Case)

我的错误：

Traceback (most recent call last):
  File "myfile.py", line 11, in <module>
  File "simple_salesforce\api.pyc", line 74, in __init__
  File "simple_salesforce\login.pyc", line 116, in Salesforce login
  File "requests\api.pyc", line 88, in post
  File "requests\api.pyc", line 44, in request
  File "requests\sessions.pyc", line 456, in request
  File "requests\sessions.pyc", line 559, in send
  File "requests\adapters.pyc", line 382, in send
requests.exceptions.SSLError: [Errno 185090050] _ssl.c:344 erroroB084002:x509
certificate routines:X509_load_cert_crl_file:system lib

Answer 1

我遇到了同样的问题，并通过将Salesforce SSL Cert添加到我机器上的cacert.pem文件来修复它。证书可通过设置>开发> API >客户端证书上的链接进行访问。http://na16.salesforce.com/soap/cliencert.jsp