I have a program that pools ad stats from different marketing systems. Everything works fine untill i convert it to the .exe format and run it.
Exception in Tkinter callback
Traceback (most recent call last):
File "C:UsersuserAppDataLocalProgramsPythonPython35libkinter\__init__.py", line 1549, in __call__
return self.func(*args)
File "C:UsersuserDesktopalgTSK_7. Marketing
eport_gui.py", line 24, in <lambda>
ok = tk.Button(root, text="DO NOT PRESS", bg="red", command=lambda: self.run())
File "C:UsersuserDesktopalgTSK_7. Marketing
eport_gui.py", line 43, in run
report.merge_all()
File "C:UsersuserDesktopalgTSK_7. Marketingprocess_data.py", line 400, in merge_all
fb_df = self.fetch_fb()
File "C:UsersuserDesktopalgTSK_7. Marketingprocess_data.py", line 156, in fetch_fb
fb_campaigns = from_fb.run_fb(self.start_date, self.end_date) # in JSON format
File "C:UsersuserDesktopalgTSK_7. Marketingfrom_fb.py", line 110, in run_fb
return s.get_stats()
File "C:UsersuserDesktopalgTSK_7. Marketingfrom_fb.py", line 84, in get_stats
params=params,
File "C:UsersuserAppDataLocalProgramsPythonPython35libsite-packagesfacebookadsadobjectsadaccount.py", line 1551, in get_insights
return request.execute()
File "C:UsersuserAppDataLocalProgramsPythonPython35libsite-packagesfacebookadsapi.py", line 653, in execute
cursor.load_next_page()
File "C:UsersuserAppDataLocalProgramsPythonPython35libsite-packagesfacebookadsapi.py", line 797, in load_next_page
params=self.params,
File "C:UsersuserAppDataLocalProgramsPythonPython35libsite-packagesfacebookadsapi.py", line 305, in call
timeout=self._session.timeout
File "C:UsersuserAppDataLocalProgramsPythonPython35libsite-packages
equestssessions.py", line 508, in request
resp = self.send(prep, **send_kwargs)
File "C:UsersuserAppDataLocalProgramsPythonPython35libsite-packages
equestssessions.py", line 618, in send
r = adapter.send(request, **kwargs)
File "C:UsersuserAppDataLocalProgramsPythonPython35libsite-packages
equestsadapters.py", line 407, in send
self.cert_verify(conn, request.url, verify, cert)
File "C:UsersuserAppDataLocalProgramsPythonPython35libsite-packages
equestsadapters.py", line 226, in cert_verify
"invalid path: {0}".format(cert_loc))
OSError: Could not find a suitable TLS CA certificate bundle, invalid path: C:UsersuserAppDataLocalTemp\_MEI253762facebookadsfb_ca_chain_bundle.crt
I tried to fix that by using this code but MEI folder keeps changing its digits everytime i run this code so it's no use.
dst = r'C:UsersuserAppDataLocalTemp\_MEI120642facebookads'
file = 'fb_ca_chain_bundle.crt'
try:
os.makedirs(dst); ## it creates the destination folder
except:
pass
shutil.move(file, dst)
So i went to this file
C:UsersuserAppDataLocalProgramsPythonPython35Libsite-packages
equestsadapters.py
and tried to comment if statements that raise this error out but got an SSL error. I couldn't find a piece of code responsible for generating those MEI digits.
def cert_verify(self, conn, url, verify, cert):
"""Verify a SSL certificate. This method should not be called from user
code, and is only exposed for use when subclassing the
:class:`HTTPAdapter <requests.adapters.HTTPAdapter>`.
:param conn: The urllib3 connection object associated with the cert.
:param url: The requested URL.
:param verify: Either a boolean, in which case it controls whether we verify
the server's TLS certificate, or a string, in which case it must be a path
to a CA bundle to use
:param cert: The SSL certificate to verify.
"""
if url.lower().startswith('https') and verify:
cert_loc = None
# Allow self-specified cert location.
if verify is not True:
cert_loc = verify
if not cert_loc:
cert_loc = DEFAULT_CA_BUNDLE_PATH
if not cert_loc or not os.path.exists(cert_loc):
raise IOError("Could not find a suitable TLS CA certificate bundle, "
"invalid path: {0}".format(cert_loc))
conn.cert_reqs = 'CERT_REQUIRED'
if not os.path.isdir(cert_loc):
conn.ca_certs = cert_loc
else:
conn.ca_cert_dir = cert_loc
else:
conn.cert_reqs = 'CERT_NONE'
conn.ca_certs = None
conn.ca_cert_dir = None
if cert:
if not isinstance(cert, basestring):
conn.cert_file = cert[0]
conn.key_file = cert[1]
else:
conn.cert_file = cert
conn.key_file = None
if conn.cert_file and not os.path.exists(conn.cert_file):
raise IOError("Could not find the TLS certificate file, "
"invalid path: {0}".format(conn.cert_file))
if conn.key_file and not os.path.exists(conn.key_file):
raise IOError("Could not find the TLS key file, "
"invalid path: {0}".format(conn.key_file))
See Question&Answers more detail:
os