Apache OpenOffice (AOO) Bugzilla – Issue 105669
OOo does not wait for server response when sending E-mailmerge with AUTH-CRAMMD5
Last modified: 2017-05-20 11:41:59 UTC
I was trying to send a serial letter and Open Office does not wait for the server response and sends "mail from", then the server closes the connection because OO does not perform accordingly to RFC. Please see below the correct CRAM-MD5 Authentification Log: T 86.59.10.180:54756 -> 89.207.144.23:25 [A] ..):(. -> openoffice verbindet sich zum Server T 89.207.144.23:25 -> 86.59.10.180:54756 [AP] 220 p0006.netstorage.at ESMTP.. <- Server antwortet T 86.59.10.180:54756 -> 89.207.144.23:25 [AP] ehlo if-PC.xip.at.. -> openoffice melde sich T 89.207.144.23:25 -> 86.59.10.180:54756 [AP] 250-p0006.netstorage.at.. <- Server antwortet T 86.59.10.180:54756 -> 89.207.144.23:25 [A] ....z. -> openoffice T 89.207.144.23:25 -> 86.59.10.180:54756 [AP] 250-AUTH=LOGIN CRAM-MD5 PLAIN..250-AUTH LOGIN CRAM-MD5 PLAIN..250-STARTTLS..250-PIPELINING..250 8BITMIME.. <- Server schlaegt Authentifizierungsvarianten vor T 86.59.10.180:54756 -> 89.207.144.23:25 [AP] AUTH CRAM-MD5.. -> openoffice waehlt CRAM-MD5 T 89.207.144.23:25 -> 86.59.10.180:54756 [AP] 334 PDMyNDMuMTI1NDg0MTE2NkBwMDAwNi5uZXRzdG9yYWdlLmF0Pg==.. <- Server sendet Key T 86.59.10.180:54756 -> 89.207.144.23:25 [A] ...db. -> openoffice sollte auf den Key antworten und das Server-OK abwarteten. T 86.59.10.180:54756 -> 89.207.144.23:25 [AP] mail FROM:<test1@cimmic.com>.. -> openoffice wartet nicht die Serverantwort ab und sendet "mail From" T 89.207.144.23:25 -> 86.59.10.180:54756 [AP] 535 malformed input.. <- Server schliesst die Verbindung da openoffice sich nicht RFC konform verhaelt. So sollte eine korrekte CRAM-MD5 Authentifizierung aussehen: Server: 220 mail.zeitform.de ESMTP Client: EHLO my.host.com Server: 250-mail.zeitform.de 250-AUTH LOGIN CRAM-MD5 PLAIN 250-AUTH=LOGIN CRAM-MD5 PLAIN 250-PIPELINING 250 8BITMIME Client: AUTH CRAM-MD5 Server: 334 PDQwMzYuMTA3NjMyNDM4MUBndWlsZGVuc3Rlcm4uemVpdGZvcm0uZGU+ Client: YmVudXR6ZXJAemVpdGZvcm0uZGUgMmQ5MzczZGZkOTFlMmU2NjMxYzhlMWFkNjk4MzRmYWQ= Server: 235 ok, go ahead (#2.0.0) Sie koennen hier diesen Bug bei openoffice reporten: http://www.openoffice.org/project/qa/issue_handling/pre_submission.html T 86.59.10.180:54756 -> 89.207.144.23:25 [AP] rset.. # T 89.207.144.23:25 -> 86.59.10.180:54756 [AP] 250 flushed.. # T 86.59.10.180:54756 -> 89.207.144.23:25 [A] ......
This is not a P1 issue. Please read http://qa.openoffice.org/issue_handling/pre_submission.html and http://www.openoffice.org/scdocs/ddIssues_EnterModify.html#priority MRU->HI: please have a look.
Reassigned to HI
any update on this issue would be appreciated
@cmc: AFAIK python doesn't support it. You know more?
You can try and example debugging output in the mailmerge script, i.e. change dbg = False to dbg = True in mailmerge.py Its a fairly simple script. Not sure if the problem is one of the script or one of the base python implementation itself. I suspect the latter.
I changed that, where can I see the debug info now?
ah, this was windows not Linux, so the debugging output doesn't appear in that case. Would have to add some logging to file code to get at the output.
this is the error message: <type 'exceptions.IOError'>: (9, 'Bad file descriptor'), traceback follows C:\Program Files\OpenOffice.org 3\Basis\program\python-core-2.6.1\lib\smtplib.py:302 in function send() [if self.debuglevel > 0: print>>stderr, 'send:', repr(str)] C:\Program Files\OpenOffice.org 3\Basis\program\python-core-2.6.1\lib\smtplib.py:478 in function data() [self.send(q)] C:\Program Files\OpenOffice.org 3\Basis\program\python-core-2.6.1\lib\smtplib.py:710 in function sendmail() [(code,resp) = self.data(msg)] C:\Program Files\OpenOffice.org 3\Basis\program\mailmerge.py:193 in function sendMailMessage() [self.server.sendmail(sendermail, truerecipients, msg.as_string())]
that last error looks more like that there's an error in writing to stderr when logging is enabled. Try with if dbg: self.server.set_debuglevel(1) commented out from mailmerge.py to see if it gets a little further
Can I get the setting in tools->options->openoffice.org->writer->Mail merge, i.e. a) SMTP port b) SSL on or off Server Authentication c) SMTP requires authentication d) outgoing requires separate authentication or outgoing uses the same authentication as incoming.
hi, adress: test@cimmic.com smtp: mail.cimmic.com pwd: cimmic
Just cc myself
.
response = user + " " + hmac.HMAC(password, challenge).hexdigest() We're passing down unicode passwords and challenges, and HMAC doesn't like that
Created attachment 65857 [details] replacement for testing
Created attachment 65858 [details] force the encoding as ascii to get hmac to play fair
reproduced under linux, above fix works there. Will check on windows now
looks good. Committed to pythonssl
works perfectly, thank you very much!
cmc->hi: Assuming an available Fedora box (where I know the default configuration has sendmail running, and will default to CRAM-MD5). Then to test, add a test-user as root with $ saslpasswd2 -c atest fill in some password fill it in again $ sasldblistusers2 atest@HOSTNAME in tools->openoffice.org->writer->email merge fill in those details e.g. HOSTNAME port 25 for smtp settings, server authentication as "requires authentication", and atest@HOSTNAME as username, and the password. Test settings should now work, while previously they would fail.
Verified with cws pythonssldedux = ok
*** Issue 112804 has been marked as a duplicate of this issue. ***