>email, especially the journaling stuff. Your email address (even if it's bcc) >should >be somewhere in the headers. Nope, that seems to be the problem? My address is not in the header.
I temporarily changed the journaling to my address and send an email. The journaling function sends two emails with my message attached. The first one is for it@... here is my address not in the header. The second message from the journaling system contains the message that’s for me, here the message contains my address as envelope-to. -----Ursprüngliche Nachricht----- Von: s...@acts.hu [mailto:s...@acts.hu] Gesendet: Dienstag, 13. Februar 2018 20:51 An: Piler User <piler-user@list.acts.hu> Betreff: Re: AW: BCC not shown ok, I see. Try retrieving this email from archive, eg. pilerget 400000005a82074b237e7e9400cba0225cf3 > /tmp/1.eml, then check the email, especially the journaling stuff. Your email address (even if it's bcc) should be somewhere in the headers. If so, then run pilertest 1.eml, and check if your (bcc) address is among the recipients. Janos On 2018-02-12 23:19, Christian Röser - PELMA wrote: > Glad to hear that. 😊 I did some extensive tests and I'm thinking that > we are dealing here with some fucked up (sorry) exchange related > problem. The address of my "colleague" is a shared folder where I also > have full access rights. But that doesn't seems to be the problem > because I also send a mail to another shared folder with my address in > bcc - worked. Then I gave me access rights and send another mail - > still worked. It seems to be something exclusive with this address but > I have no idea what's wrong. > > > Regarding the information you wanted: > > MariaDB [piler]> select * from rcpt where id=80; > +----+---------------------+------------+ > | id | to | todomain | > +----+---------------------+------------+ > | 80 | c.roe...@saftig.net | saftig.net | > | 80 | i...@saftig.net | saftig.net | > +----+---------------------+------------+ > 2 rows in set (0.00 sec) > > > Connected with sphinx and query with my address: > > MySQL [(none)]> SELECT id FROM main1,dailydelta1,delta1 WHERE MATCH(' > (@from cXroeserXsaftigXnet | @to cXroeserXsaftigXnet) ') ORDER BY > `sent` DESC LIMIT 0,20 OPTION max_matches=1000; > +------+ > | id | > +------+ > | 79 | > | 77 | > | 76 | > | 75 | > | 74 | > | 72 | > | 71 | > | 70 | > | 69 | > | 66 | > | 65 | > | 57 | > | 56 | > | 54 | > | 55 | > | 52 | > | 48 | > | 43 | > | 41 | > | 39 | > +------+ > 20 rows in set (0.00 sec) > > > Query with the address of the shared folder: > > MySQL [(none)]> SELECT id FROM main1,dailydelta1,delta1 WHERE MATCH(' > (@from itXsaftigXnet | @to itXsaftigXnet) ') ORDER BY `sent` DESC > LIMIT 0,20 OPTION max_matches=1000; > +------+ > | id | > +------+ > | 80 | > | 73 | > | 74 | > | 70 | > | 44 | > | 36 | > | 35 | > | 28 | > | 29 | > +------+ > 9 rows in set (0.00 sec) > > > And here is the entries from the log regarding this specific message: > > Feb 12 22:29:36 mailpiler piler-smtp[549]: connected from > 10.194.0.2:16698 on descriptor 6 (active connections: 1) Feb 12 > 22:29:36 mailpiler piler-smtp[549]: [54B blob data] Feb 12 22:29:36 > mailpiler piler-smtp[549]: [77B blob data] Feb 12 22:29:36 mailpiler > piler-smtp[549]: [46B blob data] Feb 12 22:29:36 mailpiler > piler-smtp[549]: sent: 250 Ok Feb 12 22:29:36 mailpiler > piler-smtp[549]: [67B blob data] Feb 12 22:29:36 mailpiler > piler-smtp[549]: sent: 250 Ok Feb 12 22:29:36 mailpiler > piler-smtp[549]: [27B blob data] Feb 12 22:29:36 mailpiler > piler-smtp[549]: sent: 354 Send mail data; end it with <CRLF>.<CRLF> > Feb 12 22:29:36 mailpiler piler-smtp[549]: received: 5VQK1KDSHAENMIU1, > from=, size=8361, client=10.194.0.2 Feb 12 22:29:36 mailpiler > piler-smtp[549]: sent: 250 OK <5VQK1KDSHAENMIU1> Feb 12 22:29:36 > mailpiler piler-smtp[549]: [27B blob data] Feb 12 22:29:36 mailpiler > piler-smtp[549]: sent: 221 mailpiler.saffig.saftig.net Goodbye Feb 12 > 22:29:36 mailpiler piler-smtp[549]: disconnected from > 10.194.0.2 on descriptor 6 (0 active connections) Feb 12 22:29:37 > mailpiler piler[554]: > 400000005a82074b237e7e9400cba0225cf3: journal rcpt: 'i...@saftig.net ' > Feb 12 22:29:37 mailpiler piler[554]: > 400000005a82074b237e7e9400cba0225cf3: hdr_len: 594, offset: 3 Feb 12 > 22:29:37 mailpiler piler[554]: > 400000005a82074b237e7e9400cba0225cf3: touch > 1d144d5a090b040ea90a909a1b06cf8b7b81d96e1b88e0d01c8949ead45a887b OK > (<20180212212922.14342101...@smtp02.mail.de>) > Feb 12 22:29:37 mailpiler piler[554]: > 400000005a82074b237e7e9400cba0225cf3: stored > '400000005a82074b237e7e9400cba0225cf3.m' 8361/3896 bytes Feb 12 > 22:29:37 mailpiler piler[554]: > 400000005a82074b237e7e9400cba0225cf3: stored 1 recipients, rc=0 Feb 12 > 22:29:37 mailpiler piler[554]: > 400000005a82074b237e7e9400cba0225cf3: stored metadata, rc=0 Feb 12 > 22:29:37 mailpiler piler[554]: 1/5VQK1KDSHAENMIU1: > 400000005a82074b237e7e9400cba0225cf3, size=8361/3896, attachments=0, > reference=, message-id=<20180212212922.14342101...@smtp02.mail.de>, > retention=4000, folder=0, delay=0.0219, status=stored Feb 12 22:29:45 > mailpiler piler-smtp[549]: connected from > 10.194.0.2:16706 on descriptor 6 (active connections: 1) Feb 12 > 22:29:45 mailpiler piler-smtp[549]: [54B blob data] Feb 12 22:29:45 > mailpiler piler-smtp[549]: [77B blob data] Feb 12 22:29:45 mailpiler > piler-smtp[549]: [46B blob data] Feb 12 22:29:45 mailpiler > piler-smtp[549]: sent: 250 Ok Feb 12 22:29:45 mailpiler > piler-smtp[549]: [67B blob data] Feb 12 22:29:45 mailpiler > piler-smtp[549]: sent: 250 Ok Feb 12 22:29:45 mailpiler > piler-smtp[549]: [27B blob data] Feb 12 22:29:45 mailpiler > piler-smtp[549]: sent: 354 Send mail data; end it with <CRLF>.<CRLF> > Feb 12 22:29:45 mailpiler piler-smtp[549]: received: R10MNQ5X6TSNS4DS, > from=, size=8279, client=10.194.0.2 Feb 12 22:29:45 mailpiler > piler-smtp[549]: sent: 250 OK <R10MNQ5X6TSNS4DS> Feb 12 22:29:45 > mailpiler piler-smtp[549]: [27B blob data] Feb 12 22:29:45 mailpiler > piler-smtp[549]: sent: 221 mailpiler.saffig.saftig.net Goodbye Feb 12 > 22:29:45 mailpiler piler-smtp[549]: disconnected from > 10.194.0.2 on descriptor 6 (0 active connections) Feb 12 22:29:46 > mailpiler piler[553]: > 400000005a8207542408b94c00f645f05987: journal rcpt: > 'c.roe...@saftig.net ' > Feb 12 22:29:46 mailpiler piler[553]: > 400000005a8207542408b94c00f645f05987: hdr_len: 594, offset: 3 Feb 12 > 22:29:46 mailpiler piler[553]: > 400000005a8207542408b94c00f645f05987: trying to add journal rcpt > (c.roe...@saftig.net ) to id=80 for message-id: > '<20180212212922.14342101...@smtp02.mail.de>' > Feb 12 22:29:46 mailpiler piler[553]: > 400000005a8207542408b94c00f645f05987: stored 1 recipients, rc=0 Feb 12 > 22:29:46 mailpiler piler[553]: 0/R10MNQ5X6TSNS4DS: discarding: > duplicate message, id: 80, message-id: > <20180212212922.14342101...@smtp02.mail.de> > Feb 12 22:29:46 mailpiler piler[553]: 0/R10MNQ5X6TSNS4DS: > 400000005a8207542408b94c00f645f05987, size=8279/0, attachments=0, > reference=, message-id=<20180212212922.14342101...@smtp02.mail.de>, > retention=0, folder=0, delay=0.0038, status=duplicate > > > > > > Von: Janos SUTO [mailto:s...@acts.hu] > Gesendet: Montag, 12. Februar 2018 20:26 > An: Piler User <piler-user@list.acts.hu> > Betreff: Re: BCC not shown > > Er, I'd like to correct myself. Your bcc address is the same as the > to/from address. > However, the gui applies an email address filter for the search query. > If you know what message you should see (but you don't) then check it > in the rcpt table. You should see your email address as well. > The id in rcpt table is the same as the id in the metadata table. You > can get the id of the given message if you hover the mouse on the > download link in the lower preview pane. > Janos > ________________________________________ > From: "Christian Röser - PELMA" > Sent: Mon Feb 12 18:47:03 GMT+01:00 2018 > To: Piler User > Subject: AW: BCC not shown > > > Hello Janos, > > now I'm a bit confused, is my bcc address not the same as my "normal" > address? Here is the query with no search term: > > sphinx query: 'SELECT id FROM main1,dailydelta1,delta1 WHERE MATCH(' > (@from cXroeserXsaftigXnet | @to cXroeserXsaftigXnet) ') ORDER BY > `sent` DESC LIMIT 0,20 OPTION max_matches=1000' in 0.00 s, 14 hits, > 14 total found > > For the tests the user was created manually, I only entered the email > address, username, full name, domain and password. > > > > > Von: Janos SUTO [mailto:s...@acts.hu] > Gesendet: Montag, 12. Februar 2018 17:44 > An: Piler User <mailto:piler-user@list.acts.hu> > Betreff: Re: BCC not shown > > Hello Christian, > check the Sphinx query in the mail log. I suspect that your bcc > address is not in the query. > The fix depends on what authentication you are using. > > Janos > ________________________________________ > > From: "Christian Röser - PELMA" > Sent: Mon Feb 12 17:37:09 GMT+01:00 2018 > To: Piler User > Subject: BCC not shown > > > > > Hello, > > I need some help. Today I made some tests with my piler installation > and I found a problem that drives me crazy - but I assume there could > be simple configuration problem. Messages I receive as bcc are not > shown in the search results. > > I checked if the exchange server behaves correctly, here seems > everything fine. The system generates two e-mails, one for the normal > recipient and a separate one for the bcc recipient. Piler receive both > e-mails, stores the first one and recognizes for the second e-mail > that it have the same message-id. In the metadata table exists an > entry and in the rcpt table two entries for this id. Nevertheless only > in the search results of the "normal" recipient the message is shown. > > Is the some parameter missing? > > Best regards, > Christian
