https://bugs.freedesktop.org/show_bug.cgi?id=77354
Priority: medium
Bug ID: 77354
Assignee: [email protected]
Summary: Mail Merge E-mail test: "No SSL support included in
this Python"
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 4.2.3.3 rc
Component: Libreoffice
Product: LibreOffice
E-mail merges don't work with SSL/TLS.
My outgoing server (SMTP) Settings:
Server name: smtp.gmail.com
Port: 587
Use secure connection (SSL): Checked
Server authentication:
The outgoing mail server (SMTP) requires authentication: Checked
The outgoing mail server (SMTP) requires separate authentication: Selected
Outgoing mail server:
User name: <Google user name>
Password: <Google password>
Clicking the Test Settings button results in:
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 'RuntimeError'>: No SSL support included in this Python, traceback
follows
C:\Program Files (x86)\LibreOffice
4\program\python-core-3.3.3\lib\smtplib.py:660 in function starttls() [raise
RuntimeError("No SSL support included in this Python")]
C:\Program Files (x86)\LibreOffice 4\program\mailmerge.py:114 in function
connect() [self.server.starttls()]
---------------------------------------
Test e-mail merges fail with:
<class 'smtplib.SMTPServerDisconnected'>: Connection unexpectedly closed,
traceback follows
C:\Program Files (x86)\LibreOffice
4\program\python-core-3.3.3\lib\smtplib.py:374 in function getreply() [raise
SMTPServerDisconnected("Connection unexpectedly closed")]
C:\Program Files (x86)\LibreOffice
4\program\python-core-3.3.3\lib\smtplib.py:487 in function mail() [return
self.getreply()]
C:\Program Files (x86)\LibreOffice
4\program\python-core-3.3.3\lib\smtplib.py:754 in function sendmail() [(code,
resp) = self.mail(from_addr, esmtp_opts)]
C:\Program Files (x86)\LibreOffice 4\program\mailmerge.py:278 in function
sendMailMessage() [self.server.sendmail(sendermail, truerecipients,
msg.as_string())]
---------------------------------------
LibreOffice 4.1.5.3 had the same problem. Upgrading to 4.2.3.3 made no
difference. Using port 465 instead of 587 makes LibreOffice unresponsive for
the Settings Test which eventually times out with:
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 'smtplib.SMTPServerDisconnected'>: Connection unexpectedly closed,
traceback follows
C:\Program Files (x86)\LibreOffice
4\program\python-core-3.3.3\lib\smtplib.py:374 in function getreply() [raise
SMTPServerDisconnected("Connection unexpectedly closed")]
C:\Program Files (x86)\LibreOffice
4\program\python-core-3.3.3\lib\smtplib.py:321 in function connect() [(code,
msg) = self.getreply()]
C:\Program Files (x86)\LibreOffice
4\program\python-core-3.3.3\lib\smtplib.py:240 in function __init__() [(code,
msg) = self.connect(host, port)]
C:\Program Files (x86)\LibreOffice 4\program\mailmerge.py:100 in function
connect() [self.server = smtplib.SMTP(server, port,timeout=tout)]
---------------------------------------
Google says to use port 587 if clients begin with plain text before issuing the
STARTTLS command. See https://developers.google.com/gmail/oauth_overview.
---------------------------------------
Once, when setting the configuration back to port 587 (my remaining settings as
posted earlier), several Test Settings were successful. So far, I haven't been
able to reproduce the success or determine why it temporarily succeeded.
---------------------------------------
E-mail merge works consistently in LibreOffice 4.2.3.3 on OS X Lion.
---------------------------------------
Tested on several Windows 7 workstations with the same results.
---------------------------------------
This bug was also reported on the LibreOffice development and discussions
mailing list:
http://lists.freedesktop.org/archives/libreoffice/2014-March/060136.html
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs