https://bugs.documentfoundation.org/show_bug.cgi?id=157480
Bug ID: 157480
Summary: [OSX] Testing Mail Merge Email settings fails with
ssl.SSLCertVerificationError
Product: LibreOffice
Version: 7.5.7.1 release
Hardware: x86-64 (AMD64)
OS: macOS (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Writer
Assignee: [email protected]
Reporter: [email protected]
Description:
When I click on "Test Settings" after entering the correct credentials/settings
in the "Preferences > LibreOffice Writer > Mail Merge Email" Dialog, the
network connection is established successfully but it always fails to find the
outgoing email server. The following error message is shown:
LibreOffice could not connect to the outgoing mail server. Check your system's
settings and the settings in LibreOffice. Check the server name, the port and
the secure connections settings
--
<class 'ssl.SSLCertVerificationError'>: [SSL: CERTIFICATE_VERIFY_FAILED]
certificate verify failed: unable to get local issuer certificate
(_ssl.c:1131), traceback follows
File
"/private/var/folders/3b/y40cdqyd2_g2xtjvtqd6m2mr0000gn/T/AppTranslocation/9470A800-D97E-4B95-9AE3-848BB8F05929/d/LibreOffice.app/Contents/Resources/mailmerge.py",
line 111, in connect
self.server.starttls(context=ssl.create_default_context())
File
"/private/var/folders/3b/y40cdqyd2_g2xtjvtqd6m2mr0000gn/T/AppTranslocation/9470A800-D97E-4B95-9AE3-848BB8F05929/d/LibreOffice.app/Contents/Frameworks/LibreOfficePython.framework/Versions/Current/lib/python3.8/smtplib.py",
line 788, in starttls
self.sock = context.wrap_socket(self.sock,
File
"/private/var/folders/3b/y40cdqyd2_g2xtjvtqd6m2mr0000gn/T/AppTranslocation/9470A800-D97E-4B95-9AE3-848BB8F05929/d/LibreOffice.app/Contents/Frameworks/LibreOfficePython.framework/Versions/Current/lib/python3.8/ssl.py",
line 500, in wrap_socket
return self.sslsocket_class._create(
File
"/private/var/folders/3b/y40cdqyd2_g2xtjvtqd6m2mr0000gn/T/AppTranslocation/9470A800-D97E-4B95-9AE3-848BB8F05929/d/LibreOffice.app/Contents/Frameworks/LibreOfficePython.framework/Versions/Current/lib/python3.8/ssl.py",
line 1073, in _create
self.do_handshake()
File
"/private/var/folders/3b/y40cdqyd2_g2xtjvtqd6m2mr0000gn/T/AppTranslocation/9470A800-D97E-4B95-9AE3-848BB8F05929/d/LibreOffice.app/Contents/Frameworks/LibreOfficePython.framework/Versions/Current/lib/python3.8/ssl.py",
line 1342, in do_handshake
self._sslobj.do_handshake()
Steps to Reproduce:
1. Open Preferences > LibreOffice Writer > Mail Merge Email
2. Enter correct settings/credentials (using TLS/SSL)
3. Click "Test Settings"
Actual Results:
The network connection is established successfully but it always fails to find
the outgoing email server. The following error message is shown:
LibreOffice could not connect to the outgoing mail server. Check your system's
settings and the settings in LibreOffice. Check the server name, the port and
the secure connections settings
--
<class 'ssl.SSLCertVerificationError'>: [SSL: CERTIFICATE_VERIFY_FAILED]
certificate verify failed: unable to get local issuer certificate
(_ssl.c:1131), traceback follows
File
"/private/var/folders/3b/y40cdqyd2_g2xtjvtqd6m2mr0000gn/T/AppTranslocation/9470A800-D97E-4B95-9AE3-848BB8F05929/d/LibreOffice.app/Contents/Resources/mailmerge.py",
line 111, in connect
self.server.starttls(context=ssl.create_default_context())
File
"/private/var/folders/3b/y40cdqyd2_g2xtjvtqd6m2mr0000gn/T/AppTranslocation/9470A800-D97E-4B95-9AE3-848BB8F05929/d/LibreOffice.app/Contents/Frameworks/LibreOfficePython.framework/Versions/Current/lib/python3.8/smtplib.py",
line 788, in starttls
self.sock = context.wrap_socket(self.sock,
File
"/private/var/folders/3b/y40cdqyd2_g2xtjvtqd6m2mr0000gn/T/AppTranslocation/9470A800-D97E-4B95-9AE3-848BB8F05929/d/LibreOffice.app/Contents/Frameworks/LibreOfficePython.framework/Versions/Current/lib/python3.8/ssl.py",
line 500, in wrap_socket
return self.sslsocket_class._create(
File
"/private/var/folders/3b/y40cdqyd2_g2xtjvtqd6m2mr0000gn/T/AppTranslocation/9470A800-D97E-4B95-9AE3-848BB8F05929/d/LibreOffice.app/Contents/Frameworks/LibreOfficePython.framework/Versions/Current/lib/python3.8/ssl.py",
line 1073, in _create
self.do_handshake()
File
"/private/var/folders/3b/y40cdqyd2_g2xtjvtqd6m2mr0000gn/T/AppTranslocation/9470A800-D97E-4B95-9AE3-848BB8F05929/d/LibreOffice.app/Contents/Frameworks/LibreOfficePython.framework/Versions/Current/lib/python3.8/ssl.py",
line 1342, in do_handshake
self._sslobj.do_handshake()
Expected Results:
Both tests should be successful:
* Establish network connection
* Find outgoing mail server
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.6.2.1 (X86_64) / LibreOffice Community
Build ID: 56f7684011345957bbf33a7ee678afaf4d2ba333
CPU threads: 8; OS: Mac OS X 13.5.1; UI render: Skia/Metal; VCL: osx
Locale: en-GB (en_GB.UTF-8); UI: en-US
Calc: threaded
I also tested earlier versions, in the following "Test Settings" works as
expected:
Version: 7.4.7.2 / LibreOffice Community
Build ID: 723314e595e8007d3cf785c16538505a1c878ca5
CPU threads: 8; OS: Mac OS X 13.5.1; UI render: default; VCL: osx
Locale: en-GB (en_GB.UTF-8); UI: en-US
Calc: threaded
But here it fails already with the mentioned error message:
Version: 7.5.7.1 (X86_64) / LibreOffice Community
Build ID: 47eb0cf7efbacdee9b19ae25d6752381ede23126
CPU threads: 8; OS: Mac OS X 13.5.1; UI render: default; VCL: osx
Locale: en-GB (en_GB.UTF-8); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
