Issue 93583 - Mailmerge fails to communicate with SMTP server (Not SSL)
Summary: Mailmerge fails to communicate with SMTP server (Not SSL)
Status: CLOSED FIXED
Alias: None
Product: porting
Classification: Code
Component: code (show other issues)
Version: OOO300m4
Hardware: Mac Mac OS X, all
: P3 Trivial with 3 votes (vote)
Target Milestone: OOo 3.3
Assignee: caolanm
QA Contact: issues@porting
URL:
Keywords: aqua
: 99078 (view as issue list)
Depends on:
Blocks:
 
Reported: 2008-09-08 06:32 UTC by lancerkind
Modified: 2010-01-08 19:05 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description lancerkind 2008-09-08 06:32:12 UTC
When testing the account settings for mailmerge, the system fails to connect to
the SMTP server.  (I'm using the same settings as I use for Mac Mail.)
Ignoring this problem and actually trying to send the mailmerge fails to send
anything too.

To reproduce the problem:
1 Create a spread sheet with a column that contains emails.
2 Create a document using Writer.
3 In Writer, click Tools->mail merge wizzard, and go through the wizard until it
asks you for mail account settings.  I used my Yahoo (plus) account which allows
pop and smtp.  I don't check SSL, I do check authentication for SMTP.

4 After I click test, it fails to connect to the SMTP server even though I'm
convinced my settings are correct and I've tried four different times.  (I tried
using SSL settings too.)
Comment 1 michael.ruess 2008-09-08 07:34:20 UTC
Reassigned to HI.
Comment 2 yserrano 2008-11-22 11:04:27 UTC
I have the same problem. My localhost test smtp server doesn't work either. 
Comment 3 craigmc 2008-12-15 07:19:40 UTC
Also having this issue. Tested several server configurations both with GMail and private SMTP server.

Running:
Leopard 10.5.5
Open Office 3.0.0

Thanks much!
Comment 4 h.ilter 2008-12-16 13:08:55 UTC
Works in SO.
I think this one depends on issue 90701 isn't it.
Comment 5 caolanm 2008-12-16 13:36:36 UTC
I doubt it.
Comment 6 bangpound 2009-02-10 16:10:47 UTC
I'm having this problem too. I can't even test my settings in the preferences "E-mail mail merge" pane. 
Can anyone else successfully test their server settings?

http://www.openoffice.org/issues/show_bug.cgi?id=99078

Comment 7 h.ilter 2009-02-12 10:12:22 UTC
*** Issue 99078 has been marked as a duplicate of this issue. ***
Comment 8 waughopenoffice 2009-06-30 21:46:08 UTC
I am also having this issue in OpenOffice 3.1 on Windows XP Pro.
My mail account settings are all fine and tested in Thunderbird (I use both
Gmail and Hotmail via pop3).

I can't get past the "test settings" in the Mail Merge Email dialogue box.  Open
Office freezes when I test my account settings - which work fine in Thunderbird.
Comment 9 michael.ruess 2009-09-14 12:22:01 UTC
*** Issue 104964 has been marked as a duplicate of this issue. ***
Comment 10 kyang 2009-09-14 18:31:22 UTC
I'm expermenting/testing with OOo 3.1.1 to see if this product is a good move 
from Microsoft Office for our organization.  We are running Windows XP SP2, 
using Thunderbird 2.0.0.23, with OOo 3.1.1 and I'm getting this exact error as 
well.  If I'm trying to do a mail merge to email, I don't get any errors but it 
never sends any of the emails and seems like its in a loop (trying to find the 
server and can't).  If I go through the options to setup and test the settings 
then I'll get the exact same errors as everyone else here.  In Issue 95849 it 
says to make sure Python-Uno is installed but I've checked the install and its 
a component installed by default.  By reading all the issues submitted in 
regards to this, it seems as though this has always kind of been an issue in 
almost every new version after 2.4.0 (something like that).  If anyone has a 
resolution/suggestions it would greatly be appreciated.  
Comment 11 caolanm 2009-09-14 19:29:16 UTC
It probably just requires someone with a modicum of python to have a look at
this under Windows and/or MacOSX and fiddle with mailmerge.py. But I have
neither of those operating systems. 
Comment 12 hilaryholz 2009-10-09 02:06:56 UTC
How about just warning folks that the feature doesn't work on Mac OS X? This
thing has been chewing up people's time for well over a year, now. I spent an
hour mucking with it before deciding it was probably a bug and another 20
minutes confirming that hypothesis. I would rather have put that time into
working on the problem... Between the lot of us, we would have solved the thing
by now. Geesh.
Comment 13 caolanm 2009-10-31 17:00:30 UTC
So, I tested this on windows (always worked under Linux) and with 
tools->options->openoffice.org writer->email settings
a) an smtp server at port 25
b) ssl unchecked
server authentication
c) The outgoing mail server requires authorization checked
d) The outgoing mail server requires separate authentication checked
   username
   password
This works fine for me from windows xp, mails definitely get sent.
Comment 14 caolanm 2009-10-31 18:09:13 UTC
A second test in windows with a gmail account:
tools->options->openoffice.org writer->email settings
a) an smtp server of smtp.gmail.com at port 587
b) ssl checked
server authentication
c) The outgoing mail server requires authorization checked
d) The outgoing mail server requires separate authentication checked
   username
   password
bzzt. "No SSL support included in this python"

So thats the answer to one problem anyway. The windows ssl support isn't
compiled into python.
Comment 15 caolanm 2009-11-02 10:12:13 UTC
So this bug has accumulated a lot of different "duplicates" and I don't think
they are all actually duplicates at all. 

So for anyone who has trouble under Window *and* with "Use secure connection"
see issue 106542 for a possible workaround and the future fix for this.

The original report is for MacOSX and *not* using "Use secure connection"
Comment 16 caolanm 2009-11-02 12:33:19 UTC
If anyone is using CRAM-MD5 authentication, then that problem is fixed with
issue 105669. Issue 105669 has a replacement mailmerge.py attached to it which
you could try overwriting your original with to see if that makes a difference.
Comment 17 caolanm 2009-11-16 10:15:47 UTC
I've fixed a pair of *possibly* related issues, I'd be interested if the
experimental Mac Intel install set which includes those fixes at 
ftp://qa-upload.services.openoffice.org/pythonssldedux/aqua/
makes any difference to the original macosx issues reported here
Comment 18 martinschniewind 2009-11-23 19:22:00 UTC
Problem seems to be the same on Linux since OOo 3.0 (also tested with 3.1.1):

Reproduction:
1) Configure Tools->Options-Writer->E-Mail merge (do not know exact english
labels) with SMTP server
2) Enter authentication details (SMTP AUTH)
3) Test will result in "network ok", but "search for SMTP server" failed

It is no matter, if I use an external relay server or my own LAN one.

But - and this is strange - if I switch off "server needs authentication" then:
3) Test will result in "network ok", but "search for SMTP server" succeeds!

So this actually seems to be a general authentication issue in smtplib.py?

This is the output I get, when I try to send merged e-mails with authentication
switched on:

~~~~~~~~~~~~~ snip ~~~~~~~~~~
<class 'smtplib.SMTPSenderRefused'>: (501, '5.5.4 BASE64 decoding error',
u'me@example.org'), traceback follows
  /opt/openoffice.org/basis3.1/program/python-core-2.6.1/lib/smtplib.py:698 in
function sendmail() [raise SMTPSenderRefused(code, resp, from_addr)]
  /opt/openoffice.org/basis3.1/program/mailmerge.py:193 in function
sendMailMessage() [self.server.sendmail(sendermail, truerecipients,
msg.as_string())]
~~~~~~~~~~~~~ snip ~~~~~~~~~~

Hope this helps ...
Comment 19 caolanm 2009-11-23 20:02:50 UTC
cmc->martinschniewind: There's a lot of mission creep with this bug, so this
particular one is only for MacOSX and hopefully someone there can test the
packages at ftp://qa-upload.services.openoffice.org/pythonssldedux/aqua/ to see
if they make a difference.

For your problem you can see if
ftp://qa-upload.services.openoffice.org/pythonssldedux/linux makes a difference,
and if it does not then open a new bug and assign it to me (cmc) and give all
the exact details of the settings you are using
Comment 20 caolanm 2010-01-08 10:01:33 UTC
No feedback on the mac install sets. But I feel fairly confident that this is a
duplicate of some of the specific bugs/missing python pre-requisites I was able
to find in the vanilla windows and linux built-in python.

I'll leave the testing install sets up for a few weeks if anyone wants to give
them a go, otherwise tests can be done on any development snapshots from
DEV300_m69 onwards up to the 3.3 release
Comment 21 caolanm 2010-01-08 10:02:33 UTC
closing, m69 onwards
Comment 22 florian 2010-01-08 19:05:52 UTC
@cmc: I tried your install set when you had uploaded it, but I couldn't tell much difference compared to 
the official 3.1 release, i.e. they both worked to some degree (with the combination of options I tried). Can 
that be because I may have newer versions of python installed?