https://bugs.freedesktop.org/show_bug.cgi?id=64098
Priority: medium
Bug ID: 64098
Assignee: [email protected]
Summary: MAILMERGE: MailMerge setup fails for an SSL connection
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.0.2.2 release
Component: Writer
Product: LibreOffice
Created attachment 78671
--> https://bugs.freedesktop.org/attachment.cgi?id=78671&action=edit
This shows ALL the communication taking place over a network, using Wireshark,
once the "Test Settings" button is clicked.
Problem description: When setting up an E-mail mail merge account that uses an
SSL secure connection on port 465, for LibreOffice Writer version Version
4.0.2.2 (Build ID: 4c82dcdd6efcd48b1d8bba66bfe1989deee49c3), the test to see if
it succeeds fails. It also fails if one ignores the test results and actually
tries to do an E-mail merge, no real surprise, just an FYI.
Steps to reproduce:
1. Open Tools > Options > LibreOffice Writer > Mail Merge E-mail
2. Enter information appropriate to connect to a POP3 mail server using SSL,
port 465, and which requires Server Authentication.
3. Press Test Settings to verify that the server was set up correctly.
Current behavior:
The test shows that it is successful in establishing a network connection.
However, the test shows (after a LONG time) that it failed to find the outgoing
mail server.
Expected behavior:
I expect the test to succeed when using an SSL connection to a mail server.
Additional Information:
LibreOffice produces the following error message -
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\LibreOffice 4.0\program\python-core-3.3.0\lib\smtplib.py:372
in function getreply() [raise SMTPServerDisconnected("Connection unexpectedly
closed")]
C:\Program Files\LibreOffice 4.0\program\python-core-3.3.0\lib\smtplib.py:319
in function connect() [(code, msg) = self.getreply()]
C:\Program Files\LibreOffice 4.0\program\python-core-3.3.0\lib\smtplib.py:238
in function __init__() [(code, msg) = self.connect(host, port)]
C:\Program Files\LibreOffice 4.0\program\mailmerge.py:99 in function
connect() [self.server = smtplib.SMTP(server, port,timeout=tout)]
Internet (Google) searches reveals that this has been an ongoing problem for
quite a few years, in particular when users are using a GMAIL account that
requires an SSL connection on port 465. However, I am running the Apache James
email server, on my own internal SOHO network and am experiencing this problem
with LibreOffice Writer as well, so this CANNOT be blamed on an improper server
configuration. (FYI My Thunderbird e-mail clients all can connect successfully
to my James email server, using SSL and port 465 without any problem.)
Furthermore, log files from the Apache James server, and more definitively, a
trace of network traffic using Wireshark, reveals that there is a single packet
sent from the system, from which the LibreOffice E-Mail merge setup is done, to
the system on which my James e-mail server is running. This is followed by an
ACK packet from the e-mail server back to the system running the E-Mail merge
setup, which surprisingly replies to this ACK with another ACK packet. This is
ALL the communication that occurs, and there is no attempt to follow up with an
attempt to actually send a 'Helo' message or log into the email server to test
if LibreOffice Writer can actually find/communicate/authenticate itself with
the e-mail server.
I therefore surmise that this initial communication between the two systems is
done for the purpose of establishing that there is a network connection, but
not for the purpose of checking if the e-mail server can actually be
used/authenticated with. That sort of communication is completely non-existent,
which places the fault within LibreOffice Writer.
I will attach a document showing the output trace from Wireshark, in the event
that it may prove helpful.
Operating System: Windows 7
Version: 4.0.2.2 release
--
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
