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
