AW: AW: BCC not shown
>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 40005a82074b237e7e9400cba0225cf3 > /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 .
> 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]:
> 40005a82074b237e7e9400cba0225cf3: journal rcpt: 'i...@saftig.net '
> Feb 12 22:29:37 mailpiler piler[554]:
> 40005a82074b237e7e9400cba0225cf3: hdr_len: 594, offset: 3 Feb 12
> 22:29:37 mailpiler piler[554]:
> 40005a82074b237e7e9400cba0225cf3: touch
> 1d144d5a090b040ea90a909a1b06cf8b7b81d96e1b88e0d01c8949ead45a887b OK
> (<20180212212922.14342101...@smtp02.mail.de>)
> Feb 12 22:29:37 mailpiler piler[554]:
&
Re: AW: BCC not shown
: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: 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]:
40005a8207542408b94c00f645f05987: journal rcpt:
'c.roe...@saftig.net '
Feb 12 22:29:46 mailpiler piler[553]:
40005a8207542408b94c00f645f05987: hdr_len: 594, offset: 3
Feb 12 22:29:46 mailpiler piler[553]:
40005a8207542408b94c00f645f05987: 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]:
40005a8207542408b94c00f645f05987: 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:
40005a8207542408b94c00f645f05987, 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
AW: BCC not shown
And now the log attached in some human readable format...
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 WHEREMATCH('
(@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
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 .
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]: 40005a82074b237e7e9400cba0225cf3:
journal rcpt: 'i...@saftig.net '
Feb 12 22:29:37 mailpiler piler[554]: 40005a82074b237e7e9400cba0225cf3:
hdr_len: 594, offset: 3
Feb 12 22:29:37 mailpiler piler[554]: 40005a82074b237e7e9400cba0225cf3:
touch 1d144d5a090b040ea90a909a1b06cf8b7b81d96e1b88e0d01c8949ead45a887b OK
(<20180212212922.14342101...@smtp02.mail.de>)
Feb 12 22:29:37 mailpiler piler[554]: 40005a82074b237e7e9400cba0225cf3:
stored '40005a82074b237e7e9400cba0225cf3.m' 8361/3896 bytes
Feb 12 22:29:37 mailpiler piler[554]: 40005a82074b237e7e9400cba0225cf3:
stored 1 recipients, rc=0
Feb 12 22:29:37 mailpiler piler[554]: 40005a82074b237e7e9400cba0225cf3:
stored metadata, rc=0
Feb 12 22:29:37 mailpiler piler[554]: 1/5VQK1KDSHAENMIU1:
40005a82074b237e7e9400cba0225cf3, 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
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 WHEREMATCH('
(@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 <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
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 Original Message From: "Christian Röser - PELMA" <c.roe...@saftig.net> Sent: Mon Feb 12 17:37:09 GMT+01:00 2018 To: Piler User <piler-user@list.acts.hu> 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
