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

Reply via email to