To reproduce - writer document - some fields from datasource - Tools > Mail Merge Wizard - step 8, send etc - choose send by e-mail and PDF etc - OK .... > no mails send NB 1: sending as html for example does work NB 2: works OK in OOo321 / OOo330rc8
tested on Ubuntu
Hi Cor, can you please provide us with a strace? That would help a lot. http://wiki.documentfoundation.org/BugReport#How_to_get_strace_log_.28on_Linux.29 Thank you in advance!
Created attachment 41352 [details] stace log BTW, I run LibO 330rc1 with the old user profile from OOo3.2.1 (will try with fresh profile too)
LibO330rc1 with a fresh user profile shows the same problem. Plus a new one: Sending mail merge as HTML, freezes, unless I mail as e.g. txt first, and then as HTML, then it works fine. Strace for that too... yes of course.
attachments too large have one for problem PDF not send and one for HTML freezes
Caolan: Can you please have a look? I'll forward you the straces.
There is a "dbg = False" in /path/to/basis3.2/program/mailmerge.py which if changed to "dbg = True" will output various foo if the process is getting as far as the actual emailing of the document.
how can I make that the output is written to a file? It is too much to get from the terminal (with my skills anyway). BTW: it seems that a first attempt to mail fails, then a second works, and then mail as PDF works too. Eg. as PDF > no result; as HTML > works, as PDF works. Odd that I did not notice that yesterday. Pls advice on what I can do to help.
To redirect the output to a file.... e.g. shutdown Libo /path/to/soffice > /tmp/thelog 2>&1 and attach the log here (well, check it for your email passwords first in it, it might log those too)
Hmm, Now sending as HTML works right away. why do I get different results and problems every time :-( Below the output of just the HTML from the terminal (some private data snipped/...) ~/LibO330rc1/libreoffice/program$ ./soffice PyMailServiceProvider init PyMailServiceProvider create with <uno.Enum com.sun.star.mail.MailServiceType ('SMTP')> PyMailSMPTService init PyMailSMPTService getSupportedConnectionTypes PyMailSMPTService connect Logging in, username ... [....], pleased to meet you\r\n' reply: '250-ENHANCEDSTATUSCODES\r\n' reply: '250-PIPELINING\r\n' reply: '250-8BITMIME\r\n' reply: '250-SIZE 31457280\r\n' reply: '250-DSN\r\n' reply: '250-AUTH LOGIN PLAIN\r\n' reply: '250-STARTTLS\r\n' reply: '250-DELIVERBY\r\n' reply: '250 HELP\r\n' reply: retcode (250); Msg: smtp-vbr2.xs4all.nl Hello ....], pleased to meet you ENHANCEDSTATUSCODES PIPELINING 8BITMIME SIZE 31457280 DSN AUTH LOGIN PLAIN STARTTLS DELIVERBY HELP send: 'AUTH PLAIN ...==\r\n' reply: '235 2.0.0 OK Authenticated\r\n' reply: retcode (235); Msg: 2.0.0 OK Authenticated PyMailSMPTService isConnected PyMailSMPTService sendMailMessage PyMailSMPTService subject tst 52553 #3 PyMailSMPTService from Cor Nouws PyMailSMTPService from cno@nouenoff.nl PyMailSMPTService send to (u'nouwsc@xs4all.nl',) PyMailSMPTService flavors len 1 PyMailSMPTService mimetype is text/html; charset=utf-8 PyMailSMPTService recipients are [u'nouwsc@xs4all.nl'] send: u'mail FROM:<cno@nouenoff.nl> size=1450\r\n' reply: '250 2.1.0 <cno@nouenoff.nl>... Sender ok\r\n' reply: retcode (250); Msg: 2.1.0 <cno@nouenoff.nl>... Sender ok send: u'rcpt TO:<nouwsc@xs4all.nl>\r\n' reply: '250 2.1.5 <nouwsc@xs4all.nl>... Recipient ok\r\n' reply: retcode (250); Msg: 2.1.5 <nouwsc@xs4all.nl>... Recipient ok send: 'data\r\n' reply: '354 Enter mail, end with "." on a line by itself\r\n' reply: retcode (354); Msg: Enter mail, end with "." on a line by itself data: (354, 'Enter mail, end with "." on a line by itself') send: 'Content-Type: text/html; charset=UTF-8\r\nMIME-Version: 1.0\r\nSubject: tst 52553 #3\r\nFrom: Cor Nouws <cno@nouenoff.nl>\r\nTo: nouwsc@xs4all.nl\r\nX-Mailer: LibreOffice 3.3 via Caolan\'s mailmerge component\r\nDate: Wed, 22 Dec 2010 13:42:25 +0100\r\n\r\n<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">\r\n<HTML>\r\n<HEAD>\r\n\t<META HTTP-EQUIV="CONTENT-TYPE" CONTENT="text/html; charset=utf-8">\r\n\t<TITLE></TITLE>\r\n\t<META NAME="GENERATOR" CONTENT="LibreOffice 3.3 (Linux)">\r\n\t<META NAME="CREATED" CONTENT="0;0">\r\n\t<META NAME="CHANGEDBY" CONTENT="Cor Nouws">\r\n\t<META NAME="CHANGED" CONTENT="20101222;13422500">\r\n\t<STYLE TYPE="text/css">\r\n\t<!--\r\n\t\t@page { size: 15.8cm 14cm; margin-left: 1cm; margin-right: 1cm }\r\n\t\tP { margin-bottom: 0.21cm }\r\n\t\tTD P { margin-bottom: 0cm }\r\n\t-->\r\n\t</STYLE>\r\n</HEAD>\r\n<BODY LANG="nl-NL" DIR="LTR"><SPAN CLASS="sd-abs-pos" STYLE="position: absolute; top: 0.79cm; left: 0.23cm; width: 583px">\r\n<IMG SRC="sv65g_tmp_m7f81eb.png" NAME="graphics1" WIDTH=583 HEIGHT=476 BORDER=0></SPAN><SPAN CLASS="sd-abs-pos" STYLE="position: absolute; top: 0.68cm; left: 0.23cm; width: 583px">\r\n<IMG SRC="sv65g_tmp_ma390a6f.gif"></SPAN>\r\n<P STYLE="margin-bottom: 0cm"><BR>\r\n</P>\r\n<P STYLE="margin-bottom: 0cm"><BR>\r\n</P>\r\n<P><BR>\r\n</P>\r\n<P><BR>\r\n</P>\r\n<P><BR>\r\n</P>\r\n<P><BR>\r\n</P>\r\n<P><BR>\r\n</P>\r\n<P><BR>\r\n</P>\r\n<P><BR>\r\n</P>\r\n<P><BR>\r\n</P>\r\n<P><BR>\r\n</P>\r\n<P><BR>\r\n</P>\r\n<P><BR>\r\n</P>\r\n<P ALIGN=CENTER STYLE="margin-bottom: 0cm">Nouws nouwsc@xs4all.nl</P>\r\n<P><BR>\r\n</P>\r\n<P><BR>\r\n</P>\r\n</BODY>\r\n</HTML>\r\n.\r\n' reply: '250 2.0.0 smtp-vbr2.xs4all.nl accepted message oBMCgO3Q065956\r\n' reply: retcode (250); Msg: 2.0.0 smtp-vbr2.xs4all.nl accepted message oBMCgO3Q065956 data: (250, '2.0.0 smtp-vbr2.xs4all.nl accepted message oBMCgO3Q065956') PyMailSMPTService sendMailMessage [snip] reply: '250 2.0.0 smtp-vbr2.xs4all.nl accepted message oBMCgO3S065956\r\n' reply: retcode (250); Msg: 2.0.0 smtp-vbr2.xs4all.nl accepted message oBMCgO3S065956 data: (250, '2.0.0 smtp-vbr2.xs4all.nl accepted message oBMCgO3S065956') PyMailSMPTService isConnected PyMailSMPTService disconnect send: 'quit\r\n' reply: '221 2.0.0 smtp-vbr2.xs4all.nl closing connection\r\n' reply: retcode (221); Msg: 2.0.0 smtp-vbr2.xs4all.nl closing connection
thanks for your advice Caolán - will try that now
"why do I get different results and problems every time :-(" Reply to myself: Maybe because you work with different files :-) Looks as if the freezing while trying to send is related to a file where there is a background image in a table. (So such a bad idea, though ?) I think you have to look to the straces for info on that?
That email log looks like a successful email process. So best thing is to provide a .odt which is a guaranteed hanger when mailed as .pdf. And if it hangs on being emailed as pdf does it also hang when just being saved as pdf ?
Created attachment 41371 [details] tst doc that hangs when mail-merge mailing "That email log looks like a successful email process." Yes, I thougth I wrote that. "So best thing is to provide a .odt which is a guaranteed hanger when mailed as .pdf." See attached. " And if it hangs on being emailed as pdf does it also hang when just being saved as pdf ? Tried that earlier - works fine,
additional info: the office freezes when merge-mailing the document. However, the first of the serie is successfully send.
additional info: https://bugs.freedesktop.org/show_bug.cgi?id=32790 : "Mail Merge > Send via mail" uses mailaddress from first record for all records
changed summary. It was " Send document as PDF with backgound image in table freezes LibO" Now with additional trouble and tests, it turned out that the problem is that the document has a table that starts right at the top. Thus, when you ad an paragraph before the table, the mail merge, sending via mail works fine. This bug is also present in LibO 331 but not in OOo 330
reproducible
So, all the foo around checking the emailmerge python thing itself turns out to be irreverent, its writer that's hanging on copying the table into a temp doc
Headline issue fixed in master as: http://cgit.freedesktop.org/libreoffice/writer/commit/?id=7482695994c5f6bf9995748944e38d2792aaed92
Good news :-) so maybe the same in bug 34187 ? I have not seen any comment on my suggestion here https://bugs.freedesktop.org/show_bug.cgi?id=34187#c11
additionally I think the existence of the flat xml filter causes the "get mime type from suffix to fail" which is another problem for e.g. sending attached .odts
Fixed that as http://cgit.freedesktop.org/libreoffice/writer/commit/?id=5c4a455137ae1fc74cdf88fe6d4d315b1948b4c0 to ensure we don't grab the flat xml "odt" mimetype which is empty rather than the normal "odt" mimetype
Similarly looking up the pdf export filter by suffix isn't always guaranteed to be the one we want for exporting a writer document, i.e. http://cgit.freedesktop.org/libreoffice/writer/commit/?id=97bce7aad1c3a6f3fd23a3380c79ca9c1515624c
*** Bug 31792 has been marked as a duplicate of this bug. ***
k, so a) reproducible hang: fixed b) as PDF > no result; as HTML > works, as PDF works: fixed c) as odt, no mimetype: fixed
Got enough acks, and cherry-picked for 3-3 and 3-3-2, not certain it'll make the cut by time for 3.3.2, but we'll see.