Bug 63388 - MAILMERGE: LibreOffice freezes when clicking Test Settings button
Summary: MAILMERGE: LibreOffice freezes when clicking Test Settings button
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
Version: 4.1.3.2 release
Hardware: Other Windows (All)
: high normal
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2013-04-10 15:39 UTC by Dan Lewis
Modified: 2014-10-23 11:40 UTC (History)
2 users (show)

See Also:
i915 platform:
i915 features:


Attachments

Description Dan Lewis 2013-04-10 15:39:50 UTC
Problem description: 
I enter my email information including what is required to authenticate me copying this information directly from my email client, Thunderbird. But when I test the settings, LibreOffice freezes. I use Gmail. OS: Ubuntu 12.04 LST 64 bit.
Steps to reproduce:
1. Tools > Options > LibreOffice Writer > Mail Merge Email
2. Copy the User information and Outgoing Server Settings
3. Check Use Secure connection (SSL)
4. Click Server Authentication button.
5. Check the box at the top.
6. Select this option button: The outgoing mail server (SMTP) requires separate authentication.
7. Copy server information from Thunderbird, and click OK.
8. Click the Test Settings button. LibreOffice freezes after approximately 5-10 seconds.

Current behavior:
I get the same results using LibreOffice 3.5.7.2, 3.6.5.2, 3.6.6.2 and 4.0.1.2. I have verified that the password entered is the one required to access Gmail on the Google website.I use IMAP with Google if that matters.

Expected behavior:
When the Test Settings button is clicked, I should get a message stating the test was successful or at least a hint of what went wrong.

              
Operating System: Ubuntu
Version: 3.5.7.1 rc
Comment 1 Alex Thurgood 2013-04-10 16:26:23 UTC
Confirming also on LO 4.0.2.2, 3.6.5 on OSX 10.8.3

This used to work in 3.3.x (although I haven't tested recently).

It also might be a DUP of a previously entered report (will have to look).


Alex
Comment 2 Alex Thurgood 2013-04-10 16:42:20 UTC
CC: Caolan - does this ring a bell ?


Alex
Comment 3 Alex Thurgood 2013-04-10 17:01:37 UTC
When running LO master from gdb, I see this 

BEFORE

and that's where it is seemingly stuck


Alex
Comment 4 Alex Thurgood 2013-04-10 17:37:38 UTC
Dan,

If you set up your connection as follows :

Server name : imap.gmail.com
Port : 25

Use secure connection (SSL)

Do not fill in the Server Authentication dialogue


Does the test then work ? It does on my master build of LO.


Alex
Comment 5 Alex Thurgood 2013-06-14 04:38:39 UTC
Dan,


For gmail, these are the settings that worked for me :

SSL option ticked
smtp.googlemail.com
Port 25

Under "Server Authentication"
Tick "Outgoing mail server (SMTP) requires authentication"
Select "The outgoing mail server requires separate authentication"
User name : enter full Gmail address here, including the @gmail.com
Password : fill in with password

No need to configure the Incoming Mail Server options


Alex
Comment 6 Andrea Tessadri 2014-09-13 14:54:57 UTC
I couldn't figure out the way to have mailmerge working with my Gmail SMTP but when I did the debug of the mailmerge.py script I've discovered that a SSL connection isn't handled properly.
At the line where the server object is created I found:

self.server = smtplib.SMTP(server, port,timeout=tout)

but in case of SSL connection the correct statement should be:

self.server = smtplib.SMTP_SSL(server, port,timeout=tout)

So, I did this simple change and my Gmail SMTP (smtp.gmail.com) works perfectly on port 465.
I didn't even checked the "Use SSL" checkbox in the mailmerge configuration windows.

I think a good patch should make a choice between smtplib.SMTP and smtplib.SMTP_SSL according to the "Use SSL" checkbox.

Cheers.

   Andrea
Comment 7 mrmister001 2014-10-23 11:39:46 UTC
Hello, I confirm THIS IS A BUG AND NEED URGENT SOLUTION please
LibreOffice Writer crash miserably when I try to send documents via email
I have my settings perfectly configured, port, ssl, smtp server, etc. and this freeze completely.
I did the changes that Andrea suggested but in my case are not working...


Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.