Good day. I have a python script which checks mailbox for unread messages. If there are unread messages with attachments it then executes some code(excel automation). It used to be working well; however, today I encountered this error while executing script:
Failed to create cached protocol with key ('********/EWS/Exc hange.asmx', Credentials('*******', '********')): HTTPSConnectio nPool(host='*******', port=443): Max retries exceeded with url: /EW S/Exchange.asmx (Caused by SSLError(SSLCertVerificationError("hostname 'mail.example.com' doesn't match either of '*.example.com', 'example.com'")))
Where example.com is company's server.
I searched for some answers and encountered an adivce saying I should set veryfy-ssl to False (Account). When I do that, I do not receive the error from the command line anymore but the script just finishes in 1 sec and does nothing.
What can be the issue here? I have not done any changes to the code, so is it mail server's fault? Below is the snippet of the code which gets attachment from mail:
def get_attachments(login, password, path):
files_list = []
credentials = Credentials(
username=login,
password=password
)
config = Configuration(server=settings.server, credentials=credentials)
account = Account(primary_smtp_address=login,
config=config, autodiscover=False, access_type=DELEGATE)
unread = account.inbox.filter(is_read=False)
attachment_counter = 0
for msg in unread:
msg.is_read = True
msg.save()
for attachment in msg.attachments:
fpath = os.path.join(path, attachment.name)
if os.path.exists(fpath):
attachment_counter += 1
fpath = os.path.join(path, (str(attachment_counter) + attachment.name))
if attachment.name.split(".")[-1].lower() in ['xlsx', 'xls']:
with open(fpath, 'wb') as f:
f.write(attachment.content)
files_list.append(fpath)
return files_list
