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
